C# .NET, SQL, PL/SQL

The new chapter..

2009-12-09T00:42:00.005+02:00

Its been a while since a new post on the blog , a lot has happened meanwhile... but not to spoil all the details in one post i will post as we start along.

Today i am working on developing a site in ASP.NET, and i am currently doing a form that has a reset pasword link. I have created a random generating password class that could be useful.
Here it is

public class reset_password
{
public string valoare = string.Empty;

public reset_password()
{
string capitals = "ABCDEFGHIJKLMNOPQRSTUVWXTZ";
string small = "abcdefghijklmnopqrstuvwxyz";
string nr ="0123456789";
string ret = string.Empty;

Random rand = new Random();
for (int i = 0; i < 4; i++)
{
ret += capitals[rand.Next(0, 24)];
ret += small[rand.Next(0, 24)];
ret += nr[rand.Next(0, 9)];
}
valoare = ret;
}

}

will get back to you soon

Cheers,

Latest version -with autosave

2009-08-03T10:59:00.004+03:00

Here it is. I also fixed a couple of bugs with the text in the description field and a couple more..

DateTime in c#

2009-07-14T14:32:00.003+03:00

How to get the number of working days per month (except the legal holidays for each country)?

This is a question that i had to answer for the timing app. Here are some great resources on DateTime class and also on System.Globalization.

And here is my implementation on how to get this number:
private void nrZileLucratoare(int luna)
{
string numeLuna = "";
switch (luna)
{
case 1: numeLuna = "Jan"; break;
case 2: numeLuna = "Feb"; break;
case 3: numeLuna = "Mar"; break;
case 4: numeLuna = "Apr"; break;
case 5: numeLuna = "May"; break;
case 6: numeLuna = "Jun"; break;
case 7: numeLuna = "Jul"; break;
case 8: numeLuna = "Aug"; break;
case 9: numeLuna = "Sep"; break;
case 10: numeLuna = "Oct"; break;
case 11: numeLuna = "Nov"; break;
case 12: numeLuna = "Dec"; break;
}
int totalZile = DateTime.DaysInMonth(DateTime.Now.Year, luna);

int contor=0;
for (int i = 1; i <= totalZile; i++)
{
string Duminica = "Sun "+i+" "+numeLuna+" 9:30 AM 2009";
string Sambata = "Sat "+i+" "+numeLuna+" 9:30 AM 2009";

string format = "ddd d MMM h:mm tt yyyy";
DateTime dateTime;

if (DateTime.TryParseExact(Duminica, format, CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime))
{
contor += 1;
}
if (DateTime.TryParseExact(Sambata, format, CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime))
{
contor += 1;
}
}
MessageBox.Show((totalZile - contor).ToString()); // this is the actual number
}

Update

2009-07-03T20:51:00.002+03:00

A short update on what has been going on.. well the app is running, and the guys at work are using it :).. i am working on finishing the Admin part to set up some usage statistics with the data collected from all the guys to complete the monthly metrics. It is going good, hope this weekend i will get things done and i will release the Admin part of the app and that will be the full package and on to a new project :p.
I realize that the app is restrictive to our department, and to that kind of reporting, it's not a general app that you can use to time any activity..

Drag and Drop - complete

2009-07-01T21:26:00.001+03:00

I managed to implement it, here it goes:

private void listView1_DragDrop(object sender, DragEventArgs e)
{

string[] files = (string[])e.Data.GetData(DataFormats.FileDrop);

foreach(string nume in files)
{
Stream fisier = new FileStream(nume, FileMode.Open, FileAccess.Read);
BinaryFormatter formater = new BinaryFormatter();
int contor = (int)formater.Deserialize(fisier);
for (int i = 0; i < contor; i++)
{
Code.Inregistrare inreg = (Code.Inregistrare)formater.Deserialize(fisier);
//MessageBox.Show(inreg.ToString());
ListViewItem item = new ListViewItem(inreg.Data.ToString());
item.SubItems.Add(inreg.Request.ToString());
item.SubItems.Add(inreg.Description);
item.SubItems.Add(inreg.Tara);
item.SubItems.Add(inreg.Requester);
item.SubItems.Add(inreg.Person);
item.SubItems.Add(inreg.OraInceput.ToString());
item.SubItems.Add(inreg.OraSfarsit.ToString());
item.SubItems.Add(inreg.Durata.ToString());
listView1.Items.Add(item);
}
}

}

private void listView1_DragEnter(object sender, DragEventArgs e)
{
//imi copiaza ce ii dau drag
e.Effect = DragDropEffects.Copy;

}

Drag and Drop

2009-07-01T20:47:00.000+03:00

I found a great resource on Drag & Drop with step by step instructions and pics:
here

Version 1.0

2009-07-01T19:51:00.004+03:00

Finally it's here. I have finished it (as v1.0) and today was the first day it was used. I got some feedback at the end of the day regarding it :

To Implement drag and drop files from Explorer into a ListView ( this sounds a little bit tricky)
Make so accelerators and just "polish" a little the controls for smother access.

I have stared already reading about the drag & drop functions and how to implement them so, by my next post i will try to post what i came up with.

Till then,

here

is the app ( the Visual Studio 2008 project, or just go in the BIN directory to find the .exe file ;)
Enjoy.

PS: Also a pic

List view Items in C#

2009-06-30T22:18:00.007+03:00

I'm always using listviews in c#. In a former project i had the same issue as with the timing app: "How to select an index from selected row in the listview". I googled it and here is what i found, and works just fine:

for (int i = 0; i < listView1.Items.Count; i++ )
{
if (listView1.Items[i].Selected)
{
  listView1.Items[i].Remove();
}


UPDATE :: I found out that the code above is limited
 to deleting only the first row
when the SelectMultipleRows option is true,
 so i googled and found a better
alternative:

while (listView1.SelectedIndices.Count > 0)
{
 listView1.Items.RemoveAt(listView1.SelectedIndices[0]);
}

Task timing App - Update

2009-06-29T21:19:00.003+03:00

The timing app is going smooth. I decided (because lack of time) to give up on making 2 different apps, and just to make a "2 in 1" to avoid using the specific defined Serialization, (like in the previous post) and just finish it as soon as I can, but i still want to try it out and see if /how it works. Soon i will start my new job, as a PL/SQL developer. I'm really excited about this.

Application.Exit();

Task Timing Application

2009-06-28T14:20:00.003+03:00

I was studying for an exam this Friday night, and out of a sudden it struck me. At my current (former) job we have to do timing on our activities and i never considered of doing an application that would facilitate this.
So.. this is how it began..
Today is Sunday, i think i have done about 80% percent of the project, but when i still see things that i can do with it the finish point still looks a little bit far.
Anyway the problem i ran into today was regarding Serialization in C#.
I want to have 2 applications : one will export data using Serialization into a binary file, that i want to open with another application. Simple i said. But the fact is when trying to open it thorough the other application, i received an error : "Unable to find assembly 'Application Timing', Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'.

I began searching on forums and here is what i found :

After i will make my implementation i will post it here and the final app plus source code, hopefully soon :)

The First Post

2009-06-28T14:13:00.002+03:00

I've created this blog for quite a while now, but i did not manage to post anything... so to get things started here i go with my 1st project :-p

c#:
 class HelloWorld

       static void Main()
       {
          System.Console.WriteLine("Hello, world!")
       }
    }

PL/SQL:

BEGIN
dmbs_output.put_line("Hello world");
END;
/

Test

2008-11-05T13:51:00.001+02:00

TEST