private void ImportData()
{
try
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
foreach (DataRow rd in dt.Rows)
{
if (!rd["YYYY"].ToString().Equals("0") && !rd["MMM"].ToString().Equals("0"))
{
int yyyy = 0;
int mmm = 0;
decimal wk = 0;
int.TryParse(Convert.ToString(rd["YYYY"].ToString()), out yyyy);
int.TryParse(Convert.ToString(rd["MMM"].ToString()), out mmm);
decimal.TryParse(Convert.ToString(rd["WorkDays"].ToString()), out wk);
var x = (from ix in db.tb_WorkDays where ix.YYYY == yyyy && ix.MMM == mmm select ix).FirstOrDefault();
if (yyyy > 0 && mmm > 0 && wk > 0)
{
if (x == null)
{
tb_WorkDay ts = new tb_WorkDay();
ts.YYYY = yyyy;
ts.MMM = mmm;
ts.WorkDays = wk;
db.tb_WorkDays.InsertOnSubmit(ts);
db.SubmitChanges();
}
else
{
x.WorkDays = wk;
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["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);
}