public DataSet ViewExistingBranchesList(AgencyBranchFilter _objAgencyBranchFilterA) { try { SqlParameter[] P = new SqlParameter[] { new SqlParameter("@AgencyID", _objAgencyBranchFilterA.AgencyID), new SqlParameter("@BranchName", _objAgencyBranchFilterA.BranchName), new SqlParameter("@StateID", _objAgencyBranchFilterA.StateID), new SqlParameter("@CityID", _objAgencyBranchFilterA.CityID), new SqlParameter("@Email", _objAgencyBranchFilterA.Email), new SqlParameter("@MobileNo", _objAgencyBranchFilterA.MobileNo), new SqlParameter("@PageNo", _objAgencyBranchFilterA.PageNo), new SqlParameter("@PageSize", _objAgencyBranchFilterA.PageSize) }; DataSet dsResult = new DataSet(); dsResult = DataLib.GetStoredProcData(DataLib.Connection.SetConnectionString, SPKeys.SPGetAgencyBranchSearch, P); return(dsResult); } catch { throw; } }
public HttpResponseMessage PosViewExistingBranchesList(AgencyBranchFilter _objAgencyBranchFilterA) { AgencyDAL _objAgencyDAL = new AgencyDAL(); Response objResponse = new Response(); string jsonData = string.Empty; DataSet dsResult = new DataSet(); AgencyBranchFilter _objAgencyBranch = new AgencyBranchFilter(); List <ExistingBranches> _objExistingBranchesList = new List <ExistingBranches>(); try { dsResult = _objAgencyDAL.ViewExistingBranchesList(_objAgencyBranchFilterA); if (dsResult != null) { if (dsResult.Tables[0].Rows.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++) { _objExistingBranchesList.Add(new ExistingBranches { AgencyBranchID = dsResult.Tables[0].Rows[i]["AgencyBranchID"].ToString(), BranchName = dsResult.Tables[0].Rows[i]["BranchName"].ToString(), AgencyName = dsResult.Tables[0].Rows[i]["AgencyName"].ToString(), FirstName = dsResult.Tables[0].Rows[i]["FirstName"].ToString(), AgencyAdminInfoID = dsResult.Tables[0].Rows[i]["AgencyAdminInfoID"].ToString(), Mobile = dsResult.Tables[0].Rows[i]["Mobile"].ToString(), Email = dsResult.Tables[0].Rows[i]["Email"].ToString(), State = dsResult.Tables[0].Rows[i]["STATE NAME"].ToString(), City = dsResult.Tables[0].Rows[i]["cityname"].ToString(), Inactive = dsResult.Tables[0].Rows[i]["Inactive"].ToString(), IncID = common.EncodeTo64(dsResult.Tables[0].Rows[i]["AgencyBranchID"].ToString()) }); } _objAgencyBranch.ExistingBranchesList = _objExistingBranchesList; if (dsResult.Tables[1].Rows.Count > 0 && dsResult.Tables[1].Rows.Count > 0) { _objAgencyBranch.TotalCount = dsResult.Tables[1].Rows[0]["TotalCount"].ToString(); } } else if (dsResult.Tables[0].Rows.Count == 0 || dsResult.Tables[1].Rows.Count == 0) { objResponse.Data = null; } } else { objResponse.Data = null; } objResponse.Data = _objAgencyBranch; objResponse.Success = true; return(Request.CreateResponse(HttpStatusCode.OK, objResponse)); } catch (Exception ex) { #region set exception response string logMsg = Environment.NewLine + DateTime.Now + Environment.NewLine + "Method Name: ViewExistingBranchesList | Contoller Name: Agency Controller" + Environment.NewLine; logMsg += "AgencyID:" + _objAgencyBranchFilterA.AgencyID + "|" + DateTime.Now + "|" + ex.ToString() + "-" + Environment.NewLine; ErrorHandler.ErrorLog(logMsg); #endregion set exception response objResponse.Success = false; objResponse.Data = null; return(Request.CreateResponse(HttpStatusCode.BadRequest, objResponse)); } }