//event method for form validation and to save record
private void button1_Click(object sender, EventArgs e)
{
if (firstName_textbox.TextLength < 3 || lastName_textBox.TextLength < 3)
{
MessageBox.Show(this, "Invalid entry for name");
}
else if (username_textbox.TextLength < 3)
{
MessageBox.Show(this, "Username must be at least 3 charachters long");
}
else if ((pw_textbox.Text.Trim() != pw2_textbox.Text.Trim()) && pw_textbox.Text.Trim().Length != 0)
{
MessageBox.Show(this, "Passwords must match");
}
else
{
BusinessLayer.User user = new BusinessLayer.User()
{
User_firstname = firstName_textbox.Text,
User_lastname = lastName_textBox.Text,
User_username = username_textbox.Text,
User_password = pw_textbox.Text
};
//bject method calling
BusinessLayer.Classes.InventoryUtil utils = new BusinessLayer.Classes.InventoryUtil();
utils.createUser(user);
MessageBox.Show(this, "User created");
this.Close();
}
}
private void AddUpdate_Load(object sender, EventArgs e)
{
DataTable dtAllForms = new DataTable();
DataTable dtCat = new DataTable();
DataTable dtUser = new DataTable();
BusinessLayer.Category cat = new BusinessLayer.Category();
BusinessLayer.Forms forms = new BusinessLayer.Forms();
BusinessLayer.User user = new BusinessLayer.User();
dtUser = user.getUserPickListFName();
dtCat = cat.getCategoryPickList();
cboUser.DataSource = dtUser;
cboUser.ValueMember = "UserID";
cboUser.DisplayMember = "Fname";
cboCategory.DataSource = dtCat;
cboCategory.ValueMember = "CategoryID";
cboCategory.DisplayMember = "Descr";
dtAllForms = forms.getAllForms();
dgView.DataSource = dtAllForms;
}
private void dgvUser_SelectionChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
BusinessLayer.User user = new BusinessLayer.User();
if (dgvUser.SelectedCells.Count > 0 && frmLoaded == 1)
{
int rowIndex = dgvUser.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dgvUser.Rows[rowIndex];
int ID = Convert.ToInt32(selectedRow.Cells["UserID"].Value);
dt = user.getPersonByID(ID);
//Must use selected value
//cboAdd.Text = "";
//cboAdd.SelectedText = Convert.ToString(dt.Rows[0]["Address1"]);
cboAdd.SelectedValue = dt.Rows[0]["AddressID"];
cboType.SelectedValue = dt.Rows[0]["TypeID"];
txtFname.Text = Convert.ToString(dt.Rows[0]["FName"]);
txtLName.Text = Convert.ToString(dt.Rows[0]["LName"]);
txtPass.Text = Convert.ToString(dt.Rows[0]["Password"]);
txtUsername.Text = Convert.ToString(dt.Rows[0]["Username"]);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
DataTable dtPerson = new DataTable();
//I really want to change how this works but in the name of speed I'll fo this now...
if (Convert.ToString(txtFname.Text) == "" && Convert.ToString(txtLName.Text) == "")
{
MessageBox.Show("Please sleect a user from the list.");
}
else
{
BusinessLayer.User user = new BusinessLayer.User();
UpdateUser up = new UpdateUser();
int rowIndex = dgvUser.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dgvUser.Rows[rowIndex];
int ID = Convert.ToInt32(selectedRow.Cells["UserID"].Value);
user.updatePerson(ID, Convert.ToString(txtFname.Text), Convert.ToString(txtLName.Text), Convert.ToString(txtUsername.Text), Convert.ToString(txtPass.Text), Convert.ToInt32(cboAdd.SelectedValue), Convert.ToInt32(cboType.SelectedValue), true);
dgvUser.DataSource = user.getPersonList();
}
}
private void dgvUser_SelectionChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
BusinessLayer.User user = new BusinessLayer.User();
if (dgvUser.SelectedCells.Count > 0 && frmLoaded == 1)
{
int rowIndex = dgvUser.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dgvUser.Rows[rowIndex];
int ID = Convert.ToInt32(selectedRow.Cells["UserID"].Value);
dt = user.getPersonByID(ID);
//Must use selected value
//cboAdd.Text = "";
//cboAdd.SelectedText = Convert.ToString(dt.Rows[0]["Address1"]);
cboAdd.SelectedValue = dt.Rows[0]["AddressID"];
cboType.SelectedValue = dt.Rows[0]["TypeID"];
txtFname.Text = Convert.ToString(dt.Rows[0]["FName"]);
txtLName.Text = Convert.ToString(dt.Rows[0]["LName"]);
txtPass.Text = Convert.ToString(dt.Rows[0]["Password"]);
txtUsername.Text = Convert.ToString(dt.Rows[0]["Username"]);
}
}
private void UpdateUser_Load(object sender, EventArgs e)
{
//Use this snippet to authenticate any user.
//the role may need to be changed.
if (BusinessLayer.Auth.role != "Admin")
{
MessageBox.Show("You do not have permission to use this page.");
this.Close();
}
DataTable dtPersonType = new DataTable();
DataTable dtAddress = new DataTable();
DataTable dtPerson = new DataTable();
BusinessLayer.Address add = new BusinessLayer.Address();
BusinessLayer.PersonType pType = new BusinessLayer.PersonType();
BusinessLayer.User user = new BusinessLayer.User();
dgvUser.DataSource = user.getPersonList();
cboAdd.DataSource = add.getAllAddress();
cboAdd.DisplayMember = "Address1";
cboAdd.ValueMember = "AddressID";
cboType.DataSource = pType.getPersonTypePickList();
cboType.DisplayMember = "Descr";
cboType.ValueMember = "TypeID";
frmLoaded = 1;
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
var session = new BusinessLayer.User(filterContext.RequestContext.HttpContext.Request.Cookies["appname"]);
if (!session.IsAdminUser())
{
filterContext.Result = new RedirectToRouteResult(
new RouteValueDictionary { {"controller", "YourControllerName"}, {"action", "Index"} });
}
base.OnActionExecuting(filterContext);
}
private void btnInsert_Click(object sender, EventArgs e)
{
BusinessLayer.User user = new BusinessLayer.User();
string FName, LName, Username, Password;
int AddressID, pType;
bool Active;
FName = txtFname.Text;
LName = txtLName.Text;
Username = txtUsername.Text;
Password = txtPass.Text;
AddressID = Convert.ToInt32(cboAdd.SelectedValue);
pType = Convert.ToInt32(cboType.SelectedValue);
Active = true;
user.insertPerson(FName, LName, Username, Password, AddressID, pType, Active);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
DataTable dtPerson = new DataTable();
//I really want to change how this works but in the name of speed I'll fo this now...
if (Convert.ToString(txtFname.Text) == "" && Convert.ToString(txtLName.Text) == "")
{
MessageBox.Show("Please sleect a user from the list.");
}
else
{
BusinessLayer.User user = new BusinessLayer.User();
UpdateUser up = new UpdateUser();
int rowIndex = dgvUser.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dgvUser.Rows[rowIndex];
int ID = Convert.ToInt32(selectedRow.Cells["UserID"].Value);
user.updatePerson(ID, Convert.ToString(txtFname.Text), Convert.ToString(txtLName.Text), Convert.ToString(txtUsername.Text), Convert.ToString(txtPass.Text), Convert.ToInt32(cboAdd.SelectedValue), Convert.ToInt32(cboType.SelectedValue), true);
dgvUser.DataSource = user.getPersonList();
}
}
public ChartFragment(int layoutId, MainActivity activity, BusinessLayer.Person person, StateFragmentChart stateFragment , BusinessLayer.User user)
{
this.layoutId = layoutId;
_person = person;
_activity = activity;
_user = user;
_stateFragment = stateFragment;
}
public ChartFragment( MainActivity activity, BusinessLayer.Person person, ref StateFragmentChart stateFragment , BusinessLayer.User user)
{
this.layoutId = UI.Resource.Layout.FrgChart;
_person = person;
_activity = activity;
_user = user;
_stateFragment = stateFragment;
}
public BestellungFragment(int layoutId, MainActivity activity, BusinessLayer.Person person, StateFragmentBestellung stateFragment , BusinessLayer.User user, PermissionBundle permission)
{
//ansprechpartnern = ansprechpartnern;
_stateFragment = stateFragment;
_activity = activity;
this.layoutId = layoutId;
_person = person;
_user = user;
this.permission = permission;
}
private void UpdateUser_Load(object sender, EventArgs e)
{
//Use this snippet to authenticate any user.
//the role may need to be changed.
if (BusinessLayer.Auth.role != "Admin")
{
MessageBox.Show("You do not have permission to use this page.");
this.Close();
}
DataTable dtPersonType = new DataTable();
DataTable dtAddress = new DataTable();
DataTable dtPerson = new DataTable();
BusinessLayer.Address add = new BusinessLayer.Address();
BusinessLayer.PersonType pType = new BusinessLayer.PersonType();
BusinessLayer.User user = new BusinessLayer.User();
dgvUser.DataSource = user.getPersonList();
cboAdd.DataSource = add.getAllAddress();
cboAdd.DisplayMember = "Address1";
cboAdd.ValueMember = "AddressID";
cboType.DataSource = pType.getPersonTypePickList();
cboType.DisplayMember = "Descr";
cboType.ValueMember = "TypeID";
frmLoaded = 1;
}
public void ResetUser( BusinessLayer.User user)
{
_user = user;
if (_mainUIManager == null)
_mainUIManager = new UIManager(this);
}
