public IEnumerable <IncomeAccountMISOverrideTEMP> IncomeAccountMISOverrideTEMPusingparams(string status, string search) { List <IncomeAccountMISOverrideTEMP> obuList = new List <IncomeAccountMISOverrideTEMP>(); using (var con = new System.Data.SqlClient.SqlConnection(connectionString)) { var cmd = new System.Data.SqlClient.SqlCommand("", con); //cmd.CommandText = "select * from Names where Id=@Id"; //cmd.Parameters.AddWithValue("@Id", id); con.Open(); cmd.CommandText = "select top 500 Id, accountnumber, mis, AccountOfficer_Code, ApprovalStatus from Income_accountMIS_Override_TEMP " + "where ApprovalStatus=@STATUS and (accountnumber like @searchval OR mis like @searchval OR AccountOfficer_Code like @searchval)"; cmd.Parameters.AddWithValue("@STATUS", status); cmd.Parameters.AddWithValue("@searchval", "%" + search + "%"); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var obu = new IncomeAccountMISOverrideTEMP(); obu.Id = reader["Id"] != DBNull.Value ? int.Parse(reader["Id"].ToString()) : 0; obu.accountnumber = reader["accountnumber"] != DBNull.Value ? reader["accountnumber"].ToString() : ""; obu.mis = reader["mis"] != DBNull.Value ? reader["mis"].ToString() : ""; obu.AccountOfficer_Code = reader["AccountOfficer_Code"] != DBNull.Value ? reader["AccountOfficer_Code"].ToString() : ""; obu.ApprovalStatus = reader["ApprovalStatus"] != DBNull.Value ? reader["ApprovalStatus"].ToString() : ""; obuList.Add(obu); } con.Close(); } return(obuList); }
public HttpResponseMessage GetIncomeAccountMISOverrideTEMP(HttpRequestMessage request, int Id) { return(GetHttpResponse(request, () => { HttpResponseMessage response = null; IncomeAccountMISOverrideTEMP icprb = _MPRBSService.GetIncomeAccountMISOverrideTEMP(Id); // notice no need to create a seperate model object since AcquirerMapping entity will do just fine response = request.CreateResponse <IncomeAccountMISOverrideTEMP>(HttpStatusCode.OK, icprb); return response; })); }
public HttpResponseMessage DeleteIncomeAccountMISOverrideTEMP(HttpRequestMessage request, [FromBody] int Id) { return(GetHttpResponse(request, () => { HttpResponseMessage response = null; // not that calling the WCF service here will authenticate access to the data IncomeAccountMISOverrideTEMP icprb = _MPRBSService.GetIncomeAccountMISOverrideTEMP(Id); if (icprb != null) { _MPRBSService.DeleteIncomeAccountMISOverrideTEMP(Id); response = request.CreateResponse(HttpStatusCode.OK); } else { response = request.CreateErrorResponse(HttpStatusCode.NotFound, "No record found under that ID."); } return response; })); }
public IncomeAccountMISOverrideTEMP UpdateIncomeAccountMISOverrideTEMP(IncomeAccountMISOverrideTEMP ic) { return(Channel.UpdateIncomeAccountMISOverrideTEMP(ic)); }
public HttpResponseMessage UpdateIncomeAccountMISOverrideTEMP(HttpRequestMessage request, [FromBody] IncomeAccountMISOverrideTEMP icprbModel) { return(GetHttpResponse(request, () => { var icprb = _MPRBSService.UpdateIncomeAccountMISOverrideTEMP(icprbModel); return request.CreateResponse <IncomeAccountMISOverrideTEMP>(HttpStatusCode.OK, icprb); })); }