private void PrepareEditView() { MDEvaluationCriteriaEntity mDEvaluationCriteriaEntity = CurrentMDEvaluationCriteriaEntity; if (!mDEvaluationCriteriaEntity.IsNew) { if (ddlEvaluationCriteriaCategoryID.Items.Count > 0 && mDEvaluationCriteriaEntity.EvaluationCriteriaCategoryID != null) { ddlEvaluationCriteriaCategoryID.SelectedValue = mDEvaluationCriteriaEntity.EvaluationCriteriaCategoryID.ToString(); } if (ddlSupervisorTypeID.Items.Count > 0 && mDEvaluationCriteriaEntity.SupervisorTypeID != null) { ddlSupervisorTypeID.SelectedValue = mDEvaluationCriteriaEntity.SupervisorTypeID.ToString(); } if (ddlEvaluationSessionCategoryID.Items.Count > 0 && mDEvaluationCriteriaEntity.EvaluationSessionCategoryID != null) { ddlEvaluationSessionCategoryID.SelectedValue = mDEvaluationCriteriaEntity.EvaluationSessionCategoryID.ToString(); } txtQuestion.Text = mDEvaluationCriteriaEntity.Question.ToString(); txtDescription.Text = mDEvaluationCriteriaEntity.Description.ToString(); txtCorrectAnswerIfAny.Text = mDEvaluationCriteriaEntity.CorrectAnswerIfAny.ToString(); txtCorrectAnswerMarkOrPoint.Text = mDEvaluationCriteriaEntity.CorrectAnswerMarkOrPoint.ToString(); txtQuestionOrderInDisplay.Text = mDEvaluationCriteriaEntity.QuestionOrderInDisplay.ToString(); chkSupervisorWillAnswer.Checked = mDEvaluationCriteriaEntity.SupervisorWillAnswer; chkIsRemoved.Checked = mDEvaluationCriteriaEntity.IsRemoved; btnSubmit.Text = "Update"; btnAddNew.Visible = true; } }
Int64 IMDEvaluationCriteriaDataAccess.Add(MDEvaluationCriteriaEntity mDEvaluationCriteriaEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(mDEvaluationCriteriaEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(mDEvaluationCriteriaEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private void PrepareEditView() { MDEvaluationCriteriaEntity mDEvaluationCriteriaEntity = CurrentMDEvaluationCriteriaEntity; if (!mDEvaluationCriteriaEntity.IsNew) { } }
private void SaveMDEvaluationCriteriaEntity() { if (IsValid) { try { MDEvaluationCriteriaEntity mDEvaluationCriteriaEntity = BuildMDEvaluationCriteriaEntity(); Int64 result = -1; if (mDEvaluationCriteriaEntity.IsNew) { result = FCCMDEvaluationCriteria.GetFacadeCreate().Add(mDEvaluationCriteriaEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(MDEvaluationCriteriaEntity.FLD_NAME_EvaluationCriteriaID, mDEvaluationCriteriaEntity.EvaluationCriteriaID.ToString(), SQLMatchType.Equal); result = FCCMDEvaluationCriteria.GetFacadeCreate().Update(mDEvaluationCriteriaEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _EvaluationCriteriaID = 0; _MDEvaluationCriteriaEntity = new MDEvaluationCriteriaEntity(); PrepareInitialView(); BindMDEvaluationCriteriaList(); if (mDEvaluationCriteriaEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Evaluation Criteria Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Evaluation Criteria Information has been updated successfully.", false); } } else { if (mDEvaluationCriteriaEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Evaluation Criteria Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Evaluation Criteria Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private Int64 Update(MDEvaluationCriteriaEntity mDEvaluationCriteriaEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.MDEvaluationCriteria_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@EvaluationCriteriaID", DbType.Int64, mDEvaluationCriteriaEntity.EvaluationCriteriaID); Database.AddInParameter(cmd, "@EvaluationCriteriaCategoryID", DbType.Int64, mDEvaluationCriteriaEntity.EvaluationCriteriaCategoryID); Database.AddInParameter(cmd, "@SupervisorTypeID", DbType.Int64, mDEvaluationCriteriaEntity.SupervisorTypeID); Database.AddInParameter(cmd, "@EvaluationSessionCategoryID", DbType.Int64, mDEvaluationCriteriaEntity.EvaluationSessionCategoryID); Database.AddInParameter(cmd, "@Question", DbType.String, mDEvaluationCriteriaEntity.Question); Database.AddInParameter(cmd, "@Description", DbType.String, mDEvaluationCriteriaEntity.Description); Database.AddInParameter(cmd, "@CorrectAnswerIfAny", DbType.String, mDEvaluationCriteriaEntity.CorrectAnswerIfAny); Database.AddInParameter(cmd, "@CorrectAnswerMarkOrPoint", DbType.Int32, mDEvaluationCriteriaEntity.CorrectAnswerMarkOrPoint); Database.AddInParameter(cmd, "@ImageUrl", DbType.String, mDEvaluationCriteriaEntity.ImageUrl); Database.AddInParameter(cmd, "@QuestionOrderInDisplay", DbType.Int32, mDEvaluationCriteriaEntity.QuestionOrderInDisplay); Database.AddInParameter(cmd, "@SupervisorWillAnswer", DbType.Boolean, mDEvaluationCriteriaEntity.SupervisorWillAnswer); Database.AddInParameter(cmd, "@IsRemoved", DbType.Boolean, mDEvaluationCriteriaEntity.IsRemoved); Database.AddInParameter(cmd, "@CreatedByEmployeeID", DbType.Int64, mDEvaluationCriteriaEntity.CreatedByEmployeeID); Database.AddInParameter(cmd, "@CreateDate", DbType.DateTime, mDEvaluationCriteriaEntity.CreateDate); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("MDEvaluationCriteriaEntity already exists. Please specify another MDEvaluationCriteriaEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("MDEvaluationCriteriaEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("MDEvaluationCriteriaEntity already exists. Please specify another MDEvaluationCriteriaEntity."); } } } } return(returnCode); }
protected void lvMDEvaluationCriteria_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 EvaluationCriteriaID; Int64.TryParse(e.CommandArgument.ToString(), out EvaluationCriteriaID); if (EvaluationCriteriaID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _EvaluationCriteriaID = EvaluationCriteriaID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(MDEvaluationCriteriaEntity.FLD_NAME_EvaluationCriteriaID, EvaluationCriteriaID.ToString(), SQLMatchType.Equal); MDEvaluationCriteriaEntity mDEvaluationCriteriaEntity = new MDEvaluationCriteriaEntity(); result = FCCMDEvaluationCriteria.GetFacadeCreate().Delete(mDEvaluationCriteriaEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _EvaluationCriteriaID = 0; _MDEvaluationCriteriaEntity = new MDEvaluationCriteriaEntity(); PrepareInitialView(); BindMDEvaluationCriteriaList(); MiscUtil.ShowMessage(lblMessage, "Evaluation Criteria has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Evaluation Criteria.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private Int64 DeleteTran(MDEvaluationCriteriaEntity mDEvaluationCriteriaEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.MDEvaluationCriteria_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(MDEvaluationCriteriaEntity mDEvaluationCriteriaEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.MDEvaluationCriteria_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("MDEvaluationCriteriaEntity already exists. Please specify another MDEvaluationCriteriaEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("MDEvaluationCriteriaEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("MDEvaluationCriteriaEntity already exists. Please specify another MDEvaluationCriteriaEntity."); } } } } return(returnCode); }
private Int64 UpdateTran(MDEvaluationCriteriaEntity mDEvaluationCriteriaEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.MDEvaluationCriteria_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, "@EvaluationCriteriaID", DbType.Int64, mDEvaluationCriteriaEntity.EvaluationCriteriaID); db.AddInParameter(cmd, "@EvaluationCriteriaCategoryID", DbType.Int64, mDEvaluationCriteriaEntity.EvaluationCriteriaCategoryID); db.AddInParameter(cmd, "@SupervisorTypeID", DbType.Int64, mDEvaluationCriteriaEntity.SupervisorTypeID); db.AddInParameter(cmd, "@EvaluationSessionCategoryID", DbType.Int64, mDEvaluationCriteriaEntity.EvaluationSessionCategoryID); db.AddInParameter(cmd, "@Question", DbType.String, mDEvaluationCriteriaEntity.Question); db.AddInParameter(cmd, "@Description", DbType.String, mDEvaluationCriteriaEntity.Description); db.AddInParameter(cmd, "@CorrectAnswerIfAny", DbType.String, mDEvaluationCriteriaEntity.CorrectAnswerIfAny); db.AddInParameter(cmd, "@CorrectAnswerMarkOrPoint", DbType.Int32, mDEvaluationCriteriaEntity.CorrectAnswerMarkOrPoint); db.AddInParameter(cmd, "@ImageUrl", DbType.String, mDEvaluationCriteriaEntity.ImageUrl); db.AddInParameter(cmd, "@QuestionOrderInDisplay", DbType.Int32, mDEvaluationCriteriaEntity.QuestionOrderInDisplay); db.AddInParameter(cmd, "@SupervisorWillAnswer", DbType.Boolean, mDEvaluationCriteriaEntity.SupervisorWillAnswer); db.AddInParameter(cmd, "@IsRemoved", DbType.Boolean, mDEvaluationCriteriaEntity.IsRemoved); db.AddInParameter(cmd, "@CreatedByEmployeeID", DbType.Int64, mDEvaluationCriteriaEntity.CreatedByEmployeeID); db.AddInParameter(cmd, "@CreateDate", DbType.DateTime, mDEvaluationCriteriaEntity.CreateDate); 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); }
protected void btnAddNew_Click(object sender, EventArgs e) { _EvaluationCriteriaID = 0; _MDEvaluationCriteriaEntity = new MDEvaluationCriteriaEntity(); PrepareInitialView(); }
private MDEvaluationCriteriaEntity BuildMDEvaluationCriteriaEntity() { MDEvaluationCriteriaEntity mDEvaluationCriteriaEntity = CurrentMDEvaluationCriteriaEntity; if (ddlEvaluationCriteriaCategoryID.Items.Count > 0) { if (ddlEvaluationCriteriaCategoryID.SelectedValue == "0") { } else { mDEvaluationCriteriaEntity.EvaluationCriteriaCategoryID = Int64.Parse(ddlEvaluationCriteriaCategoryID.SelectedValue); } } if (ddlSupervisorTypeID.Items.Count > 0) { if (ddlSupervisorTypeID.SelectedValue == "0") { } else { mDEvaluationCriteriaEntity.SupervisorTypeID = Int64.Parse(ddlSupervisorTypeID.SelectedValue); } } if (ddlEvaluationSessionCategoryID.Items.Count > 0) { if (ddlEvaluationSessionCategoryID.SelectedValue == "0") { } else { mDEvaluationCriteriaEntity.EvaluationSessionCategoryID = Int64.Parse(ddlEvaluationSessionCategoryID.SelectedValue); } } mDEvaluationCriteriaEntity.Question = txtQuestion.Text.Trim(); mDEvaluationCriteriaEntity.Description = txtDescription.Text.Trim(); mDEvaluationCriteriaEntity.CorrectAnswerIfAny = txtCorrectAnswerIfAny.Text.Trim(); if (!txtCorrectAnswerMarkOrPoint.Text.Trim().IsNullOrEmpty()) { mDEvaluationCriteriaEntity.CorrectAnswerMarkOrPoint = Int32.Parse(txtCorrectAnswerMarkOrPoint.Text.Trim()); } else { mDEvaluationCriteriaEntity.CorrectAnswerMarkOrPoint = null; } String HoverImageUrlpath; if (fuImageUrl.HasFile == true && mDEvaluationCriteriaEntity.ImageUrl.IsNotNullOrEmpty()) { if (File.Exists(Server.MapPath(mDEvaluationCriteriaEntity.ImageUrl))) { File.Delete(Server.MapPath(mDEvaluationCriteriaEntity.ImageUrl)); } HoverImageUrlpath = FileUploadConstants.HR.HREvaluation + Guid.NewGuid() + fuImageUrl.FileName; fuImageUrl.SaveAs(Server.MapPath(HoverImageUrlpath)); mDEvaluationCriteriaEntity.ImageUrl = HoverImageUrlpath; } if (mDEvaluationCriteriaEntity.ImageUrl.IsNotNullOrEmpty() && fuImageUrl.HasFile == false) { mDEvaluationCriteriaEntity.ImageUrl = mDEvaluationCriteriaEntity.ImageUrl; } if (fuImageUrl.HasFile == false && mDEvaluationCriteriaEntity.ImageUrl.IsNullOrEmpty()) { mDEvaluationCriteriaEntity.ImageUrl = null; } if (fuImageUrl.HasFile == true && mDEvaluationCriteriaEntity.ImageUrl.IsNullOrEmpty()) { HoverImageUrlpath = FileUploadConstants.DashboardItem.DashboardItemHoverImageUrl + Guid.NewGuid() + fuImageUrl.FileName; fuImageUrl.SaveAs(Server.MapPath(HoverImageUrlpath)); mDEvaluationCriteriaEntity.ImageUrl = HoverImageUrlpath; } if (!txtQuestionOrderInDisplay.Text.Trim().IsNullOrEmpty()) { mDEvaluationCriteriaEntity.QuestionOrderInDisplay = Int32.Parse(txtQuestionOrderInDisplay.Text.Trim()); } else { mDEvaluationCriteriaEntity.QuestionOrderInDisplay = null; } mDEvaluationCriteriaEntity.SupervisorWillAnswer = chkSupervisorWillAnswer.Checked; mDEvaluationCriteriaEntity.IsRemoved = chkIsRemoved.Checked; mDEvaluationCriteriaEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); mDEvaluationCriteriaEntity.CreateDate = System.DateTime.Now; return(mDEvaluationCriteriaEntity); }
Int64 IMDEvaluationCriteriaFacade.Delete(MDEvaluationCriteriaEntity mDEvaluationCriteriaEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateMDEvaluationCriteriaDataAccess().Delete(mDEvaluationCriteriaEntity, filterExpression, option, reqTran)); }
Int64 IMDEvaluationCriteriaFacade.Add(MDEvaluationCriteriaEntity mDEvaluationCriteriaEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateMDEvaluationCriteriaDataAccess().Add(mDEvaluationCriteriaEntity, option, reqTran)); }