public DataTable GeInquries(NewInquiryBDto objNewInquiryBDto) { Database db = null; DbCommand dbCmd = null; DataSet ds = null; DataTable dt = null; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand(DALHelper.USP_INQ_INQUIRY_MAIN_HEAD_SELECT); if (objNewInquiryBDto.InquiryId != 0) db.AddInParameter(dbCmd, "@INQ_NO", DbType.Int32, objNewInquiryBDto.InquiryId); else db.AddInParameter(dbCmd, "@INQ_NO", DbType.Int32, DBNull.Value); if (objNewInquiryBDto.InquiryDate != DateTime.MinValue) db.AddInParameter(dbCmd, "@INQUIRY_DATE", DbType.DateTime, objNewInquiryBDto.InquiryDate); else db.AddInParameter(dbCmd, "@INQUIRY_DATE", DbType.DateTime, DBNull.Value); if (objNewInquiryBDto.InquiryToDate != DateTime.MinValue) db.AddInParameter(dbCmd, "@INQUIRY_TO_DATE", DbType.DateTime, objNewInquiryBDto.InquiryToDate); else db.AddInParameter(dbCmd, "@INQUIRY_TO_DATE", DbType.DateTime, DBNull.Value); if (!string.IsNullOrEmpty(objNewInquiryBDto.CustomerName) && objNewInquiryBDto.CustomerName != "0") db.AddInParameter(dbCmd, "@CUSTOMER_ID", DbType.Int32, Convert.ToInt32(objNewInquiryBDto.CustomerName)); else db.AddInParameter(dbCmd, "@CUSTOMER_ID", DbType.Int32, DBNull.Value); if (!String.IsNullOrEmpty(objNewInquiryBDto.CustomerUniqueId)) db.AddInParameter(dbCmd, "@CUSTOMER_UNQ_ID", DbType.String, objNewInquiryBDto.CustomerUniqueId); else db.AddInParameter(dbCmd, "@CUSTOMER_UNQ_ID", DbType.String, DBNull.Value); if (objNewInquiryBDto.SalesPersonId != 0) // it is user id not emp.id db.AddInParameter(dbCmd, "@SALES_PERSON_ID", DbType.Int32, objNewInquiryBDto.SalesPersonId); else db.AddInParameter(dbCmd, "@SALES_PERSON_ID", DbType.Int32, DBNull.Value); if (objNewInquiryBDto.InquiryMode != 0) db.AddInParameter(dbCmd, "@INQUIRY_MODE", DbType.Int32, objNewInquiryBDto.InquiryMode); else db.AddInParameter(dbCmd, "@INQUIRY_MODE", DbType.Int32, DBNull.Value); if (objNewInquiryBDto.ReferenceId != 0) db.AddInParameter(dbCmd, "@REFERENCE_ID", DbType.Int32, objNewInquiryBDto.ReferenceId); else db.AddInParameter(dbCmd, "@REFERENCE_ID", DbType.Int32, DBNull.Value); if (objNewInquiryBDto.Branch != 0) db.AddInParameter(dbCmd, "@BRANCH_ID", DbType.Int32, objNewInquiryBDto.Branch); else db.AddInParameter(dbCmd, "@BRANCH_ID", DbType.Int32, DBNull.Value); if (objNewInquiryBDto.AgentId != 0) db.AddInParameter(dbCmd, "@AGENT_ID", DbType.Int32, objNewInquiryBDto.AgentId); else db.AddInParameter(dbCmd, "@AGENT_ID", DbType.Int32, DBNull.Value); if (objNewInquiryBDto.TourSubType != 0) db.AddInParameter(dbCmd, "@TOUR_SUBTYPE", DbType.Int32, objNewInquiryBDto.TourSubType); else db.AddInParameter(dbCmd, "@TOUR_SUBTYPE", DbType.Int32, DBNull.Value); //if (objNewInquiryBDto.Rating != 0) // db.AddInParameter(dbCmd, "@RATING", DbType.Int32, objNewInquiryBDto.Rating); //else // db.AddInParameter(dbCmd, "@RATING", DbType.Int32, DBNull.Value); if (objNewInquiryBDto.CurrentStatus != 0) db.AddInParameter(dbCmd, "@CURRENT_STATUS", DbType.Int32, objNewInquiryBDto.CurrentStatus); else db.AddInParameter(dbCmd, "@CURRENT_STATUS", DbType.Int32, DBNull.Value); if (objNewInquiryBDto.TravelFromDate1 != DateTime.MinValue) db.AddInParameter(dbCmd, "@NEXT_TRAVEL_FROM_DATE", DbType.DateTime, objNewInquiryBDto.TravelFromDate1); else db.AddInParameter(dbCmd, "@NEXT_TRAVEL_FROM_DATE", DbType.DateTime, DBNull.Value); if (objNewInquiryBDto.TravelTODate1 != DateTime.MinValue) db.AddInParameter(dbCmd, "@NEXT_TRAVEL_TO_DATE", DbType.DateTime, objNewInquiryBDto.TravelTODate1); else db.AddInParameter(dbCmd, "@NEXT_TRAVEL_TO_DATE", DbType.DateTime, DBNull.Value); if (objNewInquiryBDto.CountryId != 0) db.AddInParameter(dbCmd, "@COUNTRY_ID", DbType.Int32, objNewInquiryBDto.CountryId); else db.AddInParameter(dbCmd, "@COUNTRY_ID", DbType.Int32, DBNull.Value); if (objNewInquiryBDto.Rating != 0) db.AddInParameter(dbCmd, "@INQ_RATING", DbType.Int32, objNewInquiryBDto.Rating); else db.AddInParameter(dbCmd, "@INQ_RATING", DbType.Int32, DBNull.Value); ds = db.ExecuteDataSet(dbCmd); using (ds) { if (ds != null && ds.Tables.Count > 0) { dt = ds.Tables[0]; } } } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } finally { DALHelper.Destroy(ref dbCmd); } return dt; }
public int InquiryMainHeadUpdate(NewInquiryBDto objNewInquiryBDto) { Database db = null; DbCommand dbCmd = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand(DALHelper.USP_INQ_INQUIRY_MAIN_HEAD_UPDATE); db.AddInParameter(dbCmd, "@INQUIRY_ID", DbType.Int32, objNewInquiryBDto.InquiryId); if (objNewInquiryBDto.InquiryDate != DateTime.MinValue) db.AddInParameter(dbCmd, "@INQUIRY_DATE", DbType.DateTime, objNewInquiryBDto.InquiryDate); else db.AddInParameter(dbCmd, "@INQUIRY_DATE", DbType.DateTime, DBNull.Value); db.AddInParameter(dbCmd, "@CUSTOMER_ID", DbType.Int32, objNewInquiryBDto.CustomerId); db.AddInParameter(dbCmd, "@RELATION_ID", DbType.Int32, objNewInquiryBDto.RelationId); db.AddInParameter(dbCmd, "@RELATIVE_NAME", DbType.String, objNewInquiryBDto.RelativeName); db.AddInParameter(dbCmd, "@SALES_PERSON_ID", DbType.Int32, objNewInquiryBDto.SalesPersonId); db.AddInParameter(dbCmd, "@INQUIRY_MODE", DbType.Int32, objNewInquiryBDto.InquiryMode); db.AddInParameter(dbCmd, "@REFERENCE_ID", DbType.Int32, objNewInquiryBDto.ReferenceId); db.AddInParameter(dbCmd, "@REFERENCE_DESC", DbType.String, objNewInquiryBDto.ReferenceDesc); db.AddInParameter(dbCmd, "@BRANCH_ID", DbType.Int32, objNewInquiryBDto.Branch); db.AddInParameter(dbCmd, "@AGENT_ID", DbType.Int32, objNewInquiryBDto.AgentId); db.AddInParameter(dbCmd, "@RATING", DbType.Int32, objNewInquiryBDto.Rating); db.AddInParameter(dbCmd, "@CURRENT_STATUS", DbType.Int32, objNewInquiryBDto.CurrentStatus); db.AddInParameter(dbCmd, "@REMARKS", DbType.String, objNewInquiryBDto.Remarks); 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; }