/// <summary> /// This function Updates SCT Details into the Database /// </summary> /// <param name="is_entry_DAL"></param> /// <returns> /// <paramref name="result"/> /// </returns> /// <history> /// Hari haran 08/05/2012 created /// </history> public SCT_UpdateOutputEntity updateSCEmployeeDetails_DAL(SCT_UpdateInputEntity entry_DAL) { logger.Info("Method : updateSCEmployeeDetails_DAL Start"); logger.DebugFormat("Input Parameter entry_BAL : EmpNo value = {0} and WEF = {1}", entry_DAL.EmpNo, entry_DAL.WEF); databaseLayer dbConStr = new databaseLayer(); string connStr = dbConStr.connectionInfo; logger.Debug("Connection string : " + connStr); SqlConnection conn = new SqlConnection(connStr); SqlTransaction Trans = null; if (conn.State == System.Data.ConnectionState.Closed) { conn.Open(); logger.Debug("Connection Status opened "); } logger.Info("Connetion to the database established"); try { SCT_UpdateOutputEntity result = new SCT_UpdateOutputEntity(); SqlCommand insert_cmd = new SqlCommand(); insert_cmd.Connection = conn; insert_cmd.CommandType = CommandType.StoredProcedure; Trans = conn.BeginTransaction("InsertTransaction"); insert_cmd.Transaction = Trans; string insertQuery = "HRMSACInsertRequestChange"; insert_cmd.CommandText = insertQuery; insert_cmd.Parameters.AddWithValue("@EMPNO", Convert.ToInt32(entry_DAL.EmpNo)); insert_cmd.Parameters.AddWithValue("@REASON", entry_DAL.Reason); insert_cmd.Parameters.AddWithValue("@WEF", Convert.ToDateTime(entry_DAL.WEF).ToString()); insert_cmd.Parameters.AddWithValue("@CURRENTSBU", entry_DAL.CurrentBU); insert_cmd.Parameters.AddWithValue("@NEWSBU", entry_DAL.NewBU); insert_cmd.Parameters.AddWithValue("@CURRENTBU", entry_DAL.CurrentSBU); insert_cmd.Parameters.AddWithValue("@NEWBU", entry_DAL.NewSBU); insert_cmd.Parameters.AddWithValue("@CURRENTHORIZONTAL", entry_DAL.CurrentHorizontal); insert_cmd.Parameters.AddWithValue("@NEWHORIZONTAL", entry_DAL.NewHorizontal); insert_cmd.Parameters.AddWithValue("@CURRENTORG", entry_DAL.CurrentOrg); insert_cmd.Parameters.AddWithValue("@NEWORG", entry_DAL.NewOrg); insert_cmd.Parameters.AddWithValue("@CURRENTCOST", entry_DAL.CurrentCost); insert_cmd.Parameters.AddWithValue("@NEWCOST", entry_DAL.NewCost); insert_cmd.Parameters.AddWithValue("@CURRENTPERSONAL", entry_DAL.CurrentPersonal); insert_cmd.Parameters.AddWithValue("@NEWPERSONAL", entry_DAL.NewPersonal); insert_cmd.Parameters.AddWithValue("@CURRENTSUBAREA", entry_DAL.CurrentSubArea); insert_cmd.Parameters.AddWithValue("@NEWSUBAREA", entry_DAL.NewSubArea); insert_cmd.Parameters.AddWithValue("@CURRENTGRADE", entry_DAL.CurrentGrade); insert_cmd.Parameters.AddWithValue("@NEWGRADE", entry_DAL.NewGrade); insert_cmd.Parameters.AddWithValue("@CURRENTSUPPERID", Convert.ToInt32(entry_DAL.CurrentSuperId)); insert_cmd.Parameters.AddWithValue("@NEWSUPPERID", Convert.ToInt32(entry_DAL.NewSuperId)); insert_cmd.Parameters.AddWithValue("@SUBMMITEDCOMMENTS", entry_DAL.SubmittedComment); insert_cmd.Parameters.AddWithValue("@SUBMITTEDBY", Convert.ToInt32(entry_DAL.SubmittedBy)); insert_cmd.Parameters.AddWithValue("@SUBMITTEDFROMIP", DBNull.Value); insert_cmd.Parameters.AddWithValue("@STATUS", "S"); insert_cmd.Parameters.AddWithValue("@SUBMITTEDDATE", System.DateTime.Now.ToString("yyyy-MM-dd H:mm:ss.fff")); insert_cmd.Parameters.AddWithValue("@CURRENTET_PLACE", entry_DAL.CurrBLocation); insert_cmd.Parameters.AddWithValue("@NEWET_PLACE", entry_DAL.NewBLocation); insert_cmd.Parameters.AddWithValue("@REPORTING_TYPE", 'O'); insert_cmd.Parameters.AddWithValue("@CUR_CENTER_DEPLOYMENT", entry_DAL.CurrCDeploy); insert_cmd.Parameters.AddWithValue("@NEW_CENTER_DEPLOYMENT", entry_DAL.NewCDeploy); logger.Info("Inserting Details of SCT UpdateInput Entity"); QueryLog.CmdInfo(insert_cmd); //SqlDataReader dr; int rowsAffected = insert_cmd.ExecuteNonQuery(); //if (dr.HasRows) if (rowsAffected == 1) { //dr.Read(); //if (dr["Return Value"].Equals(0)) //{ //dr.Close(); Trans.Commit(); result.StatusFlag = 0; result.Message = SCT_Constants.Success; logger.Info("Operation : Insert operation executed successfully"); } else { //dr.Close(); Trans.Rollback("InsertTransaction"); logger.Debug("Transaction Rollback Executed"); result.StatusFlag = 1; result.Message = SCT_Constants.Error; logger.Error("Operation : Insert operation Failed"); } return result; } catch (SqlException dbEx) { logger.Fatal("SQL Exception Occured At SCT_DAL - updatePurchaseRequest_DAL : "); logger.Error("Exception Code : " + dbEx.Number.ToString()); logger.Error("Exception Description : " + dbEx.Message.ToString()); logger.Error("Error : updateSCEmployeeDetails_DAL Stop"); try { logger.Debug("Transaction Rollback Executed"); Trans.Rollback("InsertTransaction"); } catch (Exception ex2) { logger.Error("Tranasction Rollback Failed : " + ex2.Message.ToString()); //throw ex2; } throw dbEx; } catch (Exception ex) { logger.Fatal("Exception Occured At SCT_DAL - updateSCEmployeeDetails_DAL : " + ex.Message.ToString()); logger.Error("Method : updateSCEmployeeDetails_DAL Stop"); try { logger.Debug("Transaction Rollback Executed"); Trans.Rollback("InsertTransaction"); } catch (Exception ex2) { logger.Error("Transaction Rollback Failed : "+ex2.Message.ToString()); //throw ex2; } //throw new myCustomException(32, ex.Message); throw ex; } finally { logger.Debug("Connection Status Closed "); conn.Dispose(); } }
/// <summary> /// This Method validates the input parameters for the updatePurchaseRequest function /// </summary> /// <param name="entry_BAL"></param> /// <returns></returns> /// <history> /// Hari haran 08/05/2012 created /// </history> public SCT_UpdateOutputEntity updateSCEmployeeDetails_BAL(SCT_UpdateInputEntity entry_BAL) { try { logger.Info("Method : updateSCEmployeeDetails_BAL Start"); logger.Debug("Method : updateSCEmployeeDetails_BAL RequestId value : " + entry_BAL.EmpNo.ToString()); SCT_UpdateOutputEntity errRes = new SCT_UpdateOutputEntity(); errRes.StatusFlag = 1; errRes.Message = SCT_Constants.Error; int validate_sctParamFlag = 0; validate_sctParamFlag = validate_sctParam(entry_BAL); logger.Debug("SCT Input parameter validation flag value(success = 0/failure = 1) : " + validate_sctParamFlag.ToString()); if (validate_sctParamFlag == 1) { logger.Debug("Error in input parameter values"); logger.Debug("ErrorCode = " + errRes.StatusFlag.ToString()); logger.Debug("ErrorMessage = " + errRes.Message); logger.Error("Method : updateSCEmployeeDetails_BAL Stop"); return errRes; } else { SCT_DAL updateSCT_DAL = new SCT_DAL(); return (updateSCT_DAL.updateSCEmployeeDetails_DAL(entry_BAL)); } } catch (SqlException dbEx) { logger.Fatal("Exception At BAL - updateSCEmployeeDetails_BAL : " + dbEx.Message.ToString()); logger.Error("Method : updateSCEmployeeDetails_BAL Stop"); throw dbEx; } catch (Exception ex) { logger.Fatal("Exception At BAL - updateSCEmployeeDetails_BAL : " + ex.Message.ToString()); logger.Error("Method : updateSCEmployeeDetails_BAL Stop"); throw ex; } }
public SCT_UpdateOutputEntity updateSCEmployeeDetails([XmlElement("SCT_Input")] SCT_UpdateInputEntity SCT_Entry) { logger.Info("Method : updateSCEmployeeDetails Start"); logger.Debug("EmployeeID value : " + SCT_Entry.EmpNo.ToString()); SCT_UpdateOutputEntity result = new SCT_UpdateOutputEntity(); try { SCTInterface updateSCT_IS = new SCTInterface(); result = updateSCT_IS.updateSCEmployeeDetails_SI(SCT_Entry); logger.Info("Method : updateSCEmployeeDetails Stop"); return result; } catch (SqlException ex) { webServiceExHandling.ExceptionLog(ex); // string mailBody = string.Format(SCT_Constants.mail_BodyFormat, System.DateTime.Now.ToString("F"), IS_Entry[0].PReqNo, ex.TargetSite.ToString(), ex.ToString()); // webServiceExHandling.Send_Email(SCT_Constants.Email_Dic, mailBody); result.StatusFlag = 1; string expCode = ExpType(ex); result.Message = SCT_Constants.cnfgErrMessages[expCode]; logger.Debug("Return object Error : ErrorCode = " + result.StatusFlag.ToString()); logger.Debug("Return object Error : ErrorMessage = " + result.Message); logger.Error("Method : updateSCEmployeeDetails Stop"); return result; } catch (Exception ex) { webServiceExHandling.ExceptionLog(ex); //string mailBody = string.Format(SCT_Constants.mail_BodyFormat, System.DateTime.Now.ToString("F"), getPreqNo(IS_Entry), ex.TargetSite.ToString(), ex.ToString()); //webServiceExHandling.Send_Email(SCT_Constants.Email_Dic, mailBody); result.StatusFlag = 1; result.Message = SCT_Constants.Error; logger.Debug("Return object Error : ErrorCode = " + result.StatusFlag.ToString()); logger.Debug("Return object Error : ErrorMessage = " + result.Message); logger.Error("Method : updateSCEmployeeDetails Stop"); return result; } }