public bool FindNewImages(Product product) { d = new DataClasses1DataContext(); bannedHosts = d.BannedImagesSites.Select(t => t.BannedHost).ToList(); bannedImages = d.BannedImages.Select(t => t.BannedImage1).ToList(); potentialImages.Clear(); var productName = product.ProductFullName; foreach (var c in chars) { productName = productName.Replace(c, " "); } var searchURL = "http://ajax.googleapis.com/ajax/services/search/images?v=1.0&q=" + productName; var findResult = PageEncoding.GetPage(searchURL, null, null, ip, port); if (findResult == null || findResult.Contains("Bot or Human")) { return false; } // выбираем самую большую GetImagesList(findResult); foreach (var potentialImage in potentialImages.OrderByDescending(t => t.ContentLength).ToList()) { var result = GetImage(potentialImage); if (result) { //imageHost = potentialImage.ResponseUri.Host; imageHost = potentialImage.ResponseUri.AbsoluteUri.Replace("www.", ""); return true; } } return false; }
public ActionResult Details(int id) { DataClasses1DataContext db = new DataClasses1DataContext(); OrderAndServies orderservies = new OrderAndServies(); List<ListServiesModif> listServies = new List<ListServiesModif>(); /* List<list_add_services> servies = new List<list_add_services>(); //var order = db.Orders.Where(item => item.Id_order == id); var order = db.ExecuteQuery<Order>(@"SELECT * FROM Orders WHERE Id_order = " + id + ";"); Order ddd = order.First(); */ var ttt = db.ExecuteQuery<OrderModific>(@"SELECT [Orders].[Id_order], [Orders].[date], [Orders].[begin], [Orders].[end], [Client].[FIO] FROM [Orders], [Client] WHERE Orders.Id_order = '" + id + "' AND Orders.id_client = Client.Id_client;").ToList<OrderModific>().First(); //listServies = db.ExecuteQuery<ListServiesModif>(@"SELECT CAST([list_add_services].[Id_list_add_services] AS NVARCHAR(100)), CAST([list_add_services].[id_order] AS NVARCHAR(100)), CAST([type_servies].[name] AS NVARCHAR(100)) FROM [list_add_services], [type_servies], [Orders] WHERE [list_add_services].[id_servies] = [type_servies].[Id_servies] AND [list_add_services].[id_order] = '" + id + "'GROUP BY CAST([list_add_services].[Id_list_add_services] AS NVARCHAR(100)), CAST([list_add_services].[Id_order] AS NVARCHAR(100)), CAST([type_servies].[name] AS NVARCHAR(100));").ToList<ListServiesModif>(); //listServies = db.ExecuteQuery<ListServiesModif>(@"SELECT CAST([list_add_services].[Id_list_add_services] AS NVARCHAR(100)), CAST([list_add_services].[id_order] AS NVARCHAR(100)), CAST([type_servies].[name] AS NVARCHAR(100)) FROM [list_add_services], [type_servies], [Orders] WHERE [list_add_services].[id_servies] = [type_servies].[Id_servies] AND [list_add_services].[id_order] = '" + id + "'GROUP BY CAST([list_add_services].[Id_list_add_services] AS NVARCHAR(100)), CAST([list_add_services].[Id_order] AS NVARCHAR(100)), CAST([type_servies].[name] AS NVARCHAR(100));").ToList<ListServiesModif>(); //listServies = db.ExecuteQuery<ListServiesModif>(@"SELECT [list_add_services].[Id_list_add_services], [list_add_services].[id_order], CAST([type_servies].[name] AS NVARCHAR(100)) AS 'name' FROM [list_add_services], [type_servies], [Orders] WHERE [list_add_services].[id_servies] = [type_servies].[Id_servies] AND [list_add_services].[id_order] = '" + id + "' GROUP BY [list_add_services].[Id_list_add_services], [list_add_services].[Id_order], CAST([type_servies].[name] AS NVARCHAR(100));").ToList<ListServiesModif>(); /* orderservies.order = ttt; orderservies.ListServirecs = listServies; */ return View(orderservies); }
// Delete Bank <bank> from database public static bool delete(Bank bank) { using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString)) { var query = from a in database.Banks where (a.BankID == bank.BankID) select a; // It seems to me that a single account renders the foreach unnecessary. However, I can't // find another way to get the variable 'a' from 'query'. foreach (var a in query) { database.Banks.DeleteOnSubmit(a); try { database.SubmitChanges(); return true; } catch (Exception e) { return false; } } return false; } }
public static void AddCommoditypopularityByID(Guid id) { DataClasses1DataContext dd = new DataClasses1DataContext(); //在存储过程中加1了??? //dc.updatePopularityCommodity(id); dd.updatePopularityCommodity(id); }
private void button1_Click(object sender, EventArgs e) { try { if(!String.IsNullOrWhiteSpace(textBox1.Text) && !String.IsNullOrWhiteSpace(textBox2.Text) && !String.IsNullOrWhiteSpace(textBox3.Text)) { DataClasses1DataContext doctorContext= new DataClasses1DataContext(); Doctor doctor = new Doctor(); doctor.doctorName = textBox1.Text; doctor.doctorID = textBox2.Text; doctor.gloveSize = Decimal.Parse(textBox3.Text); doctorContext.Doctors.InsertOnSubmit(doctor); doctorContext.SubmitChanges(); textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; Form1.GetDoctors(); loadDoctors(); } else { MessageBox.Show("Cannot be empty...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch { MessageBox.Show("Something went wrong, does the doctor already exist? Please try again...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
// Update Account <acc> in database public static bool update(Account acc) { using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString)) { var query = from a in database.Accounts // Assuming the accountNumber is enough of an identifier. // Additional 'where' clauses can be added if necessary. where (a.AccountID == acc.AccountID) select a; // It seems to me that a single account renders the foreach unnecessary. However, I can't // find another way to get the variable 'a' from 'query'. foreach (var a in query) { a.AccountAddress = acc.AccountAddress; a.AccountFirstName = acc.AccountFirstName; a.AccountLastName = acc.AccountLastName; a.AccountNum = acc.AccountNum; a.AccountPhoneNum = acc.AccountPhoneNum; a.AccountRoutingNum = acc.AccountRoutingNum; a.BankID = acc.BankID; } try { database.SubmitChanges(); return true; } catch (Exception e) { return false; } } }
protected void Page_Load(object sender, EventArgs e) { categoryName = Request["category"]; productName = Request["product"]; using (var db = new DataClasses1DataContext()) { if (categoryName == "野菜類") { var q = from x in db.YasaiKensa where x.食品カテゴリ == categoryName.Normalize() && x.野菜品名 == productName.Normalize() orderby x.採取日D descending select x; list = q.ToList(); } else { var q = from x in db.YasaiKensa where x.食品カテゴリ == categoryName.Normalize() && x.品目 == productName.Normalize() orderby x.採取日D descending select x; list = q.ToList(); } bqByDayImage.ImageUrl = String.Format("ProductChartImage.ashx?category={0}&product={1}", HttpUtility.UrlEncode(categoryName), HttpUtility.UrlEncode(productName)); prefImage.ImageUrl = list.PreparePrefURL(300,300); } Title = String.Format("{0}({1}) | 食品の放射能検査データ", productName, categoryName); }
public P_fxrates[] GetLatestfxrates() { var db = new DataClasses1DataContext(); CultureInfo culture; culture = new CultureInfo("en-Us", false); var fxrates_update = GetfxratesLastUpdate(); string[] dt; int? upd; dt = fxrates_update[0].Day.Split('/'); upd = Convert.ToInt32(fxrates_update[0].Update); int yyyy, mm, dd; yyyy = Convert.ToInt32(dt[2]); mm = Convert.ToInt32(dt[1]); dd = Convert.ToInt32(dt[0]); var datetime = new DateTime(yyyy, mm, dd); var query = from temp in db.sp_Getfxrates(datetime, upd) select new P_fxrates { ID = temp.ID.Value.ToString(), Description = temp.Description, BuyingRates = temp.BuyingRates, SellingRates = temp.SellingRates, SightBill = temp.SightBill, Family = temp.Family.Trim(), FamilyLong = temp.FamilyLong, Bill_DD_TT = temp.Bill_DD_TT, TT = temp.TT, Update = temp.Update.Value.ToString(), Ddate = temp.Date.Value.ToString("d/MM/yyyy", culture), DTime = temp.Time }; return query.ToArray(); }
// Update Store <store> public static bool update(Store store) { using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString)) { var query = from a in database.Stores where (a.StoreID == store.StoreID) select a; foreach (var a in query) { a.StoreNum = store.StoreNum; a.StoreName = store.StoreName; a.StoreAddress = store.StoreAddress; a.StoreServiceCharge = store.StoreServiceCharge; } try { database.SubmitChanges(); return true; } catch (Exception e) { return false; } } }
public JsonResult habitacionesdisponibles(string fechai, string fechaf) { DataClasses1DataContext db = new DataClasses1DataContext(); string fii = fechai.Substring(3, 3) + fechai.Substring(0, 3) + fechai.Substring(6, 4); string fnn = fechaf.Substring(3, 3) + fechaf.Substring(0, 3) + fechaf.Substring(6, 4); DateTime fi = DateTime.Parse(fii), fn = DateTime.Parse(fnn); var numero = (db.habitacions.Where(h => db.ocupado(h.numero, fi, fn).Value).Select(h => h.numero.ToString())).ToArray(); var tipo = (db.habitacions.Where(h => db.ocupado(h.numero, fi, fn).Value).Select(h => h.tip_hab.tipo)).ToArray(); var precio = (db.habitacions.Where(h => db.ocupado(h.numero, fi, fn).Value).Select(h => (Convert.ToInt32(h.precio)).ToString())).ToArray(); var q = db.habitacions.Where(h => db.ocupado(h.numero, fi, fn).Value).Select(h => h.numero); var ress = q.ToArray(); var rr = Json(ress); int t = numero.Count(); string[,] cadena = new string[t, 3]; for (int i = 0; i < t; i++) { cadena[i, 0] = numero[i]; cadena[i, 1] = tipo[i]; cadena[i, 2] = precio[i]; } var cad = Json(cadena); return cad; }
private void calcButton_Click(object sender, EventArgs e) { try { //Get input data from text boxes int minStock = Convert.ToInt32(minStockBox.Text); int maxStock = Convert.ToInt32(maxStockBox.Text); int day = Convert.ToInt32(daysBox.Text); int endDay = Convert.ToInt32(endDayBox.Text); //testing of input data if (minStock < 0 || maxStock < 0 || endDay < 1 || day < 1 || maxStock <= minStock) throw new Exception("Invalid data"); //Calc Purchase table and parse function return DataClasses1DataContext dc = new DataClasses1DataContext(); switch (dc.CalcMRP(1, endDay, minStock, day, maxStock)) { case 1: throw new Exception("StOck overflow"); case 2: throw new Exception("Very little stock"); } this.purchaseTableAdapter.Fill(this.assyPartDS.Purchase); } catch (Exception exp) { MessageBox.Show(exp.Message); } }
private void button1_Click_1(object sender, EventArgs e) { DoctorEdit docEdit = new DoctorEdit(); if (!String.IsNullOrEmpty(doctorBox.Text)) { DataClasses1DataContext editContext = new DataClasses1DataContext(); var doctor = (from doc in editContext.Doctors where doc.doctorName == doctorBox.Text select doc).First(); docEdit.oldDoctorName.Text = doctor.doctorName; docEdit.oldInitials.Text = doctor.doctorID; docEdit.oldGloves.Text = doctor.gloveSize.ToString(); docEdit.newDoctorName.Text = doctor.doctorName; docEdit.newInitials.Text = doctor.doctorID; docEdit.newGloves.Text = doctor.gloveSize.ToString(); docEdit.ShowDialog(this); if (docEdit.DialogResult == DialogResult.OK) { Form1.DoctorsList.Clear(); Form1.GetDoctors(); loadDoctors(); } } else { MessageBox.Show("Please select a doctor from the list", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public ActionResult Index(ReservaHab model) { DataClasses1DataContext db = new DataClasses1DataContext(); reserva reserr = new reserva(); System.Guid id = System.Guid.Parse((System.Web.Security.Membership.GetUser(User.Identity.Name).ProviderUserKey).ToString()); reserr.idusuario = id; var cliiii = 0; if (model.tipocli2 == 1) { db.personas.Where(a => (a.cliente.nombre + " " + a.apellido).ToString() == model.buscarpersona.ToString()).Select(a => a.id).First(); } if (model.tipocli2 == 2) { db.empresas.Where(a => a.cliente.nombre.ToString() == model.buscarempresa.ToString()).Select(a => a.id).First(); } if (model.tipocli2 == 3) { db.agencias.Where(a => a.cliente.nombre.ToString() == model.buscaragencia.ToString()).Select(a => a.id).First(); } reserr.idcli = cliiii; reserr.idHab = model.idhab; string ini = model.Fecha_I.Substring(3, 3) + model.Fecha_I.Substring(0, 3) + model.Fecha_I.Substring(6, 4); string fin = model.Fecha_F.Substring(3, 3) + model.Fecha_F.Substring(0, 3) + model.Fecha_F.Substring(6, 4); reserr.fecha_ini = DateTime.Parse(ini); reserr.fecha_fin = DateTime.Parse(fin); reserr.estado = "pendiente"; var ppago = db.habitacions.Where(a => a.numero == model.idhab).Select(a => a.precio).First(); reserr.pago = ppago * model.CantD; db.reservas.InsertOnSubmit(reserr); db.SubmitChanges(); return View(); }
// Update Check <check> public static bool update(Check check) { using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString)) { var query = from a in database.Checks where (a.CheckID == check.CheckID) select a; foreach (var a in query) { a.CheckAmount = check.CheckAmount; a.CheckAmountOwed = check.CheckAmountOwed; a.CheckCashierID = check.CheckCashierID; a.CheckDate = check.CheckDate; a.CheckDeleted = check.CheckDeleted; a.CheckNum = check.CheckNum; a.CheckPaidDate = check.CheckPaidDate; } try { database.SubmitChanges(); return true; } catch (Exception e) { return false; } } }
public ActionResult upload(ArchivoFile datos) { string rutafisica = Server.MapPath("~/csv"); string rt = rutafisica + @"\" + datos.archivo.FileName; datos.archivo.SaveAs(rutafisica + @"\" + datos.archivo.FileName); DataClasses1DataContext db = new DataClasses1DataContext(); archivo ar = new archivo() { ruta_fisica = rutafisica + @"\" + datos.archivo.FileName, fecha = DateTime.Now }; db.archivos.InsertOnSubmit(ar); db.SubmitChanges(); CsvReader csv = new CsvReader(new StreamReader(rt), true); //int total = csv.FieldCount; //string[] headers = csv.GetFieldHeaders; List<reservasC> listares = new List<reservasC>(); while (csv.ReadNextRecord()) { reservasC res = new reservasC() { nombreCliente = csv[0], numHab = csv[1], fechaI = csv[2], fechaF = csv[3] }; listares.Add(res); } ViewBag.lista = listares; return View(); }
public void formFuncionario_Load(object sender, EventArgs e) { DataClasses1DataContext db = new DataClasses1DataContext(); var func = from funcionario in db.tblfuncionarios select funcionario; dgw_funcionario.DataSource = func ; dgw_funcionario.Columns["id_funcionario"].HeaderText = "ID"; dgw_funcionario.Columns["nome"].HeaderText = "Nome "; dgw_funcionario.Columns["sobrenome"].HeaderText = "Sobrenome"; dgw_funcionario.Columns["cpf"].HeaderText = "CPF"; dgw_funcionario.Columns["rg"].HeaderText = "RG"; dgw_funcionario.Columns["ctps"].HeaderText = "CTPS"; dgw_funcionario.Columns["data_admissao"].HeaderText = "Data Admissão"; dgw_funcionario.Columns["renumeracao_mensal"].HeaderText = "Renumeração Mensal"; dgw_funcionario.Columns["funcao"].HeaderText = "Função"; dgw_funcionario.Columns["endere"].HeaderText = "Endereço"; dgw_funcionario.Columns["bairro"].HeaderText = "Bairro"; dgw_funcionario.Columns["email"].HeaderText = "E-Mail"; dgw_funcionario.Columns["obs"].HeaderText = "Observação"; dgw_funcionario.Columns["sexo"].HeaderText = "Sexo"; // colocando nome nas coluna do datagrid // barra rodape toolStripStatusLabel1.Text = dgw_funcionario.RowCount + " Funcionários Cadastrado."; }
private void btn_deletar_Click(object sender, EventArgs e) { try { // metodo para pega index dgw_funcionario.CurrentCell.RowIndex.ToString() int selecionado = dgw_funcionario.CurrentCell.RowIndex; int idfunc; idfunc = int.Parse(dgw_funcionario.Rows[selecionado].Cells["id_funcionario"].Value.ToString()); DataClasses1DataContext db = new DataClasses1DataContext(); var funci = from funcionario in db.tblfuncionarios where funcionario.id_funcionario.Equals(idfunc) select funcionario; tblfuncionario fun = funci.Single(); db.tblfuncionarios.DeleteOnSubmit(fun); db.SubmitChanges(); MessageBox.Show("Deletado com sucesso"); Funcionarios.PreecherGridview(dgw_funcionario); } catch { MessageBox.Show("Ocorreu um erro!"); } }
public static void FlowStatics() { System.IO.StreamWriter sw = new System.IO.StreamWriter("log.txt", false); DataClasses1DataContext mydb = new DataClasses1DataContext(common.connString); var message = mydb.LA_update1.Select(e => e.ip_version_MsgType).Distinct(); Dictionary<string, int> myDic = new Dictionary<string, int>(); foreach (string m in message) { myDic.Add(m, 0); Console.Write(m + "--------------------"); Console.WriteLine(0); sw.Write(m + "--------------------"); sw.WriteLine(0); } sw.Flush(); List<string> startmessage = new List<string>(); startmessage.Add("DTAP MM.Location Updating Request"); startmessage.Add("DTAP MM.CM Service Request"); startmessage.Add("DTAP RR.Paging Response"); startmessage.Add("BSSMAP.Handover Request"); foreach (var start in startmessage) { Dictionary<string, int> newDic = new Dictionary<string, int>(); foreach (KeyValuePair<string, int> pair in myDic) newDic.Add(pair.Key, 0); var a = from p in mydb.LA_update1 where p.ip_version_MsgType == start select p.opcdpcsccp; foreach (var b in a) { foreach (KeyValuePair<string, int> kvp in myDic) { var c = mydb.LA_update1.Where(e => e.opcdpcsccp == b).Where(e => e.ip_version_MsgType == kvp.Key).FirstOrDefault(); if (c != null) newDic[kvp.Key] = newDic[kvp.Key] + 1; } } foreach (var m in newDic.OrderByDescending(e => e.Value)) { Console.Write(m.Key+"--------------------"); Console.WriteLine(m.Value); sw.Write(m.Key + "--------------------"); sw.WriteLine(m.Value); } sw.Flush(); } sw.Close(); }
protected void Page_Load(object sender, EventArgs e) { using (var db = new DataClasses1DataContext()) { SRList = db.ShippingRestriction.ToList(); SRProducts= db.ShippingRestrictedProduct.ToList(); SRCities = db.ShippingRestrictedCity.ToList(); } }
protected void Page_Load(object sender, EventArgs e) { //if (Page.IsPostBack == false) { using (var db = new DataClasses1DataContext()) { list = db.Temp_YasaiKensa.ToList(); } } }
protected void Publish_Click(object sender, EventArgs e) { using (var db = new DataClasses1DataContext()) { db.ExecuteCommand("DELETE FROM YasaiKensa WHERE No IN (SELECT No FROM Temp_YasaiKensa);"); db.ExecuteCommand("INSERT INTO YasaiKensa SELECT * FROM Temp_YasaiKensa;"); db.ExecuteCommand("DELETE FROM Temp_YasaiKensa"); } Response.Redirect("complete.aspx"); }
private void btnDeleteAll_Click(object sender, EventArgs e) { DataClasses1DataContext dc = new DataClasses1DataContext(); if (DialogResult.Yes == MessageBox.Show("Delete all StreamMoments?", "Warning", MessageBoxButtons.YesNo)) { logger.Info("Starting User requested StreamMoment wipe."); dc.ExecuteCommand("Delete from StreamMoments"); logger.Info("Completed User requested StreamMoment wipe."); } }
static void checkIp() { DataClasses1DataContext database = new DataClasses1DataContext(); string ip = "176.9.103.131"; try { ip = VerifyIp(); int nrsecwait = 0; while (ip.Contains("176.9.103.131"))//("89.33.106.3")) { Thread.Sleep(1000); nrsecwait++; if (nrsecwait % 10 == 0) { System.Console.WriteLine("VPN neconectat - " + DateTime.Now.ToString()); ip = VerifyIp(); //insereaza in tabel ip=ul database.Insert_restartVPN_last_ip(ip); } //System.Console.WriteLine(nrsecwait); if (nrsecwait > 30 && nrsecwait % 60 == 0) { #if DEBUG System.Console.WriteLine("Se Face Restart La VPN - " + DateTime.Now.ToString()); // Process.Start("C:\\Users\\Adrian.Ghibaor\\Documents\\Visual Studio 2013\\Projects\\GetAgentie\\GetAgentie\\bin\\Release\\GetAgentie.exe"); #else DateTime time = DateTime.Now; System.Console.WriteLine("Se Face Restart La VPN - " + DateTime.Now.ToString()); Process.Start("script_vpn.exe"); Thread.Sleep(25000); // se asteapta 25 secunde pt ca si script_vpn are un sleep de 10 secunde pana face connnect si poate dura 10 secunde pana se conecteaza System.Console.WriteLine("Acum ar trebui sa fie connectat - " + DateTime.Now.ToString()); #endif ip = VerifyIp(); } } System.Console.WriteLine("VPN ok"); //inseereaza in tabel ip-ul database.Insert_restartVPN_last_ip(ip); } catch (Exception e) { System.Console.WriteLine("Nu s-a putut verifica ip-ul, reincerc in 20 secunde - " + DateTime.Now.ToString()); //inseereaza in tabel ip-ul database.Insert_restartVPN_last_ip(ip); } }
//public bool advanceUserInStudy(DataClasses1DataContext database, int SID, int UID) public bool advanceUserInStudy(int SID, int UID) { DataClasses1DataContext database = new DataClasses1DataContext(); StudiesUser u = (from user in database.StudiesUsers where user.StudyID == SID && user.UserID == UID select user).Single(); //database.Refresh(refresh_mode, new Object[] {u, database.WordSublists, database.TrialTypes}); StudyUserGroup g = u.StudyUserGroup; //database.Refresh(refresh_mode, g); var subkeys = (from s in database.WordSublists select s.ID); var typekeys = (from s in database.TrialTypes select s.ID); int firstSublist = subkeys.Min(); int lastSublist = subkeys.Max(); int firstType = typekeys.Min(); int lastType = typekeys.Max(); if ((u.WordSublistID < lastSublist) && u.Mix) { u.WordSublistID++; u.Mix = false; } else if (!u.Mix) { if (u.WordSublistID == firstSublist) //nothing to mix at the beginning { u.WordSublistID++; } else { u.Mix = true; } } else if (u.TrialTypeID < lastType) { u.WordSublistID = firstSublist; u.TrialTypeID++; u.Mix = false; } else if (u.WordListID == g.FirstListID) { u.WordListID = g.SecondListID; u.WordSublistID = firstSublist; u.TrialTypeID = firstType; } else { u.Complete = true; } database.SubmitChanges(); return u.Complete; }
private static User _getUser(string username, string pass) { DataClasses1DataContext dc1 = new DataClasses1DataContext(); var queryResult = (from user in dc1.GetTable<User>() where (user.Username == username) && (user.Pass == pass) select user).ToArray<User>(); if (queryResult.Count<User>() > 0) return queryResult[0]; else return null; }
public FormPesquisa() { InitializeComponent(); Banco = new DataClasses1DataContext(); // preechendo grid PreecherGrid(); // alterando titulo do grid AlterarHeadGrid(); }
protected void Page_Load(object sender, EventArgs e) { var code = Request["code"]; using (var db = new DataClasses1DataContext()) { SR = db.ShippingRestriction.Single(x => x.Code == code); SRProducts = db.ShippingRestrictedProduct.Where(x => x.ShippingRestrictionCode == code).ToList(); SRCities = db.ShippingRestrictedCity.Where(x => x.ShippingRestrictionCode == code).ToList(); } }
public ActionResult Index() { var students = new DataClasses1DataContext() .CommonStudents .Take(4) .Select(x => x.FirstName + " " + x.LastName) .ToList(); var model = new ListStudentsViewModel(); model.Students = students; return View(model); }
protected void Page_Load(object sender, EventArgs e) { using (var db = new DataClasses1DataContext()) { var q = from x in db.YasaiKensa group x by x.食品カテゴリ into grp select new { name = grp.Key, count = grp.Count() }; categoryList = new Dictionary<string, int>(); foreach (var item in q.OrderByDescending(x => x.count)) { categoryList.Add(item.name, item.count); } } }
private static ZAST _getZast(string fname, string lname, string carnum) { DataClasses1DataContext dc = new DataClasses1DataContext(); var queryResult = (from zast in dc.GetTable<ZAST>() where (zast.FName == fname) && (zast.LName == lname) && (zast.CarNum == carnum) select zast).ToArray<ZAST>(); if (queryResult.Count<ZAST>() > 0) return queryResult[0]; else return null; }
public QLDienKeController() { db = new DataClasses1DataContext(); }
private void btn_Print_Barcode_Click(object sender, EventArgs e) { try { dt_Kanban.Rows.Clear(); this.Cursor = Cursors.WaitCursor; using (DataClasses1DataContext db = new DataClasses1DataContext()) { // Step 1 delete UserName var deleteItem = (from ii in db.TempPrintKanbans where ii.UserName == Environment.UserName select ii); foreach (var d in deleteItem) { db.TempPrintKanbans.DeleteOnSubmit(d); db.SubmitChanges(); } // Step 2 Insert to Table int c = 0; string CodeNo = ""; radGridView1.EndEdit(); //insert foreach (var Rowinfo in radGridView1.Rows) { if (StockControl.dbClss.TBo(Rowinfo.Cells["S"].Value).Equals(true)) { CodeNo = StockControl.dbClss.TSt(Rowinfo.Cells["CodeNo"].Value); var g = (from ix in db.tb_Items select ix).Where(a => a.CodeNo == CodeNo).ToList(); if (g.Count() > 0) { c += 1; TempPrintKanban tm = new TempPrintKanban(); tm.UserName = Environment.UserName; tm.CodeNo = g.FirstOrDefault().CodeNo; tm.PartDescription = g.FirstOrDefault().ItemDescription; tm.PartNo = g.FirstOrDefault().ItemNo; tm.VendorName = g.FirstOrDefault().VendorItemName; tm.ShelfNo = g.FirstOrDefault().ShelfNo; tm.GroupType = g.FirstOrDefault().GroupCode; tm.Max = Convert.ToDecimal(g.FirstOrDefault().MaximumStock); tm.Min = Convert.ToDecimal(g.FirstOrDefault().MinimumStock); tm.ReOrderPoint = Convert.ToDecimal(g.FirstOrDefault().ReOrderPoint); tm.ToolLife = Convert.ToDecimal(g.FirstOrDefault().Toollife); byte[] barcode = StockControl.dbClss.SaveQRCode2D(g.FirstOrDefault().CodeNo); tm.BarCode = barcode; db.TempPrintKanbans.InsertOnSubmit(tm); db.SubmitChanges(); this.Cursor = Cursors.Default; } } } if (c > 0) { Report.Reportx1.Value = new string[2]; Report.Reportx1.Value[0] = Environment.UserName; Report.Reportx1.WReport = "001_Kanban_Part"; Report.Reportx1 op = new Report.Reportx1("001_Kanban_Part.rpt"); op.Show(); } else { MessageBox.Show("not found."); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } this.Cursor = Cursors.Default; }
public Partidos() { Db = new DataClasses1DataContext(); }
public static List <string> GetWojewodztwos() { DataClasses1DataContext db = new DataClasses1DataContext(); return(db.Wojewodztwos.OrderBy(x => x.Nazwa_Wojewodztwo).Select(x => x.Nazwa_Wojewodztwo).ToList()); }
public static List <string> GetStopienStudiows() { DataClasses1DataContext db = new DataClasses1DataContext(); return(db.StopienStudiows.Select(x => x.Stopien_Studiow_Nazwa).ToList()); }
public DateRangePurchases() { InitializeComponent(); context = new DataClasses1DataContext(); }
public SIGEEA_Moneda Moneda(int id) { DataClasses1DataContext dc = new DataClasses1DataContext(); return(dc.SIGEEA_Monedas.FirstOrDefault(c => c.PK_Id_Moneda == id)); }
public FactPOSClass() { dataContext = new DataClasses1DataContext(); dataContextS1 = new s1_DataClasses1DataContext(); }
/// <summary> /// Obtiene la dirección de un empleado en específico a partir de su número de cédula /// </summary> /// <param name="cedula"></param> /// <returns></returns> public SIGEEA_spObtenerDireccionEmpleadoResult ObtenerDireccionEmpleado(string cedula) { DataClasses1DataContext dc = new DataClasses1DataContext(); return(dc.SIGEEA_spObtenerDireccionEmpleado(cedula).First()); }
private void DataLoad() { //dt.Rows.Clear(); try { this.Cursor = Cursors.WaitCursor; using (DataClasses1DataContext db = new DataClasses1DataContext()) { //dt = ClassLib.Classlib.LINQToDataTable(db.tb_Units.ToList()); try { // int year1 = 2017; //var gd = (from ix in db.tb_ForcastCalculates // where ix.MMM == dbClss.getMonth(cboMonth.Text) && ix.YYYY == year1 // select new { ix.YYYY, ix.MMM, Month = dbClss.getMonthRevest(ix.MMM) // , ix.CodeNo // , ItemDescription =db.tb_Items.Where(s => s.CodeNo == ix.CodeNo).Select(o => o.ItemDescription).FirstOrDefault() // ,ix.ForeCastQty,ix.Toolife_spc,ix.SumQty,ix.ExtendQty,ix.UsePerDay,ix.LeadTime,ix.KeepStock,ix.AddErrQty,ix.OrderQty}).ToList(); var gd = (from a in db.tb_Items select new { CodeNo = a.CodeNo, ItemDescription = a.ItemDescription, Order = 10, StockQty = 0, BackOrder = 0, UnitBuy = "PCS", PCSUnit = 1, LeadTime = a.Leadtime, MaxStock = a.MaximumStock, MinStock = a.MinimumStock, VendorNo = "V0001", VendorName = "HHL Interade Co.,LTD.", CreateDate = DateTime.Now, CreateBy = "Administrator", Status = "รับเข้าแล้ว", ItemName = a.ItemNo, Delivery = DateTime.Now, PRNo = "PR201705-0001", ReceiveNo = "RC201705-001", Cost = 1000 }).ToList(); //radGridView1.DataSource = gd; //int rowcount = 0; //foreach (var x in radGridView1.Rows) //{ // rowcount += 1; // x.Cells["dgvNo"].Value = rowcount; // x.Cells["dgvCodeTemp"].Value = x.Cells["CodeNo"].Value.ToString(); // x.Cells["dgvCodeTemp2"].Value = x.Cells["VendorNo"].Value.ToString(); // //x.Cells["dgvCodeTemp3"].Value = x.Cells["MMM"].Value.ToString(); // // MessageBox.Show("ss"); // // x.Cells["ModelName"].ReadOnly = true; // //x.Cells["YYYY"].ReadOnly = true; // //x.Cells["MMM"].ReadOnly = true; //} } catch (Exception ex) { MessageBox.Show(ex.Message); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } this.Cursor = Cursors.Default; // radGridView1.DataSource = dt; }
private void chartForm_Load(object sender, EventArgs e) { // SVE ZA RASPORED pictureBox string[] sva_polja = { "a1b1", "a1b2", "a1b3", "a1b4", "a1b5", "a1b6", "a2b1", "a2b2", "a2b3", "a2b4", "a2b5", "a2b6", "a3b1", "a3b2", "a3b3", "a3b4", "a3b5", "a3b6", "a4b1", "a4b2", "a4b3", "a4b4", "a4b5", "a4b6", "a5b1", "a5b2", "a5b3", "a5b4", "a5b5", "a5b6", "a6b1", "a6b2", "a6b3", "a6b4", "a6b5", "a6b6", "a7b1", "a7b2", "a7b3", "a7b4", "a7b5", "a7b6", "a8b1", "a8b2", "a8b3", "a8b4", "a8b5", "a8b6", "a9b1", "a9b2", "a9b3", "a9b4", "a9b5", "a9b6", "a10b1", "a10b2", "a10b3", "a10b4", "a10b5", "a10b6", "a11b1", "a11b2", "a11b3", "a11b4", "a11b5", "a11b6", "a12b1", "a12b2", "a12b3", "a12b4", "a12b5", "a12b6", "a13b1", "a13b2", "a13b3", "a13b4", "a13b5", "a13b6" }; int j = 0; int k = 0; int counter = 0; int index = 0; /*DataClasses3DataContext db3 = new DataClasses3DataContext(); * var varijabla1 = from s in db3.tblRasporeds select s.botunIme; * string[] ime_botuna = varijabla1.ToArray(); * var varijabla2 = from s in db3.tblRasporeds select s.botunText; * string[] text_botuna = varijabla2.ToArray(); */ DataClasses1DataContext db1 = new DataClasses1DataContext(); var varijabla1 = from s in db1.tblRasporeds select s.botunIme; string[] ime_botuna = varijabla1.ToArray(); var varijabla2 = from s in db1.tblRasporeds select s.botunText; string[] text_botuna = varijabla2.ToArray(); // za raspored for (j = 0; j < sva_polja.Length; j++) { for (k = 0; k < text_botuna.Length; k++) { if (sva_polja[j] == ime_botuna[k]) { counter++; index = k; } } if (counter > 0 && (text_botuna[index] == "Privatni trening" || text_botuna[index] == "Kickbox" || text_botuna[index] == "Kružni trening")) { trening_raspored++; } counter = 0; index = 0; } //za vadenje podataka iz baze clanove-> LINQ DataClasses2DataContext db2 = new DataClasses2DataContext(); var pomocna3 = from s in db2.tblMembers select s.spol; string[] spol = pomocna3.ToArray(); var temp3 = from s in db2.tblMembers select s.vrsta_treninga; string[] text = temp3.ToArray(); var varijabla3 = from s in db2.tblMembers select s.id; int[] broj = varijabla3.ToArray(); int[] temp_niz = { 0, 0, 0 }; int[] spol_niz = { 0, 0 }; // za graf for (int i = 0; i < text.Length; i++) // vadimo vrste treniga za chart2 { if (text[i] == "Teretana") { temp_niz[0]++; } else if (text[i] == "Kickbox") { temp_niz[1]++; } else if (text[i] == "Kružni trening") { temp_niz[2]++; } else { continue; } } for (int i = 0; i < text.Length; i++) // vadimo vrste ljudi za chart1 { if (spol[i] == "Muški") { spol_niz[0]++; } else if (spol[i] == "Ženski") { spol_niz[1]++; } else { continue; } } chart1.Series["s1"].IsValueShownAsLabel = true; chart1.Series["s1"].Points.AddXY("1", spol_niz[0]); //ovo ce bit muski chart1.Series["s1"].Points.AddXY("2", spol_niz[1]); // ovo zenski chart1.Series["s1"].Points[0].LegendText = "Muškarci"; chart1.Series["s1"].Points[1].LegendText = "Žene"; chart2.Series["s2"].IsValueShownAsLabel = true; chart2.Series["s2"].Points.AddXY("1", temp_niz[0]); //teretana chart2.Series["s2"].Points.AddXY("2", temp_niz[1]); // kickbox chart2.Series["s2"].Points.AddXY("3", temp_niz[2]); //kruzni trening chart2.Series["s2"].Points[0].LegendText = "Teretana"; chart2.Series["s2"].Points[1].LegendText = "Kickbox"; chart2.Series["s2"].Points[2].LegendText = "Kružni trening"; }
public static Guid FindStupienStudiowIdByName(string name) { DataClasses1DataContext db = new DataClasses1DataContext(); return(db.StopienStudiows.Where(x => x.Stopien_Studiow_Nazwa == name).Select(x => x.Id_Stopien_Studiow).SingleOrDefault()); }
private void Save_detail2() { using (DataClasses1DataContext db = new DataClasses1DataContext()) { int id = 0; int.TryParse(txtid.Text, out id); if (id > 0) { string Type = "CNShipping"; string Category = "Invoice"; //Temp,Invoice var g = (from ix in db.tb_Shippings //join i in db.tb_Items on ix.CodeNo equals i.CodeNo where ix.ShippingNo.Trim() == txtSHNo.Text.Trim() && ix.Status != "Cancel" && ix.id == Convert.ToInt32(txtid.Text) select ix).First(); g.Status = "Cancel"; db.SubmitChanges(); //insert Stock DateTime?CalDate = null; DateTime?AppDate = DateTime.Now; int Seq = 1; //decimal Qty_Inv = 0; //decimal Qty_DL = 0; //decimal Qty_Remain = 0; //decimal QTY = 0; //decimal QTY_temp = 0; //QTY = Convert.ToDecimal(g.QTY); //QTY_temp = 0; //Qty_Remain = (Convert.ToDecimal(db.Cal_QTY(g.CodeNo, "", 0))); //sum ทั้งหมด //Qty_Inv = (Convert.ToDecimal(db.Cal_QTY(g.CodeNo, "Invoice", 0))); //sum เฉพาะ Invoice //Qty_DL = (Convert.ToDecimal(db.Cal_QTY(g.CodeNo, "Temp", 0))); // sum เฉพาะ DL string Type_in_out = "In"; decimal RemainQty = 0; decimal Amount = 0; decimal RemainAmount = 0; decimal Avg = 0; decimal UnitCost = 0; decimal sum_Remain = 0; decimal sum_Qty = 0; UnitCost = Convert.ToDecimal(g.UnitCost); //get_cost(g.CodeNo); Amount = Convert.ToDecimal(txtQTY.Text) * UnitCost; //แบบที่ 1 จะไป sum ใหม่ RemainQty = (Convert.ToDecimal(db.Cal_QTY(g.CodeNo, "", 0))); //แบบที่ 2 จะไปดึงล่าสุดมา //RemainQty = Convert.ToDecimal(dbClss.Get_Stock(vv.CodeNo, "", "", "RemainQty")); sum_Remain = Convert.ToDecimal(dbClss.Get_Stock(g.CodeNo, "", "", "RemainAmount")) + Amount; sum_Qty = RemainQty + Convert.ToDecimal(txtQTY.Text); Avg = sum_Remain / sum_Qty; RemainAmount = sum_Qty * Avg; //กรณีที่ Shipping แบบ Temp แล้ว cancel ให้มาปรับ Flag ด้วย var s1 = (from ix in db.tb_Stocks //join i in db.tb_Items on ix.CodeNo equals i.CodeNo where ix.RefNo.Trim() == txtSHNo.Text.Trim() && ix.Status != "Cancel" && ix.Refid == Convert.ToInt32(txtid.Text) && ix.Category == "Temp" && ix.Flag_ClearTemp == 1 && ix.Type == "Shipping" select ix).ToList(); if (s1.Count > 0) { var s = (from ix in db.tb_Stocks //join i in db.tb_Items on ix.CodeNo equals i.CodeNo where ix.RefNo.Trim() == txtSHNo.Text.Trim() && ix.Status != "Cancel" && ix.Refid == Convert.ToInt32(txtid.Text) && ix.Category == "Temp" && ix.Flag_ClearTemp == 1 && ix.Type == "Shipping" select ix).First(); if (s != null) { s.Flag_ClearTemp = 2; db.SubmitChanges(); } } tb_Stock gg = new tb_Stock(); gg.AppDate = AppDate; gg.Seq = Seq; gg.App = "Cancel SH"; gg.Appid = Seq; gg.CreateBy = ClassLib.Classlib.User; gg.CreateDate = DateTime.Now; gg.DocNo = txtCNNo.Text; gg.RefNo = txtSHNo.Text; gg.Type = ddlType.Text; gg.CodeNo = txtCodeNo.Text.Trim(); gg.QTY = Convert.ToDecimal(txtQTY.Text); gg.Inbound = Convert.ToDecimal(txtQTY.Text); gg.Outbound = 0; //gg.AmountCost = Convert.ToDecimal(txtQTY.Text) * get_cost(g.CodeNo); //gg.UnitCost = get_cost(g.CodeNo); //gg.RemainQty = 0; //gg.RemainUnitCost = 0; //gg.RemainAmount = 0; gg.CalDate = CalDate; gg.Status = "Active"; gg.Type_i = 4; //Receive = 1,Cancel Receive 2,Shipping = 3,Cancel Shipping = 4,Adjust stock = 5,ClearTemp = 6 gg.Category = Category; gg.Refid = Convert.ToInt32(txtid.Text); gg.Flag_ClearTemp = 0; //0 คือ invoice,1 คือ Temp , 2 คือ clear temp แล้ว gg.Type_in_out = Type_in_out; gg.AmountCost = Amount; gg.UnitCost = UnitCost; gg.RemainQty = sum_Qty; gg.RemainUnitCost = 0; gg.RemainAmount = RemainAmount; gg.Avg = Avg; db.tb_Stocks.InsertOnSubmit(gg); db.SubmitChanges(); dbClss.AddHistory(this.Name, "เพิ่ม Stock", "Cancel รายการ Shipping [" + txtSHNo.Text.Trim() + " id : " + g.id.ToString() + " CodeNo : " + g.CodeNo + " จำนวน : " + txtQTY.Text + "]", txtCNNo.Text); //update Stock เข้า item db.sp_010_Update_StockItem(Convert.ToString(txtCodeNo.Text.Trim()), ""); //update Status db.sp_007_Update_SH_Status(g.ShippingNo, Convert.ToString(g.id)); } } }
protected void Page_Load(object sender, EventArgs e) { db = new DataClasses1DataContext(); }
private bool AddUnit() { bool ck = false; int C = 0; try { radGridView1.EndEdit(); using (DataClasses1DataContext db = new DataClasses1DataContext()) { foreach (var g in radGridView1.Rows) { if (!Convert.ToString(g.Cells["ModelName"].Value).Equals("") ) { if (Convert.ToString(g.Cells["dgvC"].Value).Equals("T")) { //int yyyy = 0; //int mmm = 0; //decimal wk = 0; //int.TryParse(Convert.ToString(g.Cells["YYYY"].Value), out yyyy); //int.TryParse(Convert.ToString(g.Cells["MMM"].Value), out mmm); //decimal.TryParse(Convert.ToString(g.Cells["WorkDays"].Value), out wk); DateTime?d = null; DateTime d1 = DateTime.Now; if (Convert.ToString(g.Cells["dgvCodeTemp"].Value).Equals("")) { tb_Model u = new tb_Model(); u.ModelName = Convert.ToString(g.Cells["ModelName"].Value); u.ModelDescription = Convert.ToString(g.Cells["ModelDescription"].Value); u.ModelActive = Convert.ToBoolean(Convert.ToString(g.Cells["ModelActive"].Value)); u.LineName = Convert.ToString(g.Cells["LineName"].Value); u.MCName = Convert.ToString(g.Cells["MCName"].Value); u.Limit = Convert.ToBoolean(g.Cells["Limit"].Value); if (DateTime.TryParse(Convert.ToString(g.Cells["ExpireDate"].Value), out d1)) { d = dbClss.ChangeFormat(Convert.ToString(g.Cells["ExpireDate"].Value)); //Convert.ToDateTime(Convert.ToString(g.Cells["ExpireDate"].Value)); } u.ExpireDate = d; db.tb_Models.InsertOnSubmit(u); db.SubmitChanges(); C += 1; dbClss.AddHistory(this.Name, "เพิ่ม", "Insert Model [" + u.ModelName + "]", ""); } else { var u = (from ix in db.tb_Models where ix.ModelName == Convert.ToString(g.Cells["dgvCodeTemp"].Value) select ix).First(); u.ModelDescription = Convert.ToString(g.Cells["ModelDescription"].Value); u.ModelActive = Convert.ToBoolean(Convert.ToString(g.Cells["ModelActive"].Value)); u.LineName = Convert.ToString(g.Cells["LineName"].Value); u.MCName = Convert.ToString(g.Cells["MCName"].Value); u.Limit = Convert.ToBoolean(g.Cells["Limit"].Value); if (DateTime.TryParse(Convert.ToString(g.Cells["ExpireDate"].Value), out d1)) { d = dbClss.ChangeFormat(Convert.ToString(g.Cells["ExpireDate"].Value)); //Convert.ToDateTime(Convert.ToString(g.Cells["ExpireDate"].Value)); } u.ExpireDate = d; C += 1; db.SubmitChanges(); dbClss.AddHistory(this.Name, "แก้ไข", "Update Model [" + u.ModelName + "]", ""); } } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); dbClss.AddError("AddUnit", ex.Message, this.Name); } if (C > 0) { MessageBox.Show("บันทึกสำเร็จ!"); } return(ck); }
private void ImportData() { try { using (DataClasses1DataContext db = new DataClasses1DataContext()) { foreach (DataRow rd in dt.Rows) { if (!rd["ModelName"].ToString().Equals("")) { var x = (from ix in db.tb_Models where ix.ModelName == rd["ModelName"].ToString().Trim() select ix).FirstOrDefault(); DateTime?d = null; DateTime d1 = DateTime.Now; if (x == null) { tb_Model u = new tb_Model(); u.ModelName = rd["ModelName"].ToString().Trim(); u.ModelDescription = rd["ModelDescription"].ToString().Trim(); u.ModelActive = Convert.ToBoolean(rd["ModelActive"].ToString()); u.LineName = rd["LineName"].ToString().Trim(); u.MCName = rd["MCName"].ToString().Trim(); u.Limit = Convert.ToBoolean(rd["Limit"].ToString()); if (DateTime.TryParse(rd["ExpireDate"].ToString(), out d1)) { u.ExpireDate = Convert.ToDateTime(rd["ExpireDate"].ToString()); } else { u.ExpireDate = d; } db.tb_Models.InsertOnSubmit(u); db.SubmitChanges(); } else { x.ModelName = rd["ModelName"].ToString().Trim(); x.ModelDescription = rd["ModelDescription"].ToString().Trim(); x.ModelActive = Convert.ToBoolean(rd["ModelActive"].ToString()); x.LineName = rd["LineName"].ToString().Trim(); x.MCName = rd["MCName"].ToString().Trim(); x.Limit = Convert.ToBoolean(rd["Limit"].ToString()); if (DateTime.TryParse(rd["ExpireDate"].ToString(), out d1)) { x.ExpireDate = Convert.ToDateTime(rd["ExpireDate"].ToString()); } else { x.ExpireDate = d; } db.SubmitChanges(); } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); dbClss.AddError("InportData", ex.Message, this.Name); } }
/// <summary> /// Obtiene la información del empleado a partir de su número de cédula /// </summary> /// <param name="pCedula"></param> /// <returns></returns> public SIGEEA_spObtenerEmpleadoResult AutenticaEmpleado(string pCedula) { DataClasses1DataContext dc = new DataClasses1DataContext(); return(dc.SIGEEA_spObtenerEmpleado(pCedula).FirstOrDefault()); }
/// <summary> /// The HomeController() function is used to create a new instance of the Database /// context variable is a simple access to its data. /// </summary> public HomeController() { context = new DataClassAdminDataContext(); contextStudent = new DataClasses1DataContext(); }
/// <summary> /// Realiza un listado de horas pendientes de pago de un empleado en específico /// </summary> /// <param name="pCedula"></param> /// <returns></returns> public List <SIGEEA_spObtenerPagosEmpleadosPendientesResult> ListarPagosEmpleados(string pCedula) { DataClasses1DataContext dc = new DataClasses1DataContext(); return(dc.SIGEEA_spObtenerPagosEmpleadosPendientes(pCedula).ToList()); }
public ClsPrueba() { dbMapeo = new DataClasses1DataContext(); }
public double PrecioVenta(string id) { DataClasses1DataContext dc = new DataClasses1DataContext(); return(dc.SIGEEA_spObtenerPrecioVentaMoneda(id).FirstOrDefault().PreVenta_Moneda); }
public static Guid FindWojIdByNazwa(string nazwa) { DataClasses1DataContext db = new DataClasses1DataContext(); return(db.Wojewodztwos.Where(x => x.Nazwa_Wojewodztwo == nazwa).Select(x => x.Id_Wojewodztwo).SingleOrDefault()); }
private bool AddUnit() { bool ck = false; int C = 0; try { radGridView1.EndEdit(); using (DataClasses1DataContext db = new DataClasses1DataContext()) { foreach (var g in radGridView1.Rows) { if (!Convert.ToString(g.Cells["YYYY"].Value).Equals("") && !Convert.ToString(g.Cells["MMM"].Value).Equals("")) { if (Convert.ToString(g.Cells["dgvC"].Value).Equals("T")) { int yyyy = 0; int mmm = 0; decimal wk = 0; int.TryParse(Convert.ToString(g.Cells["YYYY"].Value), out yyyy); int.TryParse(Convert.ToString(g.Cells["MMM"].Value), out mmm); decimal.TryParse(Convert.ToString(g.Cells["WorkDays"].Value), out wk); if (Convert.ToString(g.Cells["dgvCodeTemp"].Value).Equals("")) { // MessageBox.Show("11"); if (yyyy > 0 && mmm > 0 && wk > 0) { tb_WorkDay u = new tb_WorkDay(); u.YYYY = yyyy; u.MMM = mmm; u.WorkDays = wk; db.tb_WorkDays.InsertOnSubmit(u); db.SubmitChanges(); C += 1; dbClss.AddHistory(this.Name, "เพิ่ม", "Working Days [" + u.YYYY + "," + u.MMM + "]", ""); } } else { var unit1 = (from ix in db.tb_WorkDays where ix.YYYY == Convert.ToInt32(g.Cells["dgvCodeTemp"].Value) && ix.MMM == Convert.ToInt32(g.Cells["dgvCodeTemp2"].Value) select ix).First(); unit1.WorkDays = wk; C += 1; db.SubmitChanges(); dbClss.AddHistory(this.Name, "แก้ไข", "Update Working Days[" + unit1.YYYY + ", " + unit1.MMM + "]", ""); } } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); dbClss.AddError("AddUnit", ex.Message, this.Name); } if (C > 0) { MessageBox.Show("บันทึกสำเร็จ!"); } return(ck); }
private bool AddUnit() { bool ck = false; int C = 0; try { radGridView1.EndEdit(); using (DataClasses1DataContext db = new DataClasses1DataContext()) { foreach (var g in radGridView1.Rows) { if (!Convert.ToString(g.Cells["GroupCode"].Value).Equals("") && !Convert.ToString(g.Cells["TypeCode"].Value).Equals("")) { if (Convert.ToString(g.Cells["dgvC"].Value).Equals("T")) { if (Convert.ToString(g.Cells["dgvCodeTemp"].Value).Equals("") && Convert.ToString(g.Cells["dgvCodeTemp2"].Value).Equals("") ) { // MessageBox.Show("11"); tb_Type gy = new tb_Type(); gy.GroupCode = Convert.ToString(g.Cells["GroupCode"].Value); gy.TypeCode = Convert.ToString(g.Cells["TypeCode"].Value); gy.TypeActive = Convert.ToBoolean(g.Cells["TypeActive"].Value); gy.TypeDetail = Convert.ToString(g.Cells["TypeDetail"].Value); db.tb_Types.InsertOnSubmit(gy); db.SubmitChanges(); C += 1; dbClss.AddHistory(this.Name, "เพิ่มประเภท", "Insert Type Code [" + gy.TypeCode + "]", ""); } else { var unit1 = (from ix in db.tb_Types where ix.GroupCode == Convert.ToString(g.Cells["dgvCodeTemp"].Value) && ix.TypeCode == Convert.ToString(g.Cells["dgvCodeTemp2"].Value) select ix).First(); unit1.TypeDetail = Convert.ToString(g.Cells["TypeDetail"].Value); unit1.TypeActive = Convert.ToBoolean(g.Cells["TypeActive"].Value); C += 1; db.SubmitChanges(); dbClss.AddHistory(this.Name, "แก้ไข", "Update Type Code [" + unit1.TypeCode + "]", ""); } } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); dbClss.AddError("เพิ่มปรเภท", ex.Message, this.Name); } if (C > 0) { MessageBox.Show("บันทึกสำเร็จ!"); } return(ck); }
public FormRegister(FormFirst form11) { InitializeComponent(); this.form11 = form11; data = new DataClasses1DataContext(); }
private bool DeleteUnit() { bool ck = false; int C = 0; int m = 0; try { if (row >= 0) { string CodeTemp = Convert.ToString(radGridView1.Rows[row].Cells["dgvCodetemp"].Value); radGridView1.EndEdit(); if (MessageBox.Show("ต้องการลบรายการหรือไม่ ?", "ลบรายการ", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { using (DataClasses1DataContext db = new DataClasses1DataContext()) { if (!CodeTemp.Equals("")) { //var unit1 = db.mh_Vendors.Where(x => x.No == CodeDelete).ToList(); //foreach (var d in unit1) //{ // db.mh_Vendors.DeleteOnSubmit(d); // dbClss.AddHistory(this.Name, "ลบผู้ขาย", "Delete Vendor [" + d.Name + "]", ""); //} var t = db.mh_Shifts.Where(x => x.id == CodeTemp.ToInt()).ToList(); foreach (var d in t) { //db.mh_Routings.DeleteOnSubmit(d); d.Active = false; if (m == 0) { dbClss.AddHistory(this.Name, "ลบกะทำงาน", $"ลบกะทำงาน [{d.Description}]", ""); } m++; } C += 1; db.SubmitChanges(); } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); dbClss.AddError("ลบกะทำงาน", ex.Message, this.Name); } if (C > 0) { row = row - 1; MessageBox.Show("ลบรายการ สำเร็จ!"); } return(ck); }
// GET: QLGiaDien public QLGiaDienController() { db = new DataClasses1DataContext(); }
private void Save_detail2_H(int seq, int id, string SHNo, string CodeNo) { using (DataClasses1DataContext db = new DataClasses1DataContext()) { string Type = "CNShipping"; string Category = "Invoice"; //Temp,Invoice string Type_in_out = "In"; decimal RemainQty = 0; decimal Amount = 0; decimal RemainAmount = 0; decimal Avg = 0; decimal UnitCost = 0; decimal sum_Remain = 0; decimal sum_Qty = 0; decimal RemainUnitCost = 0; string Location = ""; string ShelfNo = ""; var g = (from ix in db.tb_Shippings //join i in db.tb_Items on ix.CodeNo equals i.CodeNo where ix.ShippingNo.Trim() == SHNo.Trim() && ix.Status != "Cancel" && ix.id == id select ix).First(); g.Status = "Cancel"; //insert Stock DateTime?CalDate = null; DateTime?AppDate = DateTime.Now; int Seq = seq; UnitCost = Convert.ToDecimal(g.UnitCost); //get_cost(g.CodeNo); Amount = Convert.ToDecimal(g.QTY) * UnitCost; //แบบที่ 1 จะไป sum ใหม่ RemainQty = (Convert.ToDecimal(db.Cal_QTY_Remain_Location(g.CodeNo, "", 0, dbClss.TSt(g.Location)))); //แบบที่ 2 จะไปดึงล่าสุดมา //RemainQty = Convert.ToDecimal(dbClss.Get_Stock(vv.CodeNo, "", "", "RemainQty")); sum_Remain = Convert.ToDecimal(dbClss.Get_Stock(g.CodeNo, "", "", "RemainAmount", dbClss.TSt(g.Location))) + Amount; sum_Qty = RemainQty + Convert.ToDecimal(g.QTY); //if (sum_Qty > 0) // Avg = sum_Remain / sum_Qty; //else // Avg = 0; RemainAmount = sum_Remain;//sum_Qty * Avg; if (sum_Qty <= 0) { RemainUnitCost = 0; } else { RemainUnitCost = Math.Round((Math.Abs(RemainAmount) / Math.Abs(sum_Qty)), 2); } //กรณีที่ Shipping แบบ Temp แล้ว cancel ให้มาปรับ Flag ด้วย var s1 = (from ix in db.tb_Stocks //join i in db.tb_Items on ix.CodeNo equals i.CodeNo where ix.DocNo.Trim() == SHNo.Trim() && ix.Status != "Cancel" && ix.CodeNo == CodeNo //&& ix.Refid == id //&& ix.Category == "Temp" //&& ix.Flag_ClearTemp == 1 && ix.Type == "Shipping" select ix).ToList(); if (s1.Count > 0) { Location = dbClss.TSt(s1.FirstOrDefault().Location); ShelfNo = dbClss.TSt(s1.FirstOrDefault().ShelfNo); var ss = (from ix in db.tb_Stocks //join i in db.tb_Items on ix.CodeNo equals i.CodeNo where ix.DocNo.Trim() == SHNo.Trim() && ix.Status != "Cancel" //&& ix.Refid == id && ix.CodeNo == CodeNo && ix.Category == "Temp" && ix.Flag_ClearTemp == 1 && ix.Type == "Shipping" select ix).ToList(); if (ss.Count > 0) { var s = (from ix in db.tb_Stocks //join i in db.tb_Items on ix.CodeNo equals i.CodeNo where ix.DocNo.Trim() == SHNo.Trim() && ix.Status != "Cancel" //&& ix.Refid == id && ix.CodeNo == CodeNo && ix.Category == "Temp" && ix.Flag_ClearTemp == 1 && ix.Type == "Shipping" select ix).First(); if (s != null) { s.Flag_ClearTemp = 2; db.SubmitChanges(); Location = dbClss.TSt(s.Location); } } tb_Stock gg = new tb_Stock(); gg.AppDate = AppDate; gg.Seq = Seq; gg.App = "Cancel SH"; gg.Appid = Seq; gg.CreateBy = ClassLib.Classlib.User; gg.CreateDate = DateTime.Now; gg.DocNo = txtCNNo.Text; gg.RefNo = SHNo; gg.Type = ddlType.Text; gg.QTY = Convert.ToDecimal(g.QTY); gg.Inbound = Convert.ToDecimal(g.QTY); gg.Outbound = 0; gg.CodeNo = g.CodeNo; gg.Status = "Active"; gg.Type_i = 4; //Receive = 1,Cancel Receive 2,Shipping = 3,Cancel Shipping = 4,Adjust stock = 5,ClearTemp = 6 gg.Category = Category; gg.Refid = dbClss.TInt(s1.FirstOrDefault().Refid); //Convert.ToInt32(txtid.Text); gg.RefidAD = s1.FirstOrDefault().RefidAD; //gg.RefShipid = id; gg.Flag_ClearTemp = 0; //0 คือ invoice,1 คือ Temp , 2 คือ clear temp แล้ว gg.Type_in_out = Type_in_out; gg.AmountCost = Amount; gg.UnitCost = UnitCost; gg.RemainQty = sum_Qty; gg.RemainUnitCost = RemainUnitCost; gg.RemainAmount = RemainAmount; gg.Avg = 0;// Avg; gg.TLCost = Amount; gg.TLQty = Convert.ToDecimal(g.QTY); gg.ShipQty = 0; gg.Location = Location; gg.ShelfNo = ShelfNo; gg.RefTempJobCode = dbClss.TSt(s1.FirstOrDefault().RefTempJobCode); gg.RefJobCode = dbClss.TSt(s1.FirstOrDefault().RefJobCode); gg.RefidJobCode = dbClss.TInt(s1.FirstOrDefault().RefidJobCode); db.tb_Stocks.InsertOnSubmit(gg); db.SubmitChanges(); dbClss.AddHistory(this.Name, "เพิ่ม Stock", "Cancel รายการ Shipping [" + txtSHNo.Text.Trim() + " id : " + g.id.ToString() + " CodeNo : " + g.CodeNo + " จำนวน : " + g.QTY.ToString() + "]", txtCNNo.Text); //update Stock เข้า item db.sp_010_Update_StockItem(Convert.ToString(g.CodeNo), ""); } } }
private void btnPrint_Click(object sender, EventArgs e) { //Report.Reportx1.Value = new string[2]; //Report.Reportx1.Value[0] = ""; //BomNo //Report.Reportx1.Value[1] = ClassLib.Classlib.User; //USERID //Report.Reportx1.WReport = "TagFG"; //Report.Reportx1 op1 = new Report.Reportx1("FG_TAG.rpt"); //op1.Show(); this.Cursor = Cursors.WaitCursor; try { if (dgvData.Rows.Where(x => x.Cells["S"].Value.ToBool()).Count() > 0) { var rowlist = dgvData.Rows.Where(x => x.Cells["S"].Value.ToBool()).ToList(); if (rowlist.Where(x => x.Cells["TagCount"].Value.ToDecimal() <= 0).Count() > 0) { baseClass.Warning("Tag cannot less than 1."); return; } using (var db = new DataClasses1DataContext()) { var l = db.mh_ProductTAGs.Where(x => x.UserID == ClassLib.Classlib.User).ToList(); db.mh_ProductTAGs.DeleteAllOnSubmit(l); db.SubmitChanges(); // int rNo = 0; foreach (var row in rowlist) { string JobNo = row.Cells["JobNo"].Value.ToSt(); decimal Qty = row.Cells["Qty"].Value.ToDecimal(); string printDate = DateTime.Now.ToString("ddMMyyyy"); int TagCount = row.Cells["TagCount"].Value.ToInt(); decimal pkStd = row.Cells["PackingSTD"].Value.ToDecimal(); //decimal q1 = Math.Round(Qty / TagCount, 0); //decimal q2 = Qty - Math.Round(q1 * (TagCount - 1), 0); var t = Math.Round(Qty / pkStd, MidpointRounding.AwayFromZero); if (t <= 0) { t = 1; } //var temp_tagCount = TagCount; int ofTag = 0; while (Qty > 0) { ofTag++; rNo++; var q1 = (Qty - pkStd > 0) ? pkStd : Qty; string qr = $"{JobNo},{q1},{printDate},{ofTag}"; byte[] qrCode = dbClss.SaveQRCode2D(qr); var m = new mh_ProductTAG { UserID = ClassLib.Classlib.User, PartNo = row.Cells["ItemNo"].Value.ToSt(), Seq = rNo, PartName = row.Cells["ItemName"].Value.ToSt(), LotNo = row.Cells["LotNo"].Value.ToSt(), Qty = q1, QRCode = qrCode, Machine = "", BOMNo = row.Cells["JobNo"].Value.ToSt(), OFTAG = ofTag.ToSt(), CustomerName = row.Cells["CstmName"].Value.ToSt(), CSTMShot = row.Cells["CstmNo"].Value.ToSt(), ProdDate = row.Cells["ProductionDate"].Value.ToDateTime().Value.Date, }; db.mh_ProductTAGs.InsertOnSubmit(m); Qty -= pkStd; } //while (t > 0) //{ // ofTag++; // rNo++; // bool last = temp_tagCount == 1; // string qr = $"{JobNo},{((last) ? q2 : q1)},{printDate},{ofTag}"; // byte[] qrCode = dbClss.SaveQRCode2D(qr); // var m = new mh_ProductTAG // { // UserID = ClassLib.Classlib.User, // PartNo = row.Cells["ItemNo"].Value.ToSt(), // Seq = rNo, // PartName = row.Cells["ItemName"].Value.ToSt(), // LotNo = row.Cells["LotNo"].Value.ToSt(), // Qty = (last) ? q2 : q1, // QRCode = qrCode, // Machine = "", // BOMNo = row.Cells["JobNo"].Value.ToSt(), // OFTAG = ofTag.ToSt(), // CustomerName = row.Cells["CstmName"].Value.ToSt(), // CSTMShot = row.Cells["CstmNo"].Value.ToSt(), // ProdDate = row.Cells["ProductionDate"].Value.ToDateTime().Value.Date, // }; // db.mh_ProductTAGs.InsertOnSubmit(m); // temp_tagCount--; //} db.SubmitChanges(); //Save Production Date DateTime ProductionDate = row.Cells["ProductionDate"].Value.ToDateTime().Value.Date; var p = db.mh_ProductionOrders.Where(x => x.JobNo == JobNo).FirstOrDefault(); if (p != null) { p.ProductionDate = ProductionDate; db.SubmitChanges(); } } if (rNo > 0) { Report.Reportx1.Value = new string[2]; Report.Reportx1.Value[0] = ""; //BomNo Report.Reportx1.Value[1] = ClassLib.Classlib.User; //USERID Report.Reportx1.WReport = "TagFG"; Report.Reportx1 op = new Report.Reportx1("FG_TAG.rpt"); op.Show(); } } } else { baseClass.Warning("Please select Data.\n"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { this.Cursor = Cursors.Default; } }
public DanhSachDuocLenSoBo() { db = new DataClasses1DataContext(); }