public bool UpdateChuyenbay(DTO.Chuyenbay cb)
{
string sql = "UPDATE CHUYENBAY SET MATB=@MATB, MATB=@MATB, NGAYGIO=@NGAYGIO, THOIGIANBAY=@THOIGIANBAY, SLGHEHANG1=@SLGHEHANG1, SLGHEHANG2=@SLGHEHANG2, MADG=@MADG WHERE MACB=@MACB";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MACB", SqlDbType.VarChar).Value = cb.macb;
cmd.Parameters.Add("@MATB", SqlDbType.VarChar).Value = cb.matb;
cmd.Parameters.Add("@NGAYGIO", SqlDbType.DateTime).Value = cb.ngaygio;
cmd.Parameters.Add("@THOIGIANBAY", SqlDbType.Float).Value = cb.thoigianbay;
//cmd.Parameters.Add("@SLGHEHANG1", SqlDbType.Int).Value = cb.slghehang1;
//cmd.Parameters.Add("@SLGHEHANG2", SqlDbType.Int).Value = cb.slghehang2;
cmd.Parameters.Add("@MADG", SqlDbType.Int).Value = cb.madg;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool InsertChuyenbay(DTO.Chuyenbay cb)
{
string sql = "INSERT INTO CHUYENBAY(MACB, MATB, NGAYGIO,THOIGIANBAY,MADG) VALUES(@MACB, @MATB,@NGAYGIO,@THOIGIANBAY,@MADG)";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MACB", SqlDbType.VarChar).Value = TaoMaChuyenBay();
cmd.Parameters.Add("@MATB", SqlDbType.VarChar).Value = cb.matb;
cmd.Parameters.Add("@NGAYGIO", SqlDbType.DateTime).Value = cb.ngaygio;
cmd.Parameters.Add("@THOIGIANBAY", SqlDbType.Float).Value = cb.thoigianbay;
//cmd.Parameters.Add("@SLGHEHANG1", SqlDbType.Int).Value = cb.slghehang1;
//cmd.Parameters.Add("@SLGHEHANG2", SqlDbType.Int).Value = cb.slghehang2;
cmd.Parameters.Add("@MADG", SqlDbType.VarChar).Value = cb.madg;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
