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