public static tbl_CheckWarehouseDetail GetByID(int ID) { using (var dbe = new inventorymanagementEntities()) { tbl_CheckWarehouseDetail ai = dbe.tbl_CheckWarehouseDetail.Where(a => a.ID == ID).SingleOrDefault(); if (ai != null) { return(ai); } else { return(null); } } }
public static string Insert(int AgentID, int CheckwarehouseID, int ProductVariableID, double Quantity_DB, double Quantity_Input, string Note, DateTime CreatedDate, string CreatedBy) { using (var dbe = new inventorymanagementEntities()) { tbl_CheckWarehouseDetail ui = new tbl_CheckWarehouseDetail(); ui.AgentID = AgentID; ui.CheckwarehouseID = CheckwarehouseID; ui.ProductVariableID = ProductVariableID; ui.Quantity_DB = Quantity_DB; ui.Quantity_Input = Quantity_Input; ui.Note = Note; ui.CreatedDate = CreatedDate; ui.CreatedBy = CreatedBy; dbe.tbl_CheckWarehouseDetail.Add(ui); int kq = dbe.SaveChanges(); return(kq.ToString()); } }