public void UpdateVendour()
{
try
{
if (ViewState["VendourId"] == null)
{
Response.Redirect("~/login.aspx");
}
var vendourId = int.Parse(ViewState["VendourId"].ToString());
var instituionObj = _db.Vendours.FirstOrDefault(m => m.VendourId == vendourId);
instituionObj.FullName = txtFullName.Text.Trim();
instituionObj.CompanyName = txtCompany.Text.Trim();
instituionObj.Address = txtAddress.Text.Trim();
instituionObj.Phone = txtPhone.Text.Trim();
instituionObj.Email = txtEmail.Text.Trim();
instituionObj.Website = txtAccountNo.Text.Trim();
instituionObj.AccountNumber = txtAccountNo.Text.Trim();
instituionObj.AccountName = txtAccountName.Text.Trim();
instituionObj.BankName = txtBankName.Text.Trim();
instituionObj.AccountType = int.Parse(ddlAccountType.SelectedValue);
_db.SaveChanges();
ErrorControl1.ShowSuccess("Vendour Updated successfully");
divFormVend.Visible = false;
divList.Visible = true;
LoadVendour();
}
catch (Exception ex)
{
ErrorControl2.ShowError("An error occurred, please contact administrator");
}
}
public void UpdateStock()
{
try
{
if (ViewState["StockId"] == null)
{
Response.Redirect("~/login.aspx");
}
var stockId = int.Parse(ViewState["StockId"].ToString());
var stockObj = _db.Stocks.FirstOrDefault(m => m.StockID == stockId);
stockObj.Name = txtName.Value;
if (int.Parse(ddlVendor.SelectedValue) > 0)
{
stockObj.VendourId = int.Parse(ddlVendor.SelectedValue);
}
stockObj.VendourId = int.Parse(ddlVendor.SelectedValue);
stockObj.Description = txtDescription.Text;
stockObj.Code = txtBarcode.Text;
stockObj.FilePath = UploadPicture();
_db.SaveChanges();
ErrorControl1.ShowSuccess("Stock Updated successfully");
divForm.Visible = false;
divList.Visible = true;
LoadStock();
}
catch (Exception ex)
{
ErrorControl2.ShowError("An error occurred, please contact administrator");
}
}
public void SaveCategory()
{
try
{
var categoryList = _db.Categories.Where(m => m.Name.ToLower().Trim().Equals(txtName.Text.ToLower().Trim()));
if (categoryList.Any())
{
ErrorControl1.ShowError("Category name already exist");
return;
}
var categoryObj = new Category
{
Name = txtName.Text,
};
_db.Categories.Add(categoryObj);
_db.SaveChanges();
ErrorControl1.ShowSuccess("Category saved successfully");
divForm.Visible = false;
divList.Visible = true;
LoadCategory();
}
catch (Exception ex)
{
ErrorControl1.ShowError("An error occurred, Please contact administrator");
}
}
public void SaveInventory()
{
try
{
if (Session["CompanyId"] == null)
{
Response.Redirect("~/Login.aspx");
}
int companyId = int.Parse(Session["CompanyId"].ToString());
int stockId = int.Parse(ddlStock.SelectedValue);
var inventories = _db.Inventories.Where(m => m.StockId == stockId);
if (inventories.Any())
{
ErrorControl1.ShowError("Stock with the same name already exist");
return;
}
var inventObj = new Inventory
{
StockId = stockId,
CostPrice = decimal.Parse(txtCostPrice.Text),
CompanyId = companyId,
Quantity = int.Parse(txtQuantity.Text),
DateCreated = DateTime.Now,
ReorderLevel = int.Parse(txtReoderLevel.Text),
};
if (chkRequired.Checked)
{
inventObj.Permision = true;
}
else
{
inventObj.Permision = false;
}
_db.Inventories.Add(inventObj);
_db.SaveChanges();
ErrorControl1.ShowSuccess("Inventory saved successfully");
ErrorControl1.ClearControls(divForm);
}
catch (Exception ex)
{
ErrorControl1.ShowError("An error occurred, Please contact administrator");
}
}
protected async void registerUser(object sender, EventArgs e)
{
try
{
if (Session["CompanyId"] == null)
{
Response.Redirect("~/login.aspx");
}
int companyId = int.Parse(Session["CompanyId"].ToString());
var manager = new UserManager();
manager.PasswordValidator = new PasswordValidator
{
RequireNonLetterOrDigit = false,
RequireDigit = false,
RequireLowercase = false,
RequireUppercase = false,
};
var user = new ApplicationUser()
{
FullName = txtFullname.Value, Email = txtEmail.Value, PhoneNumber = txtPhone.Value, UserName = txtEmail.Value, EmailConfirmed = true, CompanyId = companyId
};
IdentityResult result = manager.Create(user, txtPassword.Value.Trim());
if (result.Succeeded)
{
manager.AddToRole(user.Id, "Staff");
await Util.SendEmail(txtPassword.Value, txtEmail.Value, txtFullname.Value);
ErrorControl1.ShowSuccess("User added successfully");
txtFullname.Value = "";
txtEmail.Value = "";
txtPhone.Value = "";
}
else
{
ErrorControl1.ShowError(result.Errors.FirstOrDefault());
}
}
catch (Exception ex)
{
ErrorControl1.ShowError(ex.Message);
}
}
public void SaveStock()
{
try
{
if (Session["CompanyId"] == null)
{
Response.Redirect("~/Login.aspx");
}
int companyId = int.Parse(Session["CompanyId"].ToString());
var stockList = _db.Stocks.Where(m => m.Name.ToLower().Trim().Equals(txtName.Value.ToLower().Trim()) && m.CompanyId == companyId);
if (stockList.Any())
{
ErrorControl1.ShowError("Stock with the same name already exist");
return;
}
var stockObj = new Stock
{
Name = txtName.Value,
CategoryId = int.Parse(ddlCategory.SelectedValue),
CompanyId = companyId,
DateCreated = DateTime.Now,
Description = txtDescription.Text,
Code = txtBarcode.Text,
};
if (int.Parse(ddlVendor.SelectedValue) > 0)
{
stockObj.VendourId = int.Parse(ddlVendor.SelectedValue);
}
if (filImage.HasFile)
{
stockObj.FilePath = UploadPicture();
}
_db.Stocks.Add(stockObj);
_db.SaveChanges();
ErrorControl1.ShowSuccess("Stock saved successfully");
ErrorControl1.ClearControls(divForm);
}
catch (Exception ex)
{
ErrorControl1.ShowError("An error occurred, Please contact administrator");
}
}
public void SaveVendour()
{
try
{
if (Session["CompanyId"] == null)
{
Response.Redirect("~/login.aspx");
}
int companyId = int.Parse(Session["CompanyId"].ToString());
var vendourList = _db.Vendours.Where(m => m.FullName.ToLower().Trim().Equals(txtFullName.Text.ToLower().Trim()));
if (vendourList.Any())
{
ErrorControl1.ShowError("Vendour name already exist");
return;
}
var vendourObj = new Vendour
{
FullName = txtFullName.Text,
CompanyName = txtCompany.Text,
Address = txtAddress.Text,
Phone = txtPhone.Text,
Email = txtEmail.Text,
Website = txtWebsite.Text,
AccountNumber = txtFullName.Text,
AccountName = txtAccountName.Text,
BankName = txtBankName.Text,
AccountType = int.Parse(ddlAccountType.SelectedValue),
CompanyId = companyId
};
_db.Vendours.Add(vendourObj);
_db.SaveChanges();
ErrorControl1.ShowSuccess("Vendour saved successfully");
divFormVend.Visible = false;
divList.Visible = true;
LoadVendour();
}
catch (Exception ex)
{
ErrorControl1.ShowError("An error occurred, Please contact administrator");
}
}
public void UpdateInventory()
{
try
{
if (ViewState["InventoryId"] == null)
{
Response.Redirect("~/login.aspx");
}
var inventoryId = int.Parse(ViewState["InventoryId"].ToString());
var inventoryObj = _db.Inventories.FirstOrDefault(m => m.InventoryId == inventoryId);
if (int.Parse(ddlStock.SelectedValue) > 0)
{
inventoryObj.StockId = (int.Parse(ddlStock.SelectedValue));
}
inventoryObj.CostPrice = decimal.Parse(txtCostPrice.Text);
inventoryObj.ReorderLevel = int.Parse(txtReoderLevel.Text);
inventoryObj.Quantity = int.Parse(txtQuantity.Text);
inventoryObj.DateCreated = DateTime.Now;
if (chkRequired.Checked)
{
inventoryObj.Permision = true;
}
else
{
inventoryObj.Permision = false;
}
_db.SaveChanges();
ErrorControl1.ShowSuccess("Stock Updated successfully");
divFormIv.Visible = false;
divList.Visible = true;
LoadStock();
}
catch (Exception ex)
{
ErrorControl2.ShowError("An error occurred, please contact administrator");
}
}
public void UpdateCategory()
{
try
{
if (ViewState["CategoryId"] == null)
{
Response.Redirect("~/login.aspx");
}
var categoryId = int.Parse(ViewState["CategoryId"].ToString());
var instituionObj = _db.Categories.FirstOrDefault(m => m.CategoryId == categoryId);
instituionObj.Name = txtName.Text;
_db.SaveChanges();
ErrorControl1.ShowSuccess("Category Updated successfully");
divForm.Visible = false;
divList.Visible = true;
LoadCategory();
}
catch (Exception ex)
{
ErrorControl2.ShowError("An error occurred, please contact administrator");
}
}
