internal int insertSingleSetup(BHSingleSetupEditModel bHSingleSetupEditModel, HRProfile hrprofile, int inputMode, string ConnString)
{
Debug.WriteLine(hrprofile.name);
Debug.WriteLine(hrprofile.employee_number);
string retVal = "";
string connString = getConnectionString(ConnString);
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmnd = new SqlCommand();
cmnd.Connection = conn;
cmnd.CommandType = CommandType.StoredProcedure;
cmnd.CommandText = "zsp_insert_single_setup";
cmnd.Parameters.Add("@deptcode", SqlDbType.VarChar).Value = bHSingleSetupEditModel.SetupBranchCode;
cmnd.Parameters.Add("@deptname", SqlDbType.VarChar).Value = bHSingleSetupEditModel.SetupBranch;
cmnd.Parameters.Add("@unitcode", SqlDbType.VarChar).Value = bHSingleSetupEditModel.HODeptCode;
cmnd.Parameters.Add("@unitname", SqlDbType.VarChar).Value = bHSingleSetupEditModel.SetupDept;
cmnd.Parameters.Add("@initiatorname", SqlDbType.VarChar).Value = bHSingleSetupEditModel.StaffName;
cmnd.Parameters.Add("@initiatornumber", SqlDbType.VarChar).Value = bHSingleSetupEditModel.StaffNumber;
cmnd.Parameters.Add("@comments", SqlDbType.VarChar).Value = bHSingleSetupEditModel.Comments ?? "";
cmnd.Parameters.Add("@hrstaffnumber", SqlDbType.VarChar).Value = hrprofile.employee_number;
cmnd.Parameters.Add("@hrstaffname", SqlDbType.VarChar).Value = hrprofile.name;
cmnd.Parameters.Add("@appraisalperiod", SqlDbType.VarChar).Value = bHSingleSetupEditModel.SelectedAppraisalPeriod;
cmnd.Parameters.Add("@inputmode", SqlDbType.SmallInt).Value = inputMode;
cmnd.Parameters.Add("@rErrorCode", SqlDbType.Int, 2).Direction = ParameterDirection.Output;
cmnd.Parameters.Add("@rErrorMsg", SqlDbType.VarChar, 255).Direction = ParameterDirection.Output;
SqlDataReader dr;
try {
// Open the data connection
cmnd.Connection = conn;
conn.Open();
dr = cmnd.ExecuteReader();
int retCode = int.Parse(cmnd.Parameters["@rErrorCode"].Value.ToString());
if (retCode != 0)
{
retVal = retCode + "|" + cmnd.Parameters["@rErrorMsg"].Value.ToString();
}
} catch (SqlException ex) {
if (ex.Number != 0)
{
retVal = ex.Number + "|" + ex.Message;
logWriter.WriteErrorLog(string.Format("insertSingleSetup : Exception!!! / {0}", retVal));
}
} finally {
conn.Close();
cmnd.Dispose();
dr = null;
}
return(0);
}
public ActionResult BHSingleSetupFormEdit(BHSingleSetupEditModel bHSingleSetupEditModel)
{
if (!ModelState.IsValid)
{
TempData["ErrorMessage"] = "Invalid model ";
TempData["bHSingleSetupEditModel"] = bHSingleSetupEditModel;
return(RedirectToAction("BHSingleSetupFormEdit"));
}
HRProfile hrprofile = new LINQCalls().hrprofile(bHSingleSetupEditModel.InitiatorLoginName, 1);
if (hrprofile == null)
{
TempData["ErrorMessage"] = "Error : You staff profile is not properly setup";
TempData["bHSingleSetupEditModel"] = bHSingleSetupEditModel;
return(RedirectToAction("BHSingleSetupFormEdit"));
}
int inputMode = 1;
int retVal = new AppDatabase().insertSingleSetup(bHSingleSetupEditModel, hrprofile, inputMode, "AppraisalDbConnectionString");
return(RedirectToAction("ViewBranchInitiators"));
}
