public HttpResponseMessage Post([FromBody] UserPermission userPermission)
{
string username = Thread.CurrentPrincipal.Identity.Name;
try
{
using (InventoryDBEntities entities = new InventoryDBEntities())
{
string getUsername = username.ToLower();
var checkPermiss = entities.UserPermissions.Where(e => e.ESSUSR_Name.ToLower() == getUsername && e.Permission.ToLower() == "admin").ToList();
if (checkPermiss.Count() != 0)
{
entities.UserPermissions.Add(userPermission);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, userPermission);
message.Headers.Location = new Uri(Request.RequestUri + userPermission.ESSUSR_Name.ToString());
return(message);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "ERROR!!!!"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage LoadAllProductsByID(int ID)
{
try
{
if (ModelState.IsValid)
{
using (InventoryDBEntities inventoryDBEntities = new InventoryDBEntities())
{
var entity = inventoryDBEntities.Products.FirstOrDefault(Prod => Prod.Id == ID);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with ID =" + ID.ToString() + " not found!"));
}
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage ModifyProducts(int ID, [FromBody] Product product)
{
try
{
if (ModelState.IsValid)
{
using (InventoryDBEntities inventoryEntity = new InventoryDBEntities())
{
var entity = inventoryEntity.Products.FirstOrDefault(prod => prod.Id == ID);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with ID = " + ID.ToString() + " not found!"));
}
else
{
entity.ProductName = product.ProductName;
entity.ProductDescription = product.ProductDescription;
entity.Quantity_Available = product.Quantity_Available;
entity.Price = product.Price;
entity.Category_Id = product.Category_Id;
inventoryEntity.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IEnumerable <Category> LoadAllCategories()
{
using (InventoryDBEntities inventoryDBEntities = new InventoryDBEntities())
{
return(inventoryDBEntities.Categories.ToList());
}
}
public HttpResponseMessage Delete(string id)
{
string username = Thread.CurrentPrincipal.Identity.Name;
try
{
using (InventoryDBEntities entities = new InventoryDBEntities())
{
string getUsername = username.ToLower();
var checkPermiss = entities.UserPermissions.Where(e => e.ESSUSR_Name.ToLower() == getUsername && e.Permission.ToLower() == "admin").ToList();
var entity = entities.UserPermissions.FirstOrDefault(e => e.ESSUSR_Name == id);
if (entity == null && checkPermiss.Count() != 0)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Error with Id = " + id.ToString() + "Not Found To Delete ! "));
}
else
{
entities.UserPermissions.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage ModifyCategories(int ID, [FromBody] Category category)
{
try
{
if (ModelState.IsValid)
{
using (InventoryDBEntities inventoryEntity = new InventoryDBEntities())
{
var entity = inventoryEntity.Categories.FirstOrDefault(cat => cat.Id == ID);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Category with ID = " + ID.ToString() + " not found!"));
}
else
{
entity.Category_Name = category.Category_Name;
inventoryEntity.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
//PUT : Update the record based on id
public async Task <IHttpActionResult> PutProduct(ProductViewModel product)
{
await Task.Delay(1);
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data, please check again"));
}
using (var x = new InventoryDBEntities())
{
var checkExistingProduct = x.Products.Where(c => c.ProductID == product.ProductID)
.FirstOrDefault <Product>();
if (checkExistingProduct != null)
{
checkExistingProduct.Name = product.Name;
checkExistingProduct.Description = product.Description;
checkExistingProduct.Price = product.Price;
x.SaveChanges();
}
else
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
}
return(Ok());
}
public IEnumerable <Product> LoadAllProducts()
{
using (InventoryDBEntities inventoryDBEntities = new InventoryDBEntities())
{
return(inventoryDBEntities.Products.ToList());
}
}
public HttpResponseMessage CreateProducts([FromBody] Product product)
{
try
{
if (ModelState.IsValid)
{
using (InventoryDBEntities inventoryEntity = new InventoryDBEntities())
{
inventoryEntity.Products.Add(product);
inventoryEntity.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, product);
message.Headers.Location = new Uri(Request.RequestUri + product.Id.ToString());
return(message);
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public static bool Login(string username, string password)
{
using (InventoryDBEntities entities = new InventoryDBEntities())
{
return(entities.UserLogins.Any(user => user.ESSUSR_Name.Equals(username,
StringComparison.OrdinalIgnoreCase) && user.ESSURS_Password == password));
}
}
public Repository()
{
this.context = new InventoryDBEntities();
this.context.Database.CommandTimeout = 180;
this.context.Configuration.LazyLoadingEnabled = false;
this.context.Configuration.ProxyCreationEnabled = false;
//dbContext.Configuration.AutoDetectChangesEnabled = false;
//dbContext.Configuration.ValidateOnSaveEnabled = false;
}
public ActionResult Login()
{
InventoryDBEntities entity = new InventoryDBEntities();
UserModels.LoginUserModel model = new UserModels.LoginUserModel();
CompanySettingModels cModel = new CompanySettingModels();
var isMultiBranch = entity.S_CompanySetting.Select(c => c.IsMultiBranch);
cModel.IsMultiBranch = isMultiBranch.FirstOrDefault();
ViewBag.IsMultiBranch = cModel.IsMultiBranch;
int?firstBranchId = 0;
if (cModel.IsMultiBranch == true)
{
foreach (var branch in entity.S_Branch)
{
model.Branches.Add(new SelectListItem {
Text = branch.BranchName, Value = branch.BranchID.ToString()
});
}
for (int i = 0; i < model.Branches.Count(); i++)
{
firstBranchId = Convert.ToInt32(model.Branches[i].Value);
break;
}
if (firstBranchId.HasValue)
{
var users = (from user in entity.S_User where user.BranchID == firstBranchId.Value select user).ToList();
foreach (var user in users)
{
model.Users.Add(new SelectListItem {
Text = user.UserName, Value = user.UserID.ToString()
});
}
}
}
else
{
var users = (from user in entity.S_User select user).ToList();
foreach (var user in users)
{
model.Users.Add(new SelectListItem {
Text = user.UserName, Value = user.UserID.ToString()
});
}
}
return(View(model));
}
public HttpResponseMessage Put(string id, [FromBody] UserPermission userPermission)
{
string username = Thread.CurrentPrincipal.Identity.Name;
string getUsername = username.ToLower();
try
{
using (InventoryDBEntities entities = new InventoryDBEntities())
{
var checkPermiss = entities.UserPermissions.Where(e => e.ESSUSR_Name.ToLower() == getUsername && e.Permission.ToLower() == "user" || e.Permission.ToLower() == "manager").ToList();
var checkPermissAdmin = entities.UserPermissions.Where(e => e.ESSUSR_Name.ToLower() == getUsername && e.Permission.ToLower() == "admin").ToList();
var entity = entities.UserPermissions.FirstOrDefault(e => e.ESSUSR_Name == id);
if (entity != null && id == getUsername && checkPermiss.Count() != 0)
{
entity.EMP_EngName = userPermission.EMP_EngName;
entity.EMP_Email = userPermission.EMP_Email;
entity.Position = userPermission.Position;
entity.Location = userPermission.Location;
entity.Department = userPermission.Department;
entity.SITES = userPermission.SITES;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else if (entity != null && checkPermissAdmin.Count() != 0)
{
entity.EMP_EngName = userPermission.EMP_EngName;
entity.EMP_Email = userPermission.EMP_Email;
entity.Position = userPermission.Position;
entity.Department = userPermission.Department;
entity.SITES = userPermission.SITES;
entity.Status = userPermission.Status;
entity.Permission = userPermission.Permission;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Error with Id = " + id.ToString() + "not found to update !!"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Get()
{
string username = Thread.CurrentPrincipal.Identity.Name;
using (InventoryDBEntities entities = new InventoryDBEntities())
{
string getUsername = username.ToLower();
var entity = entities.UserPermissions.Where(e => e.ESSUSR_Name.ToLower() == getUsername).ToList();
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK,
entities.UserPermissions.Where(e => e.ESSUSR_Name.ToLower() == getUsername).ToList()));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "ERROR!!!!"));
}
// return Request.CreateResponse(HttpStatusCode.OK,
// entities.UserPermissions.Where(e => e.ESSUSR_Name.ToLower() == getUsername && e.Permission.ToLower() == "admin").ToList());
/* switch (username.ToLower())
* {
* case "all":
* return Request.CreateResponse(HttpStatusCode.OK,
* entities.EmployeeInfoes.ToList());
*
*
* case "z1":
* return Request.CreateResponse(HttpStatusCode.OK,
* entities.EmployeeInfoes.Where(e => e.Position.ToLower() == "z1").ToList());
* case "z2":
* return Request.CreateResponse(HttpStatusCode.OK,
* entities.EmployeeInfoes.Where(e => e.Position.ToLower() == "z2").ToList());
* default:
* return Request.CreateErrorResponse(HttpStatusCode.BadRequest,
* "Value for position must be All, z1 or z2." + position + "is invalid.");
* }
*/
}
}
//DELETE : Delete the record based on id
public async Task <IHttpActionResult> DeleteProduct(int id)
{
await Task.Delay(1);
if (id <= 0)
{
return(BadRequest("Invalid Product ID, pls enter correct ID"));
}
using (var x = new InventoryDBEntities())
{
var product = x.Products
.Where(c => c.ProductID == id)
.FirstOrDefault();
x.Entry(product).State = System.Data.Entity.EntityState.Deleted;
x.SaveChanges();
}
return(Ok());
}
public ActionResult AdminLogin(string adminName, string adminPassword)
{
InventoryDBEntities entity = new InventoryDBEntities();
int?result = Convert.ToInt32(entity.PrcValidateAdmin(adminName, adminPassword).FirstOrDefault());
switch (result.Value)
{
case 1:
Session["LoginUserName"] = adminName;
return(RedirectToAction("Index", "Home"));
case -1:
ViewBag.Message = "Invalid Admin.";
break;
default: break;
}
return(View());
}
//POST : Insert new record
public async Task <IHttpActionResult> PostNewProduct(ProductViewModel product)
{
await Task.Delay(1);
if (!ModelState.IsValid)
{
return(BadRequest("INVALID! Pls check"));
}
using (var x = new InventoryDBEntities())
{
x.Products.Add(new Product()
{
ProductID = product.ProductID,
Name = product.Name,
Description = product.Description,
Price = product.Price
});
x.SaveChanges();
}
return(Ok());
}
public HttpResponseMessage LoadAllCategoriesByID(int ID)
{
try
{
using (InventoryDBEntities inventoryDBEntities = new InventoryDBEntities())
{
var entity = inventoryDBEntities.Categories.FirstOrDefault(Cat => Cat.Id == ID);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Category with ID =" + ID.ToString() + " not found!"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
//GET : Retrieve data
public async Task <IHttpActionResult> GetAllProduct()
{
await Task.Delay(3000);
IList <ProductViewModel> products = null;
using (var x = new InventoryDBEntities())
{
products = x.Products
.Select(c => new ProductViewModel()
{
ProductID = c.ProductID,
Name = c.Name,
Description = c.Description,
Price = c.Price
}).ToList <ProductViewModel>();
}
if (products.Count == 0)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
return(Ok(products));
}
public HttpResponseMessage DeleteProductsByID(int ID)
{
try
{
using (InventoryDBEntities inventoryEntity = new InventoryDBEntities())
{
var entity = inventoryEntity.Products.FirstOrDefault(Prod => Prod.Id == ID);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with ID = " + ID.ToString() + " not found!"));
}
else
{
inventoryEntity.Products.Remove(entity);
inventoryEntity.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Prodcut with ID = " + ID.ToString() + " deleted"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public CategoryDb()
{
db = new InventoryDBEntities();
}
public ActionResult Login(int?branchId, int userId, string userPassword, string userName, string branchName, bool clickedLogin)
{
InventoryDBEntities entity = new InventoryDBEntities();
UserModels.LoginUserModel model = new UserModels.LoginUserModel();
CompanySettingModels cModel = new CompanySettingModels();
var isMultiBranch = entity.S_CompanySetting.Select(c => c.IsMultiBranch);
cModel.IsMultiBranch = isMultiBranch.FirstOrDefault();
ViewBag.IsMultiBranch = cModel.IsMultiBranch;
if (clickedLogin)
{
int?result = Convert.ToInt32(entity.PrcValidateUser(userId, userPassword).FirstOrDefault());
switch (result.Value)
{
case 1:
Session["LoginUserID"] = userId;
Session["LoginUserName"] = userName;
Session["LoginBranchID"] = branchId;
Session["LoginBranchName"] = branchName;
return(RedirectToAction("Index", "Home"));
case -1:
ViewBag.Message = "Password is incorrect.";
break;
default: break;
}
}
if (cModel.IsMultiBranch == true)
{
foreach (var branch in entity.S_Branch)
{
model.Branches.Add(new SelectListItem {
Text = branch.BranchName, Value = branch.BranchID.ToString()
});
}
if (branchId.HasValue)
{
var users = (from user in entity.S_User where user.BranchID == branchId.Value select user).ToList();
foreach (var user in users)
{
model.Users.Add(new SelectListItem {
Text = user.UserName, Value = user.UserID.ToString()
});
}
}
}
else
{
var users = (from user in entity.S_User select user).ToList();
foreach (var user in users)
{
model.Users.Add(new SelectListItem {
Text = user.UserName, Value = user.UserID.ToString()
});
}
}
return(View(model));
}
