Int64 IHREmployeeEvaluationReportDataAccess.Delete(HREmployeeEvaluationReportEntity hREmployeeEvaluationReportEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Delete(hREmployeeEvaluationReportEntity, filterExpression, option); break; } case TransactionRequired.Yes: { retValues = DeleteTran(hREmployeeEvaluationReportEntity, filterExpression, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private void GetReport() { HREmployeeEvaluationReportEntity ent = CurrentHREmployeeEvaluationReportEntity; hypHRReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.HR_EMPLOYEE_EVALUATIONREPORT_REPORT, UrlConstants.OVERVIEW_EVALUATION_SESSION_ID, ent.SessionID.ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, ent.EmployeeID.ToString()).ToString(); hypHRReport.Target = "_blank"; }
private void SaveHREmployeeEvaluationReportEntity() { if (IsValid) { try { HREmployeeEvaluationReportEntity hREmployeeEvaluationReportEntity = BuildHREmployeeEvaluationReportEntity(); Int64 result = -1; if (hREmployeeEvaluationReportEntity.IsNew) { result = FCCHREmployeeEvaluationReport.GetFacadeCreate().Add(hREmployeeEvaluationReportEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationReportEntity.FLD_NAME_EmployeeEvaluationReportID, hREmployeeEvaluationReportEntity.EmployeeEvaluationReportID.ToString(), SQLMatchType.Equal); result = FCCHREmployeeEvaluationReport.GetFacadeCreate().Update(hREmployeeEvaluationReportEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _EmployeeEvaluationReportID = 0; _HREmployeeEvaluationReportEntity = new HREmployeeEvaluationReportEntity(); PrepareInitialView(); PrepareEditView(); BindHREmployeeEvaluationReportList(); if (hREmployeeEvaluationReportEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Employee Evaluation Report Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Employee Evaluation Report Information has been updated successfully.", false); //Response.Redirect("~/HR/HREmployeeEvaluation.aspx"); } } else { if (hREmployeeEvaluationReportEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Employee Evaluation Report Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Employee Evaluation Report Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvHREmployeeEvaluationReport_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 EmployeeEvaluationReportID; Int64.TryParse(e.CommandArgument.ToString(), out EmployeeEvaluationReportID); if (EmployeeEvaluationReportID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _EmployeeEvaluationReportID = EmployeeEvaluationReportID; PrepareEditView(); //cpeEditor.Collapsed = false; //cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationReportEntity.FLD_NAME_EmployeeEvaluationReportID, EmployeeEvaluationReportID.ToString(), SQLMatchType.Equal); HREmployeeEvaluationReportEntity hREmployeeEvaluationReportEntity = new HREmployeeEvaluationReportEntity(); result = FCCHREmployeeEvaluationReport.GetFacadeCreate().Delete(hREmployeeEvaluationReportEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _EmployeeEvaluationReportID = 0; _HREmployeeEvaluationReportEntity = new HREmployeeEvaluationReportEntity(); PrepareInitialView(); BindHREmployeeEvaluationReportList(); MiscUtil.ShowMessage(lblMessage, "Employee Evaluation Report has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Employee Evaluation Report.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private void PrepareEditView() { HREmployeeEvaluationReportEntity hREmployeeEvaluationReportEntity = CurrentHREmployeeEvaluationReportEntity; if (!hREmployeeEvaluationReportEntity.IsNew) { GetEmployeeNameAndCode(); txtTitle1.Text = hREmployeeEvaluationReportEntity.Title1.ToString(); txtTitle1Column1.Text = hREmployeeEvaluationReportEntity.Title1Column1.ToString(); txtTitle1Column2.Text = hREmployeeEvaluationReportEntity.Title1Column2.ToString(); txtTitle1Category1.Text = hREmployeeEvaluationReportEntity.Title1Category1.ToString(); txtTitle1Category1Column1Value.Text = hREmployeeEvaluationReportEntity.Title1Category1Column1Value.ToString(); txtTitle1Category1Column2Value.Text = hREmployeeEvaluationReportEntity.Title1Category1Column2Value.ToString(); txtTitle1Category2.Text = hREmployeeEvaluationReportEntity.Title1Category2.ToString(); txtTitle1Category2Column1Value.Text = hREmployeeEvaluationReportEntity.Title1Category2Column1Value.ToString(); txtTitle1Category2Column2Value.Text = hREmployeeEvaluationReportEntity.Title1Category2Column2Value.ToString(); txtTitle2.Text = hREmployeeEvaluationReportEntity.Title2.ToString(); txtTitle2Column1.Text = hREmployeeEvaluationReportEntity.Title2Column1.ToString(); txtTitle2Category1.Text = hREmployeeEvaluationReportEntity.Title2Category1.ToString(); txtTitle2Category1Column1Value.Text = hREmployeeEvaluationReportEntity.Title2Category1Column1Value.ToString(); txtTitle2Category1Column2Value.Text = hREmployeeEvaluationReportEntity.Title2Category1Column2Value.ToString(); txtTitle2Category2.Text = hREmployeeEvaluationReportEntity.Title2Category2.ToString(); txtTitle2Category2Column1Value.Text = hREmployeeEvaluationReportEntity.Title2Category2Column1Value.ToString(); txtTitle2Category2Column2Value.Text = hREmployeeEvaluationReportEntity.Title2Category2Column2Value.ToString(); txtTitle3.Text = hREmployeeEvaluationReportEntity.Title3.ToString(); txtTitle3Column1.Text = hREmployeeEvaluationReportEntity.Title3Column1.ToString(); txtTitle3Category1.Text = hREmployeeEvaluationReportEntity.Title3Category1.ToString(); txtTitle3Category1Column1Value.Text = hREmployeeEvaluationReportEntity.Title3Category1Column1Value.ToString(); txtTitle3Category1Column2Value.Text = hREmployeeEvaluationReportEntity.Title3Category1Column2Value.ToString(); txtTitle3Category2.Text = hREmployeeEvaluationReportEntity.Title3Category2.ToString(); txtTitle3Category2Column1Value.Text = hREmployeeEvaluationReportEntity.Title3Category2Column1Value.ToString(); txtTitle3Category2Column2Value.Text = hREmployeeEvaluationReportEntity.Title3Category2Column2Value.ToString(); txtHRReportQuestion1Title.Text = hREmployeeEvaluationReportEntity.HRReportQuestion1Title.ToString(); txtHRReportQuestion1TitleValue.Text = hREmployeeEvaluationReportEntity.HRReportQuestion1TitleValue.ToString(); txtSupervisorNumberValue.Text = hREmployeeEvaluationReportEntity.SupervisorNumberValue.ToString(); txtScoreValue.Text = hREmployeeEvaluationReportEntity.ScoreValue.ToString(); txtDeducationValue.Text = hREmployeeEvaluationReportEntity.DeducationValue.ToString(); txtActualScoreValue.Text = hREmployeeEvaluationReportEntity.ActualScoreValue.ToString(); txtTitle4.Text = hREmployeeEvaluationReportEntity.Title4.ToString(); txtTitle4Column1Value.Text = hREmployeeEvaluationReportEntity.Title4Column1Value.ToString(); txtHRReportQuestion2Title.Text = hREmployeeEvaluationReportEntity.HRReportQuestion2Title.ToString(); txtHRReportQuestion2TitleValue.Text = hREmployeeEvaluationReportEntity.HRReportQuestion2TitleValue.ToString(); hREmployeeEvaluationReportEntity.SessionID = _CurrentSessionID; hREmployeeEvaluationReportEntity.EmployeeID = _CurrentSessionID; GetReport(); btnSubmit.Text = "Update"; btnSubmit.Visible = true; } }
private Int64 DeleteTran(HREmployeeEvaluationReportEntity hREmployeeEvaluationReportEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.HREmployeeEvaluationReport_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { using (IDataReader reader = db.ExecuteReader(cmd, transaction)) { returnCode = GetReturnCodeFromParameter(cmd); } if (returnCode >= 0) { transaction.Commit(); } else { throw new ArgumentException("Error Code." + returnCode.ToString()); } } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); connection.Close(); connection = null; } } return(returnCode); }
private Int64 Delete(HREmployeeEvaluationReportEntity hREmployeeEvaluationReportEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.HREmployeeEvaluationReport_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("HREmployeeEvaluationReportEntity already exists. Please specify another HREmployeeEvaluationReportEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("HREmployeeEvaluationReportEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("HREmployeeEvaluationReportEntity already exists. Please specify another HREmployeeEvaluationReportEntity."); } } } } return(returnCode); }
private Int64 Add(HREmployeeEvaluationReportEntity hREmployeeEvaluationReportEntity, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.HREmployeeEvaluationReport_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddNullPrimaryKeyParameter(cmd, "EmployeeEvaluationReportID"); Database.AddInParameter(cmd, "@SessionID", DbType.Int64, hREmployeeEvaluationReportEntity.SessionID); Database.AddInParameter(cmd, "@EmployeeID", DbType.Int64, hREmployeeEvaluationReportEntity.EmployeeID); Database.AddInParameter(cmd, "@Title1", DbType.String, hREmployeeEvaluationReportEntity.Title1); Database.AddInParameter(cmd, "@Title1Column1", DbType.String, hREmployeeEvaluationReportEntity.Title1Column1); Database.AddInParameter(cmd, "@Title1Column2", DbType.String, hREmployeeEvaluationReportEntity.Title1Column2); Database.AddInParameter(cmd, "@Title1Category1", DbType.String, hREmployeeEvaluationReportEntity.Title1Category1); Database.AddInParameter(cmd, "@Title1Category1Column1Value", DbType.String, hREmployeeEvaluationReportEntity.Title1Category1Column1Value); Database.AddInParameter(cmd, "@Title1Category1Column2Value", DbType.String, hREmployeeEvaluationReportEntity.Title1Category1Column2Value); Database.AddInParameter(cmd, "@Title1Category2", DbType.String, hREmployeeEvaluationReportEntity.Title1Category2); Database.AddInParameter(cmd, "@Title1Category2Column1Value", DbType.String, hREmployeeEvaluationReportEntity.Title1Category2Column1Value); Database.AddInParameter(cmd, "@Title1Category2Column2Value", DbType.String, hREmployeeEvaluationReportEntity.Title1Category2Column2Value); Database.AddInParameter(cmd, "@Title2", DbType.String, hREmployeeEvaluationReportEntity.Title2); Database.AddInParameter(cmd, "@Title2Column1", DbType.String, hREmployeeEvaluationReportEntity.Title2Column1); Database.AddInParameter(cmd, "@Title2Category1", DbType.String, hREmployeeEvaluationReportEntity.Title2Category1); Database.AddInParameter(cmd, "@Title2Category1Column1Value", DbType.String, hREmployeeEvaluationReportEntity.Title2Category1Column1Value); Database.AddInParameter(cmd, "@Title2Category1Column2Value", DbType.String, hREmployeeEvaluationReportEntity.Title2Category1Column2Value); Database.AddInParameter(cmd, "@Title2Category2", DbType.String, hREmployeeEvaluationReportEntity.Title2Category2); Database.AddInParameter(cmd, "@Title2Category2Column1Value", DbType.String, hREmployeeEvaluationReportEntity.Title2Category2Column1Value); Database.AddInParameter(cmd, "@Title2Category2Column2Value", DbType.String, hREmployeeEvaluationReportEntity.Title2Category2Column2Value); Database.AddInParameter(cmd, "@Title3", DbType.String, hREmployeeEvaluationReportEntity.Title3); Database.AddInParameter(cmd, "@Title3Column1", DbType.String, hREmployeeEvaluationReportEntity.Title3Column1); Database.AddInParameter(cmd, "@Title3Category1", DbType.String, hREmployeeEvaluationReportEntity.Title3Category1); Database.AddInParameter(cmd, "@Title3Category1Column1Value", DbType.String, hREmployeeEvaluationReportEntity.Title3Category1Column1Value); Database.AddInParameter(cmd, "@Title3Category1Column2Value", DbType.String, hREmployeeEvaluationReportEntity.Title3Category1Column2Value); Database.AddInParameter(cmd, "@Title3Category2", DbType.String, hREmployeeEvaluationReportEntity.Title3Category2); Database.AddInParameter(cmd, "@Title3Category2Column1Value", DbType.String, hREmployeeEvaluationReportEntity.Title3Category2Column1Value); Database.AddInParameter(cmd, "@Title3Category2Column2Value", DbType.String, hREmployeeEvaluationReportEntity.Title3Category2Column2Value); Database.AddInParameter(cmd, "@HRReportQuestion1Title", DbType.String, hREmployeeEvaluationReportEntity.HRReportQuestion1Title); Database.AddInParameter(cmd, "@HRReportQuestion1TitleValue", DbType.String, hREmployeeEvaluationReportEntity.HRReportQuestion1TitleValue); Database.AddInParameter(cmd, "@SupervisorNumberValue", DbType.Decimal, hREmployeeEvaluationReportEntity.SupervisorNumberValue); Database.AddInParameter(cmd, "@ScoreValue", DbType.Decimal, hREmployeeEvaluationReportEntity.ScoreValue); Database.AddInParameter(cmd, "@DeducationValue", DbType.Decimal, hREmployeeEvaluationReportEntity.DeducationValue); Database.AddInParameter(cmd, "@ActualScoreValue", DbType.Decimal, hREmployeeEvaluationReportEntity.ActualScoreValue); Database.AddInParameter(cmd, "@Title4", DbType.String, hREmployeeEvaluationReportEntity.Title4); Database.AddInParameter(cmd, "@Title4Column1Value", DbType.Decimal, hREmployeeEvaluationReportEntity.Title4Column1Value); Database.AddInParameter(cmd, "@HRReportQuestion2Title", DbType.String, hREmployeeEvaluationReportEntity.HRReportQuestion2Title); Database.AddInParameter(cmd, "@HRReportQuestion2TitleValue", DbType.String, hREmployeeEvaluationReportEntity.HRReportQuestion2TitleValue); Database.AddInParameter(cmd, "@Extra1", DbType.String, hREmployeeEvaluationReportEntity.Extra1); Database.AddInParameter(cmd, "@Extra2", DbType.Decimal, hREmployeeEvaluationReportEntity.Extra2); Database.AddInParameter(cmd, "@Extra3", DbType.String, hREmployeeEvaluationReportEntity.Extra3); Database.AddInParameter(cmd, "@Extra4", DbType.Decimal, hREmployeeEvaluationReportEntity.Extra4); Database.AddInParameter(cmd, "@Extra5", DbType.String, hREmployeeEvaluationReportEntity.Extra5); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("HREmployeeEvaluationReportEntity already exists. Please specify another HREmployeeEvaluationReportEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("HREmployeeEvaluationReportEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("HREmployeeEvaluationReportEntity already exists. Please specify another HREmployeeEvaluationReportEntity."); } } } } return(returnCode); }
private Int64 UpdateTran(HREmployeeEvaluationReportEntity hREmployeeEvaluationReportEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.HREmployeeEvaluationReport_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option, db); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); db.AddInParameter(cmd, "@EmployeeEvaluationReportID", DbType.Int64, hREmployeeEvaluationReportEntity.EmployeeEvaluationReportID); db.AddInParameter(cmd, "@SessionID", DbType.Int64, hREmployeeEvaluationReportEntity.SessionID); db.AddInParameter(cmd, "@EmployeeID", DbType.Int64, hREmployeeEvaluationReportEntity.EmployeeID); db.AddInParameter(cmd, "@Title1", DbType.String, hREmployeeEvaluationReportEntity.Title1); db.AddInParameter(cmd, "@Title1Column1", DbType.String, hREmployeeEvaluationReportEntity.Title1Column1); db.AddInParameter(cmd, "@Title1Column2", DbType.String, hREmployeeEvaluationReportEntity.Title1Column2); db.AddInParameter(cmd, "@Title1Category1", DbType.String, hREmployeeEvaluationReportEntity.Title1Category1); db.AddInParameter(cmd, "@Title1Category1Column1Value", DbType.String, hREmployeeEvaluationReportEntity.Title1Category1Column1Value); db.AddInParameter(cmd, "@Title1Category1Column2Value", DbType.String, hREmployeeEvaluationReportEntity.Title1Category1Column2Value); db.AddInParameter(cmd, "@Title1Category2", DbType.String, hREmployeeEvaluationReportEntity.Title1Category2); db.AddInParameter(cmd, "@Title1Category2Column1Value", DbType.String, hREmployeeEvaluationReportEntity.Title1Category2Column1Value); db.AddInParameter(cmd, "@Title1Category2Column2Value", DbType.String, hREmployeeEvaluationReportEntity.Title1Category2Column2Value); db.AddInParameter(cmd, "@Title2", DbType.String, hREmployeeEvaluationReportEntity.Title2); db.AddInParameter(cmd, "@Title2Column1", DbType.String, hREmployeeEvaluationReportEntity.Title2Column1); db.AddInParameter(cmd, "@Title2Category1", DbType.String, hREmployeeEvaluationReportEntity.Title2Category1); db.AddInParameter(cmd, "@Title2Category1Column1Value", DbType.String, hREmployeeEvaluationReportEntity.Title2Category1Column1Value); db.AddInParameter(cmd, "@Title2Category1Column2Value", DbType.String, hREmployeeEvaluationReportEntity.Title2Category1Column2Value); db.AddInParameter(cmd, "@Title2Category2", DbType.String, hREmployeeEvaluationReportEntity.Title2Category2); db.AddInParameter(cmd, "@Title2Category2Column1Value", DbType.String, hREmployeeEvaluationReportEntity.Title2Category2Column1Value); db.AddInParameter(cmd, "@Title2Category2Column2Value", DbType.String, hREmployeeEvaluationReportEntity.Title2Category2Column2Value); db.AddInParameter(cmd, "@Title3", DbType.String, hREmployeeEvaluationReportEntity.Title3); db.AddInParameter(cmd, "@Title3Column1", DbType.String, hREmployeeEvaluationReportEntity.Title3Column1); db.AddInParameter(cmd, "@Title3Category1", DbType.String, hREmployeeEvaluationReportEntity.Title3Category1); db.AddInParameter(cmd, "@Title3Category1Column1Value", DbType.String, hREmployeeEvaluationReportEntity.Title3Category1Column1Value); db.AddInParameter(cmd, "@Title3Category1Column2Value", DbType.String, hREmployeeEvaluationReportEntity.Title3Category1Column2Value); db.AddInParameter(cmd, "@Title3Category2", DbType.String, hREmployeeEvaluationReportEntity.Title3Category2); db.AddInParameter(cmd, "@Title3Category2Column1Value", DbType.String, hREmployeeEvaluationReportEntity.Title3Category2Column1Value); db.AddInParameter(cmd, "@Title3Category2Column2Value", DbType.String, hREmployeeEvaluationReportEntity.Title3Category2Column2Value); db.AddInParameter(cmd, "@HRReportQuestion1Title", DbType.String, hREmployeeEvaluationReportEntity.HRReportQuestion1Title); db.AddInParameter(cmd, "@HRReportQuestion1TitleValue", DbType.String, hREmployeeEvaluationReportEntity.HRReportQuestion1TitleValue); db.AddInParameter(cmd, "@SupervisorNumberValue", DbType.Decimal, hREmployeeEvaluationReportEntity.SupervisorNumberValue); db.AddInParameter(cmd, "@ScoreValue", DbType.Decimal, hREmployeeEvaluationReportEntity.ScoreValue); db.AddInParameter(cmd, "@DeducationValue", DbType.Decimal, hREmployeeEvaluationReportEntity.DeducationValue); db.AddInParameter(cmd, "@ActualScoreValue", DbType.Decimal, hREmployeeEvaluationReportEntity.ActualScoreValue); db.AddInParameter(cmd, "@Title4", DbType.String, hREmployeeEvaluationReportEntity.Title4); db.AddInParameter(cmd, "@Title4Column1Value", DbType.Decimal, hREmployeeEvaluationReportEntity.Title4Column1Value); db.AddInParameter(cmd, "@HRReportQuestion2Title", DbType.String, hREmployeeEvaluationReportEntity.HRReportQuestion2Title); db.AddInParameter(cmd, "@HRReportQuestion2TitleValue", DbType.String, hREmployeeEvaluationReportEntity.HRReportQuestion2TitleValue); db.AddInParameter(cmd, "@Extra1", DbType.String, hREmployeeEvaluationReportEntity.Extra1); db.AddInParameter(cmd, "@Extra2", DbType.Decimal, hREmployeeEvaluationReportEntity.Extra2); db.AddInParameter(cmd, "@Extra3", DbType.String, hREmployeeEvaluationReportEntity.Extra3); db.AddInParameter(cmd, "@Extra4", DbType.Decimal, hREmployeeEvaluationReportEntity.Extra4); db.AddInParameter(cmd, "@Extra5", DbType.String, hREmployeeEvaluationReportEntity.Extra5); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { using (IDataReader reader = db.ExecuteReader(cmd, transaction)) { returnCode = GetReturnCodeFromParameter(cmd); } if (returnCode > 0) { transaction.Commit(); } else { throw new ArgumentException("Error Code." + returnCode.ToString()); } } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); connection.Close(); connection = null; } } return(returnCode); }
Int64 IHREmployeeEvaluationReportFacade.Delete(HREmployeeEvaluationReportEntity hREmployeeEvaluationReportEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateHREmployeeEvaluationReportDataAccess().Delete(hREmployeeEvaluationReportEntity, filterExpression, option, reqTran)); }
Int64 IHREmployeeEvaluationReportFacade.Add(HREmployeeEvaluationReportEntity hREmployeeEvaluationReportEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateHREmployeeEvaluationReportDataAccess().Add(hREmployeeEvaluationReportEntity, option, reqTran)); }
protected void btnAddNew_Click(object sender, EventArgs e) { _EmployeeEvaluationReportID = 0; _HREmployeeEvaluationReportEntity = new HREmployeeEvaluationReportEntity(); PrepareInitialView(); }
private HREmployeeEvaluationReportEntity BuildHREmployeeEvaluationReportEntity() { HREmployeeEvaluationReportEntity hREmployeeEvaluationReportEntity = CurrentHREmployeeEvaluationReportEntity; hREmployeeEvaluationReportEntity.SessionID = _CurrentSessionID; hREmployeeEvaluationReportEntity.EmployeeID = _CurrentEmployeeEvaluatedID; hREmployeeEvaluationReportEntity.Title1 = txtTitle1.Text.Trim(); hREmployeeEvaluationReportEntity.Title1Column1 = txtTitle1Column1.Text.Trim(); hREmployeeEvaluationReportEntity.Title1Column2 = txtTitle1Column2.Text.Trim(); hREmployeeEvaluationReportEntity.Title1Category1 = txtTitle1Category1.Text.Trim(); hREmployeeEvaluationReportEntity.Title1Category1Column1Value = txtTitle1Category1Column1Value.Text.Trim(); hREmployeeEvaluationReportEntity.Title1Category1Column2Value = txtTitle1Category1Column2Value.Text.Trim(); hREmployeeEvaluationReportEntity.Title1Category2 = txtTitle1Category2.Text.Trim(); hREmployeeEvaluationReportEntity.Title1Category2Column1Value = txtTitle1Category2Column1Value.Text.Trim(); hREmployeeEvaluationReportEntity.Title1Category2Column2Value = txtTitle1Category2Column2Value.Text.Trim(); hREmployeeEvaluationReportEntity.Title2 = txtTitle2.Text.Trim(); hREmployeeEvaluationReportEntity.Title2Column1 = txtTitle2Column1.Text.Trim(); hREmployeeEvaluationReportEntity.Title2Category1 = txtTitle2Category1.Text.Trim(); hREmployeeEvaluationReportEntity.Title2Category1Column1Value = txtTitle2Category1Column1Value.Text.Trim(); hREmployeeEvaluationReportEntity.Title2Category1Column2Value = txtTitle2Category1Column2Value.Text.Trim(); hREmployeeEvaluationReportEntity.Title2Category2 = txtTitle2Category2.Text.Trim(); hREmployeeEvaluationReportEntity.Title2Category2Column1Value = txtTitle2Category2Column1Value.Text.Trim(); hREmployeeEvaluationReportEntity.Title2Category2Column2Value = txtTitle2Category2Column2Value.Text.Trim(); hREmployeeEvaluationReportEntity.Title3 = txtTitle3.Text.Trim(); hREmployeeEvaluationReportEntity.Title3Column1 = txtTitle3Column1.Text.Trim(); hREmployeeEvaluationReportEntity.Title3Category1 = txtTitle3Category1.Text.Trim(); hREmployeeEvaluationReportEntity.Title3Category1Column1Value = txtTitle3Category1Column1Value.Text.Trim(); hREmployeeEvaluationReportEntity.Title3Category1Column2Value = txtTitle3Category1Column2Value.Text.Trim(); hREmployeeEvaluationReportEntity.Title3Category2 = txtTitle3Category2.Text.Trim(); hREmployeeEvaluationReportEntity.Title3Category2Column1Value = txtTitle3Category2Column1Value.Text.Trim(); hREmployeeEvaluationReportEntity.Title3Category2Column2Value = txtTitle3Category2Column2Value.Text.Trim(); hREmployeeEvaluationReportEntity.HRReportQuestion1Title = txtHRReportQuestion1Title.Text.Trim(); hREmployeeEvaluationReportEntity.HRReportQuestion1TitleValue = txtHRReportQuestion1TitleValue.Text.Trim(); if (!txtSupervisorNumberValue.Text.Trim().IsNullOrEmpty()) { hREmployeeEvaluationReportEntity.SupervisorNumberValue = Decimal.Parse(txtSupervisorNumberValue.Text.Trim()); } if (!txtScoreValue.Text.Trim().IsNullOrEmpty()) { hREmployeeEvaluationReportEntity.ScoreValue = Decimal.Parse(txtScoreValue.Text.Trim()); } if (!txtDeducationValue.Text.Trim().IsNullOrEmpty()) { hREmployeeEvaluationReportEntity.DeducationValue = Decimal.Parse(txtDeducationValue.Text.Trim()); } if (!txtActualScoreValue.Text.Trim().IsNullOrEmpty()) { hREmployeeEvaluationReportEntity.ActualScoreValue = Decimal.Parse(txtActualScoreValue.Text.Trim()); } hREmployeeEvaluationReportEntity.Title4 = txtTitle4.Text.Trim(); if (!txtTitle4Column1Value.Text.Trim().IsNullOrEmpty()) { hREmployeeEvaluationReportEntity.Title4Column1Value = Decimal.Parse(txtTitle4Column1Value.Text.Trim()); } hREmployeeEvaluationReportEntity.HRReportQuestion2Title = txtHRReportQuestion2Title.Text.Trim(); hREmployeeEvaluationReportEntity.HRReportQuestion2TitleValue = txtHRReportQuestion2TitleValue.Text.Trim(); return(hREmployeeEvaluationReportEntity); }