partial void DeleteBill(Bill instance);
partial void UpdateBill(Bill instance);
private int toDatabase(String line) { int inline = 0; if (line.Length > 13) { if (line.Substring(0, 14) == "Authorization:") { string[] partsA = line.Trim().Split(':'); auth = partsA[1]; } } if (line.Length > 14) { if (line.Substring(0, 14) == "Authorization ") { string[] partsA = line.Trim().Split(':'); department = partsA[1]; } } string[] parts = line.Trim().Split((char[])null, StringSplitOptions.RemoveEmptyEntries); Bill Row = new Bill(); if (parts.Length == 10 && line.Contains("OUT")) { string[] date_parts = parts[0].Split('/'); Row.Date = new DateTime(int.Parse(date_parts[0]), int.Parse(date_parts[1]), int.Parse(date_parts[2])); Row.Day = parts[1]; Row.Time = parts[2]; Row.Type = parts[3]; Row.Number = parts[4]; Row.Location = parts[5] + " " + parts[6] + " " + parts[7]; Row.Duration = parts[8]; Row.Charge = parts[9]; Row.Authorization = auth; Row.Department = department; listDb.Bills.InsertOnSubmit(Row); inline = 1; } if (parts.Length == 9 && line.Contains("OUT")) { string[] date_parts = parts[0].Split('/'); Row.Date = new DateTime(int.Parse(date_parts[0]), int.Parse(date_parts[1]), int.Parse(date_parts[2])); Row.Day = parts[1]; Row.Time = parts[2]; Row.Type = parts[3]; Row.Number = parts[4]; Row.Location = parts[5] + " " + parts[6]; Row.Duration = parts[7]; Row.Charge = parts[8]; Row.Department = department; Row.Authorization = auth; listDb.Bills.InsertOnSubmit(Row); inline = 1; } if (parts.Length == 8 && line.Contains("OUT")) { string[] date_parts = parts[0].Split('/'); Row.Date = new DateTime(int.Parse(date_parts[0]), int.Parse(date_parts[1]), int.Parse(date_parts[2])); Row.Day = parts[1]; Row.Time = parts[2]; Row.Type = parts[3]; Row.Number = parts[4]; Row.Location = parts[5]; Row.Duration = parts[6]; Row.Charge = parts[7]; Row.Authorization = auth; Row.Department = department; listDb.Bills.InsertOnSubmit(Row); inline = 1; } return inline; }
partial void InsertBill(Bill instance);
private void sendFromSMTP(Bill bill, string reportPath,string body,string toEmail, string pickedMonth, string smtp, string email, string pass) { //Bill bill = (from a in db.GetTable<Bill>() select a).FirstOrDefault(); System.Net.Mail.MailMessage mail = new MailMessage(); System.Net.Mail.SmtpClient SmtpServer = new System.Net.Mail.SmtpClient(smtp); mail.From = new MailAddress(email); mail.To.Add(toEmail); mail.Subject = "Telephone Bill for"+" "+ bill.Authorization; mail.Body = body; System.Net.Mail.Attachment attachment; string fileAttach = toPDF2(bill.Authorization,reportPath, pickedMonth); attachment = new System.Net.Mail.Attachment(fileAttach); mail.Attachments.Add(attachment); SmtpServer.Credentials = new System.Net.NetworkCredential(email, pass); SmtpServer.Send(mail); attachment.Dispose(); File.Delete(fileAttach); //MessageBox.Show("mail Send"); }