private Arthur.PurchaseEntryDL.TransactionResult DeleteLoginUser(Microsoft.Practices.EnterpriseLibrary.Data.Database db, System.Data.Common.DbTransaction transaction) { Arthur.PurchaseEntryDL.TransactionResult transactionResult; int i = 0; System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("spDeleteLoginUser"); db.AddInParameter(dbCommand, "LoginID", System.Data.DbType.Int32, this._loginId); db.AddParameter(dbCommand, "Return Value", System.Data.DbType.Int32, System.Data.ParameterDirection.ReturnValue, "Return Value", System.Data.DataRowVersion.Default, i); db.ExecuteNonQuery(dbCommand, transaction); i = (int)db.GetParameterValue(dbCommand, "Return Value"); transactionResult = i == -1 ? new Arthur.PurchaseEntryDL.TransactionResult(Arthur.PurchaseEntryDL.TransactionStatus.Failure, "Failure Deleted") : new Arthur.PurchaseEntryDL.TransactionResult(Arthur.PurchaseEntryDL.TransactionStatus.Success, "Successfully Deleted"); return transactionResult; }
private Arthur.PurchaseEntryDL.TransactionResult AddEditLoginUser(Microsoft.Practices.EnterpriseLibrary.Data.Database db, System.Data.Common.DbTransaction transaction) { int i; Arthur.PurchaseEntryDL.TransactionResult transactionResult; bool bl; i = 0; System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("spAddEditLoginUser"); db.AddInParameter(dbCommand, "LoginID", System.Data.DbType.Int32, this._loginId); db.AddInParameter(dbCommand, "CompanyID", System.Data.DbType.Int32, this._companyId); db.AddInParameter(dbCommand, "UserName", System.Data.DbType.String, this._userName); db.AddInParameter(dbCommand, "Password", System.Data.DbType.String, this._password); db.AddInParameter(dbCommand, "RoleID", System.Data.DbType.String, this._roleId); db.AddInParameter(dbCommand, "LoginAccess", System.Data.DbType.Boolean, this._loginAccess); db.AddInParameter(dbCommand, "AddEditOption", System.Data.DbType.Int16, this._addEditOption); db.AddParameter(dbCommand, "Return Value", System.Data.DbType.Int32, System.Data.ParameterDirection.ReturnValue, "Return Value", System.Data.DataRowVersion.Default, i); db.ExecuteNonQuery(dbCommand, transaction); this._loginId = (int)db.GetParameterValue(dbCommand, "Return Value"); bl = i != 0; if (!bl) { transactionResult = new Arthur.PurchaseEntryDL.TransactionResult(Arthur.PurchaseEntryDL.TransactionStatus.Failure, "User Name Already Exists. Please Change Some Other Name"); } else { bl = i != -1; if (!bl) { bl = this._addEditOption != 1; if (!bl) { return new Arthur.PurchaseEntryDL.TransactionResult(Arthur.PurchaseEntryDL.TransactionStatus.Failure, "Failure Updated"); } transactionResult = new Arthur.PurchaseEntryDL.TransactionResult(Arthur.PurchaseEntryDL.TransactionStatus.Failure, "Failure Adding"); } else { bl = this._addEditOption != 1; transactionResult = !bl ? new Arthur.PurchaseEntryDL.TransactionResult(Arthur.PurchaseEntryDL.TransactionStatus.Success, "Successfully Updated") : new Arthur.PurchaseEntryDL.TransactionResult(Arthur.PurchaseEntryDL.TransactionStatus.Success, "Successfully Added"); } } return transactionResult; }