public bool UpdateTinhtrangve(DTO.Tinhtrangve ttv)
{
string sql = "UPDATE TINHTRANGVE SET MACB=@MACB, MAHV=@MAHV, SLGHE=@SLGHE, SLGHETRONG=@SLGHETRONG, SLGHEDAT=@SLGHEDAT WHERE MATTVE=@MATTVE";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MATTVE", SqlDbType.VarChar).Value = ttv.mattve;
cmd.Parameters.Add("@MACB", SqlDbType.VarChar).Value = ttv.macb;
cmd.Parameters.Add("@MAHV", SqlDbType.VarChar).Value = ttv.mahv;
cmd.Parameters.Add("@SLGHE", SqlDbType.Int).Value = ttv.slghe;
cmd.Parameters.Add("@SLGHETRONG", SqlDbType.Int).Value = ttv.slghetrong;
cmd.Parameters.Add("@SLGHEDAT", SqlDbType.Int).Value = ttv.slghedat;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
///dayyyyyyyyyyyyyyyyyyyyyyyy
public bool InsertTinhtrangve(DTO.Tinhtrangve ttv)
{
string sql = "INSERT INTO TINHTRANGVE(MATTVE, MACB, MAHV, SLGHE, SLGHETRONG, SLGHEDAT) VALUES(@MATTVE, @MACB,@MAHV,@SLGHE,@SLGHETRONG,@SLGHEDAT)";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MATTVE", SqlDbType.VarChar).Value = TaoMa_TTV();
cmd.Parameters.Add("@MACB", SqlDbType.VarChar).Value = ttv.macb;
cmd.Parameters.Add("@MAHV", SqlDbType.VarChar).Value = ttv.mahv;
cmd.Parameters.Add("@SLGHE", SqlDbType.Int).Value = ttv.slghe;
cmd.Parameters.Add("@SLGHETRONG", SqlDbType.Int).Value = ttv.slghetrong;
cmd.Parameters.Add("@SLGHEDAT", SqlDbType.Int).Value = ttv.slghedat;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool DeleteTinhtrangve(DTO.Tinhtrangve ttv)
{
string sql = "DELETE TINHTRANGVE WHERE MATTVE = @MATTVE";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MATTVE", SqlDbType.VarChar).Value = ttv.mattve;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool DeleteTinhtrangve(DTO.Tinhtrangve ttv)
{
return(dal.DeleteTinhtrangve(ttv));
}
public bool UpdateTinhtrangve(DTO.Tinhtrangve ttv)
{
return(dal.UpdateTinhtrangve(ttv));
}
public bool InsertTinhtrangve(DTO.Tinhtrangve ttv)
{
return(dal.InsertTinhtrangve(ttv));
}
