public static string FindProgarmebymessageandmaterial(string message, string material) { // #region // kiem tra xem co sai mesage // bool kq = true; string maprogarme = ""; string connection_string = Utils.getConnectionstr(); var db = new LinqtoSQLDataContext(connection_string); string enduser = Utils.getusername(); var rs = from p in db.tbl_CTKMs where p.Mã_SP_KM.Trim() == material && p.enduser == enduser // && message.IndexOf(p.PO_Message) > 0 select p; foreach (var item in rs) { if (message.Contains(item.PO_Message.Trim())) { // message dung // order message sai // kq = false; maprogarme = item.Mã_CT; // return true; } } return(maprogarme); // return kq; }
private void btnew_Click(object sender, EventArgs e) { this.region = this.txtma.Text; this.ghichu = txtghichu.Text; if (region == "") { MessageBox.Show("Bạn chưa có mã channel", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } chon = true; string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string); tbl_MKT_Region p = new tbl_MKT_Region(); p.Region = this.region;//= this.txtma.Text; p.Note = this.ghichu;// = txtdiachitaikhoannganhang.Text; db.tbl_MKT_Regions.InsertOnSubmit(p); db.SubmitChanges(); this.Close(); }
public static bool Iswrongmessage(string message, string maCTKM) { // #region // kiem tra xem co sai mesage bool kq = true; string connection_string = Utils.getConnectionstr(); string enduser = Utils.getusername(); var db = new LinqtoSQLDataContext(connection_string); var rs = from p in db.tbl_CTKMs where p.enduser == enduser where p.Mã_CT == maCTKM // && message.IndexOf(p.PO_Message) > 0 select p; foreach (var item in rs) { if (message.Contains(item.PO_Message.Trim())) { // message dung // order message sai kq = false; // return true; } } return(kq); }
public static void UpdateMaCTKMchodonhangmua(string material, DateTime dlv_Date, string nhomKHKM, int id) { string connection_string = Utils.getConnectionstr(); string enduser = Utils.getusername(); var db = new LinqtoSQLDataContext(connection_string); var rs = from p in db.tbl_CTKMs where p.enduser == enduser select p; foreach (var item in rs) { if (item.Mã_SP_Mua == material && item.Từ_ngày <= dlv_Date && item.Đến_Ngày >= dlv_Date && (item.Nhóm_khách_hàng == nhomKHKM || item.Nhóm_khách_hàng == "")) { var rs2 = from kh in db.tbl_Salesorders where kh.id == id select kh; foreach (var item2 in rs2) { item2.maCTKM = item.Mã_CT; item2.Ma_SP_Duoc_KM = item.Mã_SP_KM; item2.So_luong_duoc_KM = item2.ConfirmQty / item.Tỷ_lệ_CTKM; db.SubmitChanges(); } } } // throw new NotImplementedException(); }
private void button6_Click(object sender, EventArgs e) { string connection_string = Utils.getConnectionstr(); string Username = Utils.getusername(); if (Utils.IsValidnumber(this.txt_batchno.Text) == false) { MessageBox.Show("Please check Batchno doc. " + this.txt_batchno.Text, "Thông báo !", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } int BatchNo = int.Parse(this.txt_batchno.Text); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var viewrs = from tbl_kacontractsdetailpayment in dc.tbl_kacontractsdetailpayments where tbl_kacontractsdetailpayment.ContractNo == contractno && tbl_kacontractsdetailpayment.PayControl == "REQ" && tbl_kacontractsdetailpayment.CRDUSR == Username && tbl_kacontractsdetailpayment.BatchNo == BatchNo select new { tbl_kacontractsdetailpayment.ContractNo, PayType = tbl_kacontractsdetailpayment.PayType.Trim(), tbl_kacontractsdetailpayment.PayID, tbl_kacontractsdetailpayment.SubID, tbl_kacontractsdetailpayment.PayControl, tbl_kacontractsdetailpayment.PaidRequestAmt, // tbl_kacontractsdetailpayment.Balance, // tbl_kacontractsdetailpayment.BalanceAft, tbl_kacontractsdetailpayment.BatchNo, tbl_kacontractsdetailpayment.Remark, }; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; this.dataGridView1.DataSource = viewrs; }
private void Createpayment_FormClosed(object sender, FormClosedEventArgs e) { string connection_string = Utils.getConnectionstr(); string Username = Utils.getusername(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var viewrs = from tbl_kacontractsdetailpayment in dc.tbl_kacontractsdetailpayments where tbl_kacontractsdetailpayment.ContractNo == contractno && tbl_kacontractsdetailpayment.CRDUSR == Username && tbl_kacontractsdetailpayment.BatchNo == 0// && tbl_kacontractsdetailpayment.PayControl == "REQ select tbl_kacontractsdetailpayment; //{ // tbl_kacontractsdetailpayment.ContractNo, // PayType = tbl_kacontractsdetailpayment.PayType.Trim(), // tbl_kacontractsdetailpayment.PayID, // tbl_kacontractsdetailpayment.SubID, // tbl_kacontractsdetailpayment.PayControl, // tbl_kacontractsdetailpayment.PaidRequestAmt, // // tbl_kacontractsdetailpayment.Balance, // // tbl_kacontractsdetailpayment.BalanceAft, // tbl_kacontractsdetailpayment.BatchNo, // tbl_kacontractsdetailpayment.Remark, //}; // dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; // this.dataGridView1.DataSource = viewrs; dc.tbl_kacontractsdetailpayments.DeleteAllOnSubmit(viewrs); dc.SubmitChanges(); }
public void loaddatagriviewpayment() { string connection_string = Utils.getConnectionstr(); string Username = Utils.getusername(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var viewrs = from tbl_kacontractsdetailpayment in dc.tbl_kacontractsdetailpayments where tbl_kacontractsdetailpayment.ContractNo == contractno && tbl_kacontractsdetailpayment.CRDUSR == Username && tbl_kacontractsdetailpayment.BatchNo == 0 && tbl_kacontractsdetailpayment.PayControl == "REQ" select new { tbl_kacontractsdetailpayment.ContractNo, tbl_kacontractsdetailpayment.ContracName, PayType = tbl_kacontractsdetailpayment.PayType.Trim(), tbl_kacontractsdetailpayment.PayID, tbl_kacontractsdetailpayment.SubID, tbl_kacontractsdetailpayment.PayControl, tbl_kacontractsdetailpayment.PaidRequestAmt, // tbl_kacontractsdetailpayment.Balance, // tbl_kacontractsdetailpayment.BalanceAft, tbl_kacontractsdetailpayment.BatchNo, tbl_kacontractsdetailpayment.Remark, }; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; this.dataGridView1.DataSource = viewrs; }
private void txtname_KeyPress(object sender, KeyPressEventArgs e) { txtname.Focus(); string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); string username = Utils.getusername(); var regioncode = (from tbl_Temp in dc.tbl_Temps where tbl_Temp.username == username select tbl_Temp.RegionCode).FirstOrDefault(); var rscode = from tbl_KaCustomer in dc.tbl_KaCustomers where tbl_KaCustomer.FullNameN.Contains(txtname.Text.ToString().Trim()) && ((int)tbl_KaCustomer.Customer).ToString().Contains(txtcode.Text.ToString()) && (from Tka_RegionRight in dc.Tka_RegionRights where Tka_RegionRight.RegionCode == regioncode select Tka_RegionRight.Region ).Contains(tbl_KaCustomer.SalesOrg) select new { Region = tbl_KaCustomer.Region, Code = tbl_KaCustomer.Customer, Name = tbl_KaCustomer.FullNameN, // tbl_KaCustomer.SapCode, }; icount = rscode.Count(); dataGridView1.DataSource = rscode; }
public void exportexceldatagridtofile(IQueryable iquery, LinqtoSQLDataContext db, string tittle) { System.Data.DataTable datatable1 = new System.Data.DataTable(); // Utils ul = new Utils(); datatable1 = ul.ToDataTable(db, iquery); SaveFileDialog thedialog = new SaveFileDialog(); // // datagridview datagridview1 = new datagridview(); // datagridview1.datasource = datagrid.datasource; thedialog.Title = "export to excel file"; thedialog.Filter = "excel files|*.xlsx; *.xls"; thedialog.InitialDirectory = @"c:\"; if (thedialog.ShowDialog() == DialogResult.OK) { string filename = thedialog.FileName.ToString(); Thread t1 = new Thread(exportsexcel); t1.IsBackground = true; t1.Start(new datatoExport() { dataGrid1 = datatable1, filename = filename, tittle = tittle }); // t1.join(); } }
private void treeView1_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e) { string name = e.Node.Name; string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); //bangsoducd // bangnhapsodulctt // npdanhsachxe //dsxenp // dsloaitk // dstaikhoanketoan //hethongtk //phanquyen //btoanth // dsnhacungcap }
public static DriveLesson Save(DateTime shortDate, int hour, string instruktorID,string DriverID ,LinqtoSQLDataContext db) { Guid guid = Guid.NewGuid(); DriveLesson driv = new DriveLesson { Date = shortDate, Hour = hour, ID = guid, Instructor = instruktorID, Driver = DriverID }; db.DriveLesson.InsertOnSubmit(driv); LINQConnections.Save(db); return driv; }
private void button2_Click_2(object sender, EventArgs e) { string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var Programelist = from pp in dc.tbl_MKT_Payment_AprovalTMPs where pp.username == username select new { // pp.IO_number, // pp.ProgrameIDDocno, // pp.Account, // pp.costcenter, pp.Customercode, pp.CustomerName, pp.CustomerAddress, pp.AprovalBudget, pp.id, pp.username, }; if (Programelist.Count() > 0) { this.totalBudget = (float)Programelist.Sum(x => x.AprovalBudget); txttotalbudget.Text = this.totalBudget.ToString("#,#", CultureInfo.InvariantCulture); } }
private void button1_Click(object sender, EventArgs e) { // string username = Utils.getusername(); string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var channelisttmp = from pp in dc.tbl_MKT_CustomerChaneltmps where pp.username == username select pp; foreach (var item in channelisttmp) { if (item.Select_channel == true) { if (kqstring != "") { this.kqstring = item.Chanel_code + ";" + this.kqstring; } else { this.kqstring = item.Chanel_code; } } } this.Close(); }
private void reportViewer1_PrintingBegin(object sender, ReportPrintEventArgs e) { // MessageBox.Show("In payment request !"); string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var rschangepritcheck = from tbl_kacontractsdetailpayment in dc.tbl_kacontractsdetailpayments where tbl_kacontractsdetailpayment.BatchNo == BatchNo// && tbl_kacontractsdatadetail.ContractNo == contractno select tbl_kacontractsdetailpayment; if (rschangepritcheck != null) { foreach (var item in rschangepritcheck) { item.PrintChk = true; item.PrintDate = DateTime.Today; // item. dc.SubmitChanges(); if (formcreatCtract != null) { this.formcreatCtract.loadDetailContractView(contractno); } } } // this.Close(); }
public ActionResult About() { //LinqtoSQL Example LinqtoSQLDataContext nw = new LinqtoSQLDataContext(); var empQuery = from emp in nw.Employees where emp.Id == 1 select emp.Name; foreach (var _emp in empQuery) { //capture SQL statement of LinqToSQL Trace.TraceInformation(string.Format("{0}", empQuery.ToString())); } //PageView _ai.Pageview("Exception"); ViewBag.Message = ""; //capture type conversion error try { if (ViewBag.Message) { } } catch (Exception ex) { Trace.TraceError(ex.StackTrace); } return(View()); }
public void DrawDataTable(int startHourRange, int endHourRange, int jumpHour, int startWidth, int startHeight) { using (LinqtoSQLDataContext db = new LinqtoSQLDataContext()) { int tempWidth = startWidth; foreach (Instruktor instruktor in db.Instruktor.Where(x => x.Visible == true)) { tempWidth += buttonRectangleSize; labellist.Add(MakeInstructorLabel(tempWidth, instruktor.First_Name + "\n" + instruktor.Second_Name)); int tempHeight = startHeight; form.Width += buttonRectangleSize; for (int i = startHourRange; i <= endHourRange; i += jumpHour) { string buttonText = string.Empty; DriveLesson checkLesson = DrivesListModel.Load(i, form.date, instruktor.InstructorID); if (checkLesson.Driver != null) { buttonText = DriverSeterController.GetText(checkLesson.Driver); } buttonList.Add(makeButton(tempWidth, tempHeight, instruktor.InstructorID, i.ToString(), buttonRectangleSize, buttonText)); tempHeight += buttonRectangleSize; } } } AddToColection(); }
public void loaddetailinventoryforapproval() { string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); string urs = Utils.getusername(); var rs = from pp in dc.tbl_MKT_Stockcounts where pp.Store_code == this.storelocation && pp.CountingDate == this.CountingDate && pp.Idsub == this.Countingtimes 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, Counting_Quantity = pp.CountQuantity, Balance = pp.CountQuantity - pp.END_STOCK, // Real_issue = 0, }; if (rs.Count() > 0) { dataGridViewLoaddetail.DataSource = rs; this.rs = rs; this.datacontext = dc; } }
private void button1_Click(object sender, EventArgs e) { btAproval.Enabled = false; btreject.Enabled = false; #region change status approval string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var rs = from pp in dc.tbl_MKT_Stockcounts where pp.CountingDate == this.CountingDate && pp.Idsub == this.Countingtimes && pp.Store_code == this.storelocation select pp; if (rs.Count() > 0) { foreach (var item in rs) { item.Aproved = true; item.Aprovedby = txtnguoinhan.Text; item.AprovedDate = DateTime.Today; item.Status = "Reject"; dc.SubmitChanges(); } } MessageBox.Show("Done !", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information); // loaddetailinventoryforapproval(); // btAproval.Enabled = false; // btreject.Enabled = false; #endregion }
public int getStatus() { string Name = Utils.getusername(); int kq = -1; string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var rs = (from pp in dc.tbl_Temps where pp.username == Name select pp).FirstOrDefault(); if (rs != null) { if (rs.status != null) { kq = rs.status.Value; } else { rs.status = -1; // dc.SubmitChanges(); // Username.setStatus(-1); } } return(kq); }
public List <Viewtable.ComboboxItem> Getcomboudata() { List <Viewtable.ComboboxItem> dataCollection = new List <Viewtable.ComboboxItem>(); string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var rs = from tblCustomer in dc.tblCustomers where tblCustomer.Reportsend == true select tblCustomer; string drowdowvalue = ""; if (rs.Count() > 0) { foreach (var item in rs) { drowdowvalue = item.Customer.ToString() + " " + item.Name_1; Viewtable.ComboboxItem itemcb = new Viewtable.ComboboxItem(); itemcb.Text = drowdowvalue; itemcb.Value = item.Customer.ToString(); dataCollection.Add(itemcb); } return(dataCollection); } return(null); }
public static void Save(string FirstName, string SecondName, string InstructorID, PictureBox picture) { using (LinqtoSQLDataContext db = new LinqtoSQLDataContext()) { if (db.Instruktor.Any(x => x.InstructorID == InstructorID)) { var Instructor = from Instruktor in db.Instruktor where Instruktor.InstructorID == InstructorID select Instruktor; foreach (Instruktor instructor in Instructor) { instructor.First_Name = FirstName; instructor.Second_Name = SecondName; instructor.InstructorID = InstructorID; } } else { Guid ID = System.Guid.NewGuid(); Instruktor newInstruktor = new Instruktor {Visible = true, First_Name = FirstName, Second_Name = SecondName, InstructorID = InstructorID, ID = ID }; db.Instruktor.InsertOnSubmit(newInstruktor); } LINQConnections.Save(db); } }
private void btupdate_Click(object sender, EventArgs e) { // this.makho = this.txtmakho.Text; this.tenkho = this.txttenkho.Text; this.diachi = this.txtdiachi.Text; this.ghichu = this.txtghichu.Text; this.storeright = this.txtstoright.Text; //this.usertao = Utils.getusername(); //this.ngaytao = DateTime.Today; if (makho == "") { MessageBox.Show("Bạn chưa có mã nhà cung cấp", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (makho != "") { chon = true; string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string); // tbl_dstaikhoan tk = new tbl_dstaikhoan(); // MeasureItemEventArgs.re var rs = (from p in db.tbl_MKT_khoMKTs where p.makho == makho // orderby tbl_dstaikhoan.matk select p).FirstOrDefault(); if (rs != null) { rs.makho = this.makho; // = this.txtmaNCC.Text; rs.tenkho = this.tenkho; // this.txttenNCC.Text; rs.diachikho = this.diachi; // this.txtMasothue.Text; rs.ghichu = this.ghichu; // this.txtNganhnghe.Text; rs.storeright = this.storeright; // this.txtNganhnghe.Text; db.SubmitChanges(); this.Close(); } } }
public static void Save(string firstName, string secondName, string driverID, string adress, string telephone, int amountOfDrives, bool isRegularClient) { using (LinqtoSQLDataContext db = new LinqtoSQLDataContext()) { if (db.Driver.Any(x => x.DriverID == driverID)) { var drivers = from driver in db.Driver where driver.DriverID == driverID select driver; foreach (Driver driver in drivers) { driver.First_Name = firstName; driver.Last_Name = secondName; driver.DriverID = driverID; driver.Adress = adress; driver.TelephoneNumber = telephone; driver.IsRegularClient = isRegularClient; driver.Drives_Amount = amountOfDrives; } } else { Guid ID = System.Guid.NewGuid(); Driver newDriver = new Driver {First_Name = firstName, Last_Name = secondName, Adress = adress,ID = ID, IsRegularClient = isRegularClient,DriverID = driverID, TelephoneNumber = telephone, Drives_Amount = amountOfDrives }; db.Driver.InsertOnSubmit(newDriver); } LINQConnections.Save(db); } }
private void btnew_Click(object sender, EventArgs e) { this.maNVT = this.txtma.Text; this.tenNVT = this.txtten.Text; this.diachinvt = this.txtdiachi.Text; // this.masothuenvt = txtmasothue.Text; this.dienthoai = txtdienthoai.Text; // this.tknganhangso = dienthoai.Text; if (maNVT == "") { MessageBox.Show("Bạn chưa có mã nhà cung cấp", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } chon = true; string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string); tbl_MKT_Nhacungungvantai p = new tbl_MKT_Nhacungungvantai(); p.maNVT = this.maNVT; //= this.txtma.Text; p.tenNVT = this.tenNVT; //= this.txtten.Text; p.diachiNVT = this.diachinvt; // = this.txtdiachi.Text; // p.masothueNVT = this.masothuenvt;// = txtmasothue.Text; p.dienthoaiNVT = this.dienthoai; //= txtdienthoai.Text; db.tbl_MKT_Nhacungungvantais.InsertOnSubmit(p); db.SubmitChanges(); this.Close(); }
public kaPriodandcustomerpicker() { InitializeComponent(); kq = false; checkbonlycust.Checked = false; checkbokfromcode.Checked = false; string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var rs2 = from tbl_Kapriod in dc.tbl_Kapriods where tbl_Kapriod.block == false select tbl_Kapriod; string drowdownshow = ""; foreach (var item in rs2) { drowdownshow = item.Priod; cb_priod.Items.Add(drowdownshow); } priod = ""; customercode = ""; cbcustomer.Text = ""; // lbcustomername.Text = ""; lb_priods.Text = ""; lb_fromdates.Text = ""; lbtodates.Text = ""; // cb_priod.SelectedIndex = 1; // priod = null; }
private void button1_Click(object sender, EventArgs e) { // nut ok tbl_kacontractCustcode cust = new tbl_kacontractCustcode(); string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); string username = Utils.getusername(); double codetemp = this.addcode; // (double)this.dataGridView1.Rows[0].Cells["Code"].Value; string codename = this.addname; // (string)this.dataGridView1.Rows[0].Cells["Name"].Value; //this.valuetext = textBox1.Text; //this.field = this.label1.Text; cust.ContractNo = this.Contactno; cust.CustomerCode = codetemp; cust.Name = codename; cust.Addedby = username; dc.tbl_kacontractCustcodes.InsertOnSubmit(cust); dc.SubmitChanges(); MessageBox.Show("Code :" + codetemp + " add to Groupcode done !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); this.kq = true; this.Close(); }
private void button1_Click(object sender, EventArgs e) { string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var contractproductconvert = from tbl_kaConvertProductlist in dc.tbl_kaConvertProductlists where tbl_kaConvertProductlist.ContractNo == ContractNo && tbl_kaConvertProductlist.PayID == contractitem select tbl_kaConvertProductlist; dc.tbl_kaConvertProductlists.DeleteAllOnSubmit(contractproductconvert); dc.SubmitChanges(); // view detail datagview var contractproductconvert2 = from tbl_kaConvertProductlist in dc.tbl_kaConvertProductlists where tbl_kaConvertProductlist.ContractNo == ContractNo && tbl_kaConvertProductlist.PayID == contractitem select tbl_kaConvertProductlist; this.dataGridView1.DataSource = contractproductconvert2; //viewdetail datagview }
public static DriveLesson Load(int hour,DateTime shortDate, string instruktorID) { using (LinqtoSQLDataContext db = new LinqtoSQLDataContext()) { DriveLesson driv = null; try { driv = db.DriveLesson.Where(x => x.Date == shortDate && x.Hour == hour && x.Instructor == instruktorID).First(); } catch (Exception x) { Console.WriteLine(x.ToString()); } if (driv == null) { driv = Save(shortDate, hour, instruktorID, db); Console.WriteLine(driv.Hour); } return driv; } }
private void btxoa_Click(object sender, EventArgs e) { string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); if (!Model.Username.getDeleteProductright()) { View.MKTNoouthourise view = new MKTNoouthourise(); view.ShowDialog(); return; } var rs1 = (from p in dc.tbl_MKT_Stockends where p.id == this.id select p).FirstOrDefault(); if (rs1 != null) { dc.tbl_MKT_Stockends.DeleteOnSubmit(rs1); dc.SubmitChanges(); this.Close(); } }
private void button2_Click(object sender, EventArgs e) { try { int id = (int)this.dataGridView1.Rows[this.dataGridView1.CurrentCell.RowIndex].Cells["id"].Value; // MessageBox.Show(id.ToString()); double Codegroup = double.Parse(txtcustgroup.Text.ToString()); string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var rscode = (from tbl_kaCustomerGroup in dc.tbl_kaCustomerGroups where tbl_kaCustomerGroup.id == id select tbl_kaCustomerGroup).FirstOrDefault(); dc.tbl_kaCustomerGroups.DeleteOnSubmit(rscode); dc.SubmitChanges(); var rscode2 = from tbl_kaCustomerGroup in dc.tbl_kaCustomerGroups where tbl_kaCustomerGroup.Customergropcode == Codegroup//&& (tbl_KaCustomer.SapCode == true) select tbl_kaCustomerGroup; dataGridView1.DataSource = rscode2; } catch (Exception) { // throw; } }
// IQueryable rs, LinqtoSQLDataContext d public MKTProgramemake2() { InitializeComponent(); txtsohieuct.Text = ""; txttenct.Text = ""; txtfromdate.Value = DateTime.Today; txttodate.Value = DateTime.Today; txttotalbudget.Text = ""; this.ProgrameIDDocno = txtsohieuct.Text; // label7.Text = "Select one or more channel "; this.username = Utils.getusername(); string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); Model.MKT.DeleteALLIOTMP(dc); var Programelist = from pp in dc.tbl_MKT_IO_ProgrameTMPs where pp.Username == username select new { pp.IO_number, pp.ChannelGroup, pp.Budget, pp.Region, pp.Sales_Org, pp.Username, pp.id, }; Model.MKT.DeleteALLIPricelistIOTMP(dc); var priceIOlist = from pp in dc.tbl_MKT_ProgramepriceproductTMPs where pp.Username == username select new { pp.ITEM_Code, pp.MATERIAL, pp.Price, pp.SAP_CODE, pp.Description, pp.id, pp.Username, }; }
private void button1_Click(object sender, EventArgs e) { View.valueinput inputval = new valueinput("Input some text in Name to seach code", ""); inputval.ShowDialog(); bool chon = inputval.kq; string valueinput = inputval.valuetext; if (valueinput == null) { valueinput = ""; } if (chon) { string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var rscode = from tbl_KaCustomer in dc.tbl_KaCustomers where tbl_KaCustomer.FullNameN.Contains(valueinput) && (tbl_KaCustomer.SapCode == true) select new { tbl_KaCustomer.Region, tbl_KaCustomer.Customer, tbl_KaCustomer.FullNameN, tbl_KaCustomer.SapCode, }; Utils ut = new Utils(); var tblcustomer = ut.ToDataTable(dc, rscode); Viewdatatable viewtb = new Viewdatatable(tblcustomer, "Please,Choose one code !"); viewtb.ShowDialog(); string codetemp = viewtb.valuecode; string region = viewtb.region; if (codetemp != "0" && chon == true && codetemp != null) { custcode.Text = codetemp; custcode.Enabled = false; textregion.Text = region; cbcust.Checked = true; // groupBox1.Enabled = true; // cbcust.Checked = true; } } else { custcode.Text = ""; custcode.Enabled = true; textregion.Text = ""; cbcust.Checked = true; // groupBox1.Enabled = false; // cbcust.Checked = false; } }
public IQueryable Funtionsetlect_all(LinqtoSQLDataContext db) { //var db = new LinqtoSQLDataContext(connection_string); var rs = from tbl_Kafuctionlist in db.tbl_Kafuctionlists select tbl_Kafuctionlist; return(rs); }
public IQueryable Edlpsetlect_all(LinqtoSQLDataContext db) { // var db = new LinqtoSQLDataContext(connection_string); var rs = from tblEDLP in db.tblEDLPs select tblEDLP; return(rs); }
public IQueryable product_select_all(LinqtoSQLDataContext dblink) { // var db = new LinqtoSQLDataContext(connection_string); var rs = from tbl_kaProductlist in dblink.tbl_kaProductlists select tbl_kaProductlist; return(rs); }
public static void Delete(string matchID) { using (LinqtoSQLDataContext db = new LinqtoSQLDataContext()) { db.Driver.DeleteAllOnSubmit(db.Driver.Where(x => x.DriverID == matchID)); LINQConnections.Save(db); } }
public static Instruktor Load(LinqtoSQLDataContext db, string IDMatch) { var ins = db.Instruktor.Where(x => x.InstructorID == IDMatch); if (ins.Any() == false) { return null; } else return ins.First(); }
public static void Delete(string IDMatch) { using (LinqtoSQLDataContext db = new LinqtoSQLDataContext()) { db.Instruktor.DeleteAllOnSubmit(db.Instruktor.Where(x=>x.InstructorID == IDMatch)); LINQConnections.Save(db); } }
public static void Load(ListBox listbox) { using (LinqtoSQLDataContext db = new LinqtoSQLDataContext()) { foreach (Instruktor instructor in db.Instruktor) { listbox.Items.Add(instructor.First_Name + " " + instructor.Second_Name + " ," + instructor.InstructorID); } } }
public static void Load(ListBox listbox,string SearchBase) { using (LinqtoSQLDataContext db = new LinqtoSQLDataContext()) { listbox.Items.Clear(); foreach (Driver driver in db.Driver.Where(x => (x.First_Name + x.Last_Name).Contains(SearchBase))) { listbox.Items.Add(driver.First_Name.Trim(' ') + " " + driver.Last_Name.Trim(' ') + "," + driver.DriverID); } } }
private void button1_Click(object sender, EventArgs e) { using (LinqtoSQLDataContext db = new LinqtoSQLDataContext()) { Button thisbutton = sender as Button; string DriverID = DriverModel.Load(Driver_listbox.Text.Split(',').Last()).DriverID; DrivesListModel.Save(date, hour, trainerid,DriverID , db); } ReturnValue = Driver_listbox.Text; this.Visible = false; }
public static Driver Load(string IDMatch) { using (LinqtoSQLDataContext db = new LinqtoSQLDataContext()) { if (IDMatch != null) { try { return db.Driver.First(x => x.DriverID == IDMatch); } catch (InvalidOperationException x) { Console.WriteLine(x.ToString()); } } } return null; }
public static string GetText(string driverID) { //// Get First and Second name of Driver based at driverID, if driverID doesn't match any driver //// returns string.Empty; Driver driver; using (LinqtoSQLDataContext db = new LinqtoSQLDataContext()) { driver = DriverModel.Load(driverID); } if (driver == null) { return string.Empty; } else { return driver.First_Name + " " + driver.Last_Name; } }
public static void Load(TextBox FirstName, TextBox LastName, TextBox InstructorID, PictureBox picturebox, string IDMatch) { using (LinqtoSQLDataContext db = new LinqtoSQLDataContext()) { if (IDMatch != null) { try { Instruktor ins = Load(db, IDMatch); FirstName.Text = ins.First_Name.Trim(' '); LastName.Text = ins.Second_Name.Trim(' '); InstructorID.Text = ins.InstructorID.Trim(' '); } catch (InvalidOperationException x) { Console.WriteLine(x.ToString()); } } } }
public static void Save(LinqtoSQLDataContext db) { try { db.SubmitChanges(); } catch (Exception exc) { Console.WriteLine(exc); } }