public Result update(DTO_Object obj)
{
String query = "UPDATE [OBJECT] ";
query += "SET [DISPLAYNAME] = @DISPLAYNAME, [ID_SUP] = @ID_SUP, [ID_UNI] = @ID_UNI, [NUM_REPO] = @NUM_REPO ";
query += "WHERE [ID_OBJ] = @ID_OBJ";
SqlCommand cmmd = new SqlCommand();
cmmd.Connection = conn;
cmmd.CommandType = System.Data.CommandType.Text;
cmmd.CommandText = query;
cmmd.Parameters.AddWithValue("@ID_OBJ", obj.ID);
cmmd.Parameters.AddWithValue("@DISPLAYNAME", obj.DISPLAYNAME);
cmmd.Parameters.AddWithValue("@ID_SUP", obj.ID_SUP);
cmmd.Parameters.AddWithValue("@ID_UNI", obj.ID_UNI);
cmmd.Parameters.AddWithValue("@NUM_REPO", obj.NUM_REPO);
try
{
conn.Open();
cmmd.ExecuteNonQuery();
}
catch (Exception e)
{
conn.Close();
System.Console.WriteLine(e.Message);
return(new Result(false, e.Message));
}
conn.Close();
return(new Result(true));
}
public Result insert(DTO_Object obj)
{
String query = "INSERT INTO [OBJECT] ([ID_OBJ], [DISPLAYNAME], [ID_SUP], [ID_UNI], [NUM_REPO]) ";
query += "VALUES (@ID_OBJ, @DISPLAYNAME, @ID_SUP, @ID_UNI, @NUM_REPO)";
SqlCommand cmmd = new SqlCommand();
cmmd.Connection = conn;
cmmd.CommandType = System.Data.CommandType.Text;
cmmd.CommandText = query;
cmmd.Parameters.AddWithValue("@ID_OBJ", obj.ID);
cmmd.Parameters.AddWithValue("@DISPLAYNAME", obj.DISPLAYNAME);
cmmd.Parameters.AddWithValue("@ID_SUP", obj.ID_SUP);
cmmd.Parameters.AddWithValue("@ID_UNI", obj.ID_UNI);
cmmd.Parameters.AddWithValue("@NUM_REPO", obj.NUM_REPO);
try
{
conn.Open();
cmmd.ExecuteNonQuery();
}
catch (Exception e)
{
conn.Close();
System.Console.WriteLine(e.Message);
return(new Result(false, e.Message));
}
conn.Close();
return(new Result(true));
}
private void btAdd_Click(object sender, EventArgs e)
{
if (isNull(tbName.Text) || isNull(tbNumberRepo.Text))
{
MessageBox.Show("Thông tin nguyên liệu không hợp lệ", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
String id = tbID.Text;
String name = tbName.Text;
String id_sup = cbSuplier.SelectedValue.ToString();
String id_uni = cbUnit.SelectedValue.ToString();
int num_repo = Int16.Parse(tbNumberRepo.Text);
DTO_Object obj = new DTO_Object(id, name, id_sup, id_uni, num_repo);
Result result = bus_object.insert(obj);
if (result.Flag)
{
MessageBox.Show("Thêm mới nguyên liệu thành công", "Successful", MessageBoxButtons.OK,
MessageBoxIcon.Information);
tbID.Text = bus_object.nextID().ToString();
tbName.Text = String.Empty;
tbNumberRepo.Text = String.Empty;
LoadDataGridViewObject();
}
else
{
MessageBox.Show("Thêm mới nguyên liệu thất bại \nError: " + result.Message, "Failed", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
public Result update(DTO_Object obj)
{
return(dal_object.update(obj));
}
public Result insert(DTO_Object obj)
{
return(dal_object.insert(obj));
}
