public void ThemVe(DTO.Ve ve)
{
Provider p = new Provider();
try
{
p.Connect();
string strSql = "sp_ThemVe";
p.ExecuteNonQuery(CommandType.StoredProcedure, strSql,
new SqlParameter {
ParameterName = "@ID", Value = ve.ID
},
new SqlParameter {
ParameterName = "@IDGhe", Value = ve.IDGhe
},
new SqlParameter {
ParameterName = "@IdChuyen", Value = ve.IDChuyen
},
new SqlParameter {
ParameterName = "@GiaTien", Value = ve.GiaTien
},
new SqlParameter {
ParameterName = "@NgayXuat", Value = ve.NgayXuat
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
p.Disconnect();
}
}
public void Chuyen_ThemChuyen(DTO.Chuyen chuyen)
{
DAO.DAO_Chuyen.Instance.ThemChuyen(chuyen);
DataTable dt = DAO.DAO_Ghe.Instance.FillDGVGhe(chuyen.IdXe);
DTO.Ve ve = new DTO.Ve();
ve.IDChuyen = chuyen.ID;
int kc = DAO.DAO_Tuyen.Instance.FindKhoangCach(chuyen.IDTuyen);
ve.GiaTien = kc * 1000;
ve.NgayXuat = DateTime.Now;
foreach (DataRow row in dt.Rows)
{
int idve = DAO.DAO_Ve.Instance.IdVeMax();
idve++;
ve.ID = idve;
ve.IDGhe = Convert.ToInt32(row["ID_Ghe"]);
DAO.DAO_Ve.Instance.ThemVe(ve);
}
}
