private void UpdateBtn_Click(object sender, EventArgs e)
{
if (worker == null)
{
UpdateBtn.Text = "Stop";
LogTxt.Text = "";
worker = new Thread(() =>
{
try
{
Updater updater = new Updater(UpdateUrl, DatabaseLocation);
updater.ProgressMessage += new ManicTimeMonitor.Updater.NotificationEventHandler(Updater_ProgressMessage);
updater.Update();
}
catch (ThreadAbortException)
{
// do nothing
}
catch (Exception ex)
{
MessageBox.Show(ex.StackTrace, ex.Message);
}
UpdateBtn.Invoke(new Action(() => UpdateBtn.Text = "Update now"));
worker = null;
});
worker.Start();
}
else
{
worker.Abort();
worker = null;
UpdateBtn.Text = "Update now";
LogTxt.AppendText("Stopped");
}
}
private void EmployeesBtn_Click(object sender, EventArgs e)
{
Key = 1;
tableLayoutPanel3.Hide();
tableLayoutPanel2.Hide();
tableLayoutPanel1.Hide();
SaveBtn.Hide();
JobTitlesbtn.Enabled = true;
DepartmentsBtn.Enabled = true;
OfficesBtn.Enabled = true;
SqldataGridView.Show();
CreateBtn.Show();
CreateBtn.Enabled = true;
UpdateBtn.Show();
UpdateBtn.Enabled = false;
DeleteBtn.Show();
DeleteBtn.Enabled = false;
TurnOnEditBth.Show();
MainPicture.Hide();
string sql = "select p.id_pracownika as ID, p.imie as Imie, p.nazwisko as Nazwisko, s.nazwa as Stanowisko, d.nazwa_dzialu as 'Nazwa działu', si.nazwa_siedziby as Siedziba, si.adres as Adres" +
" from PRACOWNICY p join DZIALY d on p.id_dzialu=d.id_dzialu join STANOWISKA s on p.id_stanowiska=s.id_stanowiska join SIEDZIBY si on d.id_siedziby=si.id_siedziby;";
LoadDataToSqldataGridView("Pracownicy", sql);
EmployeesBtn.Enabled = false;
}
public void UpdateExistingLanguageWithDifferentLangLevel(IWebDriver driver)
{
//Populate Test Data
ExcelLib.PopulateInCollection(ConstantUtils.TestDataPath, "Profile");
// Click Language tab
WaitForElement(driver, "XPath", "//a[@data-tab='first']", 5);
LanguageTab.Click();
// Click Edit
WaitForElementClickable(driver, "XPath", "//*[@id='account-profile-section']//div[2]//div[2]//tbody[last()]/tr/td[3]/span[1]/i", 5);
EditIcon.Click();
// Enter Language
WaitForElement(driver, "XPath", "//input[@placeholder='Add Language']", 5);
LanguageName.Clear();
LanguageName.SendKeys(ExcelLib.ReadData(5, "Language"));
// Choose Language level 0-basic; 1-conversational; 2-fluent; 3-native
LanguageDropdownBox.Click();
new SelectElement(LanguageDropdownBox).SelectByText
(ExcelLib.ReadData(5, "Language Level"));
// Click Update
UpdateBtn.Click();
// Record the msg
msg = "update an existing language with different language level";
}
public void UpdateExistingLanguage(IWebDriver driver)
{
// Add a new language
AddLanguage(driver);
Thread.Sleep(1000);
// Click Language tab
WaitForElement(driver, "XPath", "//a[@data-tab='first']", 5);
LanguageTab.Click();
// Click Edit
WaitForElementClickable(driver, "XPath", "//*[@id='account-profile-section']//div[2]//div[2]//tbody[last()]/tr/td[3]/span[1]/i", 5);
EditIcon.Click();
// Enter Language
WaitForElement(driver, "XPath", "//input[@placeholder='Add Language']", 5);
LanguageName.Clear();
LanguageName.SendKeys(ExcelLib.ReadData(4, "Language"));
// Choose Language level 0-basic; 1-conversational; 2-fluent; 3-native
LanguageDropdownBox.Click();
new SelectElement(LanguageDropdownBox).SelectByText
(ExcelLib.ReadData(4, "Language Level")); // Need using OpenQA.Selenium.Support.UI;
// Click Update
UpdateBtn.Click();
// Record the msg
msg = "update an existing language";
}
private void InsertBtn_Click(object sender, EventArgs e)
{
string Instr = "insert into Category(CatName,Notes) values('" + CatNameTB.Text.Trim() + "','" + CatNotesTB.Text.Trim() + "')";
if (CatIdTB.Text.Trim() == "")
{
try
{
if (CatNameTB.Text.Trim() != "")
{
con.Open();
SqlCommand sql = new SqlCommand(Instr, con);
sql.ExecuteNonQuery();
con.Close();
MessageBox.Show("تم الأدخال بنجاح");
SqlCommand selectId = new SqlCommand();
categoryTableAdapter.Fill(this.salesDataSet.Category);
ClearBtn_Click(sender, e);
}
else
{
MessageBox.Show("من فضلك ادخل التصنيف");
}
}
catch (Exception ex)
{
con.Close();
if (ex.Message.Contains("UNIQUE KEY"))
{
MessageBox.Show(" !!القسم موجود من قبل", " خطأ");
}
else
{
MessageBox.Show("الرجاء استكمال جميع البيانات اولا و ادخال البيانات صحيحة وبدون اى علامات");
}
}
}
else
{
if (MessageBox.Show("هذه البيانات تم حفظها من قبل هل تريد تعديلها", "تحذير", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
UpdateBtn.PerformClick();
}
/* if (CatIdTB.Text == "")
* MessageBox.Show("الرجاء استكمال جميع لبيانات اولا قبل الحفظ","خطأ");
* else
* MessageBox.Show("لا يمكن ادخال بيانات موجوده من قبل لكن يمكنك تعديلها", "خطأ");
* ClearBtn_Click(sender, e);*/
}
}
public Form1()
{
InitializeComponent();
SqldataGridView.Hide();
tableLayoutPanel1.Hide();
CreateBtn.Hide();
UpdateBtn.Hide();
UpdateBtn.Enabled = false;
DeleteBtn.Hide();
DeleteBtn.Enabled = false;
TurnOnEditBth.Hide();
TurnOffEditBth.Hide();
SaveBtn.Hide();
tableLayoutPanel2.Hide();
tableLayoutPanel3.Hide();
SqldataGridView.ReadOnly = false;
}
void ReleaseDesignerOutlets()
{
if (UpdateBtn != null)
{
UpdateBtn.Dispose();
UpdateBtn = null;
}
if (SupportBtn != null)
{
SupportBtn.Dispose();
SupportBtn = null;
}
if (columnView != null)
{
columnView.Dispose();
columnView = null;
}
if (tableView != null)
{
tableView.Dispose();
tableView = null;
}
if (btnInfo != null)
{
btnInfo.Dispose();
btnInfo = null;
}
if (btnReport != null)
{
btnReport.Dispose();
btnReport = null;
}
if (btnInterest != null)
{
btnInterest.Dispose();
btnInterest = null;
}
}
//Fill Aauthors Method End
#endregion
#region Author Update Method for Row
//Author Update Method
private void DgvAuthors_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
int id = Convert.ToInt32(DgvAuthors.Rows[e.RowIndex].Cells[0].Value.ToString());
_author = _db.Authors.Find(id);
UpdateBtn.Show();
DeleteBtn.Show();
TxtName.Text = _author.Name;
TxtSurname.Text = _author.Surname;
if (_author.Status == false)
{
RdBtnActive.Checked = true;
}
else
{
RdBtnDisabled.Checked = true;
}
BtnCreate.Enabled = false;
}
private void DgvCustomer_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
int id = Convert.ToInt32(DgvCustomer.Rows[e.RowIndex].Cells[0].Value.ToString());
_customer = _db.Customers.Find(id);
UpdateBtn.Show();
DeleteBtn.Show();
FullNameTxt.Text = _customer.FullName;
EmailTxt.Text = _customer.Email;
PhoneTxt.Text = _customer.Phone;
if (_customer.Status == false)
{
ActiveRdBtn.Checked = true;
}
else
{
DisabledRdBtn.Checked = true;
}
BtnCreate.Enabled = false;
}
public void UpdateSkill(IWebDriver driver, string skillName, string skillLevel)
{
// Click Skill tab
WaitForElement(driver, "XPath", "//a[@data-tab='second']", 5);
SkillTab.Click();
// Click Edit
WaitForElementClickable(driver, "XPath", "//*[@id='account-profile-section']//div[3]/form/div[3]//div[2]//tbody[2]/tr/td[3]/span[1]/i", 5);
EditIcon.Click();
// Update Skill
WaitForElement(driver, "XPath", "//input[@placeholder='Add Skill']", 5);
SkillName.Clear();
SkillName.SendKeys(skillName);
// Choose Skill level
SkillDropdownBox.Click();
new SelectElement(SkillDropdownBox).SelectByText(skillLevel);
// Click Update
UpdateBtn.Click();
}
private void DepartmentsBtn_Click(object sender, EventArgs e)
{
Key = 4;
tableLayoutPanel3.Hide();
tableLayoutPanel2.Hide();
tableLayoutPanel1.Hide();
SaveBtn.Hide();
EmployeesBtn.Enabled = true;
JobTitlesbtn.Enabled = true;
OfficesBtn.Enabled = true;
SqldataGridView.Show();
CreateBtn.Show();
UpdateBtn.Show();
DeleteBtn.Show();
CreateBtn.Enabled = true;
UpdateBtn.Enabled = false;
DeleteBtn.Enabled = false;
TurnOnEditBth.Show();
MainPicture.Hide();
string sql = "select d.nazwa_dzialu, s.nazwa_siedziby, s.adres from DZIALY d join SIEDZIBY s on d.id_siedziby=s.id_siedziby ";
LoadDataToSqldataGridView("Dzialy", sql);
DepartmentsBtn.Enabled = false;
}
private void OfficesBtn_Click(object sender, EventArgs e)
{
Key = 3;
tableLayoutPanel3.Hide();
tableLayoutPanel2.Hide();
tableLayoutPanel1.Hide();
SaveBtn.Hide();
EmployeesBtn.Enabled = true;
JobTitlesbtn.Enabled = true;
DepartmentsBtn.Enabled = true;
SqldataGridView.Show();
CreateBtn.Show();
UpdateBtn.Show();
DeleteBtn.Show();
CreateBtn.Enabled = true;
UpdateBtn.Enabled = false;
DeleteBtn.Enabled = false;
TurnOnEditBth.Show();
MainPicture.Hide();
string sql = "select id_siedziby as ID ,nazwa_siedziby as Oddział, adres as Adres from SIEDZIBY ";
LoadDataToSqldataGridView("Siedziby", sql);
OfficesBtn.Enabled = false;
}
private void JobTitlesbtn_Click(object sender, EventArgs e)
{
Key = 2;
tableLayoutPanel3.Hide();
tableLayoutPanel2.Hide();
tableLayoutPanel1.Hide();
SaveBtn.Hide();
EmployeesBtn.Enabled = true;
OfficesBtn.Enabled = true;
DepartmentsBtn.Enabled = true;
SqldataGridView.Show();
CreateBtn.Show();
UpdateBtn.Show();
DeleteBtn.Show();
CreateBtn.Enabled = true;
UpdateBtn.Enabled = false;
DeleteBtn.Enabled = false;
TurnOnEditBth.Show();
MainPicture.Hide();
string sql = "select id_stanowiska, nazwa as Stanowisko from STANOWISKA ";
LoadDataToSqldataGridView("Stanowiska", sql);
JobTitlesbtn.Enabled = false;
}
void ShowFrameRate()
{
FrameText.gameObject.SetActive(!FrameText.gameObject.activeSelf);
UpdateBtn.SetActive(FrameText.gameObject.activeSelf);
}
void Updater_ProgressMessage(string message)
{
UpdateBtn.Invoke(new Action(() => LogTxt.AppendText("[" + DateTime.Now + "] " + message + "\r\n")));
}
