public DataSet ViewExistingagencyuserList(AgencyExectingUser _objAgencyExectingUser) { try { SqlParameter[] P = new SqlParameter[] { new SqlParameter("@AgencyID", _objAgencyExectingUser.AgencyID), new SqlParameter("@AgentName", _objAgencyExectingUser.AgentName), new SqlParameter("@MobileNo", _objAgencyExectingUser.MobileNo), new SqlParameter("@Email", _objAgencyExectingUser.Email), new SqlParameter("@cityid", _objAgencyExectingUser.cityid), new SqlParameter("@stateid", _objAgencyExectingUser.stateid), new SqlParameter("@BranchID", _objAgencyExectingUser.BranchID), new SqlParameter("@PageSize", _objAgencyExectingUser.PageSize), new SqlParameter("@PageNo", _objAgencyExectingUser.PageNo) }; DataSet dsResult = new DataSet(); dsResult = DataLib.GetStoredProcData(DataLib.Connection.SetConnectionString, SPKeys.SPGetAgencyExistingUser, P); return(dsResult); } catch { throw; } }
public HttpResponseMessage PosAgencyExistingUser(AgencyExectingUser _objAgencyExectingUser) { AgencyDAL _objAgencyDAL = new AgencyDAL(); Response objResponse = new Response(); string jsonData = string.Empty; DataSet dsResult = new DataSet(); AgencyExistinglist _objAgencyExistinglist = new AgencyExistinglist(); List <AgencyUsers> _objAgencyUsersList = new List <AgencyUsers>(); try { dsResult = _objAgencyDAL.ViewExistingagencyuserList(_objAgencyExectingUser); 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++) { _objAgencyUsersList.Add(new AgencyUsers { AUIID = dsResult.Tables[0].Rows[i]["AUIID"].ToString(), AgentName = dsResult.Tables[0].Rows[i]["AgentName"].ToString(), mobileno = dsResult.Tables[0].Rows[i]["mobileno"].ToString(), EmailAddress = dsResult.Tables[0].Rows[i]["EmailAddress"].ToString(), AgencyID = dsResult.Tables[0].Rows[i]["AgencyID"].ToString(), AgencyBranchID = dsResult.Tables[0].Rows[i]["AgencyBranchID"].ToString(), statename = dsResult.Tables[0].Rows[i]["statename"].ToString(), cityname = dsResult.Tables[0].Rows[i]["cityname"].ToString(), Inactive = dsResult.Tables[0].Rows[i]["Inactive"].ToString() }); } _objAgencyExistinglist.agencyuser = _objAgencyUsersList; if (dsResult.Tables[1].Rows.Count > 0 && dsResult.Tables[1].Rows.Count > 0) { _objAgencyExistinglist.TotalRows = dsResult.Tables[1].Rows[0]["TotalRows"].ToString(); } } else if (dsResult.Tables[0].Rows.Count == 0 || dsResult.Tables[1].Rows.Count == 0) { objResponse.Data = null; } } else { objResponse.Data = null; } objResponse.Data = _objAgencyExistinglist; 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: AgencyExistingUser | Contoller Name: Agency Controller" + Environment.NewLine; logMsg += "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)); } }