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 = DateTime.Now; 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); } }
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) { if (radGridView1.Rows.Count == 1) { row = 0; } MessageBox.Show("บันทึกสำเร็จ!"); } return(ck); }