public int SaveTourInquiryQuotedAmount(InquiryForTourBDto ObjInquiryGRDMappingBDto) { Database db = null; DbCommand dbCmd = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand("dbo.USP_INQUIRY_FOR_TOUR_QUOTED_AMOUNT_SAVE"); db.AddInParameter(dbCmd, "@INQUIRY_ID", DbType.Int32, ObjInquiryGRDMappingBDto.InquiryId); db.AddInParameter(dbCmd, "@INQUIRY_SR_NO", DbType.Int32, ObjInquiryGRDMappingBDto.SerialNo); db.AddInParameter(dbCmd, "@TOUR_INQ_SR_NO", DbType.Int32, ObjInquiryGRDMappingBDto.TourInquirySerialNo); db.AddInParameter(dbCmd, "@TOUR_ID", DbType.Int32, ObjInquiryGRDMappingBDto.TourId); db.AddInParameter(dbCmd, "@CURRENCY_ID", DbType.Int32, ObjInquiryGRDMappingBDto.CurrencyId); db.AddInParameter(dbCmd, "@PRODUCT_ID", DbType.Int32, ObjInquiryGRDMappingBDto.ProductId); if (ObjInquiryGRDMappingBDto.QuotedAmtAdult != 0) db.AddInParameter(dbCmd, "@QUOTED_ADULT", DbType.Decimal, ObjInquiryGRDMappingBDto.QuotedAmtAdult); else db.AddInParameter(dbCmd, "@QUOTED_ADULT", DbType.Decimal, DBNull.Value); if (ObjInquiryGRDMappingBDto.TaxAdult != 0) db.AddInParameter(dbCmd, "@TAX_ADULT", DbType.Decimal, ObjInquiryGRDMappingBDto.TaxAdult); else db.AddInParameter(dbCmd, "@TAX_ADULT", DbType.Decimal, DBNull.Value); if (ObjInquiryGRDMappingBDto.GstAdult != 0) db.AddInParameter(dbCmd, "@GST_ADULT", DbType.Decimal, ObjInquiryGRDMappingBDto.GstAdult); else db.AddInParameter(dbCmd, "@GST_ADULT", DbType.Decimal, DBNull.Value); if (ObjInquiryGRDMappingBDto.QuotedAmtChildWithBed != 0) db.AddInParameter(dbCmd, "@QUOTED_CHILD_WITH_BED", DbType.Decimal, ObjInquiryGRDMappingBDto.QuotedAmtChildWithBed); else db.AddInParameter(dbCmd, "@QUOTED_CHILD_WITH_BED", DbType.Decimal, DBNull.Value); if (ObjInquiryGRDMappingBDto.TaxChildWitBed != 0) db.AddInParameter(dbCmd, "@TAX_CHILD_WITH_BED", DbType.Decimal, ObjInquiryGRDMappingBDto.TaxChildWitBed); else db.AddInParameter(dbCmd, "@TAX_CHILD_WITH_BED", DbType.Decimal, DBNull.Value); if (ObjInquiryGRDMappingBDto.GstChildWitBed != 0) db.AddInParameter(dbCmd, "@GST_CHILD_WITH_BED", DbType.Decimal, ObjInquiryGRDMappingBDto.GstChildWitBed); else db.AddInParameter(dbCmd, "@GST_CHILD_WITH_BED", DbType.Decimal, DBNull.Value); if (ObjInquiryGRDMappingBDto.QuotedAmtChildWithoutBed != 0) db.AddInParameter(dbCmd, "@QUOTED_CHILD_WITHOUT_BED", DbType.Decimal, ObjInquiryGRDMappingBDto.QuotedAmtChildWithoutBed); else db.AddInParameter(dbCmd, "@QUOTED_CHILD_WITHOUT_BED", DbType.Decimal, DBNull.Value); if (ObjInquiryGRDMappingBDto.TaxChildWitoutBed != 0) db.AddInParameter(dbCmd, "@TAX_CHILD_WITHOUT_BED", DbType.Decimal, ObjInquiryGRDMappingBDto.TaxChildWitoutBed); else db.AddInParameter(dbCmd, "@TAX_CHILD_WITHOUT_BED", DbType.Decimal, DBNull.Value); if (ObjInquiryGRDMappingBDto.GstChildWitoutBed != 0) db.AddInParameter(dbCmd, "@GST_CHILD_WITHOUT_BED", DbType.Decimal, ObjInquiryGRDMappingBDto.GstChildWitoutBed); else db.AddInParameter(dbCmd, "@GST_CHILD_WITHOUT_BED", DbType.Decimal, DBNull.Value); if (ObjInquiryGRDMappingBDto.QuotedAmtInfant != 0) db.AddInParameter(dbCmd, "@QUOTED_INFANT", DbType.Decimal, ObjInquiryGRDMappingBDto.QuotedAmtInfant); else db.AddInParameter(dbCmd, "@QUOTED_INFANT", DbType.Decimal, DBNull.Value); if (ObjInquiryGRDMappingBDto.TaxInfant != 0) db.AddInParameter(dbCmd, "@TAX_INFANT", DbType.Decimal, ObjInquiryGRDMappingBDto.TaxInfant); else db.AddInParameter(dbCmd, "@TAX_INFANT", DbType.Decimal, DBNull.Value); if (ObjInquiryGRDMappingBDto.GstInfant != 0) db.AddInParameter(dbCmd, "@GST_INFANT", DbType.Decimal, ObjInquiryGRDMappingBDto.GstInfant); else db.AddInParameter(dbCmd, "@GST_INFANT", DbType.Decimal, DBNull.Value); Result = db.ExecuteNonQuery(dbCmd); return Result; } 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 InquiryForTourBookingUpdate(InquiryForTourBDto ObjInquiryGRDMappingBDto) { Database db = null; DbCommand dbCmd = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand(DALHelper.USP_INQ_INQURIES_TOUR_UPDATE); db.AddInParameter(dbCmd, "@INQUIRY_ID", DbType.Int32, ObjInquiryGRDMappingBDto.InquiryId); db.AddInParameter(dbCmd, "@SR_NO", DbType.Int32, ObjInquiryGRDMappingBDto.SerialNo); db.AddInParameter(dbCmd, "@PRODUCT_ID", DbType.Int32, ObjInquiryGRDMappingBDto.ProductId); db.AddInParameter(dbCmd, "@TOUR_INQ_SR_NO", DbType.Int32, ObjInquiryGRDMappingBDto.TourInquirySerialNo); db.AddInParameter(dbCmd, "@TOUR_TYPE_ID", DbType.Int32, ObjInquiryGRDMappingBDto.TourTypeId); if (!string.IsNullOrEmpty(ObjInquiryGRDMappingBDto.StandardOrCustomized.ToString())) db.AddInParameter(dbCmd, "@STANDARD_OR_CUSTOMIZED_TOUR", DbType.String, ObjInquiryGRDMappingBDto.StandardOrCustomized); else db.AddInParameter(dbCmd, "@STANDARD_OR_CUSTOMIZED_TOUR", DbType.String, DBNull.Value); if (ObjInquiryGRDMappingBDto.FromDate != DateTime.MinValue) db.AddInParameter(dbCmd, "@FROM_DATE", DbType.DateTime, ObjInquiryGRDMappingBDto.FromDate); else db.AddInParameter(dbCmd, "@FROM_DATE", DbType.DateTime, DBNull.Value); if (ObjInquiryGRDMappingBDto.ToDate != DateTime.MinValue) db.AddInParameter(dbCmd, "@TO_DATE", DbType.DateTime, ObjInquiryGRDMappingBDto.ToDate); else db.AddInParameter(dbCmd, "@TO_DATE", DbType.DateTime, DBNull.Value); if (ObjInquiryGRDMappingBDto.FromPlace != 0) db.AddInParameter(dbCmd, "@FROM_PLACE", DbType.Int32, ObjInquiryGRDMappingBDto.FromPlace); else db.AddInParameter(dbCmd, "@FROM_PLACE", DbType.Int32, DBNull.Value); if (ObjInquiryGRDMappingBDto.ToPlace != 0) db.AddInParameter(dbCmd, "@TO_PLACE", DbType.Int32, ObjInquiryGRDMappingBDto.ToPlace); else db.AddInParameter(dbCmd, "@TO_PLACE", DbType.Int32, DBNull.Value); if (ObjInquiryGRDMappingBDto.TourId != 0) db.AddInParameter(dbCmd, "@TOUR_ID", DbType.Int32, ObjInquiryGRDMappingBDto.TourId); else db.AddInParameter(dbCmd, "@TOUR_ID", DbType.Int32, DBNull.Value); if (ObjInquiryGRDMappingBDto.Country != 0) db.AddInParameter(dbCmd, "@COUNTRY_ID", DbType.Int32, ObjInquiryGRDMappingBDto.Country); else db.AddInParameter(dbCmd, "@COUNTRY_ID", DbType.Int32, DBNull.Value); if (ObjInquiryGRDMappingBDto.Region != 0) db.AddInParameter(dbCmd, "@REGION_ID", DbType.Int32, ObjInquiryGRDMappingBDto.Region); else db.AddInParameter(dbCmd, "@REGION_ID", DbType.Int32, DBNull.Value); db.AddInParameter(dbCmd, "@HAVE_VALID_PASSPORT", DbType.Boolean, ObjInquiryGRDMappingBDto.HaveValidPassport); db.AddInParameter(dbCmd, "@HAVE_VALID_VISA", DbType.Boolean, ObjInquiryGRDMappingBDto.HaveValidVisa); if (!string.IsNullOrEmpty(ObjInquiryGRDMappingBDto.Remarks)) db.AddInParameter(dbCmd, "@REMARKS", DbType.String, ObjInquiryGRDMappingBDto.Remarks); else db.AddInParameter(dbCmd, "@REMARKS", DbType.String, DBNull.Value); if (!string.IsNullOrEmpty(ObjInquiryGRDMappingBDto.Attachment1ContentType)) { db.AddInParameter(dbCmd, "@ATTACHMENT1", DbType.Binary, ObjInquiryGRDMappingBDto.Attachment1); db.AddInParameter(dbCmd, "@ATTACHMENT1_CONTENT_TYPE", DbType.String, ObjInquiryGRDMappingBDto.Attachment1ContentType); db.AddInParameter(dbCmd, "@ATTACHMENT1_FILE_NAME", DbType.String, ObjInquiryGRDMappingBDto.Attachment1FileName); } else { db.AddInParameter(dbCmd, "@ATTACHMENT1", DbType.Binary, DBNull.Value); db.AddInParameter(dbCmd, "@ATTACHMENT1_CONTENT_TYPE", DbType.String, DBNull.Value); db.AddInParameter(dbCmd, "@ATTACHMENT1_FILE_NAME", DbType.String, DBNull.Value); } if (!string.IsNullOrEmpty(ObjInquiryGRDMappingBDto.Attachment2ContentType)) { db.AddInParameter(dbCmd, "@ATTACHMENT2", DbType.Binary, ObjInquiryGRDMappingBDto.Attachment2); db.AddInParameter(dbCmd, "@ATTACHMENT2_CONTENT_TYPE", DbType.String, ObjInquiryGRDMappingBDto.Attachment2ContentType); db.AddInParameter(dbCmd, "@ATTACHMENT2_FILE_NAME", DbType.String, ObjInquiryGRDMappingBDto.Attachment2FileName); } else { db.AddInParameter(dbCmd, "@ATTACHMENT2", DbType.Binary, DBNull.Value); db.AddInParameter(dbCmd, "@ATTACHMENT2_CONTENT_TYPE", DbType.String, DBNull.Value); db.AddInParameter(dbCmd, "@ATTACHMENT2_FILE_NAME", DbType.String, DBNull.Value); } if (ObjInquiryGRDMappingBDto.MarginAmount != 0) db.AddInParameter(dbCmd, "@MARGIN_AMOUNT", DbType.Decimal, ObjInquiryGRDMappingBDto.MarginAmount); else db.AddInParameter(dbCmd, "@MARGIN_AMOUNT", DbType.Decimal, DBNull.Value); Result = db.ExecuteNonQuery(dbCmd); return Result; } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } finally { DALHelper.Destroy(ref dbCmd); } return Result; }