public void AccesstoUIFunctinality() { ConfigurationButton.Enabled = false; QualityControlButton.Enabled = false; ExportButton.Enabled = false; StatusChangeButton.Enabled = false; VFRSearchButton.Enabled = false; BatchRegistrationButton.Enabled = false; // Get User Information to control Accesst to Functionality if (Environment.UserName.ToUpper() == "ADMINISTRATOR") { ConfigurationButton.Enabled = true; QualityControlButton.Enabled = true; ExportButton.Enabled = true; StatusChangeButton.Enabled = true; VFRSearchButton.Enabled = true; BatchRegistrationButton.Enabled = true; } else { ResultUsers resultUsers = new ResultUsers(); List <User> users = new List <User>(); resultUsers = DBTransactions.GetUserByName(Environment.UserName); users = resultUsers.ReturnValue; foreach (UIFunctionality functionality in users[0].UIFunctionality) { switch (functionality.Description) { case "System Configuration": ConfigurationButton.Enabled = true; break; case "Quality Control": QualityControlButton.Enabled = true; break; case "Export": ExportButton.Enabled = true; break; case "Batch Administration": StatusChangeButton.Enabled = true; break; case "VFR Search": VFRSearchButton.Enabled = true; break; case "Batch Registration": BatchRegistrationButton.Enabled = true; break; } } } }
public ResultUsers LoginUser(User inUser) { // 3. send the input down to the database and check username/password // 3.d create a user operations dal object UserOperationsDAL _userOperationsDAL = new UserOperationsDAL(this._connection); // 3.e need a method that takes a User object and return a Result object ResultUsers _result = _userOperationsDAL.LoginUserToDatabase(inUser); // 3.f return the Result return(_result); }
/// <summary> /// 获取用户列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public ResultUsers GetUserList(QueryUserContact query) { ExecuteResult resultInfo = new ExecuteResult(); try { ResultUsers resultUsers = new ResultUsers(); resultUsers.Page = new Padding(); resultUsers.UserList = new List <User>(); var result = userOperator.GetUserList(" order by id desc"); if (result.Count > 0) { resultUsers.Page.Current = query.PageCurrent; resultUsers.Page.Total = result.Count; resultUsers.UserList = result.Select(p => new Model.User { GroupId = p.GroupId, GroupName = userOperator.GetUserGroupName(int.Parse(p.GroupId)), Id = p.Id, PassWord = p.PassWord, Status = p.Status, UserName = p.Name }).Skip((query.PageCurrent - 1) * query.PageSize).Take(query.PageSize).ToList(); resultInfo.Success = true; resultInfo.ExceptionMsg = string.Empty; resultUsers.ResultInfo = resultInfo; return(resultUsers); } else { resultInfo.Success = false; resultInfo.ExceptionMsg = "暂无数据!"; return(new ResultUsers { ResultInfo = resultInfo }); } } catch (Exception ex) { resultInfo.Success = false; resultInfo.ExceptionMsg = ex.Message; return(new ResultUsers { ResultInfo = resultInfo }); } }
private void FormLoad() { UserNameTextBox.Text = ""; UserEmailTextBox.Text = ""; ActiveCheckBox.Checked = false; UserTitleTextBox.Text = ""; UsersListView.Items.Clear(); AvaliableFunctionalityListView.Items.Clear(); ResultUIFunctionalities uiFunctionalities = new ResultUIFunctionalities(); uiFunctionalities = DBTransactions.GetUIFunctionalities(); foreach (UIFunctionality uiFunctionality in uiFunctionalities.ReturnValue) { ListViewItem item = new ListViewItem(new string[] { "", Convert.ToString(uiFunctionality.FunctionalityID), uiFunctionality.Description }); item.Tag = uiFunctionality.FunctionalityID; AvaliableFunctionalityListView.Items.Add(item); } AvaliableFunctionalityListView.Columns[1].Width = 0; // Load User List View ResultUsers resultUsers = new ResultUsers(); List <User> users = new List <User>(); resultUsers = DBTransactions.GetUsers(); users = resultUsers.ReturnValue; string functionalities = ""; foreach (User user in users) { if (user.UIFunctionality.Count > 0) { List <int> functionalityList = new List <int>(); foreach (UIFunctionality functionality in user.UIFunctionality) { functionalityList.Add(functionality.FunctionalityID); } functionalities = String.Join(", ", functionalityList.ToArray()); } else { functionalities = ""; } ListViewItem item = new ListViewItem(new string[] { Convert.ToString(user.UserID), Convert.ToString(user.ActiveFlag), user.UserName, user.Title, user.Email, functionalities }); UsersListView.Items.Add(item); } }
private void ApplyButton_Click(object sender, EventArgs e) { ResultBatches resultBatches = new ResultBatches(); ResultGeneric resultGeneric = new ResultGeneric(); string originalBatchStatus = ""; Batch batch = new Batch(); DialogResult result = DialogResult.No; string action = ""; DateTime currentDate = DateTime.Now; ResultUsers resultUsers = new ResultUsers(); List <User> users = new List <User>(); Boolean allowDeletion = false; Boolean allowRecall = false; Boolean allowRejection = false; try { // Get User Information to control Accesst to Functionality resultUsers = DBTransactions.GetUserByName(Environment.UserName); users = resultUsers.ReturnValue; foreach (UIFunctionality functionality in users[0].UIFunctionality) { switch (functionality.Description) { case "Batch Rejection": allowRejection = true; break; case "Batch Recall": allowRecall = true; break; case "Batch Removal": allowDeletion = true; break; } } nlogger.Trace(" QC Transaction (Apply Action) for Batch: " + BatchNameTextBox.Text); resultBatches = DBTransactions.GetBatchesInformation("BatchNumber = \"" + BatchNameTextBox.Text + "\"", ""); // OR BatchAlias = \"" + BatchNumber.Text + "\"", ""); batch = resultBatches.ReturnValue[0]; originalBatchStatus = batch.StatusFlag; if (RejectedRadioButton.Checked) { action = "Rejected"; } if (RecallRadioButton.Checked) { action = "Recall"; } if (DeleteRadioButton.Checked) { action = "Delete"; } switch (action) { case "Rejected": if (allowRejection) { result = MessageBox.Show(this, "Do you want to Reject this Batch : " + BatchNameTextBox.Text + " ?", "Confirmation...", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { batch.RejectedBy = OperatorTextBox.Text; batch.RejectionReason = RejectCommentsTextBox.Text; batch.LastTimeRejected = currentDate; batch.RejectedTimes = batch.RejectedTimes + 1; batch.StatusFlag = "Rejected"; // Update Batch Information nlogger.Trace(" Updating Batch information in Database ..."); resultGeneric = DBTransactions.BatchUpdate(batch); if (resultGeneric.ReturnCode == 0) { // Batch Event Tracking nlogger.Trace(" Adding transaction in Tracking Database Table ..."); DBTransactions.BatchTrackingEvent(batch.BatchNumber, originalBatchStatus, "Rejected", "Batch Rejected", OperatorTextBox.Text); } } } else { result = MessageBox.Show(this, "You are not auhorized to perform this operation.", "Information ...", MessageBoxButtons.OK, MessageBoxIcon.Hand); } break; case "Recall": if (allowRecall) { result = MessageBox.Show(this, "Do you want to request a Recall this Batch : " + BatchNameTextBox.Text + " ?", "Confirmation...", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { batch.RecallBy = OperatorTextBox.Text; batch.RecallReason = RecallCommentsTextBox.Text; batch.RecallDate = currentDate; batch.RecallTimes = batch.RecallTimes + 1; batch.StatusFlag = "Recall"; // Update Batch Information nlogger.Trace(" Updating Batch information in Database ..."); resultGeneric = DBTransactions.BatchUpdate(batch); if (resultGeneric.ReturnCode == 0) { // Batch Event Tracking nlogger.Trace(" Adding transaction in Tracking Database Table ..."); DBTransactions.BatchTrackingEvent(batch.BatchNumber, originalBatchStatus, "Recall", "Batch tagged for Recall", OperatorTextBox.Text); } } } else { result = MessageBox.Show(this, "You are not auhorized to perform this operation.", "Information ...", MessageBoxButtons.OK, MessageBoxIcon.Hand); } break; case "Delete": if (allowDeletion) { result = MessageBox.Show(this, "Do you want to Delete this Batch : " + BatchNameTextBox.Text + " ?", "Confirmation...", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { // Tag Batch for deletion batch.StatusFlag = "Waiting for Deletion"; // Update Batch Information nlogger.Trace(" Updating Batch information in Database ..."); resultGeneric = DBTransactions.BatchUpdate(batch); if (resultGeneric.ReturnCode == 0) { // Batch Event Tracking nlogger.Trace(" Adding transaction in Tracking Database Table ..."); DBTransactions.BatchTrackingEvent(batch.BatchNumber, originalBatchStatus, "Waiting for Deletion", "Batch tagged for Deletion", OperatorTextBox.Text); } MessageBox.Show(this, "This operation is under Construction", "Alert...", MessageBoxButtons.YesNo, MessageBoxIcon.Hand); } } else { result = MessageBox.Show(this, "You are not auhorized to perform this operation.", "Information ...", MessageBoxButtons.OK, MessageBoxIcon.Hand); } break; } ResetValues(); DisableButtons(); DisableOptions(); ExitButton.Enabled = true; } catch (Exception ex) { General.ErrorMessage(ex); } }