public static string Update(int UID, string Fullname, int Gender, DateTime BirthDay, string Email, string Phone, string Address, DateTime ModifiedDate, string ModifiedBy, string Note) { using (var dbe = new inventorymanagementEntities()) { dbe.Configuration.ValidateOnSaveEnabled = false; tbl_AccountInfo ui = dbe.tbl_AccountInfo.Where(a => a.UID == UID).SingleOrDefault(); if (ui != null) { ui.Fullname = Fullname; ui.Gender = Gender; ui.Birthday = BirthDay; ui.Email = Email; ui.Phone = Phone; ui.Address = Address; ui.ModifiedBy = ModifiedBy; ui.ModifiedDate = ModifiedDate; ui.Note = Note; int kq = dbe.SaveChanges(); return(kq.ToString()); } else { return(null); } } }
public static tbl_AccountInfo GetByUserID(int UID) { using (var dbe = new inventorymanagementEntities()) { tbl_AccountInfo ai = dbe.tbl_AccountInfo.Where(a => a.UID == UID).SingleOrDefault(); if (ai != null) { return(ai); } else { return(null); } } }
public static tbl_AccountInfo GetByPhone(string phone) { using (var dbe = new inventorymanagementEntities()) { tbl_AccountInfo acc = dbe.tbl_AccountInfo.Where(a => a.Phone == phone).SingleOrDefault(); if (acc != null) { return(acc); } else { return(null); } } }
public static string updateNote(int UID, string Note) { using (var dbe = new inventorymanagementEntities()) { dbe.Configuration.ValidateOnSaveEnabled = false; tbl_AccountInfo ui = dbe.tbl_AccountInfo.Where(a => a.UID == UID).SingleOrDefault(); if (ui != null) { ui.Note = Note; int kq = dbe.SaveChanges(); return(kq.ToString()); } else { return(null); } } }
public static string Insert(int UID, string Fullname, int Gender, DateTime BirthDay, string Email, string Phone, string Address, DateTime CreatedDate, string CreatedBy) { using (var dbe = new inventorymanagementEntities()) { dbe.Configuration.ValidateOnSaveEnabled = false; tbl_AccountInfo ui = new tbl_AccountInfo(); ui.UID = UID; ui.Fullname = Fullname; ui.Gender = Gender; ui.Birthday = BirthDay; ui.Email = Email; ui.Phone = Phone; ui.Address = Address; ui.CreatedDate = CreatedDate; ui.CreatedBy = CreatedBy; dbe.tbl_AccountInfo.Add(ui); int kq = dbe.SaveChanges(); return(kq.ToString()); } }