public ProductDetailsForExchangeFrm(SH_EXCHANGE_REQUEST_FROM_SALES anyrequet, SH_USER_ACCOUNTS anyaccount, SH_EMPLOYEES anyEmp)
{
InitializeComponent();
requet = anyrequet;
acc = anyaccount;
Memployee = anyEmp;
}
public SH_USER_ACCOUNTS getAllUsersData()
{
SH_USER_ACCOUNTS account = new SH_USER_ACCOUNTS();
try
{
DatabaseConnection conn = new DatabaseConnection();
conn.openConnection();
SqlCommand cmd = new SqlCommand("select * from SH_USER_ACCOUNTS", DatabaseConnection.mConnection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
usersList_detail.Add(new SH_USER_ACCOUNTS()
{
SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_EMP_ID = long.Parse(reader["SH_EMP_ID"].ToString()), SH_EMP_NAME = (reader["SH_EMP_NAME"].ToString()), SH_EMP_USER_NAME = reader["SH_EMP_USER_NAME"].ToString(), SH_EMP_PASSWORD = reader["SH_EMP_PASSWORD"].ToString(), SH_CREATION_DATE = DateTime.Parse(reader["SH_CREATION_DATE"].ToString())
});
}
conn.closeConnection();
return(null);
}
catch (Exception)
{
throw;
}
}
public searchinrawmaterialform(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyAccount, SH_USER_PERMISIONS anyperm)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyAccount;
mPermission = anyperm;
}
public SH_USER_PERMISIONS getUserPermission(SH_USER_ACCOUNTS acc)
{
SH_USER_PERMISIONS perm = new SH_USER_PERMISIONS();
try
{
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("select * from SH_USER_PERMISIONS", DatabaseConnection.mConnection);
// cmd.cmdandType = cmdandType.StoreaderProcedure;
// cmd.Parameters.AddWithValue("@empid", acc.SH_EMP_ID);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
perm.SH_ID = long.Parse(reader["SH_ID"].ToString());
perm.SH_ACCOUNT_ID = long.Parse(reader["SH_ACCOUNT_ID"].ToString());
perm.SH_ACCOUNT_NAME = reader["SH_ACCOUNT_NAME"].ToString();
}
myconnection.closeConnection();
return(perm);
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHIE GETTING USER PERMISSION " + ex.ToString());
}
return(null);
}
public getAllEmployeesFrm(SH_EMPLOYEES anyEmployee, SH_USER_ACCOUNTS anyAccount, SH_USER_PERMISIONS anyPermission)
{
InitializeComponent();
memployee = anyEmployee;
maccount = anyAccount;
mpermission = anyPermission;
}
public changePassword(SH_USER_ACCOUNTS acc, SH_EMPLOYEES mEmp, SH_USER_PERMISIONS anyperm)
{
InitializeComponent();
accnt = acc;
emp = mEmp;
SH_Perm = anyperm;
}
public addnewcutprintedmaterial(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyAccount, SH_USER_PERMISIONS anyPermission)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyAccount;
mPermission = anyPermission;
}
public addnewclientproductfilm(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyaccount, SH_USER_PERMISIONS anyperm)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyaccount;
mPermission = anyperm;
}
public maintenanceworkorders(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyaccount, SH_USER_PERMISIONS anypermission)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyaccount;
mPermission = anypermission;
}
public allfinishedproductsdata(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyaccount, SH_USER_PERMISIONS anyperm)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyaccount;
mPermission = anyperm;
}
public cartondividersportalform(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyAccount, SH_USER_PERMISIONS anyPerm)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyAccount;
mPermission = anyPerm;
}
public printpeelofftotalbalanceform(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyAccount, SH_USER_PERMISIONS anyPermission)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyAccount;
mPermission = anyPermission;
}
public ViewUserPermisions(SH_EMPLOYEES Memp, SH_USER_PERMISIONS anyper, SH_USER_ACCOUNTS accnt)
{
InitializeComponent();
acc = accnt;
emp = Memp;
perm = anyper;
}
public summary_receiving_information_form(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyAcount, SH_USER_PERMISIONS anyperm)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyAcount;
mPermission = anyperm;
}
public all_suppliers_data(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyAccount, SH_USER_PERMISIONS anyPerm)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyAccount;
mPermission = anyPerm;
}
public all_receiving_permission_informations(SH_EMPLOYEES anyemp , SH_USER_ACCOUNTS anyaccount , SH_USER_PERMISIONS anyparm)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyaccount;
mPermission = anyparm;
}
public addnewtwistoftype(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyaccount, SH_USER_PERMISIONS anypermission)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyaccount;
mPermission = anypermission;
}
public Display_allUsers(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyacount, SH_USER_PERMISIONS anyPerm)
{
InitializeComponent();
SH_emp = anyemp;
SH_acc = anyacount;
SH_perm = anyPerm;
}
public allproductionrequirementsforms(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyAccount, SH_USER_PERMISIONS anyPerm)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyAccount;
mPermission = anyPerm;
}
public Mainform(SH_EMPLOYEES anyEmployee, SH_USER_ACCOUNTS anyaccount, SH_USER_PERMISIONS anypermission)
{
InitializeComponent();
mEmployee = anyEmployee;
mAccount = anyaccount;
mPermission = anypermission;
}
public SH_EMPLOYEES getEmployeeData(SH_USER_ACCOUNTS acc)
{
SH_EMPLOYEES emp = new SH_EMPLOYEES();
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand com = new SqlCommand("getoneEmp", DatabaseConnection.mConnection);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@empID", acc.SH_EMP_ID);
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
emp.SH_EMPLOYEE_ADDRESS = reader["SH_EMPLOYEE_ADDRESS"].ToString();
emp.SH_EMPLOYEMENT_DATE = DateTime.Parse(reader["SH_EMPLOYEMENT_DATE"].ToString());
emp.SH_EMPLOYEE_EMAIL = reader["SH_EMPLOYEE_EMAIL"].ToString();
emp.SH_EMPLOYEE_GENDER = reader["SH_EMPLOYEE_GENDER"].ToString();
emp.SH_ID = long.Parse(reader["SH_ID"].ToString());
emp.SH_EMPLOYEE_NAME = reader["SH_EMPLOYEE_NAME"].ToString();
emp.SH_EMPLOYEE_NATIONAL_ID = reader["SH_EMPLOYEE_NATIONAL_ID"].ToString();
}
myconnection.closeConnection();
return(emp);
}
public addnewplasticcoverform(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyaccount, SH_USER_PERMISIONS anyPerm)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyaccount;
mPermission = anyPerm;
}
public AddNewDepartment(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyaccount, SH_USER_PERMISIONS anypermission)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyaccount;
mPermission = anypermission;
}
public printfinishedcanstotalbalanceform(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyaacount, SH_USER_PERMISIONS anyperm)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyaacount;
mPermission = anyperm;
}
public woodenfacepotalform(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyAccount, SH_USER_PERMISIONS anyPerm)
{
InitializeComponent();
mEmployee = anyemp;
mAccount = anyAccount;
mPermission = anyPerm;
}
public SH_USER_PERMISIONS getUserPermission(SH_USER_ACCOUNTS acc)
{
SH_USER_PERMISIONS perm = new SH_USER_PERMISIONS();
try
{
DatabaseConnection conn = new DatabaseConnection();
conn.openConnection();
SqlCommand com2 = new SqlCommand("getpermissionOneEmp", DatabaseConnection.mConnection);
com2.CommandType = CommandType.StoredProcedure;
//problem
com2.Parameters.AddWithValue("@empid", acc.SH_ID);
SqlDataReader red = com2.ExecuteReader();
while (red.Read())
{
perm.SH_ID = long.Parse(red["SH_ID"].ToString());
perm.SH_ACCOUNT_ID = long.Parse(red["SH_ACCOUNT_ID"].ToString());
perm.SH_ACCOUNT_NAME = red["SH_ACCOUNT_NAME"].ToString();
}
conn.closeConnection();
return(perm);
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHIE GETTING USER PERMISSION " + ex.ToString());
}
return(null);
}
public addSupplierCompanyContacts(SH_SUPPLY_COMPANY comp, SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyAccount, SH_USER_PERMISIONS anyPermission)
{
InitializeComponent();
Mcompany = comp;
mEmployees = anyemp;
mAccounts = anyAccount;
mPermissions = anyPermission;
}
public RegistEmp(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyaccount, SH_USER_PERMISIONS anyperm)
{
InitializeComponent();
DefaultImage = pbxImage.Image;
memployee = anyemp;
maccount = anyaccount;
mpermission = anyperm;
}
public add_new_client_company_btn(SH_CLIENT_COMPANY anycompany, SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyaccount, SH_USER_PERMISIONS anyperm)
{
InitializeComponent();
mclient = anycompany;
mEmployee = anyemp;
mAccount = anyaccount;
mPermission = anyperm;
}
public add_new_supply_company_form(SH_EMPLOYEES anyemp, SH_USER_ACCOUNTS anyAccount, SH_USER_PERMISIONS anyperm)
{
InitializeComponent();
mPermission = anyperm;
mAccount = anyAccount;
mPermission = anyperm;
mEmployee = anyemp;
}
