private void label4_Click(object sender, EventArgs e)
{
ManagerList M = new ManagerList();
M.Show();
this.Hide();
}
public void SearchMan(int s, string mname, string mpassword, string memail, string mcontact, int msalary, ManagerList m)
{
ID = s; NAME = mname; PASSWORD = mpassword; EMAIL = memail; CONTACT = mcontact; SALARY = msalary;
/* if (ID == a) {
*
* m.ErrorMassage("No data found");
* } */
// new DataAccess().SearchManager(ID,NAME,PASSWORD,EMAIL,CONTACT,SALARY,this,m);
// new DataAccess().SearchManager(s,mname, mpassword, memail, mcontact, msalary,this, m);
// new DataAccess().GetManagerData(s, mname, mpassword, memail, mcontact, msalary, m);
}
public void EditMan(int s, string mname, string mpassword, string memail, string mcontact, int msalary, ManagerList me)
{
NAME = mname; PASSWORD = mpassword; PASSWORD = mpassword; EMAIL = memail; CONTACT = mcontact; SALARY = msalary;
new DataAccess().UpdateManager(s, mname, mpassword, memail, mcontact, msalary, me);
me.ErrorMassage3("One Row Updated");
}
public void AddManager(string mname, string mpassword, string memail, string mcontact, int msalary, ManagerList M)
{
if (mname.Equals("") || mpassword.Equals("") || memail.Equals("") || mcontact.Equals("") || msalary.Equals(""))
{
M.ErrorMassage("Fill all the entries correctly");
}
else
{
NAME = mname; PASSWORD = mpassword; PASSWORD = mpassword; EMAIL = memail; CONTACT = mcontact; SALARY = msalary;
new DataAccess().NewManager(mname, mpassword, memail, mcontact, msalary, M);
}
}
public void GetManagerData(int id, string name, string pass, string email, string contNo, float sal, ManagerList MO)
{
MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Oyan Computer\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True");
var str = from a in cntx.Managers
where a.Id == id
select a;
// dataGridView1.DataSource = str;
}
public void UpdateManager(int id, string name, string pass, string email, string contNo, int sal, ManagerList MO)
{
MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Oyan Computer\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True");
var str = from a in cntx.Managers
where a.Id == id
select a;
Manager M = str.First();
M.Id = id;
M.UserName = name;
M.Password = pass;
M.Email = email;
M.ContactNo = contNo;
// M.Salary = sal;
M.Salary = sal;
cntx.SubmitChanges();
name = M.UserName;
pass = M.Password;
email = M.Email;
contNo = M.ContactNo;
sal = Convert.ToInt32(M.Salary);
cntx.SubmitChanges();
}
/* public void SearchManager(int ab,string name, string pass, string email, string contNo, int sal,AdminOperation A, ManagerList MO) {
*
*
* /* foreach (var x in list)
* {
* productName = x.Item_name;
* quantity = x.Quantity.ToString();
* categoryName = x.Category.Category_name;
* price = x.Unit_price.ToString();
* details = x.Item_description;
* sellerId = x.Seller_id.ToString();
* sellerName = x.Customer.Customer_name;
* phn = x.Customer.Phone_number;
* email = x.Customer.Email;
* country = x.Customer.Addresses.Country.Country_name;
*
* }
*
* //Manager mo = str.First();
* foreach (var a in str)
* {
* // ab = a.Id;
* name = a.UserName;
* pass = a.Password;
* email = a.Email;
* contNo = a.ContactNo;
* sal = a.Salary;
*
* }
*
*
*
* cnt.SubmitChanges();
*
* }*/
public void DeleteManager(int id, string name, string pass, string email, string contNo, float sal, ManagerList MO)
{
MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Oyan Computer\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True");
var str = from a in cntx.Managers
where a.Id == id
select a;
Manager M = str.First();
cntx.Managers.DeleteOnSubmit(M);
cntx.SubmitChanges();
}
public void NewManager(string name, string pass, string email, string contNo, int sal, ManagerList M)
{
MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\USER\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True");
Manager Man = new Manager();
People P = new People();
cntx.Managers.InsertOnSubmit(Man);
cntx.Peoples.InsertOnSubmit(P);
Man.UserName = name;
Man.Password = pass;
Man.Email = email;
Man.ContactNo = contNo;
Man.Salary = sal;
P.UserName = name;
P.password = pass;
P.UserType = "Manager";
cntx.SubmitChanges();
new ManagerList().ErrorMassage("Successfully added");
cntx.Dispose();
}