Sort the files according to date and time mentioned in file

Question

Hi

I have some files in which date and time is mentioned. I want to sort the files .In very first line of the file date and time is mentioned. Files must be sorted accordingly.

Assist me for the proper code.

regards

Kritika

Iftikar Hussain · Answer

Please mark it answer so that it will help others. Regards, Iftikar

kritika Rana · Answer

till now I hadnot receive any message as soon i get I will sure do it Thanks

Iftikar Hussain · Answer

I sent you one message. Please mark it answer so that it will help others. Regards, Iftikar

kritika Rana · Answer

there is no update on my fb acc

Iftikar Hussain · Answer

you welcome. check your fb Regards, Iftikar

kritika Rana · Answer

thank you very much

Iftikar Hussain · Answer

ok. good. Regards, Iftikar

kritika Rana · Answer

Its working now

kritika Rana · Answer

It searches only two files and send as email but i have 9 files in my directory

Iftikar Hussain · Answer

use FilePath var filePath = fileInfo.FilePath; Regards, Iftikar

kritika Rana · Answer

Showing error for FullName try { foreach (var fileInfo1 in resultFiles) { var filePath1 = fileInfo1. FullName; using (var textFile = File.OpenText(filePath1)) { SendMail(textFile.ReadToEnd()); } } MessageBox.Show("Email Send Successfully"); } catch (Exception ex) { MessageBox.Show( ex.ToString()); }

Iftikar Hussain · Answer

actually it is not '?', it is a some special character. While pasting it become like this. I will attach cs file. copy the logic from there Regards, Iftikar

kritika Rana · Answer

showing exception to highlighted line that input string is not in correct format private static DateTime GetDateValue(string fileContent, string fileName) { var temp = fileContent.Replace(fileName, string.Empty); temp = temp.Replace("APU-PERF.VDR", string.Empty); temp = temp.Replace("?", string.Empty); temp = temp.Trim(); var tempArray = temp.Split(' '); var tempDate = tempArray[2]; var tempTime = tempArray[3]; var tempDay = Convert.ToInt16(temp.Substring(5, 2)); var tempMonth = Convert.ToInt32(GetMonth(tempDate.Substring(2, 3))); var tempYear = Convert.ToInt32(tempDate.Substring(0, 2)); var tempTimeArray = tempTime.Split(':'); var tempHr = Convert.ToInt16(tempTimeArray[0]); var tempMint = Convert.ToInt16(tempTimeArray[1]); var tempSecond = Convert.ToInt16(tempTimeArray[2]); var dt = new DateTime(tempDay, tempMonth, tempYear, tempHr, tempMint, tempSecond); return dt; }

Iftikar Hussain · Answer

in the same project create a new file

kritika Rana · Answer

In the same code or create a new file for the class

Iftikar Hussain · Answer

after that try like this private void button7_Click(object sender, EventArgs e) { string path = @"D:\vikas"; DirectoryInfo dinfo = new DirectoryInfo(path); var files = dinfo.GetFiles("*"); List fileDatas=new List (); foreach (var fileInfo in files) { var filePath = fileInfo.FullName; DateTime dt; using (var textFile = File.OpenText(filePath)) { dt = GetDateValue(textFile.ReadLine(), fileInfo.Name); } var fileData=new FileData {FileName = fileInfo.Name, FilePath = filePath, FileModifiedDate = dt}; fileDatas.Add(fileData); } var resultFiles = fileDatas.OrderByDescending(x => x.FileModifiedDate); try { foreach (var fileInfo in resultFiles) { var filePath = fileInfo.FullName; using (var textFile = File.OpenText(filePath)) { SendMail(textFile.ReadToEnd()); } } MessageBox.Show("Email Send Successfully"); } catch (Exception ex) { MessageBox.Show("Mail Not Send Check for error",ex.ToString ()); } } private static DateTime GetDateValue(string fileContent, string fileName) { var temp = fileContent.Replace(fileName, string.Empty); temp = temp.Replace("APU-PERF.VDR", string.Empty); temp = temp.Replace("?", string.Empty); temp = temp.Trim(); var tempArray = temp.Split(' '); var tempDate = tempArray[2]; var tempTime = tempArray[3]; var tempDay = Convert.ToInt16(temp.Substring(5, 2)); var tempMonth = Convert.ToInt32(GetMonth(tempDate.Substring(2, 3))); var tempYear = Convert.ToInt32(tempDate.Substring(0, 2)); var tempTimeArray = tempTime.Split(':'); var tempHr = Convert.ToInt16(tempTimeArray[0]); var tempMint = Convert.ToInt16(tempTimeArray[1]); var tempSecond = Convert.ToInt16(tempTimeArray[2]); var dt = new DateTime(tempDay, tempMonth, tempYear, tempHr, tempMint, tempSecond); return dt; } private static int GetMonth(string monthName) { var month=0; switch (monthName) { case "JAN": month = 1; break; case "FEB": month = 2; break; case "MAR": month = 3; break; case "APR": month = 4; break; case "MAY": month = 5; break; case "JUN": month = 6; break; case "JUL": month = 7; break; case "AUG": month = 8; break; case "SEP": month = 9; break; case "OCT": month = 10; break; case "NOV": month = 11; break; case "DEC": month = 12; break; } return month; } private void SendMail(string fileContent) { MailMessage mailMessage = new MailMessage(); mailMessage.From = new MailAddress("trehan.kritika@gmail.com", "Kritika"); mailMessage.To.Add("rana.vikas@spicejeth.com"); mailMessage.Subject = "Test Subject"; mailMessage.IsBodyHtml = true; mailMessage.Body = fileContent+" "; using (SmtpClient mailbox = new SmtpClient("smtp.gmail.com", 587)) { mailbox.Credentials = new NetworkCredential("trehan.kritika@gmail.com", "mrsseema"); mailbox.EnableSsl = true; mailbox.Send(mailMessage); } } Regards, Iftikar

Iftikar Hussain · Answer

first create one class file named FileData.cs and declare like this public class FileData { public string FileName { get; set; } public string FilePath { get; set; } public DateTime FileModifiedDate { get; set; } }

kritika Rana · Answer

ok

Iftikar Hussain · Answer

please don't share your credentials here. you can just put some dummy value, everyone will understand

kritika Rana · Answer

This is my code: and a sample file attached private void button7_Click(object sender, EventArgs e) { string path = @"D:\vikas"; DirectoryInfo dinfo = new DirectoryInfo(path); var files = dinfo.GetFiles("*").OrderBy(s => s.LastWriteTime).ToList(); StringBuilder sb = new StringBuilder(); try { foreach (var fileInfo in files) { var filePath = fileInfo.FullName; using (var textFile = File.OpenText(filePath)) { SendMail(textFile.ReadToEnd()); } } MessageBox.Show("Email Send Successfully"); } catch (Exception ex) { MessageBox.Show("Mail Not Send Check for error",ex.ToString ()); } } private void SendMail(string fileContent) { MailMessage mailMessage = new MailMessage(); mailMessage.From = new MailAddress("trehan.kritika@gmail.com", "Kritika"); mailMessage.To.Add("rana.vikas@spicejeth.com"); mailMessage.Subject = "Test Subject"; mailMessage.IsBodyHtml = true; mailMessage.Body = fileContent+" "; using (SmtpClient mailbox = new SmtpClient("smtp.gmail.com", 587)) { mailbox.Credentials = new NetworkCredential("trehan.kritika@gmail.com", "mrsseema"); mailbox.EnableSsl = true; mailbox.Send(mailMessage); } }

Iftikar Hussain · Answer

ok, in 13AUG03 which is date and which is year

kritika Rana · Answer

R49-4002.037³ 13AUG03³ 23:48:13³ 13 AUG03³ 23:48:10³ APU-PERF.VDR the highlighted value

kritika Rana · Answer

second value of date and time in first line

Iftikar Hussain · Answer

which date and time to consider for sorting? R49-4002.049³ 13AUG14³ 11:26:52³ 13AUG14³ 11:26:49³ APU-PERF.VDR

kritika Rana · Answer

some other application

Iftikar Hussain · Answer

ok..who is creating these file? you or some other application?

kritika Rana · Answer

yes

Iftikar Hussain · Answer

are you sure, every file will have first line the date and time value? and which one need to check? R49-4002.049³ 13AUG14³ 11:26:52³ 13AUG14³ 11:26:49³ APU-PERF.VDR

kritika Rana · Answer

I think you are not getting my question. If you open the file which I have send u as attachment, date and time is mentioned in very first line of the file . I want to sort according to that date and time not as system date and time Kritika

Iftikar Hussain · Answer

you are already sorting the files by latest one at top. I am not getting why you want to sort it again

kritika Rana · Answer

Hi When you open the file in wordpad you will find in very first line date and time is mentioned. I want the files to be sorted according to that date and time. Hope you understand my query. Regards Kritika

kritika Rana · Answer

hi Again I have some new queries........ As my program is working properly but I want to sort the files according to date and time mentioned in the very first line of the files. If possible then guide me completing the project. I hereby attach sample files for your reference Regards Kritika

Iftikar Hussain · Answer

Hi, I think you have done this in your last post. string path = @"D:\Files"; DirectoryInfo dinfo = new DirectoryInfo(path); var files = dinfo.GetFiles("*").OrderByDescending(s => s.LastWriteTime).ToList(); Regards, Iftikar

Sort the files according to date and time mentioned in file

Answers (33)