private void InsertButton_Click(object sender, EventArgs e)
{
InsertButton.Text = "Running";
InsertButton.Refresh();
this.errorHasOccurred = false;
this.errorDetails = "";
if (ConnectionStringTextBox.Text.Length == 0)
{
ConnectionStringTextBox.Text = "Server=.;Database=WideWorldImporters;Integrated Security=true;Column Encryption Setting=disabled;Max Pool Size=250;";
}
if (!ConnectionStringTextBox.Text.ToUpper().Contains("MAX POOL SIZE"))
{
ConnectionStringTextBox.Text = (ConnectionStringTextBox.Text + ";Max Pool Size=250;").Replace(";;", ";");
}
var startingTime = DateTime.Now;
try
{
int numberOfThreads = (int)NumberOfThreadsNumericUpDown.Value;
var sqlTasks = new Thread[numberOfThreads];
for (int threadCounter = 0; threadCounter < numberOfThreads; threadCounter++)
{
sqlTasks[threadCounter] = new System.Threading.Thread(() => PerformSqlTask(threadCounter, this));
sqlTasks[threadCounter].Start();
}
if (sqlTasks != null)
{
foreach (Thread thread in sqlTasks)
{
thread.Join();
}
}
}
catch (Exception ex)
{
this.errorHasOccurred = true;
this.errorDetails = ex.ToString();
}
InsertButton.Text = "&Insert";
LastExecutionTimeTextBox.Text = ((int)DateTime.Now.Subtract(startingTime).TotalMilliseconds).ToString();
if (this.errorHasOccurred)
{
var errorForm = new ErrorDetailsForm();
errorForm.ErrorMessage = this.errorDetails;
errorForm.ShowDialog();
}
}
public void Do_order_and_confirm(string _remark)
{
OrderDetailButton.TouchNoScroll();
InsertButton.TouchNoScroll();
ProductListTable.Input_to_cell_of_first_row_by_index(COL_CASE, "1");
SubmitButton.TouchNoScroll();
DoneButton.TouchNoScroll();
DeliveryNote = _remark;
SubmitButton.TouchNoScroll();
}
private void AddSectionForm_Load(object sender, EventArgs e)
{
InsertButton.Select();
//EXCEPTION 1
try
{
variables = new Variables();
opacityform = new OpacityForm();
cryptography = new Cryptography();
sqlconnectionconfig = new SQLConnectionConfig();
RegistryKey registrykey = Registry.CurrentUser.OpenSubKey(@variables.pathname);
string tempdata = registrykey.GetValue("SQLServerConnectionString").ToString();
//USER SQLSERVER CONNECTION SETTINGS
sqlconnectionconfig.SqlConnectionString = cryptography.Decrypt(tempdata);
sqlconnection = new SqlConnection(sqlconnectionconfig.SqlConnectionString);
sqlconnection.Open();
//INNER EXCEPTION 1
try
{
Init_NewSectionID();
RetriveSectionData();
RetrieveSchoolYearList();
}
catch (Exception exception)
{
opacityform.Show();
MessageBox.Show(exception.ToString(), "@Add Section Form Inner Exception 1",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opacityform.Hide();
}
}
catch (Exception exception)
{
opacityform.Show();
MessageBox.Show(exception.ToString(), "@Add Section Form Exception 1",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opacityform.Hide();
}
}
public IEnumerator <ITask> OnInsertButton(InsertButton insert)
{
if (_state.Buttons.Exists(insert.Body.CompareId) ||
_state.Controls.Exists(insert.Body.CompareId))
{
insert.ResponsePort.Post(
Fault.FromCodeSubcodeReason(
FaultCodes.Receiver,
DsspFaultCodes.DuplicateEntry,
"A button with the same ID already exists: " + insert.Body.Id
)
);
}
else
{
Fault fault = null;
FormInvoke invoke = new FormInvoke(
delegate
{
_form.InsertButton(insert.Body);
}
);
WinFormsServicePort.Post(invoke);
yield return(Arbiter.Choice(
invoke.ResultPort,
EmptyHandler,
delegate(Exception e)
{
fault = Fault.FromException(e);
}
));
if (fault != null)
{
insert.ResponsePort.Post(fault);
}
else
{
_state.Buttons.Add(insert.Body);
insert.ResponsePort.Post(DefaultUpdateResponseType.Instance);
DoSendNotification(insert);
}
}
}
public void FeeList_Submission_SPP()
{
AJAXCall.WaitForAjax();
Thread.Sleep(900);
CommonUtils cookiesScreen = new CommonUtils(driver);
cookiesScreen.RejectAll_Cookies();
Thread.Sleep(900);
SignIn_Page.Click();
Excel_Suite userEmail = new Excel_Suite(Env.EXCEL_TEST_URL);
userEmail.getCellData("SPP_TestData", true);
UserEmail.SendKeys(Env.Email_Id);
Password.SendKeys("Test@123");
WebDriverWait wait = new WebDriverWait(driver, System.TimeSpan.FromSeconds(800));
Thread.Sleep(800);
SubmitButton.Click();
MyAccount_Toggle.Click();
AJAXCall.WaitForAjax();
FeesList_Link.Click();
AJAXCall.WaitForAjax();
Thread.Sleep(1000);
EditLink.Click();
EditButton.Click();
createBox.Click();
Thread.Sleep(800);
driver.SwitchTo().Frame(1);
Eyp_name.SendKeys("TestAutomation");
Eyp_agerange.SendKeys("5-10");
SelectElement option = new SelectElement(Eyp_ecceavailable);
option.SelectByText("Yes");
Eyp_fullpriceperweek_Text.SendKeys("100.00");
Thread.Sleep(800);
Eyp_daysperweek.SendKeys("5");
Eyp_hoursperweek.SendKeys("40");
Effective_Date.SendKeys("01/11/2020");
InsertButton.Click();
AJAXCall.WaitForAjax();
driver.SwitchTo().DefaultContent();
}
private void InsertButton_Click(object sender, EventArgs e)
{
//EXCEPTION 2
try
{
opacityform = new OpacityForm();
darkeropacityform = new DarkerOpacityForm();
notificationwindow = new NotificationWindow();
if (SchoolYearTextbox.Text.Trim().Length < 1)
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "PLEASE PROVIDE A SCHOOL YEAR !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else if (!SchoolYearTextbox.Text.Trim().ToUpper().Contains("S.Y."))
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "PLEASE FOLLOW AND PROVIDE\nTHE SPECIFIED SCHOOL YEAR FORMAT !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else
{
//INNER EXCEPTION 2
try
{
string TempQuery = "SELECT COUNT(*) FROM [Tbl.SchoolYear] WHERE [SCHOOL YEAR] = '" +
SchoolYearTextbox.Text.Trim().ToUpper() + "'";
sqldataadapter = new SqlDataAdapter(TempQuery, sqlconnection);
DataTable datatable0 = new DataTable();
sqldataadapter.Fill(datatable0);
if (datatable0.Rows[0][0].ToString() == "1")
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "THAT SCHOOL YEAR ALREADY EXIST !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else if (datatable0.Rows[0][0].ToString() == "0")
{
string InsertQuery = "INSERT INTO [Tbl.SchoolYear]([ENTRY ID], [SCHOOL YEAR], [WAS SET]) VALUES(@EntryID, @schoolyear, @ws)";
sqlcommand = new SqlCommand(InsertQuery, sqlconnection);
sqlcommand.Parameters.AddWithValue("@EntryID", Prefix_ID + NewEntryID.ToString());
sqlcommand.Parameters.AddWithValue("@schoolyear", SchoolYearTextbox.Text.Trim().ToUpper());
sqlcommand.Parameters.AddWithValue("@ws", "0");
sqlcommand.ExecuteNonQuery();
RetrieveSchoolYearData();
SchoolYearTextbox.ResetText();
InsertButton.Select();
Init_NewEntryID();
}
}
catch (Exception exception)
{
opacityform.Show();
MessageBox.Show(exception.StackTrace.ToString(), "@Add School Year Form Inner Exception 2",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opacityform.Hide();
}
}
}
catch (Exception exception)
{
opacityform.Show();
MessageBox.Show(exception.StackTrace.ToString(), "@Add School Year Form Exception 2",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opacityform.Hide();
}
}
private void InsertButton_Click(object sender, EventArgs e)
{
//EXCEPTION 3
try
{
variables = new Variables();
opacityform = new OpacityForm();
darkeropacityform = new DarkerOpacityForm();
notificationwindow = new NotificationWindow();
if (SectionNameTextbox.Text.Trim().Length < 1 || MaxStudentTextbox.Text.Trim().Length < 1)
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "PLEASE PROVIDE SECTION NAME,\nMAXIMUM STUDENTS AND SCHOOL YEAR !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else if (isNumber(MaxStudentTextbox.Text.Trim()) == false)
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "INVALID DATA ON MAXIMUM STUDENTS !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else
{
//INNER EXCEPTION 3
try
{
string TempQuery = "SELECT COUNT(*) FROM [Tbl.Sections] WHERE [SECTION NAME] = '" +
SectionNameTextbox.Text.Trim().ToUpper() + "' AND [SCHOOL YEAR] = '" + CurrentSchoolYearDropdown.selectedValue.ToString() + "'";
sqldataadapter = new SqlDataAdapter(TempQuery, sqlconnection);
DataTable datatable = new DataTable();
sqldataadapter.Fill(datatable);
if (datatable.Rows[0][0].ToString() == "1")
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "THAT SECTION ALREADY EXIST FOR \nSCHOOL YEAR " + CurrentSchoolYearDropdown.selectedValue.ToString();
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else if (datatable.Rows[0][0].ToString() == "0")
{
RegistryKey registrykey = Registry.CurrentUser.OpenSubKey(@variables.pathname);
CurrentSectionCount = registrykey.GetValue("NofMaxSections").ToString();
if (int.Parse(CurrentSectionCount) < 10)
{
sqlquery5 = "INSERT INTO [Tbl.Sections]([SECTION ID], [SECTION NAME], [MAXIMUM STUDENTS], ENROLLED, [SCHOOL YEAR])" +
" VALUES(@sectionid, @section_name, @maximumstudents, @enrolled, @schoolyear)";
sqlcommand = new SqlCommand(sqlquery5, sqlconnection);
sqlcommand.Parameters.AddWithValue("@sectionid", Prefix + NewSectionID.ToString());
sqlcommand.Parameters.AddWithValue("@section_name", SectionNameTextbox.Text.Trim().ToUpper());
sqlcommand.Parameters.AddWithValue("@maximumstudents", MaxStudentTextbox.Text.Trim());
sqlcommand.Parameters.AddWithValue("@enrolled", "0");
sqlcommand.Parameters.AddWithValue("@schoolyear", CurrentSchoolYearDropdown.selectedValue.ToString().ToUpper());
sqlcommand.ExecuteNonQuery();
//UPDATE SECTION COUNT
RegistryKey updateregistrykey = Registry.CurrentUser.CreateSubKey(@variables.pathname);
updateregistrykey.SetValue("NofMaxSections", (int.Parse(CurrentSectionCount) + 1).ToString());
Init_NewSectionID();
RetriveSectionData();
SectionNameTextbox.ResetText();
MaxStudentTextbox.ResetText();
CurrentSchoolYearDropdown.selectedIndex = 0;
InsertButton.Select();
}
else if (int.Parse(CurrentSectionCount) == 10)
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.error;
notificationwindow.MessageText = "YOU CAN ONLY CREATE 10 SECTIONS\nEVERY SCHOOL YEAR !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
}
}
catch (Exception exception)
{
opacityform.Show();
MessageBox.Show(exception.Message.ToString(), "@Add Section Form Inner Exception 3",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opacityform.Hide();
}
}
}
catch (Exception exception)
{
opacityform.Show();
MessageBox.Show(exception.Message.ToString(), "@Add Section Form Exception 2",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opacityform.Hide();
}
}
private void InsertButton_Click(object sender, EventArgs e)
{
if (InsertButton.Text == "&Insert")
{
InsertButton.Text = "&Stop Now";
InsertButton.Refresh();
this.Refresh();
DisplayUpdateTimer.Enabled = true;
this.errorHasOccurred = false;
this.errorDetails = "";
this.totalOrders = 0;
this.totalMilliseconds = 0;
if (ConnectionStringTextBox.Text.Length == 0)
{
ConnectionStringTextBox.Text = "Server=.;Userid=user;Password=password;Port=5432;Database=wide_world_importers_pg;Pooling=true;MinPoolSize=0;MaxPoolSize=250;SslMode=Require;Trust Server Certificate=true";
}
if (!ConnectionStringTextBox.Text.ToUpper().Contains("MAXPOOLSIZE"))
{
ConnectionStringTextBox.Text = (ConnectionStringTextBox.Text + ";MaxPoolSize=250;").Replace(";;", ";");
}
try
{
int numberOfThreads = (int)NumberOfThreadsNumericUpDown.Value;
sqlTasks = new Thread[numberOfThreads];
for (int threadCounter = 0; threadCounter < numberOfThreads; threadCounter++)
{
PerformSqlTask(threadCounter, this);
}
}
catch (Exception ex)
{
this.errorHasOccurred = true;
this.errorDetails = ex.ToString();
}
if (this.errorHasOccurred)
{
var errorForm = new ErrorDetailsForm();
errorForm.ErrorMessage = this.errorDetails;
errorForm.ShowDialog();
}
}
else
{
InsertButton.Text = "Stopping";
InsertButton.Refresh();
this.Refresh();
DisplayUpdateTimer.Enabled = false;
if (sqlTasks != null)
{
foreach (Thread thread in sqlTasks)
{
thread.Abort();
}
}
InsertButton.Text = "&Insert";
}
}