/// <summary>
/// Gets sequence number for escalationID and increments table
/// </summary>
/// <param name="mso"></param>
/// <returns></returns>
public static string GenerateEID(MSO_Model mso, string prefix, bool dataloading)
{
if (dataloading)
{
string sequence = "";
string eid = prefix;
string dateStamp = DateTime.Today.ToString("yyMMdd");
switch (prefix)
{
case "ESC_":
sequence = GlobalConfig.Connection.EIDSequence_Get("tblEIDSequence").ToString();
break;
case "LAB_":
sequence = GlobalConfig.Connection.EIDSequence_Get("tblSeqLabRequest").ToString();
break;
default:
break;
}
sequence = sequence.PadLeft(5, '0');
eid += mso.Abbreviation + "_" + dateStamp + "_" + sequence;
return(eid);
}
else
{
return("");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
MSO_Model MSO = (MSO_Model)cboMSOSelector.SelectedItem;
int MSO_ID = MSO.ID;
List <AssignmentTableModel> assignmentTableModels = GlobalConfig.Connection.GetItemByColumn <AssignmentTableModel>("tblAssignments", "MSO_ID", "", MSO_ID);
frmMultiSelect resultForm = new frmMultiSelect();
resultForm.AssignmentData = assignmentTableModels;
this.Close();
resultForm.Show();
}
public static string GeneratePID(MSO_Model mso)
{
string pid = "SR_";
string dateStamp = DateTime.Today.ToString("yyMMdd");
string sequence = GlobalConfig.Connection.Sequence_Get().ToString();
sequence = sequence.PadLeft(5, '0');
pid += mso.Abbreviation + "_" + dateStamp + "_" + sequence;
return(pid);
}
private void cbo_MSO_SelectedIndexChanged(object sender, EventArgs e)
{
if (!dataLoading)
{
MSO_Model model = ((MSO_Model)cbo_MSO.SelectedItem);
formDirty = true;
enableBoxes(true);
if (sender is ComboBox)
{
ComboBox ctl = (ComboBox)sender;
if (ctl.Name == "cbo_MSO")
{
txtEID.Text = PID_Generator.GenerateEID((MSO_Model)cbo_MSO.SelectedItem, "ESC_", dataLoading);
cbo_MSO.Enabled = false;
}
}
}
}
private List <FieldSearchModel> collectSearchTerms()
{
List <FieldSearchModel> list = new List <FieldSearchModel>();
FieldSearchModel model = new FieldSearchModel();
foreach (Control ctl in this.Controls)
{
string ctlname = ctl.Name;
string[] tagArray = null;
if (ctl.Tag != null)
{
tagArray = ctl.Tag.ToString().Split('|');
}
if (ctl.Text != "")
{
switch (ctl?.GetType().Name)
{
case "DateTimePicker":
DateTimePicker dtp = ctl as DateTimePicker;
FieldSearchModel fsm = new FieldSearchModel();
if (dtp.Format != DateTimePickerFormat.Custom)
{
fsm.FieldName = tagArray[1];
fsm.FieldValue = dtp.Text;
list.Add(fsm);
}
break;
case "TextBox":
case "RichTextBox":
fsm = new FieldSearchModel();
fsm.FieldName = tagArray[1];
fsm.FieldValue = ctl.Text;
list.Add(fsm);
break;
case "ListBox":
switch (ctl.Name)
{
case "lstFE":
ListBox listBox = ctl as ListBox;
foreach (FE_Model fe in listBox.SelectedItems)
{
fsm = new FieldSearchModel();
FE_Model fE_Model = fe as FE_Model;
fsm.FieldName = "FE_ListXML";
fsm.FieldValue = fE_Model.ID.ToString();
list.Add(fsm);
}
break;
case "lstTopics":
// ListBox listBoxTopics = ctl as ListBox;
// foreach (ProductModel prod in listBoxTopics.SelectedItems)
// {
// fsm = new FieldSearchModel();
// ProductModel productModel = prod as ProductModel;
// fsm.FieldName = "ProductListXML";
// fsm.FieldValue = prod.ID.ToString();
// list.Add(fsm);
break;
default:
break;
}
break;
case "ComboBox":
switch (ctl.Name)
{
case "cboMSO":
{
MSO_Model mso = cboMSO.SelectedItem as MSO_Model;
int mso_ID = mso.ID;
fsm = new FieldSearchModel();
fsm.FieldName = "MSO_ID";
fsm.FieldValue = mso_ID.ToString();
list.Add(fsm);
}
break;
case "cboActivity":
{
ActivityModel activity = cboActivity.SelectedItem as ActivityModel;
int activity_ID = activity.ID;
fsm = new FieldSearchModel();
fsm.FieldName = "Activity_ID";
fsm.FieldValue = activity_ID.ToString();
list.Add(fsm);
}
break;
case "cboRequestor":
{
RequestorModel requestor = cboRequestor.SelectedItem as RequestorModel;
int requestor_ID = requestor.ID;
fsm = new FieldSearchModel();
fsm.FieldName = "Requestor";
fsm.FieldValue = requestor_ID.ToString();
list.Add(fsm);
}
break;
default:
break;
}
break;
default:
break;
}
}
}
return(list);
}
