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; }