private void chkDiscontinue_Click(object sender, RoutedEventArgs e) { //rcv.getcheck(e); try { CheckBox checkBox = (CheckBox)e.OriginalSource; DataGridRow dataGridRow = FindAncestor <DataGridRow>(checkBox); int i = dataGrid1.SelectedIndex; if (App.Current.Properties["getAllSupplierList"] != null) { ListGrid1 = App.Current.Properties["getAllSupplierList"] as ObservableCollection <SuppPaymentModel>; } SuppPaymentModel produit1 = (SuppPaymentModel)dataGridRow.DataContext; if ((bool)checkBox.IsChecked) { ListGrid1[i].ischecck = true; amount = Convert.ToDecimal(produit1.PENDING_AMT) + amount; produit1.ischecck = true; } else { ListGrid1[i].ischecck = false; amount = amount - Convert.ToDecimal(produit1.PENDING_AMT); produit1.ischecck = false; } App.Current.Properties["getAllSupplierList"] = ListGrid1; //SelectedItem.getAllSupplier = ListGrid1; SELECTED_AMT.Text = amount.ToString(); //dataGrid1.ItemsSource = ListGrid1; //TOTAL_PANDING.Text = amount.ToString(); //produit1.TOTAL_REC_AMT1 = amount; App.Current.Properties["Supppendamt"] = amount; //if (App.Current.Properties["GEtSupplierName"] != null) //{ // textBox1.Text = App.Current.Properties["GEtSupplierName"].ToString(); //} if (App.Current.Properties["getTotalPending"] != null) { TOTAL_PANDING.Text = App.Current.Properties["getTotalPending"].ToString(); PENDING_AFTE_PAYMENT.Text = App.Current.Properties["getTotalPending"].ToString(); } } catch (Exception ex) { } }
public BankViewModel() { SelectedItem = new SuppPaymentModel(); var comp = Convert.ToInt32(App.Current.Properties["Company_Id"].ToString()); if (App.Current.Properties["Action"].ToString() == "Edit") { CreatVisible = "Collapsed"; UpdVisible = "Visible"; selectedBank = App.Current.Properties["BankEdit"] as BankModel; App.Current.Properties["Action"] = ""; } else { UpdVisible = "Collapsed"; CreatVisible = "Visible"; selectedBank = new BankModel(); selectedBankAC = new BankAccountModel(); GetBank(comp); GetBankAC(comp); } }
public HttpResponseMessage UpdateSuppPayment(SuppPaymentModel _SuppPaymentModel) { try { bool conn = false; conn = db.Database.Exists(); if (!conn) { ConnectionTools.changeToLocalDB(db); conn = db.Database.Exists(); } if (conn) { var SuppPay = (from a in db.TBL_SUPP_PAYMENT where a.SUPP_PAYMENT == _SuppPaymentModel.SUPP_PAYMENT select a).FirstOrDefault(); SuppPay.BUSINESS_LOCATION = _SuppPaymentModel.BUSINESS_LOCATION; SuppPay.SUPP_ID = _SuppPaymentModel.SUPP_ID; SuppPay.SUPP = _SuppPaymentModel.SUPP; SuppPay.SUPP_EMAIL = _SuppPaymentModel.SUPP_EMAIL; SuppPay.SUPP_SMS = _SuppPaymentModel.SUPP_SMS; SuppPay.IS_SEND_EMAIL = _SuppPaymentModel.IS_SEND_EMAIL; SuppPay.IS_SEND_SMS = _SuppPaymentModel.IS_SEND_SMS; SuppPay.CURRENT_ADV_AMT = _SuppPaymentModel.CURRENT_ADV_AMT; SuppPay.TOTAL_RIE_AMT = _SuppPaymentModel.TOTAL_RIE_AMT; SuppPay.PENDING_AMT = _SuppPaymentModel.PENDING_AMT; SuppPay.PAYMENT_NUMBER = _SuppPaymentModel.PAYMENT_NUMBER; SuppPay.PAYMENT_DATE = System.DateTime.Now; SuppPay.CURRENT_PAYABLE_AMT = _SuppPaymentModel.CURRENT_PAYABLE_AMT; SuppPay.TOTAL_PANDING = _SuppPaymentModel.TOTAL_PANDING; SuppPay.SELECTED_AMT = _SuppPaymentModel.SELECTED_AMT; SuppPay.PENDING_AFTE_PAYMENT = _SuppPaymentModel.PENDING_AFTE_PAYMENT; SuppPay.CASH_REG_ID = _SuppPaymentModel.CASH_REG_ID; SuppPay.CASH_REG = _SuppPaymentModel.CASH_REG; SuppPay.CASH_REG_AMT = _SuppPaymentModel.CASH_REG_AMT; SuppPay.CHEQUE_AMT = _SuppPaymentModel.CHEQUE_AMT; SuppPay.CHEQUE_NO = _SuppPaymentModel.CHEQUE_NO; SuppPay.CHEQUE_BANK_BRANCH = _SuppPaymentModel.CHEQUE_BANK_BRANCH; SuppPay.CHEQUE_BANK_AC = _SuppPaymentModel.CHEQUE_BANK_AC; SuppPay.CHEQUE_DATE = _SuppPaymentModel.CHEQUE_DATE; SuppPay.TRANSFER_AMT = _SuppPaymentModel.TRANSFER_AMT; SuppPay.TRANSFER_BANK_BRANCH = _SuppPaymentModel.TRANSFER_BANK_BRANCH; SuppPay.TRANSFER_BANK_AC = _SuppPaymentModel.TRANSFER_BANK_AC; SuppPay.TRANSFER_DATE = _SuppPaymentModel.TRANSFER_DATE; SuppPay.FINANCAL_AMT = _SuppPaymentModel.FINANCAL_AMT; SuppPay.FINACIAL_AC = _SuppPaymentModel.FINACIAL_AC; SuppPay.DISCOUNT_FLAT = _SuppPaymentModel.DISCOUNT_FLAT; SuppPay.DISCOUNT_PERCENT = _SuppPaymentModel.DISCOUNT_PERCENT; SuppPay.TOTAL_PAYMENT_MODES = _SuppPaymentModel.TOTAL_PAYMENT_MODES; SuppPay.CURRENT_PAYMENT = _SuppPaymentModel.CURRENT_PAYMENT; SuppPay.NOTE = _SuppPaymentModel.NOTE; SuppPay.IS_PRINT_CHECK = _SuppPaymentModel.IS_PRINT_CHECK; SuppPay.IS_DELETE = false; SuppPay.COMPANY_ID = _SuppPaymentModel.COMPANY_ID; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "success")); } else { return(Request.CreateResponse(HttpStatusCode.ExpectationFailed)); } } catch (Exception ex) { throw; } finally { ConnectionTools.ChangeToRemoteDB(db); } }
public HttpResponseMessage CreateSuppPayment(SuppPaymentModel _SuppPaymentModel) { try { bool conn = false; conn = db.Database.Exists(); if (!conn) { ConnectionTools.changeToLocalDB(db); conn = db.Database.Exists(); } if (conn) { TBL_SUPP_PAYMENT SuppPay = new TBL_SUPP_PAYMENT();; SuppPay.BUSINESS_LOCATION = _SuppPaymentModel.BUSINESS_LOCATION; SuppPay.SUPP_PAYMENT = _SuppPaymentModel.SUPP_PAYMENT; SuppPay.SuppPayNo = _SuppPaymentModel.SUPP_pay_no; SuppPay.SUPP_ID = _SuppPaymentModel.SUPP_ID; SuppPay.SUPP = _SuppPaymentModel.SUPP; SuppPay.SUPP_EMAIL = _SuppPaymentModel.SUPP_EMAIL; SuppPay.SUPP_SMS = _SuppPaymentModel.SUPP_SMS; SuppPay.IS_SEND_EMAIL = _SuppPaymentModel.IS_SEND_EMAIL; SuppPay.IS_SEND_SMS = _SuppPaymentModel.IS_SEND_SMS; SuppPay.CURRENT_ADV_AMT = _SuppPaymentModel.CURRENT_ADV_AMT; SuppPay.TOTAL_RIE_AMT = _SuppPaymentModel.TOTAL_RIE_AMT; SuppPay.PENDING_AMT = _SuppPaymentModel.PENDING_AMT; SuppPay.PAYMENT_NUMBER = _SuppPaymentModel.PAYMENT_NUMBER; SuppPay.PAYMENT_DATE = System.DateTime.Now; SuppPay.CURRENT_PAYABLE_AMT = _SuppPaymentModel.CURRENT_PAYABLE_AMT; SuppPay.TOTAL_PANDING = _SuppPaymentModel.TOTAL_PANDING; SuppPay.SELECTED_AMT = _SuppPaymentModel.SELECTED_AMT; SuppPay.PENDING_AFTE_PAYMENT = _SuppPaymentModel.PENDING_AFTE_PAYMENT; SuppPay.CASH_REG_ID = _SuppPaymentModel.CASH_REG_ID; SuppPay.CASH_REG = _SuppPaymentModel.CASH_REG; SuppPay.CASH_REG_AMT = _SuppPaymentModel.CASH_REG_AMT; SuppPay.CHEQUE_AMT = _SuppPaymentModel.CHEQUE_AMT; SuppPay.CHEQUE_NO = _SuppPaymentModel.CHEQUE_NO; SuppPay.CHEQUE_BANK_BRANCH = _SuppPaymentModel.CHEQUE_BANK_BRANCH; SuppPay.CHEQUE_BANK_AC = _SuppPaymentModel.CHEQUE_BANK_AC; //SuppPay.CHEQUE_DATE = _SuppPaymentModel.CHEQUE_DATE; SuppPay.CHEQUE_DATE = DateTime.Now; SuppPay.TRANSFER_AMT = _SuppPaymentModel.TRANSFER_AMT; SuppPay.TRANSFER_BANK_BRANCH = _SuppPaymentModel.TRANSFER_BANK_BRANCH; SuppPay.TRANSFER_BANK_AC = _SuppPaymentModel.TRANSFER_BANK_AC; //SuppPay.TRANSFER_DATE = _SuppPaymentModel.TRANSFER_DATE; SuppPay.TRANSFER_DATE = System.DateTime.Now; SuppPay.FINANCAL_AMT = _SuppPaymentModel.FINANCAL_AMT; SuppPay.FINACIAL_AC = _SuppPaymentModel.FINACIAL_AC; SuppPay.DISCOUNT_FLAT = _SuppPaymentModel.DISCOUNT_FLAT; SuppPay.DISCOUNT_PERCENT = _SuppPaymentModel.DISCOUNT_PERCENT; SuppPay.TOTAL_PAYMENT_MODES = _SuppPaymentModel.TOTAL_PAYMENT_MODES; SuppPay.CURRENT_PAYMENT = _SuppPaymentModel.CURRENT_PAYMENT; SuppPay.NOTE = _SuppPaymentModel.NOTE; SuppPay.IS_DELETE = false; SuppPay.IS_PRINT_CHECK = _SuppPaymentModel.IS_PRINT_CHECK; SuppPay.COMPANY_ID = _SuppPaymentModel.COMPANY_ID; SuppPay.USER_ID = _SuppPaymentModel.USER_ID; db.TBL_SUPP_PAYMENT.Add(SuppPay); db.SaveChanges(); if (_SuppPaymentModel.getAllSupplier.Count > 0) { foreach (var item in _SuppPaymentModel.getAllSupplier) { var str = (from a in db.tbl_supppaydetails where a.Supp_ID == _SuppPaymentModel.SUPP_ID && a.totalamount == item.TOTAL_AMT && a.pendingamoun == item.PENDING_AMT && a.adjustedamount == item.ROUND_OFF_ADJUSTMENTAMT select a).FirstOrDefault(); if (str != null) { str.Supp_ID = _SuppPaymentModel.SUPP_ID; str.adjustedamount = item.ROUND_OFF_ADJUSTMENTAMT; str.pendingamoun = item.PENDING_AMT; str.totalamount = item.TOTAL_AMT; db.SaveChanges(); } else { tbl_supppaydetails suppdeatils = new tbl_supppaydetails(); suppdeatils.Supp_ID = _SuppPaymentModel.SUPP_ID; suppdeatils.adjustedamount = item.ROUND_OFF_ADJUSTMENTAMT; suppdeatils.pendingamoun = item.PENDING_AMT; suppdeatils.totalamount = item.TOTAL_AMT; db.tbl_supppaydetails.Add(suppdeatils); db.SaveChanges(); } } } return(Request.CreateResponse(HttpStatusCode.OK, "success")); } else { return(Request.CreateResponse(HttpStatusCode.ExpectationFailed)); } } catch (Exception ex) { throw; } finally { ConnectionTools.ChangeToRemoteDB(db); } }