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);
}
