Int64 IDMSFileMovementRegisterDataAccess.Add(DMSFileMovementRegisterEntity dMSFileMovementRegisterEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(dMSFileMovementRegisterEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(dMSFileMovementRegisterEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private Int64 UpdateTran(DMSFileMovementRegisterEntity dMSFileMovementRegisterEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.DMSFileMovementRegister_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, "@FileMovementRegisterID", DbType.Int64, dMSFileMovementRegisterEntity.FileMovementRegisterID); db.AddInParameter(cmd, "@FileTrackingID", DbType.Int64, dMSFileMovementRegisterEntity.FileTrackingID); db.AddInParameter(cmd, "@GivenToEmployeeID", DbType.Int64, dMSFileMovementRegisterEntity.GivenToEmployeeID); db.AddInParameter(cmd, "@GivenByEmployeeID", DbType.Int64, dMSFileMovementRegisterEntity.GivenByEmployeeID); db.AddInParameter(cmd, "@MovementDateTime", DbType.DateTime, dMSFileMovementRegisterEntity.MovementDateTime); db.AddInParameter(cmd, "@FileMovementPlace", DbType.String, dMSFileMovementRegisterEntity.FileMovementPlace); 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 lvDMSFileMovementRegister_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 FileMovementRegisterID; Int64.TryParse(e.CommandArgument.ToString(), out FileMovementRegisterID); if (FileMovementRegisterID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _FileMovementRegisterID = FileMovementRegisterID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(DMSFileMovementRegisterEntity.FLD_NAME_FileMovementRegisterID, FileMovementRegisterID.ToString(), SQLMatchType.Equal); DMSFileMovementRegisterEntity dMSFileMovementRegisterEntity = new DMSFileMovementRegisterEntity(); result = FCCDMSFileMovementRegister.GetFacadeCreate().Delete(dMSFileMovementRegisterEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _FileMovementRegisterID = 0; _DMSFileMovementRegisterEntity = new DMSFileMovementRegisterEntity(); PrepareInitialView(); BindDMSFileMovementRegisterList(); MiscUtil.ShowMessage(lblMessage, "D MSFile Movement Register has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete D MSFile Movement Register.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private Int64 Update(DMSFileMovementRegisterEntity dMSFileMovementRegisterEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.DMSFileMovementRegister_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@FileMovementRegisterID", DbType.Int64, dMSFileMovementRegisterEntity.FileMovementRegisterID); Database.AddInParameter(cmd, "@FileTrackingID", DbType.Int64, dMSFileMovementRegisterEntity.FileTrackingID); Database.AddInParameter(cmd, "@GivenToEmployeeID", DbType.Int64, dMSFileMovementRegisterEntity.GivenToEmployeeID); Database.AddInParameter(cmd, "@GivenByEmployeeID", DbType.Int64, dMSFileMovementRegisterEntity.GivenByEmployeeID); Database.AddInParameter(cmd, "@MovementDateTime", DbType.DateTime, dMSFileMovementRegisterEntity.MovementDateTime); Database.AddInParameter(cmd, "@FileMovementPlace", DbType.String, dMSFileMovementRegisterEntity.FileMovementPlace); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("DMSFileMovementRegisterEntity already exists. Please specify another DMSFileMovementRegisterEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("DMSFileMovementRegisterEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("DMSFileMovementRegisterEntity already exists. Please specify another DMSFileMovementRegisterEntity."); } } } } return(returnCode); }
private DMSFileMovementRegisterEntity BuildDMSFileMovementRegisterEntity() { DMSFileMovementRegisterEntity dMSFileMovementRegisterEntity = CurrentDMSFileMovementRegisterEntity; if (ddlFileTrackingID.Items.Count > 0) { if (ddlFileTrackingID.SelectedValue == "0") { } else { dMSFileMovementRegisterEntity.FileTrackingID = Int64.Parse(ddlFileTrackingID.SelectedValue); } } if (ddlGivenToEmployeeID.Items.Count > 0) { if (ddlGivenToEmployeeID.SelectedValue == "0") { } else { dMSFileMovementRegisterEntity.GivenToEmployeeID = Int64.Parse(ddlGivenToEmployeeID.SelectedValue); } } String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEntity.FLD_NAME_MemberID, this.CurrentMember.MemberID.ToString(), SQLMatchType.Equal); IList <HREmployeeEntity> lstEmployee = FCCHREmployee.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (lstEmployee != null && lstEmployee.Count > 0) { dMSFileMovementRegisterEntity.GivenByEmployeeID = lstEmployee[0].EmployeeID; } if (txtMovementDateTime.Text.Trim().IsNotNullOrEmpty()) { dMSFileMovementRegisterEntity.MovementDateTime = MiscUtil.ParseToDateTime(txtMovementDateTime.Text); } dMSFileMovementRegisterEntity.FileMovementPlace = txtFileMovementPlace.Text.Trim(); return(dMSFileMovementRegisterEntity); }
private void PrepareEditView() { DMSFileMovementRegisterEntity dMSFileMovementRegisterEntity = CurrentDMSFileMovementRegisterEntity; if (!dMSFileMovementRegisterEntity.IsNew) { String fe = SqlExpressionBuilder.PrepareFilterExpression(DMSFileTrackingEntity.FLD_NAME_FileTrackingID, dMSFileMovementRegisterEntity.FileTrackingID.ToString(), SQLMatchType.Equal); IList <DMSFileTrackingEntity> dMSFileTrackingList = FCCDMSFileTracking.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (dMSFileTrackingList != null && dMSFileTrackingList.Count > 0) { if (ddlDepartmentID.Items.Count > 0) { ddlDepartmentID.SelectedValue = dMSFileTrackingList[0].DepartmentID.ToString(); } } BindDropDownFileByDepartment(); if (ddlFileTrackingID.Items.Count > 0 && dMSFileMovementRegisterEntity.FileTrackingID != null) { ddlFileTrackingID.SelectedValue = dMSFileMovementRegisterEntity.FileTrackingID.ToString(); } if (ddlGivenToEmployeeID.Items.Count > 0 && dMSFileMovementRegisterEntity.GivenToEmployeeID != null) { ddlGivenToEmployeeID.SelectedValue = dMSFileMovementRegisterEntity.GivenToEmployeeID.ToString(); } txtMovementDateTime.Text = dMSFileMovementRegisterEntity.MovementDateTime.ToStringDefault(); txtFileMovementPlace.Text = dMSFileMovementRegisterEntity.FileMovementPlace.ToString(); btnSubmit.Text = "Update"; btnAddNew.Visible = true; } }
protected void btnAddNew_Click(object sender, EventArgs e) { _FileMovementRegisterID = 0; _DMSFileMovementRegisterEntity = new DMSFileMovementRegisterEntity(); PrepareInitialView(); }
private void SaveDMSFileMovementRegisterEntity() { if (IsValid) { try { DMSFileMovementRegisterEntity dMSFileMovementRegisterEntity = BuildDMSFileMovementRegisterEntity(); Int64 result = -1; if (dMSFileMovementRegisterEntity.IsNew) { result = FCCDMSFileMovementRegister.GetFacadeCreate().Add(dMSFileMovementRegisterEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(DMSFileMovementRegisterEntity.FLD_NAME_FileMovementRegisterID, dMSFileMovementRegisterEntity.FileMovementRegisterID.ToString(), SQLMatchType.Equal); result = FCCDMSFileMovementRegister.GetFacadeCreate().Update(dMSFileMovementRegisterEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { #region Update File Current Location _FileMovementRegisterID = result; DMSFileMovementRegisterEntity _dMSFileMovementRegisterEntity = CurrentDMSFileMovementRegisterEntity; DMSFileTrackingEntity dMSFileTrackingEntity = FCCDMSFileTracking.GetFacadeCreate().GetByID(_dMSFileMovementRegisterEntity.FileTrackingID); dMSFileTrackingEntity.FileCurrentPlace = _dMSFileMovementRegisterEntity.FileMovementPlace; String fe = SqlExpressionBuilder.PrepareFilterExpression(DMSFileTrackingEntity.FLD_NAME_FileTrackingID, _dMSFileMovementRegisterEntity.FileTrackingID.ToString(), SQLMatchType.Equal); result = FCCDMSFileTracking.GetFacadeCreate().Update(dMSFileTrackingEntity, fe, DatabaseOperationType.Update, TransactionRequired.No); #endregion _FileMovementRegisterID = 0; _DMSFileMovementRegisterEntity = new DMSFileMovementRegisterEntity(); PrepareInitialView(); BindDMSFileMovementRegisterList(); if (dMSFileMovementRegisterEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "File Movement Register Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "File Movement Register Information has been updated successfully.", false); } } else { if (dMSFileMovementRegisterEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add File Movement Register Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update File Movement Register Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
Int64 IDMSFileMovementRegisterFacade.Delete(DMSFileMovementRegisterEntity dMSFileMovementRegisterEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateDMSFileMovementRegisterDataAccess().Delete(dMSFileMovementRegisterEntity, filterExpression, option, reqTran)); }
Int64 IDMSFileMovementRegisterFacade.Add(DMSFileMovementRegisterEntity dMSFileMovementRegisterEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateDMSFileMovementRegisterDataAccess().Add(dMSFileMovementRegisterEntity, option, reqTran)); }