public bool SetBudget(BudgetByDep item) { bool result = false; string strSQL = ""; if (item.id == 0) { strSQL = "Insert Into BudgetOfYearByDepartment (BudgetYear,DEPid,DEPcode,DEPdescT," + item.ColumnName + ")" + " VALUES (@BudgetYear,@DEPid,@DEPcode,@DEPdescT,@Budget)"; List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@BudgetYear", SqlDbType = SqlDbType.Int, Value = item.Year }, new SqlParameter() { ParameterName = "@DEPid", SqlDbType = SqlDbType.Int, Value = item.DEPid }, new SqlParameter() { ParameterName = "@DEPcode", SqlDbType = SqlDbType.NVarChar, Value = item.DEPcode }, new SqlParameter() { ParameterName = "@DEPdescT", SqlDbType = SqlDbType.NVarChar, Value = item.DEPdescT }, new SqlParameter() { ParameterName = "@Budget", SqlDbType = SqlDbType.Decimal, Value = item.Budget }, }; DBHelper.Execute(strSQL, sp); } else { strSQL = "UPDATE BudgetOfYearByDepartment SET " + item.ColumnName + "=@Budget WHERE id=@id"; List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@id", SqlDbType = SqlDbType.Int, Value = item.id }, new SqlParameter() { ParameterName = "@Budget", SqlDbType = SqlDbType.Decimal, Value = item.Budget }, }; DBHelper.Execute(strSQL, sp); } return(result); }
public HttpResponseMessage SetBudget(BudgetByDep item) { Result response = new Result(); bool ret = false; DataSet ds = new DataSet(); DataTable dt = new DataTable(); try { ret = repository.SetBudget(item); } catch (Exception e) { response.StatusCode = (int)StatusCodes.Error; response.Messages = e.Message; } response.Results = ret; //response.Records = ds.Tables[0].Rows.Count; return(Request.CreateResponse(HttpStatusCode.OK, response)); }