public DataSet GetDS(DTO.Booking Ob)
{
SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_Booking");
cmd = AddParameters_Booking(cmd, FlagType.Select, Ob);
return((DataSet)SqlHelper.ExecuteStoredProc(cmd));
}
private SqlCommand AddParameters_Booking(SqlCommand cmd, FlagType flag, DTO.Booking Ob)
{
cmd.Parameters.Add(new SqlParameter("@Flag", flag));
cmd.Parameters.Add(new SqlParameter("@BookingNumber", Ob.BookingNumber));
cmd.Parameters.Add(new SqlParameter("@IsHomeReceipt", Ob.IsHomeReceipt));
cmd.Parameters.Add(new SqlParameter("@HomeReceiptNumber", Ob.HomeReceiptNumber));
cmd.Parameters.Add(new SqlParameter("@CustomerID", Ob.CustomerID));
cmd.Parameters.Add(new SqlParameter("@DueDate", Ob.DueDate));
cmd.Parameters.Add(new SqlParameter("@DueTime", Ob.DueTime));
cmd.Parameters.Add(new SqlParameter("@IsUrgent", Ob.IsUrgent));
cmd.Parameters.Add(new SqlParameter("@IsSMS", Ob.IsSMS));
cmd.Parameters.Add(new SqlParameter("@IsEmail", Ob.IsEmail));
cmd.Parameters.Add(new SqlParameter("@ReceiptRemarks", Ob.ReceiptRemarks));
cmd.Parameters.Add(new SqlParameter("@SalesManUserID", Ob.SalesManUserID));
cmd.Parameters.Add(new SqlParameter("@CheckedByUserID", Ob.CheckedByUserID));
cmd.Parameters.Add(new SqlParameter("@TotalGrossAmount", Ob.TotalGrossAmount));
cmd.Parameters.Add(new SqlParameter("@TotalDiscount", Ob.TotalDiscount));
cmd.Parameters.Add(new SqlParameter("@TotalTax", Ob.TotalTax));
cmd.Parameters.Add(new SqlParameter("@TotalAdvance", Ob.TotalAdvance));
cmd.Parameters.Add(new SqlParameter("@ReceiptStatus", Ob.ReceiptStatus));
cmd.Parameters.Add(new SqlParameter("@Active", Ob.CommonFields.Active));
cmd.Parameters.Add(new SqlParameter("@DateCreated", Ob.CommonFields.DateCreated));
cmd.Parameters.Add(new SqlParameter("@DateModified", Ob.CommonFields.DateModified));
cmd.Parameters.Add(new SqlParameter("@CreatedBy", Ob.CommonFields.CreatedBy));
cmd.Parameters.Add(new SqlParameter("@ModifiedBy", Ob.CommonFields.ModifiedBy));
cmd.Parameters.Add(new SqlParameter("@BranchId", Ob.CommonFields.BranchId));
cmd.Parameters.Add(new SqlParameter("@XMLName", Ob.XMLName));
return(cmd);
}
public int DeleteBooking(DTO.Booking Ob)
{
SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_Booking");
FlagType flag;
flag = FlagType.Delete;
cmd = AddParameters_Booking(cmd, flag, Ob);
return((int)SqlHelper.ExecuteStoredProc(cmd));
}
public int SaveBookingData(string bookingXml, DTO.Booking Ob)
{
SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_Booking");
FlagType flag;
if (Ob.BookingID > 0)
{
flag = FlagType.Update;
}
else
{
flag = FlagType.Insert;
}
cmd = AddParameters_Booking(cmd, flag, Ob);
cmd.Parameters.Add(new SqlParameter("@booking_Xml", bookingXml));
return((int)SqlHelper.ExecuteStoredProc(cmd));
}
public int SaveBookingData(DTO.Booking Ob)
{
return(0);
//return DAL.DALFactory.Instance.DAL_Booking.SaveBookingData(Ob);
}
public int DeleteBooking(DTO.Booking Ob)
{
return(DAL.DALFactory.Instance.DAL_Booking.DeleteBooking(Ob));
}
public DataSet GetDS(DTO.Booking Ob)
{
return(DAL.DALFactory.Instance.DAL_Booking.GetDS(Ob));
}
public void DTO2DB(DTO.Booking dtoItem, ref Booking dbItem, string _tempFolder)
{
if ((!dbItem.IsETAConfirmed.HasValue || !dbItem.IsETAConfirmed.Value) && !string.IsNullOrEmpty(dtoItem.ETA))
{
if (DateTime.TryParse(dtoItem.ETA, cInfo, System.Globalization.DateTimeStyles.None, out tmpDate))
{
dbItem.ETA = tmpDate;
}
}
if ((!dbItem.IsETA2Confirmed.HasValue || !dbItem.IsETA2Confirmed.Value) && !string.IsNullOrEmpty(dtoItem.ETA2))
{
if (DateTime.TryParse(dtoItem.ETA2, cInfo, System.Globalization.DateTimeStyles.None, out tmpDate))
{
dbItem.ETA2 = tmpDate;
}
}
if (!string.IsNullOrEmpty(dtoItem.BookingDate))
{
if (DateTime.TryParse(dtoItem.BookingDate, cInfo, System.Globalization.DateTimeStyles.None, out tmpDate))
{
dbItem.BookingDate = tmpDate;
}
}
if (!string.IsNullOrEmpty(dtoItem.ShipedDate))
{
if (DateTime.TryParse(dtoItem.ShipedDate, cInfo, System.Globalization.DateTimeStyles.None, out tmpDate))
{
dbItem.ShipedDate = tmpDate;
}
}
if (!string.IsNullOrEmpty(dtoItem.ETD))
{
if (DateTime.TryParse(dtoItem.ETD, cInfo, System.Globalization.DateTimeStyles.None, out tmpDate))
{
dbItem.ETD = tmpDate;
}
}
if (!string.IsNullOrEmpty(dtoItem.CutOffDate))
{
if (DateTime.TryParse(dtoItem.CutOffDate, cInfo, System.Globalization.DateTimeStyles.None, out tmpDate))
{
dbItem.CutOffDate = tmpDate;
}
}
if (!string.IsNullOrEmpty(dtoItem.ConfirmAllLoadingDate))
{
if (DateTime.TryParse(dtoItem.ConfirmAllLoadingDate, cInfo, System.Globalization.DateTimeStyles.None, out tmpDate))
{
dbItem.ConfirmAllLoadingDate = tmpDate;
}
}
if (!string.IsNullOrEmpty(dtoItem.ResetDate))
{
if (DateTime.TryParse(dtoItem.ResetDate, cInfo, System.Globalization.DateTimeStyles.None, out tmpDate))
{
dbItem.ResetDate = tmpDate;
}
}
if (dtoItem.bookingPlanFactoryOrderDetailDTOs != null)
{
//delete item in db that exist in dto but not exist in db
foreach (var item in dbItem.BookingPlanFactoryOrderDetail.ToArray())
{
if (!dtoItem.bookingPlanFactoryOrderDetailDTOs.Select(s => s.BookingPlanFactoryOrderDetailID).Contains(item.BookingPlanFactoryOrderDetailID))
{
//delete purchase order detail
dbItem.BookingPlanFactoryOrderDetail.Remove(item);
}
}
//read from dto to db
BookingPlanFactoryOrderDetail dbFactoryOrderDetail;
foreach (var item in dtoItem.bookingPlanFactoryOrderDetailDTOs)
{
if (item.BookingPlanFactoryOrderDetailID > 0)
{
dbFactoryOrderDetail = dbItem.BookingPlanFactoryOrderDetail.Where(o => o.BookingPlanFactoryOrderDetailID == item.BookingPlanFactoryOrderDetailID).FirstOrDefault();
}
else
{
dbFactoryOrderDetail = new BookingPlanFactoryOrderDetail();
dbItem.BookingPlanFactoryOrderDetail.Add(dbFactoryOrderDetail);
}
//read purchase request detail dto to db
if (dbFactoryOrderDetail != null)
{
AutoMapper.Mapper.Map <DTO.BookingPlanFactoryOrderDetailDTO, BookingPlanFactoryOrderDetail>(item, dbFactoryOrderDetail);
dbFactoryOrderDetail.BookingPlanFactoryOrderDetailID = item.BookingPlanFactoryOrderDetailID;
}
}
}
if (dtoItem.bookingPlanFactoryOrderSampleDetailDTOs != null)
{
//delete item in db that exist in dto but not exist in db
foreach (var item in dbItem.BookingPlanFactoryOrderSampleDetail.ToArray())
{
if (!dtoItem.bookingPlanFactoryOrderSampleDetailDTOs.Select(s => s.BookingPlanFactoryOrderSampleDetailID).Contains(item.BookingPlanFactoryOrderSampleDetailID))
{
//delete purchase order detail
dbItem.BookingPlanFactoryOrderSampleDetail.Remove(item);
}
}
//read from dto to db
BookingPlanFactoryOrderSampleDetail dbFactoryOrderSampleDetail;
foreach (var item in dtoItem.bookingPlanFactoryOrderSampleDetailDTOs)
{
if (item.BookingPlanFactoryOrderSampleDetailID > 0)
{
dbFactoryOrderSampleDetail = dbItem.BookingPlanFactoryOrderSampleDetail.Where(o => o.BookingPlanFactoryOrderSampleDetailID == item.BookingPlanFactoryOrderSampleDetailID).FirstOrDefault();
}
else
{
dbFactoryOrderSampleDetail = new BookingPlanFactoryOrderSampleDetail();
dbItem.BookingPlanFactoryOrderSampleDetail.Add(dbFactoryOrderSampleDetail);
}
//read purchase request detail dto to db
if (dbFactoryOrderSampleDetail != null)
{
AutoMapper.Mapper.Map <DTO.BookingPlanFactoryOrderSampleDetailDTO, BookingPlanFactoryOrderSampleDetail>(item, dbFactoryOrderSampleDetail);
dbFactoryOrderSampleDetail.BookingPlanFactoryOrderSampleDetailID = item.BookingPlanFactoryOrderSampleDetailID;
}
}
}
if (dtoItem.bookingPlanFactoryOrderSparepartDetailDTOs != null)
{
//delete item in db that exist in dto but not exist in db
foreach (var item in dbItem.BookingPlanFactoryOrderSparepartDetail.ToArray())
{
if (!dtoItem.bookingPlanFactoryOrderSparepartDetailDTOs.Select(s => s.BookingPlanFactoryOrderSparepartDetailID).Contains(item.BookingPlanFactoryOrderSparepartDetailID))
{
//delete purchase order detail
dbItem.BookingPlanFactoryOrderSparepartDetail.Remove(item);
}
}
//read from dto to db
BookingPlanFactoryOrderSparepartDetail dbBookingPlanFactoryOrderSparepartDetail;
foreach (var item in dtoItem.bookingPlanFactoryOrderSparepartDetailDTOs)
{
if (item.BookingPlanFactoryOrderSparepartDetailID > 0)
{
dbBookingPlanFactoryOrderSparepartDetail = dbItem.BookingPlanFactoryOrderSparepartDetail.Where(o => o.BookingPlanFactoryOrderSparepartDetailID == item.BookingPlanFactoryOrderSparepartDetailID).FirstOrDefault();
}
else
{
dbBookingPlanFactoryOrderSparepartDetail = new BookingPlanFactoryOrderSparepartDetail();
dbItem.BookingPlanFactoryOrderSparepartDetail.Add(dbBookingPlanFactoryOrderSparepartDetail);
}
//read purchase request detail dto to db
if (dbBookingPlanFactoryOrderSparepartDetail != null)
{
AutoMapper.Mapper.Map <DTO.BookingPlanFactoryOrderSparepartDetailDTO, BookingPlanFactoryOrderSparepartDetail>(item, dbBookingPlanFactoryOrderSparepartDetail);
dbBookingPlanFactoryOrderSparepartDetail.BookingPlanFactoryOrderSparepartDetailID = item.BookingPlanFactoryOrderSparepartDetailID;
}
}
}
// map fields
AutoMapper.Mapper.Map <DTO.Booking, Booking>(dtoItem, dbItem);
if (dtoItem.BLFile_HasChanged)
{
dbItem.BLFile = (new Module.Framework.DAL.DataFactory()).CreateFilePointer(_tempFolder, dtoItem.BLFile_NewFile, dtoItem.BLFile, dtoItem.FriendlyName);
}
// EUTR File
if (dtoItem.EUTRFile_HasChange.HasValue && dtoItem.EUTRFile_HasChange.Value)
{
dbItem.EUTRFile = (new Module.Framework.DAL.DataFactory()).CreateFilePointer(_tempFolder, dtoItem.EUTRFile_NewFile, dtoItem.EUTRFile, dtoItem.EUTRFriendlyName);
}
// CO File
if (dtoItem.COFile_HasChange.HasValue && dtoItem.COFile_HasChange.Value)
{
dbItem.COFile = (new Module.Framework.DAL.DataFactory()).CreateFilePointer(_tempFolder, dtoItem.COFile_NewFile, dtoItem.COFile, dtoItem.COFriendlyName);
}
// Fumigation File
if (dtoItem.FumigationFile_HasChange.HasValue && dtoItem.FumigationFile_HasChange.Value)
{
dbItem.FumigationFile = (new Module.Framework.DAL.DataFactory()).CreateFilePointer(_tempFolder, dtoItem.FumigationFile_NewFile, dtoItem.FumigationFile, dtoItem.FumigationFriendlyName);
}
// Other File
if (dtoItem.OtherFile_HasChange.HasValue && dtoItem.OtherFile_HasChange.Value)
{
dbItem.OtherFile = (new Module.Framework.DAL.DataFactory()).CreateFilePointer(_tempFolder, dtoItem.OtherFile_NewFile, dtoItem.OtherFile, dtoItem.OtherFriendlyName);
}
// Confirm File
if (dtoItem.ConfirmationFile_HasChange.HasValue && dtoItem.ConfirmationFile_HasChange.Value)
{
dbItem.ConfirmationFile = (new Module.Framework.DAL.DataFactory()).CreateFilePointer(_tempFolder, dtoItem.ConfirmationFile_NewFile, dtoItem.ConfirmationFile, dtoItem.ConfirmationFriendlyName);
}
// Booking Confirmation File
if (dtoItem.BookingConfirmationFile_HasChange.HasValue && dtoItem.BookingConfirmationFile_HasChange.Value)
{
dbItem.BookingConfirmationFile = (new Module.Framework.DAL.DataFactory()).CreateFilePointer(_tempFolder, dtoItem.BookingConfirmationFile_NewFile, dtoItem.BookingConfirmationFile, dtoItem.BookingConfirmationFriendlyName);
}
}
