/// <summary> /// Update customer travel history with other detail. /// </summary> /// <param name="travel">Data transfer object contains customer data.</param> /// <returns>Returns 1 and 0; (1 indicates successful operation).</returns> public int UpdateCustomerTravelHistoryWithOther(TravelBDto travel) { Database db = null; DbCommand dbCmd = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand(DALHelper.USP_CUST_TRAVEL_HISTORY_WITH_OTHER_UPDATE); db.AddInParameter(dbCmd, "@SR_NO", DbType.Int32, travel.SerialNo); db.AddInParameter(dbCmd, "@CUST_ID", DbType.Int32, travel.CustomerId); db.AddInParameter(dbCmd, "@YEAR_MONTH", DbType.Int32, travel.YearMonth); if (travel.AgentId != 0) db.AddInParameter(dbCmd, "@AGENT_ID", DbType.Int32, travel.AgentId); else db.AddInParameter(dbCmd, "@AGENT_ID", DbType.Int32, DBNull.Value); if (travel.TourTypeId != 0) db.AddInParameter(dbCmd, "@TOUR_TYPE_ID", DbType.String, travel.TourTypeId); else db.AddInParameter(dbCmd, "@TOUR_TYPE_ID", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(travel.CountryName)) db.AddInParameter(dbCmd, "@COUNTRY_NAME", DbType.String, travel.CountryName); else db.AddInParameter(dbCmd, "@COUNTRY_NAME", DbType.String, DBNull.Value); if (travel.NoOfPersons != 0) db.AddInParameter(dbCmd, "@NO_OF_PERSONS", DbType.Int32, travel.NoOfPersons); else db.AddInParameter(dbCmd, "@NO_OF_PERSONS", DbType.Int32, DBNull.Value); if (!String.IsNullOrEmpty(travel.Description)) db.AddInParameter(dbCmd, "@DESCRIPTION", DbType.String, travel.Description); else db.AddInParameter(dbCmd, "@DESCRIPTION", DbType.String, DBNull.Value); db.AddInParameter(dbCmd, "@USER_ID", DbType.Int32, travel.UserId); db.AddOutParameter(dbCmd, "@IS_INSERT", DbType.Int32, 1); db.ExecuteNonQuery(dbCmd); Result = Convert.ToInt32(db.GetParameterValue(dbCmd, "@IS_INSERT")); } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } finally { DALHelper.Destroy(ref dbCmd); } return Result; }
/// <summary> /// Update customer detail. /// </summary> /// <param name="travel">Data transfer object contains customer data.</param> /// <returns>Returns 1 and 0; (1 indicates successful operation).</returns> public int UpdateCustomerNextTravelPlan(TravelBDto nextPlan) { Database db = null; DbCommand dbCmd = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand(DALHelper.USP_CUST_NEXT_TRAVEL_PLAN_UPDATE); db.AddInParameter(dbCmd, "@SR_NO", DbType.Int32, nextPlan.SerialNo); db.AddInParameter(dbCmd, "@CUST_ID", DbType.Int32, nextPlan.CustomerId); db.AddInParameter(dbCmd, "@PLAN_YEAR_MONTH", DbType.Int32, nextPlan.YearMonth); if (!String.IsNullOrEmpty(nextPlan.CountryName)) db.AddInParameter(dbCmd, "@COUNTRY_NAME", DbType.String, nextPlan.CountryName); else db.AddInParameter(dbCmd, "@COUNTRY_NAME", DbType.String, DBNull.Value); if (nextPlan.TourTypeId != 0) db.AddInParameter(dbCmd, "@TOUR_TYPE_ID", DbType.String, nextPlan.TourTypeId); else db.AddInParameter(dbCmd, "@TOUR_TYPE_ID", DbType.String, DBNull.Value); if (nextPlan.TourId != 0) db.AddInParameter(dbCmd, "@TOUR_ID", DbType.String, nextPlan.TourId); else db.AddInParameter(dbCmd, "@TOUR_ID", DbType.String, DBNull.Value); if (nextPlan.NoOfPersons != 0) db.AddInParameter(dbCmd, "@NO_OF_PERSONS", DbType.Int32, nextPlan.NoOfPersons); else db.AddInParameter(dbCmd, "@NO_OF_PERSONS", DbType.Int32, DBNull.Value); if (!String.IsNullOrEmpty(nextPlan.Description)) db.AddInParameter(dbCmd, "@DESCRIPTION", DbType.String, nextPlan.Description); else db.AddInParameter(dbCmd, "@DESCRIPTION", DbType.String, DBNull.Value); if (nextPlan.InquiryMode != 0) db.AddInParameter(dbCmd, "@INQUIRY_MODE", DbType.Int32, nextPlan.InquiryMode); else db.AddInParameter(dbCmd, "@INQUIRY_MODE", DbType.Int32, DBNull.Value); if (nextPlan.StatusId != 0) db.AddInParameter(dbCmd, "@STATUS_ID", DbType.Int32, nextPlan.StatusId); else db.AddInParameter(dbCmd, "@STATUS_ID", DbType.Int32, DBNull.Value); db.AddInParameter(dbCmd, "@USER_ID", DbType.Int32, nextPlan.UserId); db.AddOutParameter(dbCmd, "@IS_INSERT", DbType.Int32, 1); db.ExecuteNonQuery(dbCmd); Result = Convert.ToInt32(db.GetParameterValue(dbCmd, "@IS_INSERT")); } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } finally { DALHelper.Destroy(ref dbCmd); } return Result; }