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"); } } }