public HttpResponseMessage PostSetAgencyBranchUpdate(CreateNewBranchStep1 _objBranchUpdateA) { AgencyDAL _objAgencyDAL = new AgencyDAL(); Response objResponse = new Response(); try { var jsonResult = new StringBuilder(); jsonResult = _objAgencyDAL.SetUpdateBranchDetails(_objBranchUpdateA); objResponse.Data = jsonResult.ToString(); if (!string.IsNullOrEmpty(jsonResult.ToString()) && jsonResult.ToString() != "-2000") { objResponse.Success = true; } else { objResponse.Success = false; } return(Request.CreateResponse(HttpStatusCode.OK, objResponse)); } catch (Exception ex) { #region set exception response string logMsg = Environment.NewLine + DateTime.Now + Environment.NewLine + "Method Name: SetAgencyBranchUpdate | Contoller Name: Agency Controller" + Environment.NewLine; logMsg += "Temp Reg ID:" + _objBranchUpdateA.AgencyID + "|" + DateTime.Now + "|" + ex.ToString() + "-" + Environment.NewLine; ErrorHandler.ErrorLog(logMsg); #endregion objResponse.Success = false; HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.BadRequest, objResponse); return(response); } }
public HttpResponseMessage PostGetAgencyBranchUpdate(CreateNewBranchStep1 _objGetBranchUpdateA) { AgencyDAL _objAgencyDAL = new AgencyDAL(); Response objResponse = new Response(); CreateNewBranchStep1 _objCreateNewBranchStep1 = new CreateNewBranchStep1(); try { DataSet dsResult = new DataSet(); string jsonData = string.Empty; dsResult = _objAgencyDAL.GetAgencyBranchUpdate(_objGetBranchUpdateA); if (dsResult != null) { if (dsResult.Tables[0] != null) { if (dsResult.Tables[0].Rows.Count > 0) { _objCreateNewBranchStep1.AgencyBranchID = dsResult.Tables[0].Rows[0]["AgencyBranchID"].ToString(); _objCreateNewBranchStep1.AgencyID = dsResult.Tables[0].Rows[0]["AgencyID"].ToString(); _objCreateNewBranchStep1.BranchName = dsResult.Tables[0].Rows[0]["BranchName"].ToString(); _objCreateNewBranchStep1.AddressLine1 = dsResult.Tables[0].Rows[0]["Address1"].ToString(); _objCreateNewBranchStep1.AddressLine2 = dsResult.Tables[0].Rows[0]["Address2"].ToString(); _objCreateNewBranchStep1.State = dsResult.Tables[0].Rows[0]["StateID"].ToString(); _objCreateNewBranchStep1.City = dsResult.Tables[0].Rows[0]["CityID"].ToString(); _objCreateNewBranchStep1.POBoxNo = dsResult.Tables[0].Rows[0]["Pincode"].ToString(); _objCreateNewBranchStep1.IncID = common.EncodeTo64(dsResult.Tables[0].Rows[0]["AgencyBranchID"].ToString()); } objResponse.Data = _objCreateNewBranchStep1; objResponse.Success = true; } } else { objResponse.Success = false; objResponse.Data = "-2"; } return(Request.CreateResponse(HttpStatusCode.OK, objResponse)); } catch (Exception ex) { #region set exception response string logMsg = Environment.NewLine + DateTime.Now + Environment.NewLine + "Method Name: GetAgencyBranchUpdate | Contoller Name: Agency Controller" + Environment.NewLine; logMsg += "Temp Reg ID:" + _objGetBranchUpdateA.AgencyBranchID + "|" + DateTime.Now + "|" + ex.ToString() + "-" + Environment.NewLine; ErrorHandler.ErrorLog(logMsg); #endregion objResponse.Success = false; HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.BadRequest, objResponse); return(response); } }
public DataSet GetNewBranchStep1(CreateNewBranchStep1 _objCreateNewBranchStep1A) { try { SqlParameter[] P = new SqlParameter[] { new SqlParameter("@TmpAgencyBranchID", _objCreateNewBranchStep1A.AgencyBranchID), }; DataSet dtResult = new DataSet(); dtResult = DataLib.GetStoredProcData(DataLib.Connection.GetConnectionString, SPKeys.SPGetTmpAgencyBranch, P); return(dtResult); } catch { throw; } }
public StringBuilder SetNewBranchStep1(CreateNewBranchStep1 _objCreateNewBranchStep1A) { try { SqlParameter[] P = new SqlParameter[] { new SqlParameter("@AgencyID", _objCreateNewBranchStep1A.AgencyID), new SqlParameter("@BranchName", String.IsNullOrEmpty(_objCreateNewBranchStep1A.BranchName)?DBNull.Value:(object)_objCreateNewBranchStep1A.BranchName), new SqlParameter("@Address1", String.IsNullOrEmpty(_objCreateNewBranchStep1A.AddressLine1)?DBNull.Value:(object)_objCreateNewBranchStep1A.AddressLine1), new SqlParameter("@Address2", String.IsNullOrEmpty(_objCreateNewBranchStep1A.AddressLine2)?DBNull.Value:(object)_objCreateNewBranchStep1A.AddressLine2), new SqlParameter("@StateID", String.IsNullOrEmpty(_objCreateNewBranchStep1A.State)?DBNull.Value:(object)_objCreateNewBranchStep1A.State), new SqlParameter("@CityID", String.IsNullOrEmpty(_objCreateNewBranchStep1A.City)?DBNull.Value:(object)_objCreateNewBranchStep1A.City), new SqlParameter("@POBox", String.IsNullOrEmpty(_objCreateNewBranchStep1A.POBoxNo)?DBNull.Value:(object)_objCreateNewBranchStep1A.POBoxNo), new SqlParameter("@CreatedBy", String.IsNullOrEmpty(_objCreateNewBranchStep1A.CreatedBy)?DBNull.Value:(object)_objCreateNewBranchStep1A.CreatedBy), }; var jsonResult = new StringBuilder(); jsonResult = DataLib.JsonStringExecuteReader(DataLib.Connection.SetConnectionString, SPKeys.SPSetTmpAgencyBranch, P); return(jsonResult); } catch { throw; } }