public bool addCustomer(DTO_Departurement dept)
{
try
{
conn.Open();
string sqlStr = string.Format(@"INSERT INTO [dbo].[DEPARTMENT] ([CODE],[NAME_ENG],[NAME_VIE]) VALUES('{0}','{1}',N'{2}')", dept.Code, dept.Eng, dept.Vie);
SqlCommand cmd = new SqlCommand(sqlStr, conn);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
}
finally
{
conn.Close();
}
return(false);
}
private void button3_Click(object sender, EventArgs e)
{
int complete = 0, count = 0;
foreach (DataGridViewRow row in dgData.Rows)
{
try{
DTO_Departurement dept = new DTO_Departurement();
dept.Code = row.Cells[0].Value.ToString();
dept.Eng = row.Cells[1].Value.ToString();
dept.Vie = row.Cells[2].Value.ToString();
if (BUS_User.addCustomer(dept))
{
complete++;
}
}
catch
{
}
count++;
}
MessageBox.Show("Hoàn thành " + complete + " / " + (count));
dgData.DataSource = BUS_User.getDeptTable();
}
public List <DTO_Departurement> getDept()
{
String queryString = string.Format(@"SELECT TOP 1000 [CODE]
,[NAME_ENG]
,[NAME_VIE]
FROM .[dbo].[DEPARTMENT]");
SqlDataAdapter da = new SqlDataAdapter(queryString, conn);
DataTable dt = new DataTable();
da.Fill(dt);
List <DTO_Departurement> listDept = new List <DTO_Departurement>();
foreach (DataRow row in dt.Rows)
{
DTO_Departurement dept = new DTO_Departurement();
dept.Code = row[0].ToString();
dept.Eng = row[1].ToString();
dept.Vie = row[2].ToString();
listDept.Add(dept);
}
return(listDept);
}
public bool addCustomer(DTO_Departurement dept)
{
return(dalUser.addCustomer(dept));
}
