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();
}
