public bool InsertDongia(DTO.Dongia dg)
{
string sql = "INSERT INTO DONGIA(MADG, MATB, MAHV, DONGIA) VALUES(@MADG, @MATB,@MAHV,@DONGIA)";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MADG", SqlDbType.VarChar).Value = TaoMaDG();
//cmd.Parameters.Add("@MATB", SqlDbType.VarChar).Value = dg.matb;
//cmd.Parameters.Add("@MAHV", SqlDbType.VarChar).Value = dg.mahv;
cmd.Parameters.Add("@DONGIA", SqlDbType.Decimal).Value = dg.dongia;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool UpdateDongia(DTO.Dongia dg)
{
string sql = "UPDATE DONGIA SET MATB=@MATB, MAHV=@MAHV, DONGIA=@DONGIA WHERE MADG=@MADG";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MADG", SqlDbType.VarChar).Value = dg.madg;
// cmd.Parameters.Add("@MATB", SqlDbType.VarChar).Value = dg.matb;
//cmd.Parameters.Add("@MAHV", SqlDbType.VarChar).Value = dg.mahv;
cmd.Parameters.Add("@DONGIA", SqlDbType.Decimal).Value = dg.dongia;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool DeleteDongia(DTO.Dongia dg)
{
string sql = "DELETE DONGIA WHERE MADG = @MADG";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MADG", SqlDbType.VarChar).Value = dg.madg;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool Delete(DTO.Dongia dto)
{
return(dal.DeleteDongia(dto));
}
public bool Update(DTO.Dongia dto)
{
return(dal.UpdateDongia(dto));
}
public bool Add(DTO.Dongia dto)
{
return(dal.InsertDongia(dto));
}
