private void SalesManager_Load(object sender, EventArgs e)
{
//Create an object of type DataSet and name it as CollegeDS
dsHiTechOrderManagement = new DataSet("HiTechDS");
//Create an object of type DataTable and name it as Students
// and add the object to the DataSet object
dtCustomers = new DataTable("Customers");
dsHiTechOrderManagement.Tables.Add(dtCustomers);
//dsCollegeDB.Tables.Add("Students");
// Create columns , add columns to the DataTable Students
dtCustomers.Columns.Add("CustomerId", typeof(int));
dtCustomers.Columns.Add("FirstName", typeof(string));
dtCustomers.Columns.Add("LastName", typeof(string));
dtCustomers.Columns.Add("Street", typeof(string));
dtCustomers.Columns.Add("City", typeof(string));
dtCustomers.Columns.Add("PostalCode", typeof(string));
dtCustomers.Columns.Add("CreditLimit", typeof(int));
dtCustomers.Columns.Add("PhoneNumber", typeof(int));
dtCustomers.Columns.Add("FaxNumber", typeof(string));
dtCustomers.PrimaryKey = new DataColumn[] { dtCustomers.Columns["CustomerId"] };
da = new SqlDataAdapter("SELECT * FROM Customers", UtilityDB.ConnectDB());
SqlBuilder = new SqlCommandBuilder(da);
}
//public static Employee SearchPasswordById(int empId)
//{
// Employee emp = new Employee();
// string sqlSelect = "SELECT * FROM Employees " +
// "WHERE employeeId = " + empId;
// SqlConnection sqlConn = UtilityDB.ConnectDB();
// SqlCommand sqlCmd = new SqlCommand(sqlSelect, sqlConn);
// SqlDataReader sqlReader = sqlCmd.ExecuteReader();
// if (sqlReader.Read())
// {
// emp.Password = sqlReader["Password"].ToString();
// }
// else
// {
// emp = null;
// }
// sqlConn.Close();
// return emp;
//}
public static bool ValidatePassword(int empId, string password)
{
bool success = false;
try
{
Employee emp = new Employee();
string sqlSelect = "SELECT * FROM Employees " +
"WHERE employeeId = " + empId;
SqlConnection sqlConn = UtilityDB.ConnectDB();
SqlCommand sqlCmd = new SqlCommand(sqlSelect, sqlConn);
SqlDataReader sqlReader = sqlCmd.ExecuteReader();
if (sqlReader.Read())
{
emp.Password = sqlReader["Password"].ToString();
}
else
{
emp = null;
}
if (emp.Password == password)
{
success = true;
}
}
catch (SqlException ex)
{
throw ex;
}
return(success);
}
private void salesButtonList_Click(object sender, EventArgs e)
{
labelDSInfo.Visible = false;
LabelDBinfo.Visible = true;
da = new SqlDataAdapter("SELECT * FROM Clients", UtilityDB.ConnectDB());
da.Fill(dsHiTech.Tables["Clients"]);
dataGridViewSales.DataSource = dsHiTech.Tables["Clients"];
}
private void ManagerForm_Load(object sender, EventArgs e)
{
dsHiTechDB = new DataSet("HiTechDS");
dtCustomers = new DataTable("Customers");
dtCustomers.Columns.Add("CustomerId", typeof(Int32));
dtCustomers.Columns.Add("CustomerName", typeof(string));
dtCustomers.Columns.Add("Street", typeof(string));
dtCustomers.Columns.Add("City", typeof(string));
dtCustomers.Columns.Add("PostalCode", typeof(string));
dtCustomers.Columns.Add("PhoneNumber", typeof(string));
dtCustomers.Columns.Add("FaxNumber", typeof(string));
dtCustomers.Columns.Add("CreditLimit", typeof(float));
dtCustomers.PrimaryKey = new DataColumn[] { dtCustomers.Columns["CustomerId"] };
dsHiTechDB.Tables.Add(dtCustomers);
//MessageBox.Show(dsHiTechDB.Tables.Count.ToString());
//MessageBox.Show(dsHiTechDB.Tables["Students"].ToString());
da = new SqlDataAdapter("SELECT * FROM Customers", UtilityDB.ConnectDB());
da.Fill(dsHiTechDB.Tables["Customers"]);
//dataGridViewStudent.DataSource = dsHiTechDB.Tables["Students"];
}
private void ButtonLogin_Click(object sender, EventArgs e)
{
if (userTextBox.Text == "")
{
HintUser.Text = " User Id cannot be empty";
}
else if (passTextBox.Text == "")
{
hint.Text = "Password cannot be empty";
}
else
{
SqlConnection connDB = UtilityDB.ConnectDB();
SqlCommand cmd = new SqlCommand();
cmd.Connection = connDB;
cmd.CommandText = "Select * from Login where UserId=@UserId and Password=@password";
cmd.Parameters.AddWithValue("@UserId", userTextBox.Text);
cmd.Parameters.AddWithValue("@password", passTextBox.Text);
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
connDB.Close();
int count = ds.Tables[0].Rows.Count;
//If count is equal to 1, then show select form
if (count == 1)
{
SqlDataAdapter sda = new SqlDataAdapter("Select JobTitle from [User] where UserId='" + userTextBox.Text + "'", connDB);
DataTable dt = new DataTable();
sda.Fill(dt);
connDB.Close();
if (dt.Rows.Count == 1)
{
switch (dt.Rows[0]["JobTitle"].ToString())
{
case "MIS Manager":
{
this.Hide();
ManagementForm mm = new ManagementForm();
mm.Show();
break;
}
case "Sales Manager":
{
this.Hide();
CustomerForm um = new CustomerForm();
um.Show();
break;
}
default:
{
break;
}
}
}
}
else
{
hint.Text = "Wrong Credentials";
}
}
}
private void btnLogIn_Click(object sender, EventArgs e)
{
if (textBoxUserID.Text == "" || textBoxUserPassword.Text == "")
{
MessageBox.Show("Please enter UserID and Password");
return;
}
try
{
SqlConnection connect = UtilityDB.ConnectDB();
SqlCommand cmd = new SqlCommand();
cmd.Connection = connect;
cmd.CommandText = "Select * from Users where userId = @userId and password = @password";
cmd.Parameters.AddWithValue("@userId", textBoxUserID.Text);
cmd.Parameters.AddWithValue("@password", textBoxUserPassword.Text);
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
connect.Close();
if (textBoxUserID.Text == "1111" && textBoxUserPassword.Text == "henry1234")
{
MessageBox.Show("Login Successful!");
this.Hide();
ManagerForm mis = new ManagerForm();
mis.Show();
}
else if (textBoxUserID.Text == "1112" && textBoxUserPassword.Text == "thomas1234")
{
MessageBox.Show("Login Successful!");
this.Hide();
SalesManager smf = new SalesManager();
smf.Show();
}
/*else if (textBoxUserID.Text == "4000" && textBoxUserPassword.Text == "kim4000")
* {
* MessageBox.Show("Login Successful!");
* this.Hide();
* AccountantForm af = new AccountantForm();
* af.Show();
* }*/
else if (textBoxUserID.Text == "1113" && textBoxUserPassword.Text == "peter1234")
{
MessageBox.Show("Login Successful!");
this.Hide();
InventoryForm mf = new InventoryForm();
mf.Show();
}
else if (textBoxUserID.Text == "1114" && textBoxUserPassword.Text == "mary1234")
{
MessageBox.Show("Login Successful!");
this.Hide();
OrderForm of = new OrderForm();
of.Show();
}
else if (textBoxUserID.Text == "1115" && textBoxUserPassword.Text == "jennifer1234")
{
MessageBox.Show("Login Successful!");
this.Hide();
OrderForm of = new OrderForm();
of.Show();
}
else
{
MessageBox.Show("UserId or Password invalid!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
MessageBox.Show(UtilityDB.ConnectDB().State.ToString(), "Database Connected");
}
private void Change_Click(object sender, EventArgs e)
{
if (UsId.Text == "")
{
Hintuser.Text = "Please enter user id";
}
else if (ePassword.Text == "")
{
hintpassword.Text = "Please enter existing password";
;
}
else if (nPassword.Text == "")
{
hintnew.Text = "Please enter new password";
}
else if (confirm.Text == "")
{
hint.Text = "Please enter new password";
}
else if (nPassword.Text == confirm.Text)
{
try
{
SqlConnection connDB = UtilityDB.ConnectDB();
SqlCommand cmd = new SqlCommand();
cmd.Connection = connDB;
cmd.CommandText = "Select * from Login where LoginId=@UserId and Password=@password";
cmd.Parameters.AddWithValue("@UserId", UsId.Text);
cmd.Parameters.AddWithValue("@password", ePassword.Text);
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
connDB.Close();
int count = ds.Tables[0].Rows.Count;
//If count is equal to 1, than show select form
if (count == 1)
{
Login log = new Login();
log.UserId = Convert.ToInt32(UsId.Text.Trim());
log.Password = nPassword.Text.Trim();
log.UpdateLogin(log);
MessageBox.Show("Password updated successfully!", "Update Password", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Password Change Failed! Wrong Credentials");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
hint.Text = "New Password and Confirm Password should be same";
}
}
//button search
protected void ButtonSearch_Click(object sender, EventArgs e)
{
if (TextBoxSearch.Text == "")
{
MessageBox.Show("Search input can't be empty!", "error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
switch (Convert.ToInt32(DropDownList1.SelectedIndex))
{
case 1:
Label1.Visible = false;
int SearchId = Convert.ToInt32(TextBoxSearch.Text.Trim());
SqlConnection conn = UtilityDB.ConnectDB();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Select * From Appartments where AppartmentId = @AppartmentId";
cmd.Parameters.AddWithValue("@AppartmentId", SearchId);
SqlDataReader reader = cmd.ExecuteReader();
listapp = app.SearchAppartments(reader);
if (listapp != null)
{
GridViewEmployee.DataSource = listapp;
GridViewEmployee.DataBind();
GridViewEmployee.Visible = true;
}
else
{
GridViewEmployee.DataSource = null;
GridViewEmployee.DataBind();
MessageBox.Show("Appartment not found !", "Message",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
break;
case 2:
SearchId = Convert.ToInt32(TextBoxSearch.Text.Trim());
conn = UtilityDB.ConnectDB();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Select * From Appartments where NumberOfRoom = @NumberOfRoom";
cmd.Parameters.AddWithValue("@NumberOfRoom", SearchId);
reader = cmd.ExecuteReader();
listapp = app.SearchAppartments(reader);
if (listapp != null)
{
GridViewEmployee.DataSource = listapp;
GridViewEmployee.DataBind();
GridViewEmployee.Visible = true;
}
else
{
GridViewEmployee.DataSource = null;
GridViewEmployee.DataBind();
MessageBox.Show("Appartment not found !", "Message",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
break;
case 3:
SearchId = Convert.ToInt32(TextBoxSearch.Text.Trim());
conn = UtilityDB.ConnectDB();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Select * From Appartments where NumberOfBath = @NumberOfBath";
cmd.Parameters.AddWithValue("@NumberOfBath", SearchId);
reader = cmd.ExecuteReader();
listapp = app.SearchAppartments(reader);
if (listapp != null)
{
GridViewEmployee.DataSource = listapp;
GridViewEmployee.DataBind();
GridViewEmployee.Visible = true;
}
else
{
GridViewEmployee.DataSource = null;
GridViewEmployee.DataBind();
MessageBox.Show("Appartment not found !", "Message",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
break;
case 4:
SearchId = Convert.ToInt32(TextBoxSearch.Text.Trim());
conn = UtilityDB.ConnectDB();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Select * From Appartments where NumberOfParking = @NumberOfParking";
cmd.Parameters.AddWithValue("@NumberOfParking", SearchId);
reader = cmd.ExecuteReader();
listapp = app.SearchAppartments(reader);
if (listapp != null)
{
GridViewEmployee.DataSource = listapp;
GridViewEmployee.DataBind();
GridViewEmployee.Visible = true;
}
else
{
GridViewEmployee.DataSource = null;
GridViewEmployee.DataBind();
MessageBox.Show("Appartment not found !", "Message",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
break;
case 5:
SearchId = Convert.ToInt32(TextBoxSearch.Text.Trim());
conn = UtilityDB.ConnectDB();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Select * From Appartments where FloorNum = @FloorNum";
cmd.Parameters.AddWithValue("@FloorNum", SearchId);
reader = cmd.ExecuteReader();
listapp = app.SearchAppartments(reader);
if (listapp != null)
{
GridViewEmployee.DataSource = listapp;
GridViewEmployee.DataBind();
GridViewEmployee.Visible = true;
}
else
{
GridViewEmployee.DataSource = null;
GridViewEmployee.DataBind();
MessageBox.Show("Appartment not found !", "Message",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
break;
case 6:
Label1.Visible = true;
SearchId = Convert.ToInt32(TextBoxSearch.Text.Trim());
conn = UtilityDB.ConnectDB();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Select * From Appartments where PricePerMonth <= @PricePerMonth";
cmd.Parameters.AddWithValue("@PricePerMonth", SearchId);
reader = cmd.ExecuteReader();
listapp = app.SearchAppartments(reader);
if (listapp != null)
{
GridViewEmployee.DataSource = listapp;
GridViewEmployee.DataBind();
GridViewEmployee.Visible = true;
}
else
{
GridViewEmployee.DataSource = null;
GridViewEmployee.DataBind();
MessageBox.Show("Appartment not found !", "Message",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
break;
}
}
}
