public List <GetAllPart_Result> GetAllPart() { using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { var RetVal = entity.GetAllPart().ToList().Select(s => new GetAllPart_Result { Category_Id = s.Category_Id, Part_Type_Id = s.Part_Type_Id, Part_Name = s.Part_Name, Part_Id = s.Part_Id, Part_Code = s.Part_Code, Outsource_Type_Id = s.Outsource_Type_Id, Color_Id = s.Color_Id, Material_Id = s.Material_Id, Category_Name = s.Category_Name, Color_Name = s.Color_Name, Material_Name = s.Material_Name, Unit_Id = s.Unit_Id, Outsource_Type = s.Outsource_Type, Part_Type = s.Part_Type, Unit_Name = s.Unit_Name, Criticality_Id = s.Criticality_Id, Criticality_Name = s.Criticality_Name, Min_Quantity = s.Min_Quantity, Image_Id = s.Image_Id }).ToList(); return(RetVal); } }
public List <vw_MinimumBalance> GetMinBalanceReport() { using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { var RetVal = entity.vw_MinimumBalance.ToList().Select(s => new vw_MinimumBalance { Category_Id = s.Category_Id, Part_Type_Id = s.Part_Type_Id, Part_Name = s.Part_Name, Part_Id = s.Part_Id, Part_Code = s.Part_Code, Outsource_Type_Id = s.Outsource_Type_Id, Color_Id = s.Color_Id, Material_Id = s.Material_Id, Category_Name = s.Category_Name, Color_Name = s.Color_Name, Material_Name = s.Material_Name, Unit_Id = s.Unit_Id, Outsource_Type = s.Outsource_Type, Part_Type = s.Part_Type, Unit_Name = s.Unit_Name, Criticality_Id = s.Criticality_Id, Criticality_Name = s.Criticality_Name, Balance_Quantity = s.Balance_Quantity, Min_Quantity = s.Min_Quantity }).ToList(); return(RetVal); } }
public List <GetPartByFilter_Result> GetPartByFilter(int?part_Type_Id, int?outsource_Type_Id, string part_Code, string part_Name, int?unit_Id, int?category_Id, int?color_Id, int?material_Id, int?criticality_Id) { using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { var RetVal = entity.GetPartByFilter(part_Type_Id, outsource_Type_Id, part_Code, part_Name, unit_Id, category_Id, color_Id, material_Id, criticality_Id).ToList().Select(s => new GetPartByFilter_Result { Category_Id = s.Category_Id, Part_Type_Id = s.Part_Type_Id, Part_Name = s.Part_Name, Part_Id = s.Part_Id, Part_Code = s.Part_Code, Outsource_Type_Id = s.Outsource_Type_Id, Color_Id = s.Color_Id, Material_Id = s.Material_Id, Category_Name = s.Category_Name, Color_Name = s.Color_Name, Material_Name = s.Material_Name, Unit_Id = s.Unit_Id, Outsource_Type = s.Outsource_Type, Part_Type = s.Part_Type, Unit_Name = s.Unit_Name, Criticality_Id = s.Criticality_Id, Criticality_Name = s.Criticality_Name, Balance_Quantity = s.Balance_Quantity, Image_Id = s.Image_Id }).ToList(); return(RetVal); } }
public int UpdatePartStock(UpdatePartStock UpdatePartStock) { using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { entity.Database.ExecuteStoredProcedure(UpdatePartStock); return(Convert.ToInt32(UpdatePartStock.return_Status)); } }
public IHttpActionResult UpdatePartImage(VMImage PartImage) { var return_Status = new ObjectParameter("return_Status", typeof(int)); using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { entity.UpdatePartImage(PartImage.Parent_Id, PartImage.Image.Image_Data, PartImage.Image.LastModifiedBy, return_Status); return(Ok(return_Status.Value)); } }
public IHttpActionResult UpdateProduct(M_Product product) { var return_Status = new ObjectParameter("return_Status", typeof(int)); using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { entity.UpdateProduct(product.Product_Id, product.Product_Code, product.Product_Name, product.Manufacturing_Days, product.Description, product.LastModifiedBy, return_Status); return(Ok(return_Status.Value)); } }
public int DeleteCustomer(int Customer_Id, string LastModifiedBy) { var return_Status = new ObjectParameter("return_Status", typeof(int)); using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { entity.DeleteCustomer(Customer_Id, LastModifiedBy, return_Status); return(Convert.ToInt32(return_Status.Value)); } }
public IHttpActionResult UpdatePart(M_Part Part) { var return_Status = new ObjectParameter("return_Status", typeof(int)); using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { entity.UpdatePart(Part.Part_Id, Part.Part_Type_Id, Part.Outsource_Type_Id, Part.Part_Code, Part.Part_Name, Part.Unit_Id, Part.Category_Id, Part.Color_Id, Part.Material_Id, Part.Criticality_Id, Part.Min_Quantity, Part.LastModifiedBy, return_Status); return(Ok(return_Status.Value)); } }
public List <GetAllStore_Result> GetAllStore() { using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { var RetVal = entity.GetAllStore().ToList().Select(s => new GetAllStore_Result { Store_Id = s.Store_Id, Store_Name = s.Store_Name }).ToList(); return(RetVal); } }
public int AddUpdateCustomer(M_Customer Customer) { var return_Status = new ObjectParameter("return_Status", typeof(int)); using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { entity.UpdateCustomer(Customer.Customer_Id, Customer.Customer_Code, Customer.Customer_Name, Customer.Contact_No, Customer.Email, Customer.Address1, Customer.Address2, Customer.City, Customer.State, Customer.PinCode, Customer.TinNo, Customer.VatNo, Customer.Note, Customer.LastModifiedBy, return_Status); return(Convert.ToInt32(return_Status.Value)); } }
public List <GetAllCriticality_Result> GetAllCriticality() { using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { var RetVal = entity.GetAllCriticality().ToList().Select(s => new GetAllCriticality_Result { Criticality_Id = s.Criticality_Id, Criticality_Name = s.Criticality_Name }).ToList(); return(RetVal); } }
public List <GetAllOutsourceType_Result> GetAllOutsourceType() { using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { var RetVal = entity.GetAllOutsourceType().ToList().Select(s => new GetAllOutsourceType_Result { Outsource_Type = s.Outsource_Type, Outsource_Type_Id = s.Outsource_Type_Id }).ToList(); return(RetVal); } }
public List <GetAllMaterial_Result> GetAllMaterial() { using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { var RetVal = entity.GetAllMaterial().ToList().Select(s => new GetAllMaterial_Result { Material_Id = s.Material_Id, Material_Name = s.Material_Name }).ToList(); return(RetVal); } }
public List <GetImage_Result> GetImage(int Image_Id) { using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { var RetVal = entity.GetImage(Image_Id).ToList().Select(s => new GetImage_Result { Image_Data = s.Image_Data, Image_Id = s.Image_Id }).ToList(); return(RetVal); } }
public List <GetAllProduct_Result> GetAllProduct() { using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { var RetVal = entity.GetAllProduct().ToList().Select(s => new GetAllProduct_Result { Description = s.Description, Manufacturing_Days = s.Manufacturing_Days, Product_Code = s.Product_Code, Product_Id = s.Product_Id, Product_Name = s.Product_Name }).ToList(); return(RetVal); } }
public List <GetUserPermission_Result> GetUserPermission(string User_Name) { using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { var RetVal = entity.GetUserPermission(User_Name).ToList().Select(s => new GetUserPermission_Result { Window_Id = s.Window_Id, Role_Id = s.Role_Id, CanView = s.CanView, CanAdd = s.CanAdd, CanUpdate = s.CanUpdate, CanDelete = s.CanDelete, CanPrint = s.CanPrint, CanDownload = s.CanDownload, CanUpload = s.CanUpload }).ToList(); return(RetVal); } }
public List <GetAllCustomer_Result> GetAllCustomer() { using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { var RetVal = entity.GetAllCustomer().ToList().Select(s => new GetAllCustomer_Result { Customer_Code = s.Customer_Code, Customer_Id = s.Customer_Id, Customer_Name = s.Customer_Name, Address1 = s.Address1, Address2 = s.Address2, City = s.City, Contact_No = s.Contact_No, Email = s.Email, Note = s.Note, PinCode = s.PinCode, State = s.State, TinNo = s.TinNo, VatNo = s.VatNo }).ToList(); return(RetVal); } }
public List <GetStockPartDetailReport_Result> GetStockPartDetailReport(int?Part_Id) { using (InventoryToolDBEntities entity = new InventoryToolDBEntities()) { var RetVal = entity.GetStockPartDetailReport(Part_Id).ToList().Select(s => new GetStockPartDetailReport_Result { Part_Name = s.Part_Name, Part_Id = s.Part_Id, Action_Guid = s.Action_Guid, Date = s.Date, Description = s.Description, In_Quantity = s.In_Quantity, Out_Quantity = s.Out_Quantity, Part_Stock_Id = s.Part_Stock_Id, StoreTransferType_Id = s.StoreTransferType_Id, StoreTransferType_Name = s.StoreTransferType_Name, Store_Id = s.Store_Id, Store_Name = s.Store_Name, Image_Id = s.Image_Id }).ToList(); return(RetVal); } }