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