public int UpdateOutputBookingChecklist(TourBookingChecklistBDto bookingChecklist)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand("BOOKING_TOUR_BOOKING_OUTPUT_CHECKLIST_UPDATE");
db.AddInParameter(dbCmd, "@BOOKING_ID", DbType.Int32, bookingChecklist.BookingId);
db.AddInParameter(dbCmd, "@CHECKLIST_ID", DbType.String, bookingChecklist.CheckListId);
db.AddInParameter(dbCmd, "@DOC_NAME", DbType.String, bookingChecklist.documentName);
db.AddInParameter(dbCmd, "@DOC_CONTENT", DbType.String, bookingChecklist.DocumentContent);
Result = db.ExecuteNonQuery(dbCmd);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{
throw ex;
}
}
finally
{
DALHelper.Destroy(ref dbCmd);
}
return Result;
}
public int InsertOutputBookingChecklist(TourBookingChecklistBDto bookingChecklist)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand("BOOKING_TOUR_BOOKING_OUTPUT_CHECKLIST_INSERT");
db.AddInParameter(dbCmd, "@BOOKING_ID", DbType.Int32, bookingChecklist.BookingId);
db.AddInParameter(dbCmd, "@CHECKLIST_ID", DbType.String, bookingChecklist.CheckListId);
db.AddInParameter(dbCmd, "@DOC_NAME", DbType.String, bookingChecklist.documentName);
db.AddInParameter(dbCmd, "@DOC_CONTENT", DbType.String, bookingChecklist.DocumentContent);
db.AddInParameter(dbCmd, "@CHECKLIST_SRNO", DbType.Int32, bookingChecklist.SerialNo);
if (!string.IsNullOrEmpty(bookingChecklist.Remarks))
db.AddInParameter(dbCmd, "@REMARKS", DbType.String, bookingChecklist.Remarks);
else
db.AddInParameter(dbCmd, "@REMARKS", DbType.String, DBNull.Value);
db.AddInParameter(dbCmd, "@ANSWER_YES_OR_NO", DbType.Boolean, bookingChecklist.Answer);
Result = db.ExecuteNonQuery(dbCmd);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{
throw ex;
}
}
finally
{
DALHelper.Destroy(ref dbCmd);
}
return Result;
}