private void ImportData()
{
try
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
foreach (DataRow rd in dt.Rows)
{
if (!rd["CRRNCY"].ToString().Equals(""))
{
var x = (from ix in db.tb_CRRNCies where ix.CRRNCY.ToLower().Trim() == rd["CRRNCY"].ToString().ToLower().Trim() select ix).FirstOrDefault();
if (x == null)
{
tb_CRRNCY ts = new tb_CRRNCY();
ts.CRRNCY = Convert.ToString(rd["CRRNCY"].ToString());
ts.Rate = Convert.ToDecimal(rd["Rate"].ToString());
//ts.UnitActive = Convert.ToBoolean(rd["UnitActive"].ToString());
db.tb_CRRNCies.InsertOnSubmit(ts);
db.SubmitChanges();
}
else
{
x.Rate = Convert.ToDecimal(rd["Rate"].ToString());
//x.UnitActive = Convert.ToBoolean(rd["UnitActive"].ToString());
db.SubmitChanges();
}
}
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message);
dbClss.AddError("ImportData", 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["CRRNCY"].Value).Equals("") && g.IsVisible)
{
if (Convert.ToString(g.Cells["dgvC"].Value).Equals("T"))
{
if (Convert.ToString(g.Cells["dgvCRRNCYTemp"].Value).Equals(""))
{
// MessageBox.Show("11");
tb_CRRNCY u = new tb_CRRNCY();
u.CRRNCY = Convert.ToString(g.Cells["CRRNCY"].Value);
//u.UnitActive = Convert.ToBoolean(g.Cells["UnitActive"].Value);
u.Rate = dbClss.TDe(g.Cells["Rate"].Value);
db.tb_CRRNCies.InsertOnSubmit(u);
db.SubmitChanges();
C += 1;
dbClss.AddHistory(this.Name, "เพิ่ม", "Insert CRRNCY Code [" + u.CRRNCY + "]", "");
}
else
{
var unit1 = (from ix in db.tb_CRRNCies
where ix.CRRNCY == Convert.ToString(g.Cells["dgvCRRNCYTemp"].Value)
select ix).First();
unit1.Rate = dbClss.TDe(g.Cells["Rate"].Value);
//unit1.UnitActive = Convert.ToBoolean(g.Cells["UnitActive"].Value);
C += 1;
db.SubmitChanges();
dbClss.AddHistory(this.Name, "แก้ไข", "Update CRRNCY Code [" + unit1.CRRNCY + "]", "");
}
}
}
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message);
dbClss.AddError("AddCRRNCY", ex.Message, this.Name); }
if (C > 0)
{
MessageBox.Show("บันทึกสำเร็จ!");
}
return(ck);
}
