public void Insert(SaleInfo saleInfo, CustomerInfo customerInfo, SaleDetailInfo saleDetailInfo)
{
try
{
DataControlBaseDataAccess.StartTransaction();
string customerID = CustomerDataAccess.CustomerInsert(customerInfo.CustomerID, customerInfo.CustomerName, customerInfo.Gender, customerInfo.NRCNo, customerInfo.PhoneNo);
string saleID = SaleDataAccess.SaleInsert(saleInfo.SaleID, saleInfo.SaleNo, saleInfo.SaleDate, saleInfo.Quantity, customerID);
SaleDetailDataAccess.SaleDetailInsert(saleDetailInfo.SaleDetailID, saleID, saleDetailInfo.TripID, saleDetailInfo.SeatNo);
if (saleDetailInfo.SeatNo != string.Empty)
{
string seat = saleDetailInfo.SeatNo;
string[] array = seat.Split(',');
seatNo = "";
for (int i = 0; i < array.Length; i++)
{
seatNo = array[i];
TripDetailDataAccess.UpdateStatusByTripID(saleDetailInfo.TripID, seatNo, "S");
}
}
DataControlBaseDataAccess.CommitTransaction();
}
catch (Exception ex)
{
DataControlBaseDataAccess.RollBackTransaction();
throw ex;
}
}
public void Delete(string tripID, string saleID)
{
try
{
DataControlBaseDataAccess.StartTransaction();
SaleDetailController controller = new SaleDetailController();
SaleDetailInfo saleDetailInfo = controller.SelectSaleDetail(tripID, saleID);
SaleDetailDataAccess.SaleDetailDeleteSaleID(tripID, saleID);
SaleDataAccess.SaleDelete(saleID);
string seat = saleDetailInfo.SeatNo;
string[] array = seat.Split(',');
seatNo = "";
for (int i = 0; i < array.Length; i++)
{
seatNo = array[i];
TripDetailDataAccess.UpdateStatusByTripID(tripID, seatNo, "A");
}
DataControlBaseDataAccess.CommitTransaction();
}
catch (Exception ex)
{
DataControlBaseDataAccess.RollBackTransaction();
throw ex;
}
}
public SaleDetailInfo SelectSaleDetail(string tripID, string saleID)
{
IDataReader Reader = DataAccess.SelectSaleDetail(tripID, saleID);
SaleDetailInfo saleDetailInfo = new SaleDetailInfo();
while (Reader.Read())
{
saleDetailInfo.SaleDetailID = Convert.ToString(Reader["SaleDetailID"]);
saleDetailInfo.SeatNo = Convert.ToString(Reader["SeatNo"]);
}
Reader.Close();
return(saleDetailInfo);
}
public void TripDetailUpdate(SaleDetailInfo saleDetailInfo)//for edit
{
if (saleDetailInfo.SeatNo != null)
{
string seat = saleDetailInfo.SeatNo;
string[] array = seat.Split(',');
seatNo = "";
for (int i = 0; i < array.Length; i++)
{
seatNo = array[i];
TripDetailDataAccess.UpdateStatusByTripID(saleDetailInfo.TripID, seatNo, "A");
}
}
}
