public List <MODEL.risk_project_res_assignment> getPrjResAssignListByPrjId(int projectId)
{
List <MODEL.risk_project_res_assignment> prjResAssignList = new List <MODEL.risk_project_res_assignment>();
string sql = "select * from risk_project_res_assignment where PRI_ID=:prjId";
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":prjId", OracleDbType.Int32, 11)
};
parameters[0].Value = projectId;
try
{
using (OracleDataReader reader = SqlHelper.ExecuteQuery(sql, parameters))
{
while (reader.Read())
{
MODEL.risk_project_res_assignment prjResAssign = new MODEL.risk_project_res_assignment();
prjResAssign.Auto_id = Convert.ToInt32(reader["auto_id"]);
prjResAssign.Assignment_amount = Convert.ToInt32(reader["ASSIGNMENT_AMOUNT"]);
prjResAssign.Assignment_remains = Convert.ToInt32(reader["ASSIGNMENT_REMAINS"]);
prjResAssign.Pri_id = projectId;
prjResAssign.Resource_id = Convert.ToInt32(reader["resource_id"]);;
prjResAssignList.Add(prjResAssign);
}
}
return(prjResAssignList);
}
catch (Exception ex)
{
throw ex;
}
}
public MODEL.risk_project_res_assignment findResByPrjIdResId(int prjId, int resId)
{
string sql = "select * from risk_project_res_assignment where PRI_ID=:prjId and RESOURCE_ID=:resId";
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":prjId", OracleDbType.Int32, 11),
new OracleParameter(":resId", OracleDbType.Int32, 11)
};
parameters[0].Value = prjId;
parameters[1].Value = resId;
MODEL.risk_project_res_assignment prjResAssign = new MODEL.risk_project_res_assignment();
try
{
using (OracleDataReader reader = SqlHelper.ExecuteQuery(sql, parameters))
{
if (reader.Read())
{
prjResAssign.Auto_id = Convert.ToInt32(reader["auto_id"]);
prjResAssign.Assignment_amount = Convert.ToInt32(reader["ASSIGNMENT_AMOUNT"]);
prjResAssign.Assignment_remains = Convert.ToInt32(reader["ASSIGNMENT_REMAINS"]);
prjResAssign.Pri_id = prjId;
prjResAssign.Resource_id = resId;
}
}
return(prjResAssign);
}
catch (Exception ex)
{
throw ex;
}
}
public static void deleteResources(string resource_name, MODEL.risk_project_res_assignment res_assignment)
{
MODEL.risk_resource originalRes = CommonArugment.getResources.findResByName(resource_name);
originalRes.Resource_remains += res_assignment.Assignment_amount;
CommonArugment.getResources.updateByName(originalRes);
CommonArugment.getPrjResAssign.deleteByPrjIdResId(res_assignment);
}
public void deleteByPrjIdResId(MODEL.risk_project_res_assignment res_assignment)
{
string sql = "delete risk_project_res_assignment where PRI_ID=:prjId and RESOURCE_ID=:resourceId";
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":prjId", OracleDbType.Int32, 11),
new OracleParameter(":resourceId", OracleDbType.Int32, 11)
};
parameters[0].Value = res_assignment.Pri_id;
parameters[1].Value = res_assignment.Resource_id;
try
{
SqlHelper.ExecuteNonQuery(sql, parameters);
}
catch (System.Exception ex)
{
throw ex;
}
}
public static bool modifyResources(string resource_name, MODEL.risk_project_res_assignment res, bool Isright)
{
MODEL.risk_resource originalRes = CommonArugment.getResources.findResByName(resource_name);
if (Isright)
{
originalRes.Resource_remains -= res.Assignment_amount;
res.Assignment_remains += res.Assignment_amount;
CommonArugment.getResources.updateByName(originalRes);
CommonArugment.getPrjResAssign.updateByPrjIdResId(res);
}
else
{
originalRes.Resource_remains += res.Assignment_amount;
res.Assignment_remains -= res.Assignment_amount;
CommonArugment.getResources.updateByName(originalRes);
CommonArugment.getPrjResAssign.updateByPrjIdResId(res);
}
return(true);
}
public void updateByPrjIdResId(MODEL.risk_project_res_assignment prjResAssign)
{
string sql = "update risk_project_res_assignment set assignment_amount=:assignmentAmount,assignment_remains=:assignmentRemains where PRI_ID=:prjId and RESOURCE_ID=:resId";
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":assignmentAmount", OracleDbType.Int32, 11),
new OracleParameter(":assignmentRemains", OracleDbType.Int32, 11),
new OracleParameter(":prjId", OracleDbType.Int32, 11),
new OracleParameter(":resId", OracleDbType.Int32, 11)
};
parameters[0].Value = prjResAssign.Assignment_remains;
parameters[1].Value = prjResAssign.Assignment_remains;
parameters[2].Value = prjResAssign.Pri_id;
parameters[3].Value = prjResAssign.Resource_id;
try
{
SqlHelper.ExecuteNonQuery(sql, parameters);
}
catch (Exception ex)
{
throw ex;
}
}
