public int InsertInquiryGRDMapping(InquiryGRDMappingBDto objInquiryGRDMappingBDto) { Database db = null; DbCommand dbCmd = null; DataSet ds = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand(DALHelper.USP_INQ_INQUIRY_AIRLINE_GDS_MAPPING_INSERT); db.AddInParameter(dbCmd, "@INQUIRY_ID", DbType.Int32, objInquiryGRDMappingBDto.InquiryId); db.AddInParameter(dbCmd, "@PREFERED_AIRLINES_ID", DbType.Int32, objInquiryGRDMappingBDto.PreferedAirlinesId); db.AddInParameter(dbCmd, "@GDS_AIRPORT_CODE", DbType.Int32, objInquiryGRDMappingBDto.GDSAirportCode); db.AddInParameter(dbCmd, "@TIME_DETAILS", DbType.String, objInquiryGRDMappingBDto.TimeDetails); db.AddOutParameter(dbCmd, "@ISEXIST", DbType.Int32, 1); int r = db.ExecuteNonQuery(dbCmd); Result = Convert.ToInt32(db.GetParameterValue(dbCmd, "@ISEXIST")); return Result; } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } finally { DALHelper.Destroy(ref dbCmd); } return 0; }
public int UpdateTicketGdsDetail(InquiryGRDMappingBDto inquiryGDS) { Database db = null; DbCommand dbCmd = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand("dbo.USP_INQ_INQUIRY_FOR_TICKET_GDS_UPDATE"); db.AddInParameter(dbCmd, "@SR_NO", DbType.Int32, inquiryGDS.SerialNo); if (inquiryGDS.InquiryId != 0) db.AddInParameter(dbCmd, "@INQUIRY_ID", DbType.Int32, inquiryGDS.InquiryId); else db.AddInParameter(dbCmd, "@INQUIRY_ID", DbType.Int32, DBNull.Value); if (inquiryGDS.TicketInqSrNo != 0) db.AddInParameter(dbCmd, "@TICKET_INQ_SR_NO", DbType.Int32, inquiryGDS.TicketInqSrNo); else db.AddInParameter(dbCmd, "@TICKET_INQ_SR_NO", DbType.Int32, DBNull.Value); if (inquiryGDS.TicketTabId != 0) db.AddInParameter(dbCmd, "@TICKET_TAB_ID", DbType.Int32, inquiryGDS.TicketTabId); else db.AddInParameter(dbCmd, "@TICKET_TAB_ID", DbType.Int32, DBNull.Value); if (inquiryGDS.ProductId != 0) db.AddInParameter(dbCmd, "@PRODUCT_ID", DbType.Int32, inquiryGDS.ProductId); else db.AddInParameter(dbCmd, "@PRODUCT_ID", DbType.Int32, DBNull.Value); if (inquiryGDS.DestinationCityId != 0) db.AddInParameter(dbCmd, "@DESTINATION_CITY_ID", DbType.Int32, inquiryGDS.DestinationCityId); else db.AddInParameter(dbCmd, "@DESTINATION_CITY_ID", DbType.Int32, DBNull.Value); if (inquiryGDS.AirlinesId != 0) db.AddInParameter(dbCmd, "@AIRLINE_ID", DbType.Int32, inquiryGDS.AirlinesId); else db.AddInParameter(dbCmd, "@AIRLINE_ID", DbType.Int32, DBNull.Value); if (!String.IsNullOrEmpty(inquiryGDS.GDSAirportCode)) db.AddInParameter(dbCmd, "@GDS_AIRPORT_CODE", DbType.String, inquiryGDS.GDSAirportCode); else db.AddInParameter(dbCmd, "@GDS_AIRPORT_CODE", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(inquiryGDS.TimeDetails)) db.AddInParameter(dbCmd, "@TIME_DETAILS", DbType.String, inquiryGDS.TimeDetails); else db.AddInParameter(dbCmd, "@TIME_DETAILS", DbType.String, DBNull.Value); if (inquiryGDS.TotalFareWithTax != 0) db.AddInParameter(dbCmd, "@TOTAL_FARE_WITH_TAX", DbType.Decimal, inquiryGDS.TotalFareWithTax); else db.AddInParameter(dbCmd, "@TOTAL_FARE_WITH_TAX", DbType.Decimal, DBNull.Value); if (!String.IsNullOrEmpty(inquiryGDS.TimeLimit)) db.AddInParameter(dbCmd, "@TIME_LIMIT", DbType.String, inquiryGDS.TimeLimit); else db.AddInParameter(dbCmd, "@TIME_LIMIT", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(inquiryGDS.BaggageAllwance)) db.AddInParameter(dbCmd, "@BAGGAGE_ALLOWANCE", DbType.String, inquiryGDS.BaggageAllwance); else db.AddInParameter(dbCmd, "@BAGGAGE_ALLOWANCE", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(inquiryGDS.Cancellation)) db.AddInParameter(dbCmd, "@CANCELLATION", DbType.String, inquiryGDS.Cancellation); else db.AddInParameter(dbCmd, "@CANCELLATION", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(inquiryGDS.DateChange)) db.AddInParameter(dbCmd, "@DATE_CHANGE", DbType.String, inquiryGDS.DateChange); else db.AddInParameter(dbCmd, "@DATE_CHANGE", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(inquiryGDS.PaxNo)) db.AddInParameter(dbCmd, "@LOCAL_PAX_NO", DbType.String, inquiryGDS.PaxNo); else db.AddInParameter(dbCmd, "@LOCAL_PAX_NO", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(inquiryGDS.Email)) db.AddInParameter(dbCmd, "@EMAIL", DbType.String, inquiryGDS.Email); else db.AddInParameter(dbCmd, "@EMAIL", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(inquiryGDS.PaymentPolicy)) db.AddInParameter(dbCmd, "@PAYMENT_POLICY", DbType.String, inquiryGDS.PaymentPolicy); else db.AddInParameter(dbCmd, "@PAYMENT_POLICY", DbType.String, DBNull.Value); if (inquiryGDS.FaqDocument != null) db.AddInParameter(dbCmd, "@FAQ_DOC", DbType.Binary, inquiryGDS.FaqDocument); else db.AddInParameter(dbCmd, "@FAQ_DOC", DbType.Binary, DBNull.Value); if (!String.IsNullOrEmpty(inquiryGDS.FaqDocType)) db.AddInParameter(dbCmd, "@FAQ_DOC_CONTENT_TYPE", DbType.String, inquiryGDS.FaqDocType); else db.AddInParameter(dbCmd, "@FAQ_DOC_CONTENT_TYPE", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(inquiryGDS.FaqDocFileName)) db.AddInParameter(dbCmd, "@FAQ_DOC_FILE_NAME", DbType.String, inquiryGDS.FaqDocFileName); else db.AddInParameter(dbCmd, "@FAQ_DOC_FILE_NAME", DbType.String, DBNull.Value); if (inquiryGDS.TermsDocument != null) db.AddInParameter(dbCmd, "@T_C_DOC", DbType.Binary, inquiryGDS.TermsDocument); else db.AddInParameter(dbCmd, "@T_C_DOC", DbType.Binary, DBNull.Value); if (!String.IsNullOrEmpty(inquiryGDS.TermsDocType)) db.AddInParameter(dbCmd, "@T_C_DOC_CONTENT_TYPE", DbType.String, inquiryGDS.TermsDocType); else db.AddInParameter(dbCmd, "@T_C_DOC_CONTENT_TYPE", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(inquiryGDS.TermsDocFileName)) db.AddInParameter(dbCmd, "@T_C_DOC_FILE_NAME", DbType.String, inquiryGDS.TermsDocFileName); else db.AddInParameter(dbCmd, "@T_C_DOC_FILE_NAME", DbType.String, DBNull.Value); db.AddOutParameter(dbCmd, "@IS_UPDATE", DbType.Int32, 10); Result = db.ExecuteNonQuery(dbCmd); Result = Convert.ToInt32(db.GetParameterValue(dbCmd, "@IS_UPDATE")); } 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 UpdateTicketInquiryQuotedAmount(InquiryGRDMappingBDto 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_TICKET_QUOTED_AMOUNT_UPDATE"); db.AddInParameter(dbCmd, "@INQUIRY_ID", DbType.Int32, ObjInquiryGRDMappingBDto.InquiryId); db.AddInParameter(dbCmd, "@INQUIRY_SR_NO", DbType.Int32, ObjInquiryGRDMappingBDto.SerialNo); db.AddInParameter(dbCmd, "@TICKET_TAB_ID", DbType.Int32, ObjInquiryGRDMappingBDto.TicketTabId); db.AddInParameter(dbCmd, "@TICKET_INQ_SR_NO", DbType.Int32, ObjInquiryGRDMappingBDto.TicketInqSrNo); db.AddInParameter(dbCmd, "@AIRLINE_ID", DbType.Int32, ObjInquiryGRDMappingBDto.AirlinesId); 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, "@QUOUTED_ADULT", DbType.Decimal, ObjInquiryGRDMappingBDto.QuotedAmtAdult); else db.AddInParameter(dbCmd, "@QUOUTED_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", DbType.Decimal, ObjInquiryGRDMappingBDto.QuotedAmtChildWithBed); else db.AddInParameter(dbCmd, "@QUOTED_CHILD", DbType.Decimal, DBNull.Value); if (ObjInquiryGRDMappingBDto.TaxChildWitBed != 0) db.AddInParameter(dbCmd, "@TAX_CHILD", DbType.Decimal, ObjInquiryGRDMappingBDto.TaxChildWitBed); else db.AddInParameter(dbCmd, "@TAX_CHILD", DbType.Decimal, DBNull.Value); if (ObjInquiryGRDMappingBDto.GstChildWitBed != 0) db.AddInParameter(dbCmd, "@GST_CHILD", DbType.Decimal, ObjInquiryGRDMappingBDto.GstChildWitBed); else db.AddInParameter(dbCmd, "@GST_CHILD", 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; }