private void button1_Click_1(object sender, EventArgs e)
{
// NPDanhsachnhavantai
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
// var rs1 = Model.MKT.danhsachkhoMKT(dc);
// string storeright = Model.Username.getmaquyenkho();
var rs1 = Model.MKT.danhsachkhoMKTRight(dc);
Viewtable viewtbl = new Viewtable(rs1, dc, "DANH SÁCH STORE rIGHT", 15, "MKT_kHORIGHT");// mã 15 là danh sach STORE Right
viewtbl.ShowDialog();
}
private void button3_Click_1(object sender, EventArgs e)
{
if (this.ionumber == "")
{
MessageBox.Show("Please nhập IO number ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtionumber.Focus();
return;
}
if (txtchargetoaccount.Text == "")
{
MessageBox.Show("Please nhập Account charge to ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtchargetoaccount.Focus();
return;
}
if (txtcostcenter.Text == "")
{
MessageBox.Show("Please nhập Cost center ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtcostcenter.Focus();
return;
}
//check if payment natf đã request ? // một khách hàng 1/ 1 iio chỉ một lần request
#region q List các document có trong bảng tbl_MKT_Payment_AprovalTMP không có trong bảng tbl_MKT_Payment_Aproval !
//---
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
var q = from paymenttemp in dc.tbl_MKT_Payment_AprovalTMPs
where (from payment in dc.tbl_MKT_Payment_Aprovals
select payment.Customercode).Contains(paymenttemp.Customercode) &&
(from payment in dc.tbl_MKT_Payment_Aprovals
select payment.IO_number).Contains(paymenttemp.IO_number)
select paymenttemp;
if (q.Count() != 0)
{
Viewtable viewtbl = new Viewtable(q, dc, "List các payment request đã lập request rồi, please check", 100, "paymentrequest");
viewtbl.ShowDialog();
return;
}
var q2 = from p in dc.tbl_MKT_Payment_AprovalTMPs
where p.username == username
select p;
if (q2.Count() == 0)
{
MessageBox.Show("Please nhập nhập chi tiết request ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
btiosetup.Focus();
return;
}
#endregion q
//update head IOpayment
var newpaymentrequest = (from p in dc.tbl_MKT_Payment_Aproval_heads
where p.IO_number == "TMP" && p.username == username
select p).FirstOrDefault();
if (newpaymentrequest != null)
{
newpaymentrequest.IO_number = Utils.Truncate(txtionumber.Text, 50);
newpaymentrequest.payID = this.payID;
newpaymentrequest.Account = Utils.Truncate(txtchargetoaccount.Text, 50);
newpaymentrequest.costcenter = Utils.Truncate(txtcostcenter.Text, 50);
newpaymentrequest.Requestby = username;
newpaymentrequest.ProgrameIDDocno = Utils.Truncate(txtsohieuct.Text, 225);
newpaymentrequest.ProgrameName = Utils.Truncate(txttenct.Text, 50);
newpaymentrequest.Approval = "Not Approved";
newpaymentrequest.TotalAprovalBudget = this.totalBudget;
dc.SubmitChanges();
}
else
{
MessageBox.Show("Pleae check IO payment ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
btiosetup.Focus();
return;
}
// tbl_MKT_Payment_Aproval_head newpaymentrequest = new tbl_MKT_Payment_Aproval_head();
// udate payment progarme
var tmprequest = from p in dc.tbl_MKT_Payment_AprovalTMPs
where p.username == username
select p;
foreach (var item in tmprequest)
{
tbl_MKT_Payment_Aproval newpaymentRQ = new tbl_MKT_Payment_Aproval();
newpaymentRQ.IO_number = Utils.Truncate(txtionumber.Text, 50);
newpaymentRQ.payID = this.payID;
newpaymentRQ.Account = Utils.Truncate(txtchargetoaccount.Text, 50);
newpaymentRQ.costcenter = Utils.Truncate(txtcostcenter.Text, 50);
newpaymentRQ.Requestby = username;
newpaymentRQ.AprovalBudget = item.AprovalBudget;
newpaymentRQ.Customercode = item.Customercode;
newpaymentRQ.CustomerName = item.CustomerName;
newpaymentRQ.CustomerAddress = item.CustomerAddress;
newpaymentRQ.ProgrameIDDocno = Utils.Truncate(txtsohieuct.Text, 50);
newpaymentRQ.Requsestdate = txtfromdate.Value;
newpaymentRQ.Approval = "Not Approved";
dc.tbl_MKT_Payment_Aprovals.InsertOnSubmit(newpaymentRQ);
dc.SubmitChanges();
}
MessageBox.Show("Upload payment done ! ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
blanknewpayment();
}
