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