public UndeliveredPurchaseOrdersDepositsModel GetDataIntoModel() { UndeliveredPurchaseOrdersDepositsModel JForm = new UndeliveredPurchaseOrdersDepositsModel(); JForm.UndeliveredPurchaseOrdersDepositsDetailsData = new List <UndeliveredPurchaseOrdersDepositsEntity>(); //UnpaidSalesInvoiceEntity model = new UnpaidSalesInvoiceEntity(); //JForm.UnpaidSalesInvoiceData = model; foreach (var item in UndeliveredPurchaseOrdersDepositsDetailsEntity) { if (item.ID != null) { UndeliveredPurchaseOrdersDepositsEntity jEntity = new UndeliveredPurchaseOrdersDepositsEntity(); jEntity.ID = item.ID; jEntity.SupplierName = item.SupplierName; jEntity.OrderNo = "OPO-" + item.OrderNo; jEntity.UndeliveredAmount = item.UndeliveredAmount; jEntity.DepositAmount = item.DepositAmount; jEntity.OrderDate = item.OrderDate; jEntity.OrderDateTime = DateTime.ParseExact(item.OrderDate, DateFormat, null); if (item.ID != 0 && Convert.ToInt32(item.ID) > 0) { JForm.UndeliveredPurchaseOrdersDepositsDetailsData.Add(jEntity); } } } return(JForm); }
public int SaveUndeliveredPurchaseOrdersDepositsData(UndeliveredPurchaseOrdersDepositsModel JForm) { //int autoId = 0; // UnpaidSalesInvoice obj = new UnpaidSalesInvoice(); try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { UndeliveredPurchaseOrdersWithDeposit obj1; if (JForm.UndeliveredPurchaseOrdersDepositsDetailsData != null) { foreach (UndeliveredPurchaseOrdersDepositsEntity JEntity in JForm.UndeliveredPurchaseOrdersDepositsDetailsData) { //save entity value obj1 = new UndeliveredPurchaseOrdersWithDeposit(); obj1.S_ID = JEntity.ID; obj1.UPurchaseOrder_No = JEntity.OrderNo; obj1.UPurchaseOrder_Date = JEntity.OrderDateTime; obj1.UPurchaseOrder_Amount = JEntity.UndeliveredAmount; obj1.UPurchaseOrderDeposit_Amount = JEntity.DepositAmount; obj1.CreatedDate = DateTime.Now; obj1.IsDeleted = false; if (obj1 != null) { entities.UndeliveredPurchaseOrdersWithDeposits.Add(obj1); entities.SaveChanges(); } //if (entities.UndeliveredPurchaseOrdersWithDeposits.AsNoTracking().FirstOrDefault(x => x.ID == JEntity.ID) == null) //{ // entities.UndeliveredPurchaseOrdersWithDeposits.Add(obj1); // entities.SaveChanges(); //} //else //{ // entities.Entry(obj1).State = EntityState.Modified; // entities.SaveChanges(); //} } } else { } } return(1); } catch (Exception e) { return(0); throw e; } }
public string ValidateJournal() { string msg = string.Empty; UndeliveredPurchaseOrdersDepositsModel JForm = GetDataIntoModel(); //var tempInvoiceNumber = UndeliveredPurchaseRepository.IsChequeNoPresent(); //string result = JForm.UndeliveredPurchaseOrdersDepositsDetailsData.Where(x => x.OrderNo == tempInvoiceNumber).Select(x => x.OrderNo).FirstOrDefault(); //if (result != null) //{ // msg = "Entry against Cheque No is already done"; //} //return msg; List <string> ListInvoiceNumber = UndeliveredPurchaseRepository.IsChequeNoPresent(); List <string> InsideList = JForm.UndeliveredPurchaseOrdersDepositsDetailsData.Select(x => x.OrderNo).ToList(); List <string> PINumberList = InsideList.Distinct().ToList(); foreach (var item in JForm.UndeliveredPurchaseOrdersDepositsDetailsData) { if (InsideList.Count != PINumberList.Count) { msg = "Two Invoice Number Should Not Be Same"; //this.CASErrors =msg; break; } if (ListInvoiceNumber == null) { msg = "No Entry is done till Now"; //this.CASErrors=msg; break; } if (ListInvoiceNumber.Contains(item.OrderNo)) { msg = "Entry against Cheque No is already done "; // this.CASErrors = msg; break; } } return(msg); }
public void SaveUndeliveredPurchase(object param) { MessageBoxResult result = System.Windows.MessageBox.Show("Do you want to save changes?", "Save Confirmation", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait; string msg = ValidateJournal(); if (msg != string.Empty && msg != "No Entry is done till Now") { CASErrors = msg; Mouse.OverrideCursor = null; return; } CASErrors = string.Empty; UndeliveredPurchaseOrdersDepositsModel JForm = GetDataIntoModel(); UndeliveredPurchaseRepository.SaveUndeliveredPurchaseOrdersDepositsData(JForm); Mouse.OverrideCursor = null; } }
public int SaveUndeliveredPurchaseOrdersDepositsData(UndeliveredPurchaseOrdersDepositsModel JForm) { IUndeliveredPurchaseOrdersDepositsBL obj = new UndeliveredPurchaseOrdersDepositsBL(); return(obj.SaveUndeliveredPurchaseOrdersDepositsData(JForm)); }