public static Chang GetInfo(string MaChang)
{
DataTable dt = ShipBookingData.FillDataTable("spChang_SelectByID", "@MaChang", MaChang);
Chang chang = new Chang();
if (dt.Rows.Count > 0)
{
chang.MaChang = dt.Rows[0]["MaChang"].ToString();
chang.TinhTrang = dt.Rows[0]["TinhTrang"].ToString();
chang.MaTPDi = dt.Rows[0]["MaTPDi"].ToString();
chang.MaTPDen = dt.Rows[0]["MaTPDen"].ToString();
chang.TenTPDi = dt.Rows[0]["TenTPDi"].ToString();
chang.TenTPDen = dt.Rows[0]["TenTPDen"].ToString();
}
else
{
chang = null;
}
return chang;
}
public static void Update(Chang chang)
{
string[] parameters = new string[] { "@MaChang", "@TinhTrang", "@MaTPDi", "@MaTPDen", "@TenTPDi", "@TenTPDen" };
string[] values = new string[] { chang.MaChang, chang.TinhTrang, chang.MaTPDi, chang.MaTPDen, chang.TenTPDi, chang.TenTPDen };
ExecuteData("spChang_UpdateByID", parameters, values);
}
