Re: Recreate email from database record - C# Discussion Boards

Abhinav S8-Jul-10 19:21

8-Jul-10 19:21

Currency rates are changing all the while - so you will need to communicate with a web service / site that provides updated currency rates.

Once you have the correct rates, updating the currency should be easy.

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

rahul.net118-Jul-10 20:01

rahul.net11

8-Jul-10 20:01

Hi Abhinav,

I am getting all the current currency rates just need a formula to convert each curr inEURo.

Will try and let u knkow?

Thanks

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

elchupathingy8-Jul-10 19:26

elchupathingy

8-Jul-10 19:26

http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml[^]

Bam, simple parsing as well Big Grin | :-D

rahul.net118-Jul-10 19:51

rahul.net11

8-Jul-10 19:51

Hi,
I am getting the daily rates. I just want to know the formula to convert.
Suppose i got amount 140 in GBP now i want to convert it into EURO so what will be the formula.

Regards
Rahul

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

SeMartens8-Jul-10 20:59

SeMartens

8-Jul-10 20:59

Hi,

you will need this formula:

x (in Euro) = y (foreign currency) / z (current rate).

For example for the 140 GBP with a rate of 1 € = 1.5 GBP the formula will be

x = 140 / 1.5 = 93.33 (Euro)

If you have the rate like 1 GBP = 0.67 Euro you need this formula:

x (in Euro) = y (foreign currency) * z (current rate)

Hope this helps.

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Recreate email from database record

Luc Pattyn8-Jul-10 23:34

Luc Pattyn

8-Jul-10 23:34

the formula is: multiplication.
It is similar as converting inches to millimeters, and much simpler than converting Fahrenheit to Celsius.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

RCoate8-Jul-10 17:15

RCoate

8-Jul-10 17:15

I am writing an application to migrate records from a DocuShare document management system to a TRIM Records management system.
Moving documents (anything that is not an email) is straight forward, but for some reason DocuShare takes any email that is lodged and ripps it up into component pieces and stores these in a database table.
I can find the To, From, Subject, Body, Header and other data and now my challenge is to reconstitute the original email so I can move it into TRIM.

I have tried using the Office.Interop.Outlook class to create an email, but I can't include the Header or the From Information.
I.E.

Outlook.MailItem mailItem = new Microsoft.Office.Interop.Outlook.MailItem();
mailItem.Body = "This is My Test";
mailItem.Subject = "Test Message";
mailItem.Attachments.Add("C:\\AttachmentDocument.txt", Outlook.OlAttachmentType.olByValue, 1, "AttachmentDocument.txt");
mailItem.BodyFormat = Microsoft.Office.Interop.Outlook.OlBodyFormat.olFormatHTML;
mailItem.To = "ToPerson@theirEmail.Address.com";
mailItem.BCC = "";
mailItem.CC = "";
mailItem.SaveAs("Path", Outlook.OlSaveAsType.olMSG);

Does anyone know of an other way to recreate these emails so that I can include the header and from (and maybe other) fields?

Re: Recreate email from database record

Abhinav S8-Jul-10 18:43

Re: Recreate email from database record

8-Jul-10 18:43

RCoate wrote:
DocuShare

You might want to have a look at their documentation to see if they provide any solutions.

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

RCoate8-Jul-10 20:18

RCoate

8-Jul-10 20:18

Yeah, DocuShare documentation is fairly sparse, does not cover anything other than documents (nothing on emails) and is really quite useless.
I have done quite a bit of research on all available DocuShare tools, sdk's and api's before starting this project.

One thing I found out from dissecting their database is that they do not save emails (unless the email is an attachment to another email), so you can not export emails.

Howto: get a textbox to display bytes as 0's and 1's.. ?

Shaareable8-Jul-10 15:48

Shaareable

8-Jul-10 15:48

How do you take a byte array and get a textbox to display it as it is bit wise.
So for example if I have a byte it gets displayed as maybe 00010100

thanks for helping out the newbie Smile | :)

ps: Please reply if you want to share how to do this and do not reply otherwise... thanks.

Re: Howto: get a textbox to display bytes as 0's and 1's.. ?

JF20158-Jul-10 18:20

JF2015

8-Jul-10 18:20

Hi,

This should be the solution: (copied from MSDN)

txtFieldInBinary.Text = Convert.ToString(valueToDisplayAsBinary, 2);

Re: Howto: get a textbox to display bytes as 0's and 1's.. ?

Abhinav S8-Jul-10 18:46

Re: Howto: get a textbox to display bytes as 0's and 1's.. ?

8-Jul-10 18:46

You could write your own code to do this -

public class ShowBits { 
  public static void Main() { 
    int t; 
    byte val;  
  
    val = 123; 
    for(t=128; t > 0; t = t/2) { 
      if((val & t) != 0) Console.Write("1 ");  
      if((val & t) == 0) Console.Write("0 ");  
    } 
  } 
}

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

harold aptroot8-Jul-10 23:09

harold aptroot

8-Jul-10 23:09

public class ShowBits { 
  public static void Main() { 
    byte val;  
  
    val = 123; 
    for(int i = 7; i >= 0; i--) { 
      Console.Write(((val >> i) & 1) + " ");  
    } 
  } 
}

Re: Howto: get a textbox to display bytes as 0's and 1's.. ?

Shaareable9-Jul-10 0:35

Shaareable

9-Jul-10 0:35

Hi Thanks for answering.
I don't understand (val & t).
I will look it up Smile | :)

Re: Howto: get a textbox to display bytes as 0's and 1's.. ?

DaveyM698-Jul-10 21:17

DaveyM69

8-Jul-10 21:17

Here's[^] an older article of mine that has what you need and more.

Dave

If this helped, please vote & accept answer!

Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.(Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Re: Howto: get a textbox to display bytes as 0's and 1's.. ?

Luc Pattyn8-Jul-10 23:39

Luc Pattyn

8-Jul-10 23:39

No need for explicit loops. I'd go for

string binary=Convert.ToString(myUnsignedByte, 2).PadLeft(8, '0');

which yields 8 binary digits.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: Howto: get a textbox to display bytes as 0's and 1's.. ?

Shaareable9-Jul-10 0:31

Shaareable

9-Jul-10 0:31

Ok I found that there's a Convert.ToString for that Smile | :)

http://msdn.microsoft.com/en-us/library/14kwkz77.aspx

HELP! Windows Services

Charlie Curtis8-Jul-10 6:52

Charlie Curtis

8-Jul-10 6:52

Hi All,

I am using the XYNTServices example I found here. If I start the Service with everything using local computer resources it works great. However, I want to be able to place the log file it creates on a server rather then the local computer. Does anyone out there know how to accomplish this? I have tried mapping the server resource to a drive letter, I have tried using the complete IP address to the resource folder and I have tried using the \\servername\folder\folder\logfile.log None of which have worked! So any information on how this can be made to work would be greatly appreciated. Oh almost forgot if I use the \\IPAddress\folder\folder\logfile.log in this case it does in fact create the log file on the server, but then the windows service won't start. I keep getting the "Could not start the MyWinService service on Local Computer."
"Error 1053: The service did not respond to the start or control request in a timely fashion." Both statements without quotes of course. So the only change is to the path of the log file. Again ANY help would be appreciated!

Thanks,
Charlie

Everything is Free... Until You Have to Pay for it...

Platforms Windows 2000/XP Professional using Visual C++ 6.0 Visual Studio 2005

Abhinav S8-Jul-10 7:02

8-Jul-10 7:02

Charlie Curtis wrote:
XYNTServices example I found here

You might want to provide a link to this article. Or better still, you could post this question at the bottom of the article (in the messages section).

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

Charlie Curtis8-Jul-10 7:22

Charlie Curtis

8-Jul-10 7:22

Thanks for... Nothing

Everything is Free... Until You Have to Pay for it...

Platforms Windows 2000/XP Professional using Visual C++ 6.0 Visual Studio 2005

Keith Barrow8-Jul-10 7:57

Keith Barrow

8-Jul-10 7:57

Charlie Curtis wrote:
Everything is Free... Until You Have to Pay for it...

Charlie Curtis wrote:
Thanks for... Nothing

Well you paid nothing, so you got nothing, I'm not sure what you expected.

What is expected is a decent question, and reasonable politeness, you have failed point one in your first post, and point two in your second.
We aren't having your problem, you are.
We aren't getting paid to sort your problem, you are.
We aren't getting paid to scrabble round for information to help you sort your problem, so the least you can do is try and give us all a clue.

Try reading the FAQs at the top of this forum, that way you are more likely to get help.

Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
Pete o'Hanlon: If it wasn't insulting tools, I'd say you were dumber than a bag of spanners.

Dave Kreskowiak8-Jul-10 7:06

Dave Kreskowiak

8-Jul-10 7:06

If you're going to use non-local resources, i.e.: Network Share, from your service, you service has to run under a different account. The LocalSystem account used by default does not have any permissions to any network resources. The fix is to setup a user account that has the appropriate permissions to the network resources it needs and change the service in the Service Manager to logon using that account.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Charlie Curtis8-Jul-10 7:23

Charlie Curtis

8-Jul-10 7:23

Hi Dave,

Thanks for the info I will give this a shot. Sounds like it might be what the problem is.

Charlie

Everything is Free... Until You Have to Pay for it...

Platforms Windows 2000/XP Professional using Visual C++ 6.0 Visual Studio 2005

PIEBALDconsult8-Jul-10 8:12

PIEBALDconsult

8-Jul-10 8:12

If you put the log on a network drive, how do you log that you have a network outage?

I prefer to keep log files local.