public void addTranDau(string mav, int sotran)
{
DTO_TRANDAU dtot = new DTO_TRANDAU();
dtot.MaTran = nextMa();
dtot.MaVong = mav;
dtot.SoTran = sotran;
addTRAN(dtot);
}
//xoa
public bool delTRAN(DTO_TRANDAU d)
{
try
{
connect.Open();
string sql = string.Format("DELETE FROM TRANDAU WHERE MaTran={0}", d.MaTran);
SqlCommand cmd = new SqlCommand(sql, connect);
//kiem tra
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e) { }
finally
{
connect.Close();
}
return(false);
}
//sua
public bool upTRAN(DTO_TRANDAU d)
{
try
{
connect.Open();
string sql = string.Format("UPDATE LICHTD SET MaVong='{0}', SoTran={1} WHERE MaTran='{2}'", d.MaVong, d.SoTran, d.MaTran);
SqlCommand cmd = new SqlCommand(sql, connect);
//kiem tra
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e) { }
finally
{
connect.Close();
}
return(false);
}
//them
public bool addTRAN(DTO_TRANDAU d)
{
try
{
connect.Open();
string sql = string.Format("INSERT INTO TRANDAU(MaTran,MaVong,SoTran) VALUES ('{0}','{1}',{2})", d.MaTran, d.MaVong, d.SoTran);
SqlCommand cmd = new SqlCommand(sql, connect);
//kiem tra
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e) { }
finally
{
//close connect
connect.Close();
}
return(false);
}
public bool delTRAN(DTO_TRANDAU g)
{
return(dalTRANDAU.delTRAN(g));
}
public bool upTRAN(DTO_TRANDAU g)
{
return(dalTRANDAU.upTRAN(g));
}
public bool addTRAN(DTO_TRANDAU g)
{
return(dalTRANDAU.addTRAN(g));
}
