public void fillStockIDComboBox()
{
MySqlConnection conn = Connection.getConnection();
try
{
conn.Open();
MySqlCommand command = new MySqlCommand("SELECT * FROM shophope.stocks", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
string s = dataReader.GetString("stockID");
stockIDComboBox.Items.Add(s);
}
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager");
}
finally {
conn.Close();
}
}
private void returnWeightComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
MySqlConnection conn = Connection.getConnection();
try
{
conn.Open();
MySqlCommand command = new MySqlCommand("SELECT * FROM shophope.stocks WHERE catagory ='" + returnCatagoryComboBox.Text + "' and brand ='" + returnBrandComboBox.Text + "' and name = '" + returnNameComboBox.Text + "' and weight = '" + returnWeightComboBox.Text + "'", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
returnedId = dataReader.GetString("stockID");
}
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager weight combo");
}
finally
{
conn.Close();
}
}
private void button2_Click(object sender, EventArgs e)
{
MySqlConnection conn = Connection.getConnection();
try
{
conn.Open();
MySqlCommand command;
if (stockIDComboBox.Text.Length > 0)
{
command = new MySqlCommand("SELECT * FROM shophope.stocks WHERE stockID = '" + stockIDComboBox.Text + "'", conn);
}
else
{
command = new MySqlCommand("SELECT * FROM shophope.stocks WHERE catagory = '" + catagoryComboBox.Text + "' and brand = '" + brandComboBox.Text + "' and name = '" + nameComboBox.Text + "' and weight = '" + weightComboBox.Text + "'", conn);
}
MySqlDataReader dataReader = command.ExecuteReader();
bool flag = false;
while (dataReader.Read())
{
MessageBox.Show("Available stock quantity is " + dataReader.GetString("quantity"));
flag = true;
}
if (!flag)
{
MessageBox.Show("No stocks available.");
}
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager " + ex.Message);
}
finally
{
conn.Close();
}
conn = Connection.getConnection();
string updatingString = "";
try
{
conn.Open();
MySqlCommand command = new MySqlCommand("SELECT * FROM shophope.system WHERE id = '1'", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
updatingString = dataReader.GetString("isStocksUpdating");
}
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager");
}
finally
{
conn.Close();
}
if (updatingString.Equals("true"))
{
MessageBox.Show("Stocks are in updating mode.");
}
}
private static void checkOfferClose()
{
MySqlConnection conn = Connection.getConnection();
DateTime date = DateTime.Today;
try
{
conn.Open();
MySqlCommand command = new MySqlCommand("SELECT * FROM shophope.stocks", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
if (dataReader.GetString("offerDate").Length == 0)
{
continue;
}
if (int.Parse(dataReader.GetString("offerDate")) < int.Parse(date.ToString("yyyyMMdd")))
{
string id = dataReader.GetString("stockId");
MySqlConnection conn1 = Connection.getConnection();
string realPrice = "";
string realOfferPrice = "";
try
{
conn1.Open();
MySqlCommand command1 = new MySqlCommand("SELECT * FROM shophope.stocks WHERE stockId = '" + id + "'", conn1);
MySqlDataReader dataReader1 = command1.ExecuteReader();
while (dataReader1.Read())
{
realPrice = dataReader1.GetString("realPrice");
realOfferPrice = dataReader1.GetString("price");
}
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager " + ex.Message);
}
finally
{
conn1.Close();
}
conn1 = Connection.getConnection();
try
{
conn1.Open();
MySqlCommand command1 = new MySqlCommand("UPDATE shophope.stocks SET price = '" + realPrice + "', offerDate = '' WHERE stockId = '" + id + "'", conn1);
MySqlDataReader dataReader1 = command1.ExecuteReader();
while (dataReader1.Read())
{
}
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager " + ex.Message);
}
finally
{
conn1.Close();
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager " + ex.Message);
}
finally
{
conn.Close();
}
}
private void signUpSecondBtn_Click(object sender, EventArgs e)
{
if (!(nameTxt.Text.Length > 0 && IDTxt.Text.Length > 0 && PhoneNoTxt.Text.Length > 0 && mailTxt.Text.Length > 0 && ageTxt.Text.Length > 0 && confirmCodeTxt.Text.Length > 0))
{
MessageBox.Show("Please fill all boxes.");
return;
}
MySqlConnection conn = Connection.getConnection();
try
{
conn.Open();
MySqlCommand command = new MySqlCommand("SELECT * FROM shophope.employeetable WHERE userId = '1'", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
if (!dataReader.GetString("passWord").Equals(confirmCodeTxt.Text))
{
MessageBox.Show("Confirmation code wrong!");
return;
}
}
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager " + ex.Message);
}
finally {
conn.Close();
}
lock (lockObject)
{
try
{
conn = Connection.getConnection();
conn.Open();
MySqlCommand command = new MySqlCommand("SELECT * FROM shophope.employeetable WHERE userName = '******'", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
MessageBox.Show("User name already exist");
return;
}
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager " + ex.Message);
}
finally
{
conn.Close();
}
signUpPanel.Visible = false;
if (salesManRadioBtn.Checked)
{
SalesMan.getEmployee(nameTxt.Text, IDTxt.Text, mailTxt.Text, long.Parse(PhoneNoTxt.Text), int.Parse(ageTxt.Text), passwordSecondTxt.Text, "SalesMan");
userNameTxt.Text = nameTxt.Text;
nameTxt.Text = "";
IDTxt.Text = "";
mailTxt.Text = "";
PhoneNoTxt.Text = "";
ageTxt.Text = "";
passwordSecondTxt.Text = "";
}
else if (stockManagerRadioBtn.Checked)
{
StockManager.getEmployee(nameTxt.Text, IDTxt.Text, mailTxt.Text, long.Parse(PhoneNoTxt.Text), int.Parse(ageTxt.Text), passwordSecondTxt.Text, "StockManager");
userNameTxt.Text = nameTxt.Text;
nameTxt.Text = "";
IDTxt.Text = "";
mailTxt.Text = "";
PhoneNoTxt.Text = "";
ageTxt.Text = "";
passwordSecondTxt.Text = "";
}
else
{
Labour.getEmployee(nameTxt.Text, IDTxt.Text, mailTxt.Text, long.Parse(PhoneNoTxt.Text), int.Parse(ageTxt.Text), passwordSecondTxt.Text, "Labour");
userNameTxt.Text = nameTxt.Text;
nameTxt.Text = "";
IDTxt.Text = "";
mailTxt.Text = "";
PhoneNoTxt.Text = "";
ageTxt.Text = "";
passwordSecondTxt.Text = "";
}
signUpPanel.Visible = false;
}
}
private void button1_Click(object sender, EventArgs e)
{
double oldPrice = 0;
MySqlConnection conn = Connection.getConnection();
string offerDate = "";
bool flag = false;
try
{
conn.Open();
MySqlCommand command = new MySqlCommand("SELECT * FROM shophope.stocks WHERE stockID = '" + stockIDLbl.Text + "'", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
oldPrice = double.Parse(dataReader.GetString("price"));
offerDate = dataReader.GetString("offerDate");
flag = true;
}
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager change btn in stocks " + ex.Message);
}
finally
{
conn.Close();
}
if (!flag)
{
MessageBox.Show("Product Info Wrong");
return;
}
if (offerDate.Length > 0)
{
Mediator.notifyManager("Offer deleted for stock " + stockIDLbl.Text);
}
if (!oldPrice.ToString().Equals(priceTxt.Text))
{
MessageBox.Show("Notified");
Mediator.notifyManager("Stock " + nameComboBox.Text + " changed from " + oldPrice.ToString() + " to " + priceTxt.Text);
}
try
{
conn = Connection.getConnection();
conn.Open();
string temp = int.Parse(quantityTxt.Text).ToString();
if (addQuantityTxt.Text.Length != 0)
{
temp = (int.Parse(addQuantityTxt.Text) + int.Parse(quantityTxt.Text)).ToString();
}
MySqlCommand command = new MySqlCommand("UPDATE shophope.stocks SET price ='" + priceTxt.Text + "', realPrice ='" + priceTxt.Text + "', quantity = '" + temp + "',expirydate = '" + expieryTxt.Text + "',warningLevel='" + warningLevelTxt.Text + "',offerDate = '' WHERE stockID = '" + stockIDLbl.Text + "'", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
}
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager change btn " + ex.Message);
}
finally
{
conn.Close();
}
}
public static void checkEmployeesAsAbsent()
{
MySqlConnection conn = Connection.getConnection();
List <bool> attandanceList = new List <bool>();
List <int> attandanceCountList = new List <int>();
List <int> overTimeList = new List <int>();
List <int> userIdList = new List <int>();
List <string> leavesCountList = new List <string>();
try
{
conn.Open();
MySqlCommand command = new MySqlCommand("SELECT * FROM shophope.employeetable", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
attandanceCountList.Add(int.Parse(dataReader.GetString("monthlyAttandance")));
userIdList.Add(int.Parse(dataReader.GetString("userId")));
overTimeList.Add(int.Parse(dataReader.GetString("todayOverTime")) + int.Parse(dataReader.GetString("overTime")));
leavesCountList.Add(dataReader.GetString("leavesPerMonth"));
if (dataReader.GetString("presence").Equals("t"))
{
attandanceList.Add(true);
}
else
{
attandanceList.Add(false);
}
}
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager weight combo " + ex.Message);
}
finally
{
conn.Close();
}
for (int i = 0; i < attandanceList.Count; i++)
{
if (attandanceList[i])
{
try
{
conn = Connection.getConnection();
conn.Open();
MySqlCommand command = new MySqlCommand("UPDATE shophope.employeetable SET monthlyAttandance = '" + (attandanceCountList[i] + 1).ToString() + "', overTime = '" + overTimeList[i].ToString() + "',todayOverTime = '0', presence = 'f' WHERE userId = '" + userIdList[i].ToString() + "'", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
}
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager weight combo " + ex.Message);
}
finally
{
conn.Close();
}
}
else
{
try
{
conn = Connection.getConnection();
conn.Open();
MySqlCommand command = new MySqlCommand("UPDATE shophope.employeetable SET leavesPerMonth = '" + (int.Parse(leavesCountList[i]) + 1).ToString() + "',todayOverTime = '0' WHERE userId = '" + userIdList[i].ToString() + "'", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
}
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager weight combo " + ex.Message);
}
finally
{
conn.Close();
}
}
}
}
private void createOfferBtn_Click(object sender, EventArgs e)
{
if (!price.Equals(priceTxt.Text))
{
string oldPrice = "";
string dateTime = dateTimePicker1.Value.ToString("yyyyMMdd");
string offerDate = "";
MySqlConnection conn = Connection.getConnection();
try
{
conn.Open();
MySqlCommand command = new MySqlCommand("SELECT * FROM shophope.stocks WHERE catagory ='" + catagoryComboBox.Text + "' and brand ='" + brandComboBox.Text + "' and name = '" + nameComboBox.Text + "' and weight = '" + weightComboBox.Text + "'", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
oldPrice = dataReader.GetString("price");
offerDate = dataReader.GetString("offerDate");
}
//MessageBox.Show("Offer Created...");
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager weight combo " + ex.Message);
}
finally
{
conn.Close();
}
if (offerDate.Length > 0)
{
MessageBox.Show("Already an offer created");
return;
}
conn = Connection.getConnection();
try
{
conn.Open();
MySqlCommand command = new MySqlCommand("UPDATE shophope.stocks SET price = '" + priceTxt.Text + "' , offerPrice = '" + oldPrice + "', offerDate = '" + dateTime + "' WHERE catagory ='" + catagoryComboBox.Text + "' and brand ='" + brandComboBox.Text + "' and name = '" + nameComboBox.Text + "' and weight = '" + weightComboBox.Text + "'", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
}
MessageBox.Show("Offer Created...");
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager weight combo " + ex.Message);
}
finally
{
conn.Close();
}
dateTimePicker1.Enabled = false;
brandComboBox.Text = "";
nameComboBox.Text = "";
weightComboBox.Text = "";
priceTxt.Text = "";
createOfferBtn.Enabled = false;
brandComboBox.Items.Clear();
nameComboBox.Items.Clear();
weightComboBox.Items.Clear();
}
}
private void notificationPanel_MouseClick(object sender, MouseEventArgs e)
{
performResetCountDown();
lock (lockObject)
{
notificationCountLbl.Text = "";
MySqlConnection conn = Connection.getConnection();
for (int i = 0; i < notificationStringList.Count - 1; i++)
{
//MessageBox.Show("notificatiion split: " + notificationStringList[i]);
if (notificationStringList[i].Length == 0)
{
continue;
}
if (notificationStringList[i].Substring(0, 1).Equals("/"))
{
DialogResult dialog = MessageBox.Show(notificationStringList[i].Substring(1), "", MessageBoxButtons.YesNo);
string temp = notificationStringList[i].Substring(7);
string quantity = "";
string returnQuantity = "";
try
{
conn.Open();
MySqlCommand command = new MySqlCommand("SELECT * FROM shophope.stocks WHERE stockId = '" + getId(temp) + "'", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
quantity = dataReader.GetString("quantity");
returnQuantity = dataReader.GetString("returnQuantity");
}
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager timer elapsed " + ex.Message);
}
finally
{
conn.Close();
}
if (dialog == DialogResult.Yes)
{
try
{
conn = Connection.getConnection();
conn.Open();
//MessageBox.Show(getQuantity(temp) + " " + returnQuantity);
MySqlCommand command = new MySqlCommand("UPDATE shophope.stocks SET returnQuantity = '" + (int.Parse(getQuantity(temp)) + int.Parse(returnQuantity)).ToString() + "' WHERE stockId = '" + getId(temp) + "'", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
}
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager timer elapsed " + ex.Message);
}
finally
{
conn.Close();
}
}
else
{
try
{
conn = Connection.getConnection();
conn.Open();
MySqlCommand command = new MySqlCommand("UPDATE shophope.stocks SET quantity = '" + (int.Parse(getQuantity(temp)) + int.Parse(quantity)).ToString() + "' WHERE stockId = '" + getId(temp) + "'", conn);
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
}
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager timer elapsed " + ex.Message);
}
finally
{
conn.Close();
}
}
}
else
{
MessageBox.Show(notificationStringList[i]);
}
}
notificationStringList.Clear();
conn = Connection.getConnection();
try
{
conn.Open();
MySqlCommand command = new MySqlCommand("UPDATE shophope.employeetable SET notificationSpace= '' WHERE userId = 1", conn);
notificationString = "";
MySqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
}
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine("error occured at stock manager click " + ex.Message);
}
finally
{
conn.Close();
}
}
}
