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);
}
}
