public static bool insert_delivery_note(Phieu_Giao pg)
{
if (QLLK_DAO.add_delivery_note(pg))
{
return(true);
}
return(false);
}
public static bool add_delivery_note(Phieu_Giao pg)
{
string query = @"insert into PHIEU_GIAO values('" + pg.Id_pg + "','" + pg.Id_hd + "',convert(datetime,'" + pg.Ngaygiao + "',103),'" + pg.Noinhan + "','" + pg.Trangthai + "','" + pg.Id_kh + "')";
SqlConnection conn = new SqlConnection(@"Data Source=LAPTOP-A27VSOCJ\SQLEXPRESS;Initial Catalog=QLLK;Integrated Security=True");
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(false);
}
public bool UpData(Phieu_Giao pgObj)
{
cmd.CommandText = "update PHIEU_GIAO set TRANG_THAI = '" + pgObj.Trangthai + "' where ID_PG='" + pgObj.Id_pg + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn.Connection;
try
{
conn.OpenConn();
cmd.ExecuteNonQuery();
conn.CloseConn();
return(true);
}
catch (Exception ex)
{
String mex = ex.Message;
cmd.Dispose();
conn.CloseConn();
}
return(false);
}
public bool UpdData(Phieu_Giao hdObj)
{
return(hdMod.UpData(hdObj));
}
