private void FrmInput_InputDataReady(object sender, InputDataReadyEventArgs e)
{
string searchTerm = e.SearchString;
List <LabRequestModel> models = GlobalConfig.Connection.SearchLabRequests(searchTerm.ToUpper());
this.Show();
switch (models.Count)
{
case 0:
MessageBox.Show("No matching records found.");
break;
case 1:
LabRequestModel model = models[0];;
loadBoxes(model);
cboMSO.Focus();
displayAttachments();
break;
default:
frmMultiSelect displayForm = new frmMultiSelect();
displayForm.LabRequests = models;
displayForm.Show();
break;
}
}
private void loadBoxes(LabRequestModel model)
{
txtDescription.Text = model.Description;
txtRemarks.Text = model.Remarks;
txtRequestID.Text = model.LRID;
dtpEnd.Value = model.EndDate;
dtpStart.Value = model.StartDate;
cboMSO.Text = model.MSO;
cboProduct.Text = model.Product;
txtID.Text = model.ID.ToString();
}
private LabRequestModel loadModel()
{
LabRequestModel model = new LabRequestModel();
int id = 0;
int.TryParse(txtID.Text, out id);
model.ID = id;
model.Description = txtDescription.Text;
model.EndDate = dtpEnd.Value;
model.LRID = txtRequestID.Text;
model.MSO = cboMSO.Text;
model.Product = cboProduct.Text;
model.Remarks = txtRemarks.Text;
model.StartDate = dtpStart.Value;
return(model);
}
public void LabRequests_CRUD(LabRequestModel model, char action)
{
using (IDbConnection connection = new SqlConnection(GlobalConfig.ConnString(db)))
{
var p = new DynamicParameters();
p.Add("@Action", action, DbType.String);
p.Add("@ID", model.ID, DbType.Int32);
p.Add("@LRID", model.LRID, DbType.String);
p.Add("@MSO", model.MSO, DbType.String);
p.Add("@Product", model.Product, DbType.String);
p.Add("@StartDate", model.StartDate, DbType.DateTime);
p.Add("@EndDate", model.EndDate, DbType.DateTime);
p.Add("@Description", model.Description, DbType.String);
p.Add("@Remarks", model.Remarks, DbType.String);
connection.Execute("dbo.spLabRequest_CRUD", p,
commandType: CommandType.StoredProcedure);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
LabRequestModel model = loadModel();
switch (GV.MODE)
{
case Mode.LabRequestAdd:
GlobalConfig.Connection.LabRequests_CRUD(model, 'C');
MessageBox.Show(model.LRID + " saved.");
break;
case Mode.LabRequestEdit:
GlobalConfig.Connection.LabRequests_CRUD(model, 'U');
MessageBox.Show(model.LRID + " saved.");
break;
case Mode.LabRequestDelete:
GlobalConfig.Connection.LabRequests_CRUD(model, 'D');
break;
default:
break;
}
}
private void dgvResults_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
int selectedRow = dgvResults.CurrentRow.Index;
CustomerModel customer;
switch (GV.MODE)
{
case Mode.New:
break;
case Mode.Edit:
case Mode.DateRangeReport:
AssignmentDisplayModel assignment = displayList[selectedRow];
GV.ASSIGNMENTFORM.Assignment = retrieveList[selectedRow];
GV.ASSIGNMENTFORM.BringToFront();
break;
case Mode.Undo:
break;
case Mode.CustomerSearch:
customer = customerData[selectedRow];
GV.ASSIGNMENTFORM.FillCustomerData(customer);
GV.MODE = GV.PreviousMode;
this.Close();
break;
case Mode.CustomerSearchMDI:
customer = customerData[selectedRow];
CallingForm.FillBoxes(customer);
this.Close();
break;
// added this LD not sure....
case Mode.DeleteCustomer:
customer = customerData[selectedRow];
CallingForm.FillBoxes(customer);
this.Close();
break;
case Mode.LocationSearch:
LocationModel location = locationData[selectedRow];
GV.ASSIGNMENTFORM.FillLocationData(location);
GV.MODE = GV.PreviousMode;
this.Close();
break;
case Mode.SearchEscalation:
ATEscalationsDisplayModel escalation = escalations[selectedRow];
GV.ESCALATIONFORM.loadBoxes(escalation);
GV.MODE = Mode.EditEscalation;
break;
case Mode.LabRequestEdit:
LabRequestModel labRequest = labRequests[selectedRow];
GV.LABREQUESTFORM.LabRequest = labRequest;
break;
case Mode.None:
break;
default:
break;
}
//GV.MAINMENU.BringToFront();
this.Close();
}
