public static void deleteUser(user u)
{
using (var context = new STOK_TAKIPEntities())
{
//get sql parameters for deleteuser procedure
var userID = new SqlParameter("@userID", u.id);
try
{
//execute deleteuser stored procedure
context.Database.ExecuteSqlCommand("exec deleteUser @userID",
userID);
MessageBox.Show("The transaction was successful!");
ucLoans.Instance = null;
ucUsers.Instance = null;
ucProduct.Instance = null;
ucRemoveProduct.Instance = null;
ucUndoProduct.Instance = null;
ucDepartmentChief.Instance = null;
}
catch
{
MessageBox.Show("There are products with this user!");
}
}
}
public static void loanToUser(loanDetail l)
{
using (var context = new STOK_TAKIPEntities())
{
//get sql parameters for addLoan procedure
var userID = new SqlParameter("@userID", l.userID);
var loanByID = new SqlParameter("@loanByID", l.loanByID);
var productID = new SqlParameter("@productID", l.productID);
var loanDate = new SqlParameter("@loanDate", l.loanDate);
var pieces = new SqlParameter("@loanPieces", l.loanPieces);
try
{
//execute addLoan stored procedure
context.Database.ExecuteSqlCommand("exec addLoan @userID , @loanByID , @productID , @loanDate, @loanPieces",
userID, loanByID, productID, loanDate, pieces);
MessageBox.Show("The transaction (Loan) was successful!");
ucLoans.Instance = null;
ucProduct.Instance = null;
ucRemoveProduct.Instance = null;
ucUndoProduct.Instance = null;
ucDepartmentChief.Instance = null;
}
catch
{
MessageBox.Show("The transaction (Loan) was failed!");
}
}
}
public static void addProduct(product p, purchase purc)
{
using (var context = new STOK_TAKIPEntities())
{
var productName = new SqlParameter("@productName", p.productName);
var productFeatures = new SqlParameter("@productFeatures", p.productFeatures);
var purchasedDate = new SqlParameter("@purchasedDate", purc.purchasedDate);
var purchasedByID = new SqlParameter("@purchasedByID", purc.purchasedByID);
var purchasedPrice = new SqlParameter("@purchasedPrice", purc.purchasePrice);
var pieces = new SqlParameter("@pieces", p.pieces);
try
{
context.Database.ExecuteSqlCommand("exec createNewProduct @productName , @productFeatures , @purchasedDate , @purchasedByID, @purchasedPrice, @pieces",
productName, productFeatures, purchasedDate, purchasedByID, purchasedPrice, pieces);
MessageBox.Show("The transaction was successful!");
ucProduct.Instance = null;
ucRemoveProduct.Instance = null;
ucLoantoUser.Instance = null;
ucEditProduct.Instance = null;
}
catch
{
MessageBox.Show("The transaction was failed!");
}
}
}
public static void editProduct(purchase purc, product p)
{
using (var context = new STOK_TAKIPEntities())
{
//get sql parameters for addLoan procedure
var productID = new SqlParameter("@productID", p.productID);
var productName = new SqlParameter("@productName", p.productName);
var productFeatures = new SqlParameter("@productFeatures", p.productFeatures);
var productPiece = new SqlParameter("@productPiece", purc.purchasePrice);
try
{
//execute addLoan stored procedure
context.Database.ExecuteSqlCommand("exec editProduct @productID , @productName , @productFeatures , @productPiece",
productID, productName, productFeatures, productPiece);
MessageBox.Show("The transaction was successful!");
ucLoans.Instance = null;
ucProduct.Instance = null;
ucRemoveProduct.Instance = null;
ucUndoProduct.Instance = null;
ucDepartmentChief.Instance = null;
}
catch
{
MessageBox.Show("The transaction was failed!");
}
}
}
public static void editUser(user u)
{
using (var context = new STOK_TAKIPEntities())
{
//get sql parameters for edituser procedure
using (MD5 md5 = MD5.Create())
{
//Hashing with MD5
string strHashedPassword = md5.Hash(u.password);
var userID = new SqlParameter("@userID", u.id);
var userName = new SqlParameter("@username", u.username);
var userPassword = new SqlParameter("@password", strHashedPassword);
try
{
//execute edituser stored procedure
context.Database.ExecuteSqlCommand("exec editUser @userID , @username , @password",
userID, userName, userPassword);
MessageBox.Show("The transaction was successful!");
ucLoans.Instance = null;
ucProduct.Instance = null;
ucRemoveProduct.Instance = null;
ucUndoProduct.Instance = null;
ucDepartmentChief.Instance = null;
}
catch
{
MessageBox.Show("The transaction was failed!");
}
}
}
}
private void ucAddUser_Load(object sender, EventArgs e)
{
// Get whole users from database
STOK_TAKIPEntities db = new STOK_TAKIPEntities();
foreach (var item in db.userTypes)
{
cbUserRole.Items.Add(item.userType1);
}
}
private void ucEditUser_Load(object sender, EventArgs e)
{
STOK_TAKIPEntities db = new STOK_TAKIPEntities();
foreach (var item in db.users)
{
cbUsers.Items.Add(item.id + "-" + item.name + " " + item.lastName);
userList.Add(item);
}
}
public ucUndoProduct()
{
InitializeComponent();
STOK_TAKIPEntities db = new STOK_TAKIPEntities();
foreach (var item in db.users)
{
cbUser.Items.Add(item.id + " - " + item.name + " " + item.lastName);
}
}
private void ucEditProduct_Load(object sender, EventArgs e)
{
STOK_TAKIPEntities db = new STOK_TAKIPEntities();
foreach (var item in db.products)
{
if (item.isAvailable == 1)
{
cbProducts.Items.Add(item.productName);
productList.Add(item);
}
}
}
private void ucUnusedProducts_Load(object sender, EventArgs e)
{
STOK_TAKIPEntities db = new STOK_TAKIPEntities();
var model = db.products.Select(m => new
{
m.productName,
m.productFeatures,
m.pieces,
m.isAvailable
}).Where(x => x.isAvailable == 0);
gridUnused.DataSource = model.ToList();
}
private void ucUsers_Load(object sender, EventArgs e)
{
using (STOK_TAKIPEntities db = new STOK_TAKIPEntities())
{
var model = db.users.Select(m => new
{
Username = m.username,
Name = m.name,
Last_Name = m.lastName,
User_Type = m.userType.userType1,
m.lastLogin
});
gridControl1.DataSource = model.ToList();
}
}
public void getData()
{
// Refresh Items After Deleted Product
cbRemoveProducts.Items.Clear();
STOK_TAKIPEntities db = new STOK_TAKIPEntities();
foreach (var item in db.products)
{
if (item.isAvailable == 1)
{
cbRemoveProducts.Items.Add(item.productName);
productList.Add(item);
}
}
}
private void cbUser_SelectedValueChanged(object sender, EventArgs e)
{
list = cbUser.SelectedItem.ToString().Split('-');
cbProducts.SelectedIndex = -1;
cbProducts.Items.Clear();
using (STOK_TAKIPEntities db = new STOK_TAKIPEntities()) {
var products = db.getLoanbyUserID3(int.Parse(list[0]));
foreach (var i in products)
{
cbProducts.Items.Add(i.Pieces + " - " + i.productName + "-" + i.productID);
lblAvailable.Text = i.Pieces.ToString();
}
}
}
public ucLoantoUser()
{
InitializeComponent();
STOK_TAKIPEntities db = new STOK_TAKIPEntities();
foreach (var item in db.users)
{
cbUser.Items.Add(item.id + " - " + item.name + " " + item.lastName);
}
foreach (var item in db.products)
{
if (item.isAvailable == 1)
{
cbProducts.Items.Add(item.productName);
productList.Add(item);
}
}
}
private void ucLoans_Load(object sender, EventArgs e)
{
ucLoantoUser.Instance = null;
//We can see registered products in here
STOK_TAKIPEntities db = new STOK_TAKIPEntities();
var model = from l in db.loanDetails
join p in db.products on l.productID equals p.productID
join u in db.users on l.userID equals u.id
where (l.loanPieces >= 1)
select new
{
p.productName,
p.productFeatures,
Who = u.name + " " + u.lastName,
l.loanDate,
How_Many = l.loanPieces
};
gridControl1.DataSource = model.ToList();
}
private void gridControl1_Load(object sender, EventArgs e)
{
using (STOK_TAKIPEntities db = new STOK_TAKIPEntities()) {
var model = from m in db.products
join purc in db.purchases on m.purchaseID equals purc.purchaseID
join u in db.users on purc.purchasedByID equals u.id
where m.isAvailable == 1
select new
{
m.productName,
m.productFeatures,
m.purchase.purchasedDate,
m.purchase.purchasePrice,
Purchased_By = u.name + " " + u.lastName,
Number = m.pieces,
In_Stock = m.purchase.isDeleted == false ? "Yes" : "No"
};
gridControl1.DataSource = model.ToList();
}
}
private void cbProducts_SelectedIndexChanged(object sender, EventArgs e)
{
string[] product = cbProducts.SelectedItem.ToString().Split('-');
STOK_TAKIPEntities db = new STOK_TAKIPEntities();
var result = productList.Find(x => x.productName == cbProducts.SelectedItem.ToString());
if (result.pieces == 0)
{
txtPiece.Visible = false;
label5.Text = "";
lblAvailable.Text = "Not available";
tableLayoutPanel1.Visible = false;
}
else
{
txtPiece.Visible = true;
label5.Text = "Piece";
lblAvailable.Text = result.pieces.ToString();
tableLayoutPanel1.Visible = true;
}
}
// Login user check
public static void checkUser(user model)
{
using (var context = new STOK_TAKIPEntities())
{
try
{
using (MD5 md5 = MD5.Create())
{
//Hashing with MD5
string strHashedPassword = md5.Hash(model.password);
using (var db = new STOK_TAKIPEntities())
{
var result = db.users.Select(s => s)
.Where(x => x.username == model.username)
.Where(x => x.password == strHashedPassword);
ucProduct.Instance = null;
ucLoans.Instance = null;
frm login = new frm();
string[] authors =
{
result.First().username,
result.First().name,
result.First().lastName,
result.First().id.ToString(),
result.First().userTypeID.ToString()
};
login.GetUser = authors;
login.ShowDialog();
return;
}
}
}
catch
{
MessageBox.Show("Username or password wrong!");
}
}
}
private void btnUndoLoan_Click(object sender, EventArgs e)
{
int oProp = cbProducts.SelectedIndex;
if (cbProducts.SelectedIndex != -1 && cbUser.SelectedIndex != -1 && txtPiece.Text != "")
{
using (var context = new STOK_TAKIPEntities())
{
string txtuserID = cbUser.SelectedItem.ToString().Split('-')[0];
string txtProductID = cbProducts.SelectedItem.ToString().Split('-')[2];
string txtpieces = txtPiece.Text;
//get sql parameters for addLoan procedure
var userID = new SqlParameter("@userID", int.Parse(txtuserID));
var productID = new SqlParameter("@productID", int.Parse(txtProductID));
var piece = new SqlParameter("@piece", int.Parse(txtpieces));
try
{
//execute addLoan stored procedure
context.Database.ExecuteSqlCommand("exec undoProduct @userID , @productID , @piece",
userID, productID, piece);
MessageBox.Show("The transaction was successful!");
txtPiece.Text = "";
ucLoans.Instance = null;
ucProduct.Instance = null;
ucLoantoUser.Instance = null;
ucRemoveProduct.Instance = null;
}
catch
{
MessageBox.Show("The transaction was failed!");
}
}
}
else
{
MessageBox.Show("You must fill in the required fields");
}
}
public static void addUser(user u)
{
using (var context = new STOK_TAKIPEntities())
{
try
{
using (MD5 md5 = MD5.Create())
{
string strHashedPassword = md5.Hash(u.password);
context.addUser(u.name, u.lastName, u.username, strHashedPassword, u.userTypeID);
ucUsers.Instance = null;
ucLoantoUser.Instance = null;
ucEditUser.Instance = null;
MessageBox.Show("User Created");
}
}
catch
{
MessageBox.Show("Something went wrong!");
}
}
}
private void btnRemoveProduct_Click(object sender, EventArgs e)
{
if (cbRemoveProducts.SelectedIndex == -1)
{
MessageBox.Show("You must fill in the required fields!");
return;
}
product p = new product();
var result = productList.Find(x => x.productName == cbRemoveProducts.SelectedItem.ToString());
try
{
using (var context2 = new STOK_TAKIPEntities())
{
//Delete Product from stored procedure
var productID = new SqlParameter("@productID", result.productID);
context2.Database.ExecuteSqlCommand("exec removeProduct @productID", productID);
MessageBox.Show("The transaction was successful!");
getData();
gridRegistered.Visible = false;
//Refresh related instance
ucProduct.Instance = null;
ucLoantoUser.Instance = null;
ucUnusedProducts.Instance = null;
cbRemoveProducts.SelectedIndex = -1;
}
}
catch (SqlException err)
{
formLogin.Instance = null;
switch (err.Number)
{
//If the product registered before
case 35100:
{
MessageBox.Show("There are users associated with this product!");
STOK_TAKIPEntities db = new STOK_TAKIPEntities();
var model = from l in db.loanDetails
join pr in db.products on l.productID equals pr.productID
join u in db.users on l.userID equals u.id
where l.loanPieces >= 1
where pr.productID == result.productID
select new
{
pr.productName,
pr.productFeatures,
Who = u.name + " " + u.lastName,
l.loanDate,
How_Many = l.loanPieces
};
gridRegistered.Visible = true;
gridRegistered.DataSource = model.ToList();
}
break;
default:
MessageBox.Show("This product is not deleting!");
throw;
}
}
}
