public List<PurchaseRequisitionNoteModel> GetAllData() { try { using (_context = new HSSNInventoryEntities()) { var data = _context.PurchaseRequisitionNotes.Select(a => new PurchaseRequisitionNoteModel() { PurchaseRequisitionNoteId = a.PurchaseRequisitionNoteId, PrnNumber = a.PrnNumber, CreatedBy = a.PrnNumber, Reason = a.Reason, IsApprovedByGM = a.IsApprovedByGM, ApproverId = a.ApproverId, DateOfApproved = a.DateOfApproved }).ToList(); return data; } } catch (Exception e) { Console.WriteLine(e); throw; } }
public int saveData(FinanceDispatchModel model) { try { using (_context = new HSSNInventoryEntities()) { var addModel = new FinanceDispatch() { DispatchOrderId = model.DispatchOrderId, EntryDate = model.EntryDate, CreatedDate = model.CreatedDate, CreatedBy = model.CreatedBy, }; _context.Entry(addModel).State = EntityState.Added; _context.SaveChanges(); model.FinanceDispatchId = addModel.FinanceDispatchId; return model.FinanceDispatchId; } } catch (Exception e) { //Console.WriteLine(e); return 0; } }
public int EditIssueMaterial(IssueMaterialModel model) { try { using (_context = new HSSNInventoryEntities()) { var editModel = _context.IssueMaterials.FirstOrDefault(a => a.IssueProductMaterilId == model.IssueProductMaterilId); if (editModel != null) { editModel.IssueProductMaterilId = model.IssueProductMaterilId; editModel.Issuedcode = model.Issuedcode; editModel.Issuedby = model.Issuedby; editModel.BillOfMaterialId = model.BillOfMaterialId; editModel.IssueRemarks = model.IssueRemarks; } _context.Entry(editModel).State = EntityState.Modified; _context.SaveChanges(); return editModel.IssueProductMaterilId; } } catch (Exception e) { Console.WriteLine(e); throw; } }
public bool EditData(MODEL.FinanceDispatchModel model) { try { using (_context = new HSSNInventoryEntities()) { var data = _context.FinanceDispatches.FirstOrDefault(a => a.FinanceDispatchId == model.FinanceDispatchId); data.DispatchOrderId = model.DispatchOrderId; data.EntryDate = model.EntryDate; data.CreatedDate = model.CreatedDate; data.CreatedBy = model.CreatedBy; _context.Entry(data).State = EntityState.Modified; _context.SaveChanges(); return true; } } catch (Exception e) { //Console.WriteLine(e); return false; } }
public bool EditIssueproductionDetail(List<IssueMaterialDetailModel> modellist, int Issueproductionmaterialid) { try { using (_context = new HSSNInventoryEntities()) { foreach (var issueproductiondetail in modellist) { var model = new IssueProductMaterialDetail() { IssueProductMaterialDetailId=issueproductiondetail.IssueProductMaterialDetailId, IssueProductMaterialId = Issueproductionmaterialid, ProductMaterialId = issueproductiondetail.ProductMaterialId, OrderedQty = issueproductiondetail.OrderedQty, ReturnQty = issueproductiondetail.ReturnQty, IssuedQty = issueproductiondetail.IssuedQty, }; _context.Entry(model).State = EntityState.Modified; _context.SaveChanges(); } return true; } } catch (Exception e) { Console.WriteLine(e); throw; } }
public GoodReceivedNoteModel GetAllDataBYId(int Joborderid) { try { using (_context= new HSSNInventoryEntities() ) { var data = _context.GoodReceivedNotes.Where(a => a.JobOrderId == Joborderid) .Select(a => new GoodReceivedNoteModel() { GoodReceivedNoteId = a.GoodReceivedNoteId, GoodReceivedDate = a.GoodReceivedDate, GoodRecievedBy = a.GoodReceivedBy, CreatedBy = a.CreatedBy, CreatedDate = a.CreatedDate, ModifiedBy = a.ModifiedBy, ModifiedDate = a.ModifiedDate, }).FirstOrDefault(); return data; } } catch (Exception ex) { Console.WriteLine(ex); return new GoodReceivedNoteModel(); } }
public ProductModel GetProductDetailByProductId(int productId) { using (_context = new HSSNInventoryEntities()) { try { var data = _context.Products.Where(b => b.ProductId == productId).Select(a => new ProductModel() { ProductId = a.ProductId, BrandId = a.BrandId, CreatedBy = a.CreatedBy, CreatedDate = a.CreatedDate, ExerciseDuty = a.ExerciseDuty, FlavourId = a.FlavourId, IsVat = a.IsVat, ModifiedBy = a.ModifiedBy, ModifiedDate = a.ModifiedDate, PacketPerCartoon = a.PacketPerCartoon }).FirstOrDefault(); return data; } catch (Exception) { return new ProductModel(); } } }
public ProductStockModel GetInfo(int ProductId, int OrganisationId, int WareHouseid) { try { using (_context = new HSSNInventoryEntities()) { var data = (from a in _context.ProductStocks.ToList() where a.ProductId == ProductId && a.OrganisationId == OrganisationId && a.WareHouseId == WareHouseid select new ProductStockModel() { ProductId = a.ProductId, OrganisationId = a.OrganisationId, WareHouseId = a.WareHouseId, }).FirstOrDefault(); if (data != null) return data; else return new ProductStockModel(); } } catch (Exception e) { Console.WriteLine(e); throw; } }
public List<ProductModel> GetdataByProductId(int Productid) { try { using (_context = new HSSNInventoryEntities()) { var data = (from a in _context.Products join b in _context.DispatchOrderDetails on a.ProductId equals b.ProductId join c in _context.DispatchOrders on b.DispatchOrderId equals c.DispatchOrderId where a.ProductId==Productid select new ProductModel() { ProductId = a.ProductId, ProductName = a.ProductName, IsCheckedByManager = c.IsCheckedByManager, WhetherDoApproved = c.WhetherDoApproved, Quantity =b.Quantity, Rate=b.Rate, }).ToList(); return data; } } catch (Exception) { throw; } }
public MODEL.ProductionMaterialModel Save(MODEL.ProductionMaterialModel model) { try { using (_context = new HSSNInventoryEntities()) { var addmodel = new ProductionMaterial() { MaterialName = model.MaterialName, Description = model.Description, MaterialType = model.MaterialType, UnitOfMeasurementId = model.UnitOfMeasurementId }; _context.Entry(addmodel).State = EntityState.Added; _context.SaveChanges(); model.ProductionMaterialId = addmodel.ProductionMaterialId; return model; } } catch (Exception aException) { return new ProductionMaterialModel(); } }
public List<ProductModel> GetAllProduct() { using (_context = new HSSNInventoryEntities()) { try { var data = _context.Products.Select(a => new ProductModel() { ProductId = a.ProductId, ProductName = a.ProductName, BrandId = a.BrandId, CreatedBy = a.CreatedBy, CreatedDate = a.CreatedDate, ExerciseDuty = a.ExerciseDuty, FlavourId = a.FlavourId, IsVat = a.IsVat, ModifiedBy = a.ModifiedBy, ModifiedDate = a.ModifiedDate, PacketPerCartoon = a.PacketPerCartoon }).ToList(); return data; } catch (Exception) { return new List<ProductModel>(); } } }
public List<BillOFMaterialModel> GetAllData() { try { using (_context = new HSSNInventoryEntities()) { var data = _context.BillOfMaterials.Select(a => new BillOFMaterialModel() { BillOfMaterialId = a.BillOfMaterialId, BillOfmaterialCode = a.BillOfmaterialCode, ProductId = a.ProductId, BatchQuantity = a.BatchQuantity, CartoonQuantity = a.CartoonQuantity, IsIssued = a.IsIssued, PreparedBy = a.PreparedBy, PreparedDate = a.PreparedDate, }).ToList(); return data; } } catch (Exception e) { Console.WriteLine(e); throw; } }
public List<MODEL.BillOfMaterialModel> GetAllNormTemplateByProductID(int productid, int batchquantity, int cartoonquantity) { try { using (_context = new HSSNInventoryEntities()) { var data = (from a in _context.Products join b in _context.ProductNormTemplates on a.ProductId equals b.ProductId join c in _context.ProductNormTemplateDetails on b.ProductNormTemplateId equals c.ProductNormTemplateId join d in _context.ProductionMaterials on c.ProductionMaterialId equals d.ProductionMaterialId join e in _context.SubProducts on c.SubProductId equals e.SubProductId where a.ProductId == productid select new BillOfMaterialModel() { ProductMaterialId = d.ProductionMaterialId, ProductId = a.ProductId, SubProductId = e.SubProductId, subProductName = e.SubProductName, ProductMaterialName = d.MaterialName, BatchQuantity = c.BatchQuantity * batchquantity, CartoonQuantity = c.CartoonQuantity * cartoonquantity, }).ToList(); return data; } } catch (Exception) { throw; } }
public List<UserProfileModel> GetProfileData() { try { using (_context = new HSSNInventoryEntities()) { var data = _context.UserProfiles.Select(b => new UserProfileModel() { ProfileId = b.ProfileId, ProfileName = b.ProfileName, ProfileDesc = b.ProfileDesc, CreatedDate = b.CreatedDate, CreatedBy = b.CreatedBy }).ToList(); return data; } } catch (Exception ex) { Console.WriteLine(); throw ex; } }
public int editJobOrder(JobOrderModel model) { try { using (_context = new HSSNInventoryEntities()) { var editModel = _context.JobOrders.FirstOrDefault(a => a.JobOrderId == model.JobOrderId); if (editModel != null) { //editModel.DealerId = model.DealerId; //editModel.JobOrderDate = model.JobOrderDate; //editModel.Description = model.Description; //editModel.PreparedBy = model.PreparedBy; editModel.IsApproved = model.IsApproved; editModel.ApprovedBy = model.ApprovedBy; //editModel.ModifiedDate = model.ModifiedDate; //editModel.ApprovedDate = model.ApprovedDate; } _context.Entry(editModel).State = EntityState.Modified; _context.SaveChanges(); return model.JobOrderId; } } catch (Exception e) { Console.WriteLine(e); return 0; } }
public int EditGoodReceivedNote(GoodReceivedNoteModel model) { try { using (_context= new HSSNInventoryEntities() ) { var editModel = _context.GoodReceivedNotes.FirstOrDefault(a => a.GoodReceivedNoteId == model.GoodReceivedNoteId); if (editModel != null) { editModel.GoodReceivedBy = model.GoodRecievedBy; editModel.GoodReceivedDate = model.GoodReceivedDate; editModel.CreatedBy = model.CreatedBy; editModel.CreatedDate = model.CreatedDate; } _context.Entry(editModel).State = EntityState.Modified; _context.SaveChanges(); return model.GoodReceivedNoteId; } } catch (Exception e) { Console.WriteLine(e); return 0; } }
public List<ProductStockModel> GetAllProductDatabyWarehouseID(int warehouseid) { try { using (_context = new HSSNInventoryEntities()) { var data = (from a in _context.ProductStocks join b in _context.Products on a.ProductId equals b.ProductId where a.WareHouseId == warehouseid select new ProductStockModel() { ProductId = a.ProductId, ProductName = b.ProductName, CurrentStock = a.CurrentStock }).ToList(); return data; } } catch (Exception e) { Console.WriteLine(e); throw; } }
public Boolean EditPurchaseRequisitionNoteSumamry(PurchaseRequisitionNoteModel prnModel) { using (_context = new HSSNInventoryEntities()) { try { var data = _context.PurchaseRequisitionNotes.FirstOrDefault( a => a.PurchaseRequisitionNoteId == prnModel.PurchaseRequisitionNoteId); if (data != null) { data.PrnNumber = prnModel.PrnNumber; data.CreatedBy = prnModel.PrnNumber; data.Reason = prnModel.Reason; data.IsApprovedByGM = prnModel.IsApprovedByGM; data.ApproverId = prnModel.ApproverId; data.DateOfApproved = prnModel.DateOfApproved; } _context.Entry(data).State = EntityState.Modified; _context.SaveChanges(); //dispatchOrderModel.DispatchOrderId =data.DispatchOrderId; return true; } catch (Exception e) { Console.WriteLine(e); return false; //new DispatchOrderModel(); } } }
public bool SaveFinanceDispatchDetail(List<FinanceDispatchDetailModel> financeDispatchDetailModelsList, int FinanceDispatchid) { using (_context=new HSSNInventoryEntities()) { try { foreach (var rowData in financeDispatchDetailModelsList) { var model = new FinanceDispatchDetail() { FinanceDispatchId = FinanceDispatchid, ProductId = rowData.ProductId, DispatchFromWareHouseId = rowData.DispatchFromWareHouseId, DispatchOrderId = rowData.DispatchOrderId, Quantity = rowData.Quantity, Rate = rowData.Rate, ExcessShortageQuantity = rowData.ExcessShortageQuantity, UnitOfMeasurementId = rowData.UnitOfMeasurementId, }; _context.Entry(model).State=EntityState.Added; } _context.SaveChanges(); return true; } catch (Exception) { throw; } } }
public List<FinanceDispatchDetailModel> GetAllFinanceDispatchDetailBydealerId(int dealerid,int WareHouseId) { try { using (_context= new HSSNInventoryEntities() ) { var data = (from a in _context.Dealers join b in _context.DispatchOrders on a.DealerId equals b.DealerId join c in _context.FinanceDispatchDetails on b.DispatchOrderId equals c.DispatchOrderId join d in _context.Products on c.ProductId equals d.ProductId join E in _context.FinanceDispatches on c.FinanceDispatchId equals E.FinanceDispatchId where a.DealerId == dealerid && c.DispatchFromWareHouseId==WareHouseId select new FinanceDispatchDetailModel() { FinanceDispatchId = E.FinanceDispatchId, DispatchOrderId = b.DispatchOrderId, ProductId = c.ProductId, ProductName = d.ProductName, DispatchFromWareHouseId = c.DispatchFromWareHouseId, Quantity = c.Quantity, ExcessShortageQuantity = c.ExcessShortageQuantity, UnitOfMeasurementId = c.UnitOfMeasurementId, Rate = c.Rate, }).ToList(); return data; } } catch (Exception) { throw; } }
public List<UserDetailModel> GetAllUserDetailData() { try { using (_context= new HSSNInventoryEntities() ) { var data = _context.UserDetails.Select(a => new UserDetailModel() { UserDetailId = a.UserDetailId, Name = a.Name, Address = a.Address, Telephone = a.Telephone, EmailId = a.EmailId, UserName = a.UserName, Password = a.Password, DisplayName = a.DisplayName, OrganisationId = a.OrganisationId, CreatedDate = a.CreatedDate, CreatedBy = a.CreatedBy, ProfileId = a.ProfileId, }).ToList(); return data; } } catch (Exception e) { Console.WriteLine(e); throw; } }
public int EditUserDetail(UserDetailModel model) { try { using (_context = new HSSNInventoryEntities()) { var editModel = _context.UserDetails.FirstOrDefault(a => a.UserDetailId == model.UserDetailId); if (editModel != null) { editModel.Name = model.Name; editModel.Address = model.Address; editModel.Telephone = model.Telephone; editModel.EmailId = model.EmailId; editModel.UserName = model.UserName; editModel.Password = model.Password; editModel.DisplayName = model.DisplayName; editModel.OrganisationId = model.OrganisationId; editModel.CreatedBy = model.CreatedBy; editModel.CreatedDate = model.CreatedDate; editModel.ProfileId = model.ProfileId; } _context.Entry(editModel).State = EntityState.Modified; _context.SaveChanges(); return 1; } } catch (Exception e) { Console.WriteLine(e); throw; } }
public void DeleteUserDetail(int UserDetailId) { using (_context= new HSSNInventoryEntities() ) { var data = _context.UserDetails.FirstOrDefault(a => a.UserDetailId == UserDetailId); _context.Entry(data).State = EntityState.Deleted; _context.SaveChanges(); } }
public bool DeleteDetail(int JoborderID) { try { using (_context = new HSSNInventoryEntities()) { _context.Database.ExecuteSqlCommand("DeleteJobOrderDetailByJobOrderId @joborderid", new SqlParameter("@joborderid", JoborderID)); return true; } } catch (Exception) { throw; } }
public bool DeleteUserDetail(int ProfileId) { try { using (_context= new HSSNInventoryEntities() ) { _context.Database.ExecuteSqlCommand("DeleteUserDetailDataByProfileId @ProfileId", new SqlParameter("@ProfileId", ProfileId)); return true; } } catch (Exception) { throw; } }
public bool DeleteGrnDetail(int GoodReceivedNoteId) { try { using (_context= new HSSNInventoryEntities() ) { _context.Database.ExecuteSqlCommand("DeleteGRNDetailByGoodReceivedNoteId @goodReceivedNoteId", new SqlParameter("@goodReceivedNoteId", GoodReceivedNoteId)); return true; } } catch (Exception) { throw; } }
public bool Delete(int brandId) { try { using (_context = new HSSNInventoryEntities()) { var deleteModel = _context.Flavours.FirstOrDefault(a => a.FlavourId == brandId); _context.Entry(deleteModel).State = EntityState.Deleted; _context.SaveChanges(); return true; } } catch (Exception e) { Console.WriteLine(e); return false; } }
public Boolean Delete(int unitId) { try { using (_context= new HSSNInventoryEntities() ) { var data = _context.UnitOfMeasurements.FirstOrDefault(a => a.UnitOfMeasurementId == unitId); _context.Entry(data).State = EntityState.Deleted; _context.SaveChanges(); return true; } } catch (Exception e) { return false; } }
public List<MODEL.BrandModel> GetAllBrands() { using (_context = new HSSNInventoryEntities()) { try { var data = _context.Brands.Select(a => new BrandModel() { BrandId = a.BrandId, BrandName = a.BrandName, Description = a.Description }).ToList(); return data; } catch (Exception) { return new List<BrandModel>(); } } }
public List<MODEL.FlavourModel> GetAllFlavours() { using (_context = new HSSNInventoryEntities()) { try { var data = _context.Flavours.Select(a => new FlavourModel() { FlavourId = a.FlavourId, FlavourName = a.FlavourName, Description = a.Description }).ToList(); return data; } catch (Exception) { return new List<FlavourModel>(); } } }