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