public void TemplateSelector_GotFocus(object sender, EventArgs e)
{
DataSet clDs = DBConnection.getDBConnectionToInstance().getDataSet("SELECT TemplateName FROM CreateTemplate");
cbCl.DataSource = clDs.Tables[0];
cbCl.DisplayMember = "templateName";
}
public void fillEditOptionComment()
{
foreach (int optionCommentEditElement in editTemplate.opID)
{
DBConnection.getDBConnectionToInstance().fillOptionComment(Constants.SQLFillEditOptionTitle, optionCommentEditElement);
}
}
static List <string> getTemplateNames()
{
//gets the templatenames
List <string> templateNames = DBConnection.getDBConnectionToInstance().displayTemplateNames(Constants.select);
return(templateNames);
}
public void getLastestRemoveOptionsID()
{
foreach (int optionIDElement in sectID)
{
int temporarySectId = optionIDElement;
DBConnection.getDBConnectionToInstance().getRemoveOptionId(Constants.getRemoveOptionID, temporarySectId);
}
}
public void getOptComments()
{
int count = optionID.Count();
for (int i = 0; i < count; i++)
{
optionComment.Add(DBConnection.getDBConnectionToInstance().getTempOptComment(Constants.searchOptComment, optionID[i]));
}
}
public void getOptTitles()
{
int count = optionID.Count;
for (int i = 0; i < count; i++)
{
optionTitle.Add(DBConnection.getDBConnectionToInstance().getTempOptTitle(Constants.searchOptTitle, optionID[i]));
}
}
private void TemplateSelector_Load(object sender, EventArgs e)
{
DataSet clDs = DBConnection.getDBConnectionToInstance().getDataSet("SELECT templateName FROM createTemplate");
cbCl.DataSource = clDs.Tables[0];
cbCl.DisplayMember = "templateName";
// TODO: This line of code loads data into the 'templateNameDataSet.createTemplate' table. You can move, or remove it, as needed.
this.createTemplateTableAdapter.Fill(this.templateNameDataSet.createTemplate);
}
public void wasChanged()
{
if ((string)TemplateNameTextboxData.Tag != TemplateNameTextboxData.Text)
{
DBConnection.getDBConnectionToInstance().updateTemp(Constants.SQLUpdateTemplate, editTemplate.tempEditID);
}
if ((string)TemplateReviewerTextboxData.Tag != TemplateReviewerTextboxData.Text)
{
DBConnection.getDBConnectionToInstance().updateTempReviewer(Constants.SQLUpdateTemplateReviewer, editTemplate.tempEditID);
}
if ((string)TemplatePositionTextboxData.Tag != TemplatePositionTextboxData.Text)
{
DBConnection.getDBConnectionToInstance().updateTempPosition(Constants.SQLUpdateTemplatePosition, editTemplate.tempEditID);
}
foreach (int update in editTemplate.sectID)
{
if ((string)sectionTitleTextboxData[DBConnection.updateSectionTitleIndex].Tag != sectionTitleTextboxData[DBConnection.updateSectionTitleIndex].Text)
{
DBConnection.getDBConnectionToInstance().updateSectionTitle(Constants.SQLUpdateSectionTitle, update);
DBConnection.updateSectionTitleIndex += 1;
}
else
{
DBConnection.updateSectionTitleIndex += 1;
}
}
foreach (int update in editTemplate.opID)
{
if ((string)optionTitleTextboxData[DBConnection.updateOptionTitleIndex].Tag != optionTitleTextboxData[DBConnection.updateOptionTitleIndex].Text)
{
DBConnection.getDBConnectionToInstance().updateOptionsTitle(Constants.SQLUpdateOptionsTitle, update);
DBConnection.updateOptionTitleIndex += 1;
}
else
{
DBConnection.updateOptionTitleIndex += 1;
}
}
foreach (int update in editTemplate.opID)
{
if ((string)optionCommentTextboxData[DBConnection.updateCommentIndex].Tag != optionCommentTextboxData[DBConnection.updateCommentIndex].Text)
{
DBConnection.getDBConnectionToInstance().updateOptionsComment(Constants.SQLUpdateOptionsComment, update);
DBConnection.updateCommentIndex += 1;
}
else
{
DBConnection.updateCommentIndex += 1;
}
}
}
private void dataGridView1__Load(object sender, DataGridViewCellEventArgs e)
{
// populate the GridView
DataSet dsPerson = DBConnection.getDBConnectionToInstance().getDataSet("SELECT * FROM createTemplate");
//get the only table in the dataset person
DataTable table = dsPerson.Tables[0];
//set up the data grid view
dataGridView1.DataSource = table;
}
public void getOptIDs()
{
List <int> a = new List <int>();
int count = sectionID.Count();
for (int i = 0; i < count; i++)
{
a = DBConnection.getDBConnectionToInstance().getTempOptID(Constants.searchOptID, sectionID[i]);
optionsCount.Add(a.Count());
optionID.AddRange(a);
}
}
public void removeChosenTemplate()
{
foreach (int optionElement in opID)
{
DBConnection.getDBConnectionToInstance().removeOption(Constants.RemoveOption, optionElement);
}
foreach (int sectionElement in sectID)
{
DBConnection.getDBConnectionToInstance().removeSection(Constants.RemoveSection, sectionElement);
}
DBConnection.getDBConnectionToInstance().removeTemplate(Constants.RemoveTemplate, tempID);
}
public void getTPosition()
{
templatePosition = DBConnection.getDBConnectionToInstance().getTempPosition(Constants.searchTPos, templateID);
}
public void getLatestRemoveSectionID()
{
DBConnection.getDBConnectionToInstance().getRemoveSectionID(Constants.getRemoveSectionID, tempID);
}
public void getLatestRemoveTemplateID()
{
DBConnection.getDBConnectionToInstance().getRemoveTemplateID(Constants.getRemoveTemplateID, templateRemoveName);
}
//writeNameToDB Runs the InsertSectioName SQL Statement to Insert Section Name and Template ID to table
public void writeNameToDB()
{
DBConnection.getDBConnectionToInstance().insertSectionTitle(Constants.InsertSectionName, sectionNameOne, tempID);
}
//getLatestTemplateID Runs the getTemplateID SQL Statement with DB Conenction Instance
public void getLatestTemplateID()
{
DBConnection.getDBConnectionToInstance().getTempTemplateID(Constants.getTempTemplateID);
}
public void getSecIDs()
{
sectionID = DBConnection.getDBConnectionToInstance().getTempSecID(Constants.searchSecID, templateID);
}
public void fillEditSection()
{
DBConnection.getDBConnectionToInstance().fillSection(Constants.SQLFillEditSection, editTemplate.tempEditID);
}
public void createEditOption()
{
DBConnection.getDBConnectionToInstance().makeTemplateOption(Constants.SQLCreateEditOption, editTemplate.sectID[optionCount]);
optionCount += 1;
}
public void getLatestEditSectionID()
{
DBConnection.getDBConnectionToInstance().getEditSectionID(Constants.getEditSectionID, tempEditID);
}
public void getLatestEditTemplateID()
{
DBConnection.getDBConnectionToInstance().getEditTemplateID(Constants.getEditTemplateID, templateEditName);
}
public void getTReviewer()
{
templateReviewer = DBConnection.getDBConnectionToInstance().getTempReviewer(Constants.searchTRev, templateID);
}
//Gets the Database Connection and Runs the SQL Statement.
public void writeOptionDetailsToDB()
{
DBConnection.getDBConnectionToInstance().insertOption(Constants.InsertOption, optionTitleOne, optionCommentOne, secID);
}
//Gets the Database Connection and Runs the SQL Statement.
public void getLatestsectionID()
{
DBConnection.getDBConnectionToInstance().getSectioneID(Constants.getSectionsID);
}
public void getSecTitles()
{
sectionTitle = DBConnection.getDBConnectionToInstance().getTempSecTitle(Constants.searchSecTitle, templateID);
}
public void getTID()
{
templateID = DBConnection.getDBConnectionToInstance().getTempID(Constants.searchTID, templateName);
}
//Gets the Database Connection and Runs the SQL Statement.
public void writeTemplateDetailsToDB()
{
DBConnection.getDBConnectionToInstance().insertTemplate(Constants.Insert, templateNameOne, templateReviewerOne, templatePositionOne);
}