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