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