private void button6_Click(object sender, EventArgs e)
{
//Product prd = new Product();
//DialogResult kq1 = MessageBox.Show("Xóa toàn bộ Product ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
//bool kq;
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
//switch (kq1)
//{
// case DialogResult.None:
// break;
// case DialogResult.Yes:
// DialogResult kq2 = MessageBox.Show("Yes là xóa toàn bộ data product, are you sure ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
// // this.uploadCustomerToolStripMenuItem.Enabled = false;
// // this.reportsToolStripMenuItem.Enabled = false;
// if (kq2 == DialogResult.Yes)
// {
// prd.productlistinput();
// VInputchange inputcdata2 = new VInputchange("", "LIST MASTER DATA PRODUCTS ", dc, "tbl_kaProductlist", "tbl_kaProductlist", typeff, typeff, "id", "id", "");
// inputcdata2.Show();
// }
// break;
// case DialogResult.Cancel:
// break;
// case DialogResult.Abort:
// break;
// case DialogResult.Retry:
// break;
// case DialogResult.Ignore:
// break;
// case DialogResult.OK:
// break;
// case DialogResult.No:
var typeff = typeof(tbl_kaProductlist);
VInputchange inputcdata = new VInputchange("", "LIST MASTER DATA PRODUCTS ", dc, "tbl_kaProductlist", "tbl_kaProductlist", typeff, typeff, "id", "id", "");
inputcdata.Show();
// break;
//default:
// break;
// }
}
private void button7_Click(object sender, EventArgs e)
{
programlist proglist = new programlist();
// DialogResult kq1 = MessageBox.Show("Xóa toàn bộ Program ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
// bool kq;
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
var typeff = typeof(tbl_kaprogramlist);
//switch (kq1)
//{
// case DialogResult.None:
// break;
// case DialogResult.Yes:
// // this.uploadCustomerToolStripMenuItem.Enabled = false;
// // this.reportsToolStripMenuItem.Enabled = false;
// proglist.input();
VInputchange inputcdata = new VInputchange("", "LIST PROGRAM LIST ", dc, "tbl_kaprogramlist", "tbl_kaprogramlist", typeff, typeff, "id", "id", "");
inputcdata.Show();
// break;
// case DialogResult.Cancel:
// break;
// case DialogResult.Abort:
// break;
// case DialogResult.Retry:
// break;
// case DialogResult.Ignore:
// break;
// case DialogResult.OK:
// break;
// case DialogResult.No:
//inputcdata = new VInputchange("", "LIST PROGRAM LIST ", dc, "tbl_kaprogramlist", "tbl_kaprogramlist", typeff, typeff, "id", "id", "");
//inputcdata.Show();
// break;
// default:
// break;
//}
}
public Seachcode(VInputchange Fromeditable, string tablename)
{
// return false;
InitializeComponent();
this.Fromeditable = Fromeditable;
this.tablename = tablename;
}
private void button1_Click_1(object sender, EventArgs e)
{
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
// tbl_kaPrcingreportsTem
var typeff = typeof(tbl_KAlistpricefunction);
VInputchange inputcdata = new VInputchange("", "LIST CONDITION TYPE TO CONVER FUCTION AND PROMOTION ", dc, "tbl_KAlistpricefunction", "tbl_KAlistpricefunction", typeff, typeff, "id", "id", "");
inputcdata.Show();
}
private void button2_Click(object sender, EventArgs e)
{
string connection_string = Utils.getConnectionstr();
string urs = Utils.getusername();
// var db = new LinqtoSQLDataContext(connection_string);
LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string);
// tbl_karegion
var typeff = typeof(Tka_RegionRight);
VInputchange inputcdata = new VInputchange("", "LIST EDIT REGION VIEW RIGHT", db, "Tka_RegionRight", "Tka_RegionRight", typeff, typeff, "id", "id", "");
inputcdata.Show();
}
private void button17_Click_1(object sender, EventArgs e)
{
string connection_string = Utils.getConnectionstr();
string urs = Utils.getusername();
// var db = new LinqtoSQLDataContext(connection_string);
LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string);
// tbl_karegion
var typeff = typeof(Tka_RightContracttypeview);
VInputchange inputcdata = new VInputchange("", "LIST CONTRACT TYPE VIEW RIGHT", db, "Tka_RightContracttypeview", "Tka_RightContracttypeview", typeff, typeff, "id", "id", "");
inputcdata.Show();
}
private void button14_Click(object sender, EventArgs e)
{
string connection_string = Utils.getConnectionstr();
//string urs = Utils.getusername();
// var db = new LinqtoSQLDataContext(connection_string);
LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string);
// tbl_karegion
var typeff = typeof(tbl_kaChannel);
VInputchange inputcdata = new VInputchange("", "LIST CHANNEL", db, "tbl_kaChannel", "tbl_kaChannel", typeff, typeff, "id", "id", "");
inputcdata.Show();
}
private void button15_Click(object sender, EventArgs e)
{
kaPriodmake makepriod = new kaPriodmake();
makepriod.ShowDialog();
string connection_string = Utils.getConnectionstr();
// string urs = Utils.getusername();
// var db = new LinqtoSQLDataContext(connection_string);
LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string);
// tbl_karegion
var typeff = typeof(tbl_Kapriod);
VInputchange inputcdata = new VInputchange("", "LIST PRIOD", db, "tbl_Kapriod", "tbl_Kapriod", typeff, typeff, "id", "id", "");
inputcdata.Show();
}
private void button9_Click(object sender, EventArgs e)
{
string connection_string = Utils.getConnectionstr();
string urs = Utils.getusername();
// var db = new LinqtoSQLDataContext(connection_string);
LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string);
// tbl_karegion
var typeff = typeof(tbl_karegion);
//string sql =" IF OBJECT_ID(N'tbl_kaPrdgrpTMP" + urs + @"', N'U') IS NOT NULL
// DROP TABLE tbl_kaPrdgrpTMP" + urs;
//db.ExecuteCommand(sql);
//db.SubmitChanges();
//sql ="CREATE TABLE tbl_kaPrdgrpTMP" + urs + @"
// ( [PrdGrp] [nvarchar](255) NULL,
// [ProductGroup] [nvarchar](255) NULL,
// [WStatement] [nvarchar](255) NULL,
// [id] [int] IDENTITY(1,1) NOT NULL)
// ";
//db.ExecuteCommand(sql);
//db.SubmitChanges();
VInputchange inputcdata = new VInputchange("", "LIST REGION", db, "tbl_karegion", "tbl_karegion", typeff, typeff, "id", "id", "");
inputcdata.Show();
}
private void button2_Click(object sender, EventArgs e)
{
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
dc.CommandTimeout = 0;
// select tblEDLP;
string username = Utils.getusername();
// tbl_Kasa
dc.ExecuteCommand("DELETE FROM tbl_kasalesTemp where tbl_kasalesTemp.Username = '******' or tbl_kasalesTemp.Username is null or tbl_kasalesTemp.Priod is null");
// dc.tblFBL5Nnewthisperiods.DeleteAllOnSubmit(rsthisperiod);
dc.SubmitChanges();
//tbl_kasalesTemp p = new tbl_kasalesTemp();
//p.Priod
dc.ExecuteCommand("DELETE FROM tbl_KaCustomertemp where tbl_KaCustomertemp.Username ='******' or tbl_KaCustomertemp.Username is null");
dc.SubmitChanges();
FormCollection fc = System.Windows.Forms.Application.OpenForms;
bool kq = false;
foreach (Form frm in fc)
{
if (frm.Text == "kaPriodpicker")
{
kq = true;
frm.Focus();
}
}
if (!kq)
{
View.kaPriodpicker kaPriodpicker = new View.kaPriodpicker();
// Datepick
kaPriodpicker.ShowDialog();
string priod = kaPriodpicker.priod;
DateTime fromdate = kaPriodpicker.fromdate;
DateTime todate = kaPriodpicker.todate;
bool chon = kaPriodpicker.kq;
if (chon)
{
if (priod != "" && fromdate != todate && priod != null)
{
Model.Salesinput_ctrl slmodel = new Model.Salesinput_ctrl();
slmodel.edlpinput();
List <string> condtypelist = new List <string>();
condtypelist.Add("YPR0");
condtypelist.Add("YPRD");
condtypelist.Add("NETP");
#region // giới hạn doc type chỉ chấp nhận 3 loại YPR0,YPRD,NETP
var rsdoc = (from tbl_kasalesTemp in dc.tbl_kasalesTemps
where tbl_kasalesTemp.Username == username && !condtypelist.Contains(tbl_kasalesTemp.Cond_Type)
select tbl_kasalesTemp).Take(10);
if (rsdoc.Count() > 0)
{
Viewtable viewtbl2 = new Viewtable(rsdoc, dc, "kHÔNG UPLOAD ĐƯỢC, CÓ CÁC DOC TYPE KHÔNG ĐÚNG KIỂU : YPR0, YPRD, NETP ", 3);// view code 1 la can viet them lenh
viewtbl2.Show();
viewtbl2.Focus();
return;
}
#endregion
#region // list doc da post
var rsdoc3 = (from tbl_kasalesTemp in dc.tbl_kasalesTemps
where tbl_kasalesTemp.Username == username &&
((tbl_kasalesTemp.Invoice_Date <fromdate || tbl_kasalesTemp.Invoice_Date> todate))
select tbl_kasalesTemp).Take(10);
if (rsdoc3.Count() > 0)
{
Viewtable viewtbl2 = new Viewtable(rsdoc3, dc, "kHÔNG UPLOAD ĐƯỢC, CÓ CÁC DOC DATE KHÔNG THUỘC PRIOD: " + priod, 3);// view code 1 la can viet them lenh
viewtbl2.Show();
viewtbl2.Focus();
return;
}
#endregion
#region // productnew
var da = new LinqtoSQLDataContext(connection_string);
da.ExecuteCommand("DELETE FROM tbl_kaProductlistemp where tbl_kaProductlistemp.Username ='******'");
da.SubmitChanges();
var rscustemp = from tbl_kasalesTemp in dc.tbl_kasalesTemps
where !(from tbl_kaProductlist in dc.tbl_kaProductlists
select tbl_kaProductlist.MatNumber).Contains(tbl_kasalesTemp.Mat_Number) && tbl_kasalesTemp.Mat_Number != null
group tbl_kasalesTemp by tbl_kasalesTemp.Mat_Number into g
select new
{
MatNumber = g.Key,
MatText = g.Select(gg => gg.Mat_Text).FirstOrDefault(),
UoM = g.Select(gg => gg.UoM).FirstOrDefault(),
Pcrate = 0,
Ucrate = 0
};
if (rscustemp.Count() > 0)
{
// var db = new LinqtoSQLDataContext(connection_string);
foreach (var item in rscustemp)
{
tbl_kaProductlistemp prduct = new tbl_kaProductlistemp();
prduct.MatNumber = item.MatNumber;
prduct.MatText = item.MatText;
prduct.UoM = item.UoM;
prduct.Pcrate = 0;
prduct.Ucrate = 0;
prduct.Username = username;
if (prduct.MatNumber != null)
{
da.tbl_kaProductlistemps.InsertOnSubmit(prduct);
da.SubmitChanges();
}
}
var typeffmain = typeof(tbl_kaProductlist);
var typeffsub = typeof(tbl_kaProductlistemp);
VInputchange inputcdata = new VInputchange("PRODUCT LIST", "LIST PRODUCT NOT IN MASTER DATAPRODUCT", dc, "tbl_kaProductlist", "tbl_kaProductlistemp", typeffmain, typeffsub, "id", "id", username);
inputcdata.Show();
inputcdata.Focus();
return;
}
#endregion product new //--------------------
#region// update pc, uc
SqlConnection conn2 = null;
SqlDataReader rdr1 = null;
string destConnString = Utils.getConnectionstr();
try
{
conn2 = new SqlConnection(destConnString);
conn2.Open();
SqlCommand cmd1 = new SqlCommand("KAupdateSalePC_UCtemptable", conn2);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add("@priod", SqlDbType.VarChar).Value = priod;
cmd1.CommandTimeout = 0;
rdr1 = cmd1.ExecuteReader();
// rdr1 = cmd1.ExecuteReader();
}
finally
{
if (conn2 != null)
{
conn2.Close();
}
if (rdr1 != null)
{
rdr1.Close();
}
}
// MessageBox.Show("ok", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
#endregion update pc, uc
#region // view sales volume
var rs = from tbl_kasalesTemp in dc.tbl_kasalesTemps
where tbl_kasalesTemp.Username == username && tbl_kasalesTemp.Priod == priod //&& tbl_kasalesTemp.Username == username
select new
{
tbl_kasalesTemp.Priod,
tbl_kasalesTemp.Sold_to,
tbl_kasalesTemp.Sales_Org,
tbl_kasalesTemp.Sales_District,
tbl_kasalesTemp.Sales_District_desc,
tbl_kasalesTemp.Cust_Name,
tbl_kasalesTemp.Outbound_Delivery,
tbl_kasalesTemp.Delivery_Date,
tbl_kasalesTemp.Invoice_Doc_Nr,
tbl_kasalesTemp.Invoice_Date,
tbl_kasalesTemp.Key_Acc_Nr,
tbl_kasalesTemp.Cond_Type,
tbl_kasalesTemp.Mat_Group,
tbl_kasalesTemp.Mat_Group_Text,
tbl_kasalesTemp.Mat_Number,
tbl_kasalesTemp.Mat_Text,
tbl_kasalesTemp.Currency,
PCs = tbl_kasalesTemp.EC,
tbl_kasalesTemp.UoM,
tbl_kasalesTemp.EmptyCountValue,
tbl_kasalesTemp.GSR,
tbl_kasalesTemp.Litter,
tbl_kasalesTemp.NETP,
tbl_kasalesTemp.NSR,
EC = tbl_kasalesTemp.PC,
tbl_kasalesTemp.UC,
tbl_kasalesTemp.Username,
tbl_kasalesTemp.id,
};
if (rs.Count() > 0)
{
Viewtable viewtbl = new Viewtable(rs, dc, "SALES DATA PRIOD: " + priod, 1);// view code 1 la can viet them lenh
viewtbl.Show();
viewtbl.Focus();
}
#endregion
}
}
}
}
private void button16_Click(object sender, EventArgs e)
{
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
var typeff = typeof(tbl_kacontractsdatadetail);
VInputchange inputcdata = new VInputchange("", "LIST DATA CONTRACTS DETAIL ", dc, "tbl_kacontractsdatadetail", "tbl_kacontractsdatadetail", typeff, typeff, "id", "id", "");
inputcdata.Show();
//#region
//Contract ctract = new Contract();
//DialogResult kq1 = MessageBox.Show("Delete all begin contract detail ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
//// bool kq;
//string connection_string = Utils.getConnectionstr();
//LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
//var typeff = typeof(tbl_kacontractbegindatadetail);
//switch (kq1)
//{
// case DialogResult.None:
// break;
// case DialogResult.Yes:
// DialogResult kq2 = MessageBox.Show("YEs là xóa dữ liệu begin Contract, bạn định xóa ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
// if (kq2 == DialogResult.Yes)
// {
// Contract Rm = new Contract();
// bool kq = Rm.deleteallcontractbegindetail();
// }
// ctract.inputcontractdetail();
// //VInputchange inputcdata = new VInputchange("", "LIST DATA CONTRACTS DETAIL ", dc, "tbl_kacontractmasterdatadetail", "tbl_kacontractmasterdatadetail", typeff, typeff, "id", "id", "");
// //inputcdata.Show();
// var rscustemp2 = from tbl_kacontractmasterdatadetail in dc.tbl_kacontractbegindatadetails
// select tbl_kacontractmasterdatadetail;
// Viewtable viewtbl = new Viewtable(rscustemp2, dc, "LIST DATA CONTRACTS DETAIL", 3);// view code 1 la can viet them lenh
// viewtbl.Show();
// break;
// case DialogResult.Cancel:
// break;
// case DialogResult.Abort:
// break;
// case DialogResult.Retry:
// break;
// case DialogResult.Ignore:
// break;
// case DialogResult.OK:
// break;
// case DialogResult.No:
// ctract.inputcontractdetail();
// rscustemp2 = from tbl_kacontractmasterdatadetail in dc.tbl_kacontractbegindatadetails
// select tbl_kacontractmasterdatadetail;
// viewtbl = new Viewtable(rscustemp2, dc, "LIST DATA CONTRACTS DETAIL", 3);// view code 1 la can viet them lenh
// viewtbl.Show();
// break;
// default:
// break;
//}
//#endregion
}
private void button1_Click(object sender, EventArgs e)
{
customerinput_ctrl md = new customerinput_ctrl();
// DialogResult kq1 = MessageBox.Show("Xóa toàn bộ dataCustomer ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
// bool kq;
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
var typeffmain = typeof(tbl_KaCustomer);
var typeffsub = typeof(tbl_KaCustomer);
//switch (kq1)
//{
// case DialogResult.None:
// break;
// case DialogResult.Yes:
// // this.uploadCustomerToolStripMenuItem.Enabled = false;
//DialogResult kq2 = MessageBox.Show("YEs là xóa dữ liệu customer, bạn định xóa ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
//if (kq2 == DialogResult.Yes)
//{
// md.customerinput();
// VInputchange inputcdata1 = new VInputchange("", "LIST MASTER DATA CUSTOMER ", dc, "tbl_KaCustomer", "tbl_KaCustomer", typeffmain, typeffsub, "id", "id", "");
// inputcdata1.Show();
//}
//else
//{
// return;
//}
// inputcdata.show
// inputcdata.MaximumSize = true;
// break;
//case DialogResult.Cancel:
// break;
//case DialogResult.Abort:
// break;
//case DialogResult.Retry:
// break;
//case DialogResult.Ignore:
// break;
//case DialogResult.OK:
// break;
//case DialogResult.No:
// var typeffmain = typeof(tbl_KaCustomer);
// var typeffsub = typeof(tbl_KaCustomer);
VInputchange inputcdata = new VInputchange("", "LIST MASTER DATA CUSTOMER ", dc, "tbl_KaCustomer", "tbl_KaCustomer", typeffmain, typeffsub, "id", "id", "");
inputcdata.Show();
// break;
//default:
// break;
// }
}
