public static string UpdateFTEx(string p1, string p2, string p3, string p4, string colIndex, string mode)
{
double newsubtotal = 0;
double fte;
Double.TryParse(p4, out fte);
if (fte >= 0)
{
SQL_utils sql = new SQL_utils("backend");
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("idnbr", p1, "text"));
ps.Add(sql.CreateParam("budgetNbr", p2, "text"));
ps.Add(sql.CreateParam("mo", p3, "text"));
ps.Add(sql.CreateParam("calcFTE", p4, "float"));
ps.Add(sql.CreateParam("mode", mode, "text"));
newsubtotal = sql.DoubleScalar_from_ProcName("fin.spFTE_FutureMo_UPDATE", ps);
//sql.NonQuery_from_ProcName("fin.spFTE_FutureMo_UPDATE", ps);
sql.Close();
}
string output = string.Format("{0},{1},{2}", p2, colIndex, newsubtotal);
return(output);
}
