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