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