public static tbl_MovePro GetByIDAndAgentIDSend(int ID, int AgentIDSend) { using (var dbe = new inventorymanagementEntities()) { tbl_MovePro ai = dbe.tbl_MovePro.Where(a => a.ID == ID && a.AgentIDSend == AgentIDSend).SingleOrDefault(); if (ai != null) { return(ai); } else { return(null); } } }
public static string UpdateStatus(int ID, int Status, DateTime ModifiedDate, string ModifiedBy) { using (var dbe = new inventorymanagementEntities()) { tbl_MovePro ui = dbe.tbl_MovePro.Where(a => a.ID == ID).SingleOrDefault(); if (ui != null) { ui.Status = Status; ui.ModifiedBy = ModifiedBy; ui.ModifiedDate = ModifiedDate; int kq = dbe.SaveChanges(); return(kq.ToString()); } else { return(null); } } }
public static string Insert(int AgentIDSend, string AgentNameSend, int AgentIDReceive, string AgentNameReceive, int Status, string Note, bool IsHidden, DateTime CreatedDate, string CreatedBy) { using (var dbe = new inventorymanagementEntities()) { tbl_MovePro ui = new tbl_MovePro(); ui.AgentIDSend = AgentIDSend; ui.AgentNameSend = AgentNameSend; ui.AgentIDReceive = AgentIDReceive; ui.AgentNameReceive = AgentNameReceive; ui.Status = Status; ui.Note = Note; ui.IsHidden = IsHidden; ui.CreatedDate = CreatedDate; ui.CreatedBy = CreatedBy; dbe.tbl_MovePro.Add(ui); int kq = dbe.SaveChanges(); return(kq.ToString()); } }