Int64 IHREmployeeEvaluationResultDataAccess.Add(HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
try
{
long retValues = -99;
switch (reqTran)
{
case TransactionRequired.No:
{
retValues = Add(hREmployeeEvaluationResultEntity, option);
break;
}
case TransactionRequired.Yes:
{
retValues = AddTran(hREmployeeEvaluationResultEntity, option);
break;
}
default:
{
retValues = -99;
break;
}
}
return(retValues);
}
catch (Exception ex)
{
throw ex;
}
}
private Int64 Update(HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HREmployeeEvaluationResult_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
Database.AddInParameter(cmd, "@EmployeeEvaluationResultID", DbType.Int64, hREmployeeEvaluationResultEntity.EmployeeEvaluationResultID);
Database.AddInParameter(cmd, "@EvaluationCriteriaCategoryID", DbType.Int64, hREmployeeEvaluationResultEntity.EvaluationCriteriaCategoryID);
Database.AddInParameter(cmd, "@Question", DbType.String, hREmployeeEvaluationResultEntity.Question);
Database.AddInParameter(cmd, "@Description", DbType.String, hREmployeeEvaluationResultEntity.Description);
Database.AddInParameter(cmd, "@EmployeeEvaluationID", DbType.Int64, hREmployeeEvaluationResultEntity.EmployeeEvaluationID);
Database.AddInParameter(cmd, "@EmployeeEvaluationCriteriaID", DbType.Int64, hREmployeeEvaluationResultEntity.EmployeeEvaluationCriteriaID);
Database.AddInParameter(cmd, "@AnswerGivenByEmployeeDepartmentName", DbType.String, hREmployeeEvaluationResultEntity.AnswerGivenByEmployeeDepartmentName);
Database.AddInParameter(cmd, "@EmployeeFullName", DbType.String, hREmployeeEvaluationResultEntity.EmployeeFullName);
Database.AddInParameter(cmd, "@EmployeeCode", DbType.String, hREmployeeEvaluationResultEntity.EmployeeCode);
Database.AddInParameter(cmd, "@SupervisorEvaluationCriteriaID", DbType.Int64, hREmployeeEvaluationResultEntity.SupervisorEvaluationCriteriaID);
Database.AddInParameter(cmd, "@SupervisorDepartmentName", DbType.String, hREmployeeEvaluationResultEntity.SupervisorDepartmentName);
Database.AddInParameter(cmd, "@AnswerGivenBySupervisorEmployeeFullName", DbType.String, hREmployeeEvaluationResultEntity.AnswerGivenBySupervisorEmployeeFullName);
Database.AddInParameter(cmd, "@SupervisorEmployeeCode", DbType.String, hREmployeeEvaluationResultEntity.SupervisorEmployeeCode);
Database.AddInParameter(cmd, "@EmployeeResult", DbType.Int32, hREmployeeEvaluationResultEntity.EmployeeResult);
Database.AddInParameter(cmd, "@Result", DbType.Int32, hREmployeeEvaluationResultEntity.Result);
Database.AddInParameter(cmd, "@PointInThisQuestion", DbType.Int32, hREmployeeEvaluationResultEntity.PointInThisQuestion);
Database.AddInParameter(cmd, "@Remarks", DbType.String, hREmployeeEvaluationResultEntity.Remarks);
Database.AddInParameter(cmd, "@Extra1", DbType.String, hREmployeeEvaluationResultEntity.Extra1);
Database.AddInParameter(cmd, "@Extra2", DbType.String, hREmployeeEvaluationResultEntity.Extra2);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("HREmployeeEvaluationResultEntity already exists. Please specify another HREmployeeEvaluationResultEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("HREmployeeEvaluationResultEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("HREmployeeEvaluationResultEntity already exists. Please specify another HREmployeeEvaluationResultEntity.");
}
}
}
}
return(returnCode);
}
private void SaveHREmployeeEvaluationResultEntity()
{
if (IsValid)
{
try
{
HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity = BuildHREmployeeEvaluationResultEntity();
Int64 result = -1;
if (hREmployeeEvaluationResultEntity.IsNew)
{
result = FCCHREmployeeEvaluationResult.GetFacadeCreate().Add(hREmployeeEvaluationResultEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationResultEntity.FLD_NAME_EmployeeEvaluationResultID, hREmployeeEvaluationResultEntity.EmployeeEvaluationResultID.ToString(), SQLMatchType.Equal);
result = FCCHREmployeeEvaluationResult.GetFacadeCreate().Update(hREmployeeEvaluationResultEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
_EmployeeEvaluationResultID = 0;
_HREmployeeEvaluationResultEntity = new HREmployeeEvaluationResultEntity();
PrepareInitialView();
BindHREmployeeEvaluationResultList();
if (hREmployeeEvaluationResultEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Employee Evaluation Result Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Employee Evaluation Result Information has been updated successfully.", false);
}
}
else
{
if (hREmployeeEvaluationResultEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Employee Evaluation Result Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Employee Evaluation Result Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
protected void lvHREmployeeEvaluationResult_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 EmployeeEvaluationResultID;
Int64.TryParse(e.CommandArgument.ToString(), out EmployeeEvaluationResultID);
if (EmployeeEvaluationResultID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_EmployeeEvaluationResultID = EmployeeEvaluationResultID;
PrepareEditView();
cpeEditor.Collapsed = false;
cpeEditor.ClientState = "false";
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationResultEntity.FLD_NAME_EmployeeEvaluationResultID, EmployeeEvaluationResultID.ToString(), SQLMatchType.Equal);
HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity = new HREmployeeEvaluationResultEntity();
result = FCCHREmployeeEvaluationResult.GetFacadeCreate().Delete(hREmployeeEvaluationResultEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_EmployeeEvaluationResultID = 0;
_HREmployeeEvaluationResultEntity = new HREmployeeEvaluationResultEntity();
PrepareInitialView();
BindHREmployeeEvaluationResultList();
MiscUtil.ShowMessage(lblMessage, "Employee Evaluation Result has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Employee Evaluation Result.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
private Int64 DeleteTran(HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HREmployeeEvaluationResult_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 void PrepareEditView()
{
HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity = CurrentHREmployeeEvaluationResultEntity;
if (!hREmployeeEvaluationResultEntity.IsNew)
{
if (ddlEvaluationCriteriaCategoryID.Items.Count > 0 && hREmployeeEvaluationResultEntity.EvaluationCriteriaCategoryID != null)
{
ddlEvaluationCriteriaCategoryID.SelectedValue = hREmployeeEvaluationResultEntity.EvaluationCriteriaCategoryID.ToString();
}
txtQuestion.Text = hREmployeeEvaluationResultEntity.Question.ToString();
txtDescription.Text = hREmployeeEvaluationResultEntity.Description.ToString();
if (ddlEmployeeEvaluationID.Items.Count > 0 && hREmployeeEvaluationResultEntity.EmployeeEvaluationID != null)
{
ddlEmployeeEvaluationID.SelectedValue = hREmployeeEvaluationResultEntity.EmployeeEvaluationID.ToString();
}
if (ddlEmployeeEvaluationCriteriaID.Items.Count > 0 && hREmployeeEvaluationResultEntity.EmployeeEvaluationCriteriaID != null)
{
ddlEmployeeEvaluationCriteriaID.SelectedValue = hREmployeeEvaluationResultEntity.EmployeeEvaluationCriteriaID.ToString();
}
txtAnswerGivenByEmployeeDepartmentName.Text = hREmployeeEvaluationResultEntity.AnswerGivenByEmployeeDepartmentName.ToString();
txtEmployeeFullName.Text = hREmployeeEvaluationResultEntity.EmployeeFullName.ToString();
txtEmployeeCode.Text = hREmployeeEvaluationResultEntity.EmployeeCode.ToString();
if (ddlSupervisorEvaluationCriteriaID.Items.Count > 0 && hREmployeeEvaluationResultEntity.SupervisorEvaluationCriteriaID != null)
{
ddlSupervisorEvaluationCriteriaID.SelectedValue = hREmployeeEvaluationResultEntity.SupervisorEvaluationCriteriaID.ToString();
}
txtSupervisorDepartmentName.Text = hREmployeeEvaluationResultEntity.SupervisorDepartmentName.ToString();
txtAnswerGivenBySupervisorEmployeeFullName.Text = hREmployeeEvaluationResultEntity.AnswerGivenBySupervisorEmployeeFullName.ToString();
txtSupervisorEmployeeCode.Text = hREmployeeEvaluationResultEntity.SupervisorEmployeeCode.ToString();
txtEmployeeResult.Text = hREmployeeEvaluationResultEntity.EmployeeResult.ToString();
txtResult.Text = hREmployeeEvaluationResultEntity.Result.ToString();
txtPointInThisQuestion.Text = hREmployeeEvaluationResultEntity.PointInThisQuestion.ToString();
txtRemarks.Text = hREmployeeEvaluationResultEntity.Remarks.ToString();
txtExtra1.Text = hREmployeeEvaluationResultEntity.Extra1.ToString();
txtExtra2.Text = hREmployeeEvaluationResultEntity.Extra2.ToString();
btnSubmit.Text = "Update";
btnAddNew.Visible = true;
}
}
private Int64 Delete(HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HREmployeeEvaluationResult_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("HREmployeeEvaluationResultEntity already exists. Please specify another HREmployeeEvaluationResultEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("HREmployeeEvaluationResultEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("HREmployeeEvaluationResultEntity already exists. Please specify another HREmployeeEvaluationResultEntity.");
}
}
}
}
return(returnCode);
}
private void UpdateEvaluationInfo()
{
if (SubmittedAction == "UnLocked")
{
try
{
IList <ListViewDataItem> list = lvMDEvaluationCriteria.Items;
if (list != null && list.Count > 0)
{
Int32 tempDataItemIndex = 0;
foreach (ListViewDataItem lvdi in list)
{
//DataKey currentDataKey = lvPRMBOQDetail.DataKeys[tempDataItemIndex++];
//Int64 intPreBOQDetailID = (Int64)currentDataKey["BOQDetailID"];
//
TextBox txtRemarksLV = (TextBox)lvdi.FindControl("txtRemarksLV");
TextBox txtEmployeeResultLV = (TextBox)lvdi.FindControl("txtEmployeeResultLV");
TextBox txtSupervisorResultLV = (TextBox)lvdi.FindControl("txtSupervisorResultLV");
Label lblQuestionLV = (Label)lvdi.FindControl("lblQuestionLV");
Label lblDescriptionLV = (Label)lvdi.FindControl("lblDescriptionLV");
DropDownList ddlAnswerScaleID = (DropDownList)lvdi.FindControl("ddlAnswerScaleID");
Label lblPointInThisQuestionLV = (Label)lvdi.FindControl("lblPointInThisQuestionLV");
Label lblEvaluationCriteriaCategoryIDLV = (Label)lvdi.FindControl("lblEvaluationCriteriaCategoryIDLV");
Label lblEmployeeEvaluationResultIDLV = (Label)lvdi.FindControl("lblEmployeeEvaluationResultIDLV");
Label lblEmployeeEvaluationIDLV = (Label)lvdi.FindControl("lblEmployeeEvaluationIDLV");
Label lblEvaluationCriteriaIDLV = (Label)lvdi.FindControl("lblEvaluationCriteriaIDLV");
Int64 resultID = 0;
Int64.TryParse(lblEmployeeEvaluationResultIDLV.Text.ToString(), out resultID);
HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity = new HREmployeeEvaluationResultEntity();
if (resultID > 0)
{
hREmployeeEvaluationResultEntity = FCCHREmployeeEvaluationResult.GetFacadeCreate().GetByID(resultID);
}
hREmployeeEvaluationResultEntity.EvaluationCriteriaCategoryID = Int64.Parse(lblEvaluationCriteriaCategoryIDLV.Text); // should come from Session
hREmployeeEvaluationResultEntity.Question = lblQuestionLV.Text.Trim();
hREmployeeEvaluationResultEntity.Description = lblDescriptionLV.Text.Trim();
hREmployeeEvaluationResultEntity.EmployeeEvaluationID = Int64.Parse(lblEmployeeEvaluationIDLV.Text);
_EmployeeEvaluationID = Int64.Parse(hREmployeeEvaluationResultEntity.EmployeeEvaluationID.ToString());
hREmployeeEvaluationResultEntity.EmployeeEvaluationCriteriaID = Int64.Parse(lblEvaluationCriteriaCategoryIDLV.Text);
hREmployeeEvaluationResultEntity.AnswerGivenByEmployeeDepartmentName = "";
hREmployeeEvaluationResultEntity.EmployeeFullName = "";
hREmployeeEvaluationResultEntity.EmployeeCode = "";
hREmployeeEvaluationResultEntity.EmployeeEvaluationCriteriaID = Int64.Parse(lblEvaluationCriteriaIDLV.Text);
//hREmployeeEvaluationResultEntity.SupervisorEvaluationCriteriaID = Int64.Parse(ddlSupervisorEvaluationCriteriaID.SelectedValue);
//hREmployeeEvaluationResultEntity.SupervisorDepartmentName = txtSupervisorDepartmentName.Text.Trim();
//hREmployeeEvaluationResultEntity.AnswerGivenBySupervisorEmployeeFullName = txtAnswerGivenBySupervisorEmployeeFullName.Text.Trim();
//hREmployeeEvaluationResultEntity.SupervisorEmployeeCode = txtSupervisorEmployeeCode.Text.Trim();
//if (!txtEmployeeResultLV.Text.Trim().IsNullOrEmpty())
//{
// hREmployeeEvaluationResultEntity.EmployeeResult = Int32.Parse(txtEmployeeResultLV.Text.Trim());
//}
//else
//{
// hREmployeeEvaluationResultEntity.EmployeeResult = null;
//}
if (Action == "Employee")
{
if (ddlAnswerScaleID != null && ddlAnswerScaleID.Items.Count > 0)
{
hREmployeeEvaluationResultEntity.EmployeeResult = Int32.Parse(ddlAnswerScaleID.SelectedValue.Trim());
}
else
{
hREmployeeEvaluationResultEntity.EmployeeResult = null;
}
hREmployeeEvaluationResultEntity.Remarks = txtRemarksLV.Text.Trim().ToString();
}
if (Action == "Supervisor")
{
if (ddlAnswerScaleID != null && ddlAnswerScaleID.Items.Count > 0)
{
hREmployeeEvaluationResultEntity.Result = Int32.Parse(ddlAnswerScaleID.SelectedValue.Trim());
}
else
{
hREmployeeEvaluationResultEntity.Result = null;
}
hREmployeeEvaluationResultEntity.Extra1 = txtRemarksLV.Text.Trim().ToString();
}
//if (!lblPointInThisQuestionLV.Text.Trim().IsNullOrEmpty())
//{
// hREmployeeEvaluationResultEntity.PointInThisQuestion = Int32.Parse(lblPointInThisQuestionLV.Text.Trim());
//}
//else
//{
// hREmployeeEvaluationResultEntity.PointInThisQuestion = null;
//}
hREmployeeEvaluationResultEntity.Extra2 = "";
if (resultID > 0)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationResultEntity.FLD_NAME_EmployeeEvaluationResultID, resultID.ToString(), SQLMatchType.Equal);
FCCHREmployeeEvaluationResult.GetFacadeCreate().Update(hREmployeeEvaluationResultEntity, fe, DatabaseOperationType.Update, TransactionRequired.No);
}
else
{
FCCHREmployeeEvaluationResult.GetFacadeCreate().Add(hREmployeeEvaluationResultEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
MiscUtil.ShowMessage(lblMessage, "Evaluation Information has been saved successfully.", false);
}
BindMDEvaluationCriteriaList();
BindLabel();
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "Failed to Save Evaluation Information.", true);
}
}
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
_EmployeeEvaluationResultID = 0;
_HREmployeeEvaluationResultEntity = new HREmployeeEvaluationResultEntity();
PrepareInitialView();
}
private HREmployeeEvaluationResultEntity BuildHREmployeeEvaluationResultEntity()
{
HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity = CurrentHREmployeeEvaluationResultEntity;
if (ddlEvaluationCriteriaCategoryID.Items.Count > 0)
{
if (ddlEvaluationCriteriaCategoryID.SelectedValue == "0")
{
}
else
{
hREmployeeEvaluationResultEntity.EvaluationCriteriaCategoryID = Int64.Parse(ddlEvaluationCriteriaCategoryID.SelectedValue);
}
}
hREmployeeEvaluationResultEntity.Question = txtQuestion.Text.Trim();
hREmployeeEvaluationResultEntity.Description = txtDescription.Text.Trim();
if (ddlEmployeeEvaluationID.Items.Count > 0)
{
if (ddlEmployeeEvaluationID.SelectedValue == "0")
{
}
else
{
hREmployeeEvaluationResultEntity.EmployeeEvaluationID = Int64.Parse(ddlEmployeeEvaluationID.SelectedValue);
}
}
if (ddlEmployeeEvaluationCriteriaID.Items.Count > 0)
{
if (ddlEmployeeEvaluationCriteriaID.SelectedValue == "0")
{
}
else
{
hREmployeeEvaluationResultEntity.EmployeeEvaluationCriteriaID = Int64.Parse(ddlEmployeeEvaluationCriteriaID.SelectedValue);
}
}
hREmployeeEvaluationResultEntity.AnswerGivenByEmployeeDepartmentName = txtAnswerGivenByEmployeeDepartmentName.Text.Trim();
hREmployeeEvaluationResultEntity.EmployeeFullName = txtEmployeeFullName.Text.Trim();
hREmployeeEvaluationResultEntity.EmployeeCode = txtEmployeeCode.Text.Trim();
if (ddlSupervisorEvaluationCriteriaID.Items.Count > 0)
{
if (ddlSupervisorEvaluationCriteriaID.SelectedValue == "0")
{
hREmployeeEvaluationResultEntity.SupervisorEvaluationCriteriaID = null;
}
else
{
hREmployeeEvaluationResultEntity.SupervisorEvaluationCriteriaID = Int64.Parse(ddlSupervisorEvaluationCriteriaID.SelectedValue);
}
}
hREmployeeEvaluationResultEntity.SupervisorDepartmentName = txtSupervisorDepartmentName.Text.Trim();
hREmployeeEvaluationResultEntity.AnswerGivenBySupervisorEmployeeFullName = txtAnswerGivenBySupervisorEmployeeFullName.Text.Trim();
hREmployeeEvaluationResultEntity.SupervisorEmployeeCode = txtSupervisorEmployeeCode.Text.Trim();
if (!txtEmployeeResult.Text.Trim().IsNullOrEmpty())
{
hREmployeeEvaluationResultEntity.EmployeeResult = Int32.Parse(txtEmployeeResult.Text.Trim());
}
else
{
hREmployeeEvaluationResultEntity.EmployeeResult = null;
}
if (!txtResult.Text.Trim().IsNullOrEmpty())
{
hREmployeeEvaluationResultEntity.Result = Int32.Parse(txtResult.Text.Trim());
}
else
{
hREmployeeEvaluationResultEntity.Result = null;
}
if (!txtPointInThisQuestion.Text.Trim().IsNullOrEmpty())
{
hREmployeeEvaluationResultEntity.PointInThisQuestion = Int32.Parse(txtPointInThisQuestion.Text.Trim());
}
else
{
hREmployeeEvaluationResultEntity.PointInThisQuestion = null;
}
hREmployeeEvaluationResultEntity.Remarks = txtRemarks.Text.Trim();
hREmployeeEvaluationResultEntity.Extra1 = txtExtra1.Text.Trim();
hREmployeeEvaluationResultEntity.Extra2 = txtExtra2.Text.Trim();
return(hREmployeeEvaluationResultEntity);
}
Int64 IHREmployeeEvaluationResultFacade.Delete(HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateHREmployeeEvaluationResultDataAccess().Delete(hREmployeeEvaluationResultEntity, filterExpression, option, reqTran));
}
Int64 IHREmployeeEvaluationResultFacade.Add(HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateHREmployeeEvaluationResultDataAccess().Add(hREmployeeEvaluationResultEntity, option, reqTran));
}
private Int64 UpdateTran(HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HREmployeeEvaluationResult_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, "@EmployeeEvaluationResultID", DbType.Int64, hREmployeeEvaluationResultEntity.EmployeeEvaluationResultID);
db.AddInParameter(cmd, "@EvaluationCriteriaCategoryID", DbType.Int64, hREmployeeEvaluationResultEntity.EvaluationCriteriaCategoryID);
db.AddInParameter(cmd, "@Question", DbType.String, hREmployeeEvaluationResultEntity.Question);
db.AddInParameter(cmd, "@Description", DbType.String, hREmployeeEvaluationResultEntity.Description);
db.AddInParameter(cmd, "@EmployeeEvaluationID", DbType.Int64, hREmployeeEvaluationResultEntity.EmployeeEvaluationID);
db.AddInParameter(cmd, "@EmployeeEvaluationCriteriaID", DbType.Int64, hREmployeeEvaluationResultEntity.EmployeeEvaluationCriteriaID);
db.AddInParameter(cmd, "@AnswerGivenByEmployeeDepartmentName", DbType.String, hREmployeeEvaluationResultEntity.AnswerGivenByEmployeeDepartmentName);
db.AddInParameter(cmd, "@EmployeeFullName", DbType.String, hREmployeeEvaluationResultEntity.EmployeeFullName);
db.AddInParameter(cmd, "@EmployeeCode", DbType.String, hREmployeeEvaluationResultEntity.EmployeeCode);
db.AddInParameter(cmd, "@SupervisorEvaluationCriteriaID", DbType.Int64, hREmployeeEvaluationResultEntity.SupervisorEvaluationCriteriaID);
db.AddInParameter(cmd, "@SupervisorDepartmentName", DbType.String, hREmployeeEvaluationResultEntity.SupervisorDepartmentName);
db.AddInParameter(cmd, "@AnswerGivenBySupervisorEmployeeFullName", DbType.String, hREmployeeEvaluationResultEntity.AnswerGivenBySupervisorEmployeeFullName);
db.AddInParameter(cmd, "@SupervisorEmployeeCode", DbType.String, hREmployeeEvaluationResultEntity.SupervisorEmployeeCode);
db.AddInParameter(cmd, "@EmployeeResult", DbType.Int32, hREmployeeEvaluationResultEntity.EmployeeResult);
db.AddInParameter(cmd, "@Result", DbType.Int32, hREmployeeEvaluationResultEntity.Result);
db.AddInParameter(cmd, "@PointInThisQuestion", DbType.Int32, hREmployeeEvaluationResultEntity.PointInThisQuestion);
db.AddInParameter(cmd, "@Remarks", DbType.String, hREmployeeEvaluationResultEntity.Remarks);
db.AddInParameter(cmd, "@Extra1", DbType.String, hREmployeeEvaluationResultEntity.Extra1);
db.AddInParameter(cmd, "@Extra2", DbType.String, hREmployeeEvaluationResultEntity.Extra2);
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);
}
