public string addAdmin(Administrator tempAdmin) { try { using (var context = new MailRecorderDBEntities()) { ADMIN admin = new ADMIN { ADMIN_NAME = tempAdmin.getAdminName(), ADMIN_UNAME = tempAdmin.getAdminUname(), ADMIN_PASSWORD = tempAdmin.getAdminPword() }; if (context.ADMINs.Any(x => x.ADMIN_UNAME == admin.ADMIN_UNAME)) { return(null); } else { context.ADMINs.Add(admin); context.SaveChanges(); return(admin.ADMIN_UNAME); } } } catch (Exception e) { throw e; } }
public List <Object> bookingDataGridPopulator() { try { using (var context = new MailRecorderDBEntities()) { List <Object> mails = context.MAILs.Select(x => new { x.Id, x.DIARY_NO, x.MRDIARY_NO, x.DATE_TODAY, x.SUBJECT, x.INITIATOR, x.RECEIVED_FROM, x.SENT_TO, x.CC, x.DATE_SENT, x.REMARKS }).ToList <Object>(); return(mails); } } catch (Exception e) { throw e; } }
public int mailIDIncrementer() { try { using (var context = new MailRecorderDBEntities()) { var customers = context.MAILs.OrderByDescending(x => x.Id); if (customers.Count() > 0) { var lastId = customers.FirstOrDefault <MAIL>(); return(++lastId.Id); } else { return(0); } } } catch (Exception e) { throw e; } }
public string updateCustomer(Mail mail, int id) { try { using (var context = new MailRecorderDBEntities()) { MAIL mailUp = context.MAILs.Where(x => x.Id == id).FirstOrDefault <MAIL>(); mailUp.Id = mail.getmailID(); mailUp.DIARY_NO = mail.getDiaryNo(); mailUp.MRDIARY_NO = mail.getmrDiary(); mailUp.SUBJECT = mail.getSubject(); mailUp.DATE_SENT = mail.getDateSent(); mailUp.DATE_TODAY = mail.getDateToday(); mailUp.INITIATOR = mail.getInitiator(); mailUp.RECEIVED_FROM = mail.getRecievedFrom(); mailUp.SENT_TO = mail.getSentTo(); mailUp.CC = mail.getCc(); mailUp.REMARKS = mail.getRemarks(); context.SaveChanges(); return(mailUp.DIARY_NO.ToString()); } } catch (Exception e) { throw e; } }
public string addMail(Mail tempMail) { try { using (var context = new MailRecorderDBEntities()) { var mail = new MAIL() { Id = tempMail.getmailID(), DIARY_NO = tempMail.getDiaryNo(), MRDIARY_NO = tempMail.getmrDiary(), SUBJECT = tempMail.getSubject(), DATE_SENT = tempMail.getDateSent(), DATE_TODAY = tempMail.getDateToday(), INITIATOR = tempMail.getInitiator(), RECEIVED_FROM = tempMail.getRecievedFrom(), SENT_TO = tempMail.getSentTo(), CC = tempMail.getCc(), REMARKS = tempMail.getRemarks() }; context.MAILs.Add(mail); context.SaveChanges(); return(mail.SUBJECT); } } catch (Exception e) { throw e; } }
public string deleteMail(int id) { using (var context = new MailRecorderDBEntities()) { var author = new MAIL { Id = id }; context.Entry(author).State = EntityState.Deleted; context.SaveChanges(); return(author.Id.ToString()); } }
internal void SearchData(TextBox txtFilter, DataGrid bookingDataGrid) { using (MailRecorderDBEntities mailDB = new MailRecorderDBEntities()) { var src = from mail in mailDB.MAILs where ((mail.SUBJECT) + (mail.DIARY_NO) + (mail.MRDIARY_NO) + (mail.INITIATOR) + (mail.RECEIVED_FROM) + (mail.REMARKS) + (mail.SENT_TO) + (mail.CC)).Contains(txtFilter.Text) select new { mail.Id, mail.DIARY_NO, mail.MRDIARY_NO, mail.DATE_TODAY, mail.SUBJECT, mail.INITIATOR, mail.RECEIVED_FROM, mail.SENT_TO, mail.CC, mail.DATE_SENT, mail.REMARKS }; bookingDataGrid.ItemsSource = src.ToList(); } }
public string adminAuthenticator(string uname, string pword) { try { using (var context = new MailRecorderDBEntities()) { ADMIN admin = context.ADMINs.Where(a => a.ADMIN_UNAME == uname && a.ADMIN_PASSWORD == pword).FirstOrDefault <ADMIN>(); if (admin != null) { return(admin.ADMIN_UNAME); } else { return("Invalid Credentials"); } } } catch (Exception e) { throw e; } }