private void ImportData() { try { using (DataClasses1DataContext db = new DataClasses1DataContext()) { foreach (DataRow rd in dt.Rows) { if (!rd["GroupCode"].ToString().Equals("") && !rd["TypeCode"].ToString().Equals("")) { var x = (from ix in db.mh_Types where ix.GroupCode.ToLower().Trim() == rd["GroupCode"].ToString().ToLower().Trim() && ix.TypeCode.ToLower().Trim() == rd["TypeCode"].ToString().ToLower().Trim() select ix).FirstOrDefault(); if (x == null) { mh_Type ts = new mh_Type(); ts.GroupCode = Convert.ToString(rd["GroupCode"].ToString()); ts.TypeCode = Convert.ToString(rd["TypeCode"].ToString()); ts.TypeDetail = Convert.ToString(rd["TypeDetail"].ToString()); ts.TypeActive = Convert.ToBoolean(rd["TypeActive"].ToString()); db.mh_Types.InsertOnSubmit(ts); db.SubmitChanges(); } else { x.TypeDetail = Convert.ToString(rd["TypeDetail"].ToString()); x.TypeActive = Convert.ToBoolean(rd["TypeActive"].ToString()); 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["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"); mh_Type gy = new mh_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.mh_Types.InsertOnSubmit(gy); db.SubmitChanges(); C += 1; dbClss.AddHistory(this.Name, "เพิ่มประเภท", "Insert Type Code [" + gy.TypeCode + "]", ""); } else { var unit1 = (from ix in db.mh_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); }