private void bt_exporttoex_Click(object sender, EventArgs e)
{
Control_ac ctrex = new Control_ac();
//string connection_string = Utils.getConnectionstr();
//LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
//string urs = Utils.getusername();
//var rs = from pp in dc.tbl_MKT_Stockends
// where pp.Store_code == this.storelocation
// select new
// {
// Store = pp.Store_code,
// SAP_CODE = pp.SAP_CODE,
// ITEM_Code = pp.ITEM_Code,
// Material_name = pp.MATERIAL,
// Description = pp.Description,
// UNIT = pp.UNIT,
// // END_STOCK = pp.END_STOCK,
// // Real_issue = 0,
// };
ctrex.exportexceldatagridtofile(this.rs, this.datacontext, "STOCK COUNT FOR APROVAL " + dateupdate.Value.ToShortDateString());
}
private void bt_exporttoex_Click(object sender, EventArgs e)
{
Control_ac ctrex = new Control_ac();
ctrex.exportexceldatagridtofile(this.rs, this.dc, "Detail list of Ordered Gate pass");
}
private void button1_Click(object sender, EventArgs e)
{
Control_ac ctrex = new Control_ac();
string connection_string = Utils.getConnectionstr();
string username = Utils.getusername();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
var listupdate1 = from p in dc.tbl_tempmastercontractmasscreates
where p.Username == username
select p;
ctrex.exportExceldatagridtofile(listupdate1, dc, "DANH SÁCH HỢP ĐỒNG ");
}
private void bt_exporttoex_Click(object sender, EventArgs e)
{
Control_ac ctrex = new Control_ac();
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
string urs = Utils.getusername();
var rs = from pp in dc.tbl_MKT_Stockends
where pp.Store_code == this.storelocation
select new
{
Store = pp.Store_code,
SAP_CODE = pp.SAP_CODE,
ITEM_Code = pp.ITEM_Code,
Material_name = pp.MATERIAL,
Description = pp.Description,
UNIT = pp.UNIT,
// END_STOCK = pp.END_STOCK,
// Real_issue = 0,
};
ctrex.exportexceldatagridtofile(rs, dc, "STOCK COUNT " + datecreated.Value.ToShortDateString());
}
private void button1_Click(object sender, EventArgs e)
{
if (this.tblnamesub == "tbl_kaProductlistemp")
{
var rs = from tbl_kaProductlistemp in db.tbl_kaProductlistemps
select tbl_kaProductlistemp;
this.rs = rs;
}
if (this.tblnamesub == "tbl_KaCustomertemp")
{
var rs = from tblCustomerTmp in db.tbl_KaCustomertemps
select tblCustomerTmp;
this.rs = rs;
}
//if (this.tblnamesub == "tblFBL5beginbalaceTemp")
//{
// var rs = from tblFBL5beginbalaceTemp in db.tbl_be
// select tblFBL5beginbalaceTemp;
// this.rs = rs;
//}
//if (this.tblnamesub == "tbl_kaCustomerGroupTemp")
//{
// var rs = from tbl_kaCustomerGroupTemp in db.tbl_kaCustomerGroupTemps
// select tbl_kaCustomerGroupTemp;
// this.rs = rs;
//}
//if (this.tblnamesub == "tbl_Comboundtemp")
//{
// var rs = from tbl_Comboundtemp in db.tbl_Comboundtemps
// select tbl_Comboundtemp;
// this.rs = rs;
//}
if (this.tblnamesub == "tbl_KaCustomer")
{
var rs = from tbl_KaCustomer in db.tbl_KaCustomers
select tbl_KaCustomer;
this.rs = rs;
}
if (this.tblnamesub == "tbl_kaProductlist")
{
var rs = from tbl_kaProductlist in db.tbl_kaProductlists
select tbl_kaProductlist;
this.rs = rs;
}
if (this.tblnamesub == "tbl_kacontractbegindata")
{
var rs = from tblFBL5beginbalace in db.tbl_kacontractbegindatas
select tblFBL5beginbalace;
this.rs = rs;
}
if (this.rs != null)
{
Control_ac ctrex = new Control_ac();
ctrex.exportExceldatagridtofile(this.rs, this.db, this.Text);
}
//else
//{
//}
}
private void button1_Click(object sender, EventArgs e)
{
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string);
LinqtoSQLDataContext da = new LinqtoSQLDataContext(connection_string);
if (this.txt_batchno.Text == "")
{
this.txt_batchno.Text = "0";
}
if (Utils.IsValidnumber(this.txt_batchno.Text) == false)
{
MessageBox.Show("Please check Batch No !", "Thông báo !", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
int Batchno = int.Parse(this.txt_batchno.Text);
#region delete DETAIL AND GRUOP RPT BY USER
string username = Utils.getusername();
// string connection_string = Utils.getConnectionstr();
// LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
string sqltext = "DELETE FROM tbl_KAdetailprogrRpt WHERE tbl_KAdetailprogrRpt.Username = '******'";
dc.ExecuteCommand(sqltext);
dc.SubmitChanges();
sqltext = "DELETE FROM tbl_KapaymentrequestRpt WHERE tbl_KapaymentrequestRpt.Username = '******'";
dc.ExecuteCommand(sqltext);
dc.SubmitChanges();
sqltext = "DELETE FROM tbl_KapaymentrequestRpt WHERE tbl_KapaymentrequestRpt.Username = '******'";
dc.ExecuteCommand(sqltext);
dc.SubmitChanges();
#endregion
#region input detail request payment
tbl_KAdetailprogrRpt detailrpt2 = new tbl_KAdetailprogrRpt(); //total line
detailrpt2.Balance = 0;
detailrpt2.BalanceAftApproval = 0;
detailrpt2.Paid = 0;
detailrpt2.PaymentRequest = 0;
detailrpt2.Sponsorship = 0;
detailrpt2.Programe = "Total";
detailrpt2.Username = username;
var rss1 = from tbl_kaprogramlist in dc.tbl_kaprogramlists
where tbl_kaprogramlist.Code != "DIS"
select tbl_kaprogramlist;
foreach (var item in rss1)
{
tbl_KAdetailprogrRpt detailrpt = new tbl_KAdetailprogrRpt(); //detail line
detailrpt.Programe = item.Name;
detailrpt.Username = username;
detailrpt.Remarks = (from tbl_kacontractsdatadetail in dc.tbl_kacontractsdatadetails
where tbl_kacontractsdatadetail.PayType.Trim() == item.Code.Trim() && tbl_kacontractsdatadetail.ContractNo == contractno && tbl_kacontractsdatadetail.PayID == payiD && tbl_kacontractsdatadetail.PayType != "DIS"
select tbl_kacontractsdatadetail.Remark).FirstOrDefault();
var totaldetailrs = (from tbl_kacontractsdatadetail in db.tbl_kacontractsdatadetails
where tbl_kacontractsdatadetail.PayType == item.Code && tbl_kacontractsdatadetail.ContractNo.Trim() == contractno.Trim()
group tbl_kacontractsdatadetail by tbl_kacontractsdatadetail.PayType into g
select new
{
PayType = g.Key,
Paid = g.Sum(gg => gg.PaidAmt).GetValueOrDefault(0),
Sponsorship = g.Sum(gg => gg.SponsoredTotal).GetValueOrDefault(0),
}).FirstOrDefault();
if (totaldetailrs != null)
{
detailrpt.Paid = totaldetailrs.Paid;
detailrpt.Sponsorship = totaldetailrs.Sponsorship;
detailrpt.Balance = detailrpt.Sponsorship - detailrpt.Paid;
detailrpt.PaymentRequest = (from tbl_kacontractsdetailpayment in da.tbl_kacontractsdetailpayments
where tbl_kacontractsdetailpayment.BatchNo == Batchno && tbl_kacontractsdetailpayment.ContractNo == contractno && tbl_kacontractsdetailpayment.PayType == item.Code && tbl_kacontractsdetailpayment.DoneOn == null
select tbl_kacontractsdetailpayment.PaidRequestAmt).Sum().GetValueOrDefault(0);
detailrpt.BalanceAftApproval = detailrpt.Balance - detailrpt.PaymentRequest;
}
else
{
detailrpt.PaymentRequest = 0;
detailrpt.Paid = 0;
detailrpt.Sponsorship = 0;
detailrpt.Balance = 0;
detailrpt.BalanceAftApproval = 0;
}
detailrpt2.Balance = detailrpt2.Balance + detailrpt.Balance;
detailrpt2.BalanceAftApproval = detailrpt2.BalanceAftApproval + detailrpt.BalanceAftApproval;
detailrpt2.Paid = detailrpt2.Paid + detailrpt.Paid;
detailrpt2.PaymentRequest = detailrpt2.PaymentRequest + detailrpt.PaymentRequest;
detailrpt2.Sponsorship = detailrpt2.Sponsorship + detailrpt.Sponsorship;
dc.tbl_KAdetailprogrRpts.InsertOnSubmit(detailrpt);
dc.SubmitChanges();
}
dc.tbl_KAdetailprogrRpts.InsertOnSubmit(detailrpt2);
dc.SubmitChanges();
#endregion
#region MAKE master rpt
var itemmasterKA = (from tbl_kacontractdata in dc.tbl_kacontractdatas
where tbl_kacontractdata.ContractNo == contractno
select tbl_kacontractdata).FirstOrDefault();
if (itemmasterKA != null)
{
tbl_KapaymentrequestRpt requestmaster = new tbl_KapaymentrequestRpt();
requestmaster.ContractNo = itemmasterKA.ContractNo;
requestmaster.Username = username;
// requestmaster.AchvRevenue
// requestmaster.address = itemmasterKA.a
requestmaster.Annualvolume = itemmasterKA.AnnualVolume;
requestmaster.Channel = itemmasterKA.Channel;
requestmaster.CityProvince = itemmasterKA.Province;
// requestmaster.Colddrinks
requestmaster.Committedvol = itemmasterKA.VolComm;
// requestmaster.ContractNo
requestmaster.ContractType = itemmasterKA.ConType;
// requestmaster.Costpercase
requestmaster.Creditlimit = itemmasterKA.CreditLimit;
requestmaster.Creditterm = itemmasterKA.CreditTerm;
requestmaster.Currency = itemmasterKA.Currency;
requestmaster.Customercode = itemmasterKA.Customer;
requestmaster.Deliveredby = itemmasterKA.DeliveredBy;
// requestmaster.Discount
requestmaster.District = itemmasterKA.District;
requestmaster.EffectiveDate = itemmasterKA.EffDate;
requestmaster.ExpireDate = itemmasterKA.EftDate;
requestmaster.ExtendDate = itemmasterKA.ExtDate;
// requestmaster.Fundspercent
requestmaster.Note = txt_note.Text;
// requestmaster.ProductGroup = itemmasterKA.PrdGrp;
requestmaster.Representative = itemmasterKA.Representative;
requestmaster.SalesOrg = itemmasterKA.SalesOrg;
requestmaster.Street = itemmasterKA.HouseNo;
// requestmaster.SupportCase
requestmaster.TermYear = (itemmasterKA.EftDate.Value.Year - itemmasterKA.EffDate.Value.Year);
requestmaster.TradeName = itemmasterKA.Fullname;
requestmaster.ReferrenceDoc = Batchno.ToString();
//requestmaster.Username
requestmaster.AchievedVolPCs = itemmasterKA.PCVolAched;
requestmaster.NSRcommit = itemmasterKA.NSRComm; // hiện nsa co,,it
requestmaster.AchvRevenue = itemmasterKA.NSRAched;
if (itemmasterKA.VolComm > 0 && itemmasterKA.VolComm != null && itemmasterKA.PCVolAched != null)
{
requestmaster.Achievedpercent = ((itemmasterKA.PCVolAched) / itemmasterKA.VolComm);
}
dc.tbl_KapaymentrequestRpts.InsertOnSubmit(requestmaster);
dc.SubmitChanges();
}
//requestmaster.Vendor
#endregion
#region view reports payment request
Control_ac ctrac = new Control_ac();
var rs1 = ctrac.KArptdataset1(dc);
var rs2 = ctrac.KArptdataset2(dc);
if (rs1 != null && rs2 != null)
{
Utils ut = new Utils();
var dataset1 = ut.ToDataTable(dc, rs1);
var dataset2 = ut.ToDataTable(dc, rs2);
Reportsview rpt = new Reportsview(dataset1, dataset2, "PaymentRequest.rdlc", Batchno, contractno, formcreatCtract);
rpt.ShowDialog();
}
#endregion view reports payment request //
}
