private Boolean CheckCreateMSRFields(Domain.ApproverInfo approverInfo) { Boolean checkFieldFlag = false; if (budgetYear_createTab_comboBox.SelectedIndex == -1) { MessageBox.Show("Please select a budget year."); checkFieldFlag = false; } else if (budgetPool_createTab_comboBox.SelectedIndex == -1) { MessageBox.Show("Please select a budget pool."); checkFieldFlag = false; } else if (originator_createTab_comboBox.SelectedIndex == -1) { MessageBox.Show("Please select an originator."); checkFieldFlag = false; } else if (createTab_dataGridView.Rows.Count == 0) { MessageBox.Show("Please add an item."); checkFieldFlag = false; } else if (approval_createTab_comboBox.SelectedIndex == -1) { MessageBox.Show("Please select an approver."); checkFieldFlag = false; } else if (BusinessAPI.BusinessSingleton.Instance.userInfo_EF.UserId == Int32.Parse(approverInfo.UserId)) { MessageBox.Show("You can not approve yourself. Please select a different approver."); checkFieldFlag = false; } // Checking if all item's fields are correct else if (UserInterfaceAPI.UserInterfaceSIngleton.Instance.CheckMSRFormItemsDGV(createTab_dataGridView, budgetPool_createTab_comboBox.Text, approverInfo.UserId) == false) { checkFieldFlag = false; } else { checkFieldFlag = true; } return(checkFieldFlag); }
public void InsertIntialMSR(Domain.ApproverInfo approverInfo, String project, String vwl, String comments, String budgetYear, String bpNo, String afe, String sugVendor, String contactVendor, DateTime reqDate) { using (var context = new MSR_MaxEntities()) { //Log DB commands to console context.Database.Log = Console.WriteLine; //First obtain referenced users var usr_RO = context.Usrs.Find(BusinessAPI.BusinessSingleton.Instance.userInfo_EF.UserId); var usr_CA = context.Usrs.Find(Int32.Parse(approverInfo.UserId)); //Initialize new MSR var tempMSR = new MSR { Project = project, WVL = vwl, Comments = comments, BudgetYear = Int32.Parse(budgetYear), BP_No = bpNo, AFE = afe, SugVendor = sugVendor, ContactVendor = contactVendor, Usr_RO = usr_RO, Usr_CA = usr_CA, Req_Date = reqDate, PUR_Comment = "", Decline_Comment = "", Review_Comment = "", StateFlag = Domain.WorkFlowTrace.WAIT_FOR_APPROVAL }; //Adds the newly created MSR context.MSRs.Add(tempMSR); context.SaveChanges(); //Gets the just inserted MSR int MSRId = tempMSR.MSRId; //Attaches the FormItems to that MSR just created InsertInitialFormItems(BusinessAPI.BusinessSingleton.Instance.formItemListCreateMSR, MSRId); } }
public Domain.ApproverInfo GetApproverInfoByUsername(String username) { Domain.ApproverInfo approverInfo = null; using (var context = new MSR_MaxEntities()) { Usr usr_db = context.Usrs.SingleOrDefault(u => u.Username.Equals(username)); Domain.ApproverInfo approverInfoTemp = new Domain.ApproverInfo { UserId = usr_db.UserId.ToString(), Username = usr_db.Username, FullName = usr_db.FullName, Email = usr_db.Email, DeptId = usr_db.DeptId.ToString() }; approverInfo = approverInfoTemp; } return(approverInfo); }
private void Save_createTab_button_Click(object sender, EventArgs e) { //Inital Variables: //Obtain approver info of selected Domain.ApproverInfo approverInfo = (Domain.ApproverInfo)approval_createTab_comboBox.SelectedItem; //Validation: //Unselect DataGridView createTab_dataGridView.ClearSelection(); //Checking all required fields if (CheckCreateMSRFields(approverInfo) == false) { return; } //To confirm if you want to Submit MSR DialogResult result = MessageBox.Show("Are you sure you want to submit the MSR?", "Confirmation", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { //MessageBox.Show("Selected YES."); //... } else if (result == DialogResult.No) { //MessageBox.Show("Selected NO."); return; } else { //MessageBox.Show("Selected NO."); return; } //EF Workflow //Creates MSR with Associated FormItems BusinessAPI.BusinessSingleton.Instance.MSRInfoAPI.InsertIntialMSR( approverInfo, project_createTab_textBox.Text, wellVL_createTab_textBox.Text, comments_createTab_textBox.Text, budgetYear_createTab_comboBox.Text, budgetPool_createTab_comboBox.Text, AFE_createTab_textBox.Text, suggVendor_createTab_textBox.Text, vendorContact_createTab_textBox.Text, changeDate_createTab_dateTimePicker.Value ); //Clears the Business formItemList_CreateMSR BusinessAPI.BusinessSingleton.Instance.formItemListCreateMSR.Clear(); //Refresh all the DataGridViews RefreshDataGridViews(); //Clear all fields of Create Tab clearAllFields_createTab_button.PerformClick(); }