public static FundAllocationInfo[] GetAllocatedFunds() { ArrayList al = new ArrayList(); int retValue = -1; //Generated Code for query : dbo.GetAllVendors using (SqlDataReader dr = ProjManagementAdmin.GetAllocatedFunds(out retValue)) //Initialize and retrieve code for Datareader goes here { while (dr.Read()) { FundAllocationInfo alloc = new FundAllocationInfo(); alloc.AllocationId = Convert.ToInt32(dr["allocation_id"]); alloc.FundId = Convert.ToInt32(dr["fund_id"]); alloc.FundDesc = dr["fund_desc"].ToString(); alloc.BeneficiaryId = Convert.ToInt32(dr["beneficiary_id"]); alloc.BeneficiaryName = dr["beneficiary_name"].ToString(); alloc.AllocatedBy = dr["allocated_by"].ToString(); alloc.ChangedBy = dr["changed_by"].ToString(); alloc.AllocatedBy = dr["allocated_by"].ToString(); alloc.Amount = Convert.ToDecimal(dr["allocated_amount"]); al.Add(alloc); } //dr.Close(); } FundAllocationInfo[] allInfo = new FundAllocationInfo[al.Count]; al.CopyTo(allInfo); return allInfo; }
public static int AddNewFA(FundAllocationInfo FA) { if ( FA == null) throw new ArgumentNullException("Fund is missing"); int retValue = -1; return ProjManagementAdmin.AddNewFA(FA, out retValue); }
public HttpResponseMessage Post(FundAllocationInfo FA) { try { FundAllocationBl.AddNewFA(FA); return new HttpResponseMessage(HttpStatusCode.OK); } catch (Exception ex) { return new HttpResponseMessage(HttpStatusCode.BadRequest); } }
private static SqlParameter[] GetAddNewFAParams(FundAllocationInfo FA) { SqlParameter[] sqlParms = new SqlParameter[100]; sqlParms = SQLHelper.GetCachedParameters(PROC_ADDNEWFA); if (sqlParms == null) { sqlParms = new SqlParameter[] { new SqlParameter(PARAM_RETURN, SqlDbType.Int), new SqlParameter(PARAM_FUND_ID, SqlDbType.Int), new SqlParameter(PARAM_BENEFICIARY_ID, SqlDbType.Int), new SqlParameter(PARAM_CHANGEDBY, SqlDbType.NVarChar, 100), new SqlParameter(PARAM_ALLOCATEDBY, SqlDbType.NVarChar, 100), new SqlParameter(PARAM_ALLOCATED_AMOUNT, SqlDbType.Float) }; sqlParms[0].Direction = ParameterDirection.ReturnValue; SQLHelper.CacheParameters(PROC_ADDNEWFA, sqlParms); } //Assigning values to parameter sqlParms[0].Value = -1; sqlParms[1].Value = FA.FundId; sqlParms[2].Value = FA.BeneficiaryId; sqlParms[3].Value = "vysali"; sqlParms[4].Value = "vysali"; sqlParms[5].Value = FA.Amount; return sqlParms; }
public static int AddNewFA(FundAllocationInfo FA, out int retValue) { retValue = -1; SqlParameter[] parms = GetAddNewFAParams(FA); return ExecuteNonQuery(PROC_ADDNEWFA, parms, out retValue); }
public static int AddNewFA(FundAllocationInfo FA) { return FundAllocationDal.AddNewFA(FA); }