public IEnumerable <branchModel> getBranchdata(string BranchCode) { List <branchModel> getbraData = new List <branchModel>(); try { if (BranchCode != null) { int BraCode = Convert.ToInt16(BranchCode); using (AssetManagementEntities entities = new AssetManagementEntities()) { var branches = entities.asm_getBranchdata(BraCode); foreach (var bra in branches) { getbraData.Add(new branchModel { Branch_Code = bra.Branch_Code, CompanyID = bra.CompanyID, Branch_Name = bra.Branch_Name, Country = bra.Country, Contact = bra.Contact, Status = bra.Status, Actions = bra.Actions }); } } return(getbraData); } } catch (Exception e) { } return(getbraData); }
public IEnumerable <companyModel> getCompanydata(string CompanyID) { List <companyModel> getcomData = new List <companyModel>(); try { if (CompanyID != null) { int ComID = Convert.ToInt16(CompanyID); using (AssetManagementEntities entities = new AssetManagementEntities()) { var companies = entities.asm_getCompanydata(ComID); foreach (var com in companies) { getcomData.Add(new companyModel { CompanyID = com.CompanyID, Company_Code = com.Company_Code, Company_Name = com.Company_Name, Country = com.Country, Contact = com.Contact, Status = com.Status, Actions = com.Actions }); } } return(getcomData); } } catch (Exception e) { } return(getcomData); }
public IEnumerable <categoryModel> getCategorydata(string categoryCode) { List <categoryModel> getcatData = new List <categoryModel>(); try { if (categoryCode != null) { int catCode = Convert.ToInt16(categoryCode); using (AssetManagementEntities entities = new AssetManagementEntities()) { var categories = entities.asm_getCategorydata(catCode); foreach (var cat in categories) { getcatData.Add(new categoryModel { Category_Code = cat.Category_Code, BranchID = cat.BranchID, Location_Code = cat.Location_Code, Category_Name = cat.Category_Name, Actions = cat.Actions }); } } return(getcatData); } } catch (Exception e) { } return(getcatData); }
public IEnumerable <TreeData> getBranchTree(int companyId) { using (AssetManagementEntities entities = new AssetManagementEntities()) { List <TreeData> branchFilter = new List <TreeData>(); try { var branches = entities.asm_getCategoryTree(companyId); foreach (var bra in branches) { branchFilter.Add(new TreeData { id = bra.id, text = bra.text, parent = bra.parent }); } return(branchFilter); } catch (Exception e) { } return(branchFilter); } }
public IEnumerable <locationModel> getLocationdata(string locationCode) { List <locationModel> getlocData = new List <locationModel>(); try { if (locationCode != null) { int LocCode = Convert.ToInt16(locationCode); using (AssetManagementEntities entities = new AssetManagementEntities()) { var locations = entities.asm_getLocationdata1(LocCode); foreach (var locdat in locations) { getlocData.Add(new locationModel { Location_Code = locdat.Location_Code, Location_Name = locdat.Location_Name, Parent_ID = locdat.Parent_ID, CreatedOn = locdat.CreatedOn, ModifiedOn = locdat.ModifiedOn, Actions = locdat.Actions }); } } return(getlocData); } } catch (Exception e) { } return(getlocData); }
public ActionResult ListJson() { List <LocatedAssetsViewModel> model = new List <LocatedAssetsViewModel>(); AssetManagementEntities entities = new AssetManagementEntities(); try { List <AssetLocation1> assets = entities.AssetLocations1.ToList(); //muodostetaan näkymämalli tietokannan rivien pohjalta CultureInfo fiFI = new CultureInfo("fi-FI"); foreach (AssetLocation1 asset in assets) { LocatedAssetsViewModel view = new LocatedAssetsViewModel(); view.id = asset.Id; view.LocationCode = asset.AssetLocation.Code; view.LocationName = asset.AssetLocation.Name; view.AssetCode = asset.Asset.Code; view.AssetName = asset.Asset.Type + ": " + asset.Asset.Model; view.LastSeen = asset.LastSeen.Value.ToString(fiFI); model.Add(view); } } finally { entities.Dispose(); } return(Json(model, JsonRequestBehavior.AllowGet)); }
// GET: Asset/Edit/5 public ActionResult List() { List <LocatedAssetsViewModel> model = new List <LocatedAssetsViewModel>(); AssetManagementEntities entities = new AssetManagementEntities(); try { List <AssetLocations> assets = entities.AssetLocations.ToList(); //muodostetaan näkymämalli tietokannan rivien pohjalta CultureInfo fiFI = new CultureInfo("fi-FI"); foreach (AssetLocations asset in assets) { LocatedAssetsViewModel view = new LocatedAssetsViewModel(); view.Id = asset.AssetLocationId; view.LocationCode = asset.Location.Code; view.LocationName = asset.Location.Name; view.AssetCode = asset.Asset.Code; view.AssetName = asset.Asset.Type + ": " + asset.Asset.Model; view.LastSeen = asset.LastSeen.Value.ToString("dd.MM.yyyy"); //view.LastSeen = asset.LastSeen.Value.ToString("fiFI"); //[vaihtoehto] model.Add(view); } } finally { entities.Dispose(); } return(View(model)); }
public IEnumerable <TreeData> getCategoryTree(int bId) { using (AssetManagementEntities entities = new AssetManagementEntities()) { List <TreeData> categoryFilter = new List <TreeData>(); try { var catagories = entities.asm_getCategoryTree(bId); foreach (var cat in catagories) { categoryFilter.Add(new TreeData { id = cat.id, text = cat.text, parent = cat.parent }); } return(categoryFilter); } catch (Exception e) { } return(categoryFilter); } }
public IEnumerable <TreeData> getLocationTree(int bId) { using (AssetManagementEntities entities = new AssetManagementEntities()) { List <TreeData> locationFilter = new List <TreeData>(); try { var locations = entities.asm_getLocationTree(bId); foreach (var loc in locations) { locationFilter.Add(new TreeData { id = loc.id, text = loc.text, parent = loc.parent }); } return(locationFilter); } catch (Exception e) { } return(locationFilter); } }
public void AddCategory(CategoryAdditionModel cat) { using (AssetManagementEntities entities = new AssetManagementEntities()) { entities.asm_addCategory( cat.Name ); } }
public JsonResult AssignLocation() { string json = Request.InputStream.ReadToEnd(); AssetLocationModel inputData = JsonConvert.DeserializeObject <AssetLocationModel>(json); bool success = false; string error = ""; AssetManagementEntities entities = new AssetManagementEntities(); try { //haetaan ensin paikan id-numero koodin perusteella int locationId = (from l in entities.Location where l.Code == inputData.LocationCode select l.LocationId).FirstOrDefault(); //haetaan ensin laitteen id-numero koodin perusteella int assetId = (from a in entities.Asset where a.Code == inputData.AssetCode select a.AssetId).FirstOrDefault(); if ((locationId > 0) && (assetId > 0)) { //tallennetaan uusi rivi aikaleiman kanssa kantaan AssetLocations newEntry = new AssetLocations(); newEntry.LocationId = locationId; newEntry.AssetId = assetId; newEntry.LastSeen = DateTime.Now; entities.AssetLocations.Add(newEntry); entities.SaveChanges(); success = true; } } catch (Exception ex) { error = ex.GetType().Name + ": " + ex.Message; } finally { entities.Dispose(); } //palautetaan JSON-muotoinen tulos kutsujalle var result = new { success = success, error = error }; return(Json(result)); }
public ActionResult Ticket(string id, string solution) { var _context = new AssetManagementEntities(); var ticket = _context.Tickets.Find(int.Parse(id)); ticket.datecompleted = DateTime.Now; ticket.accomplishstatus = true; ticket.ticketstatus = true; ticket.solution = solution; _context.Entry(ticket).State = EntityState.Modified; _context.SaveChanges(); TempData["Success"] = "Ticket has been completed"; return(RedirectToAction("Ticket")); }
public ActionResult RenderImage(string id) { var _context = new AssetManagementEntities(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var image = _context.Employees.FirstOrDefault(x => x.employeeNumber == id); if (image == null) { return(HttpNotFound()); } return(File(image.fileBytes, image.fileType)); }
public void AddUser(userAdditionModel user) { using (AssetManagementEntities entities = new AssetManagementEntities()) { entities.asm_addUser( user.UserName, user.Password, user.firstName, user.lastName, user.Email, user.contactNumber, user.mobileNumber, user.userAddress, user.designation ); } }
public ActionResult TicketDetails(int?id) { var _context = new AssetManagementEntities(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var ticket = _context.Tickets.Find(id); var progress = _context.Progresses.Where(x => x.ticketid == ticket.ticketid); var model = new Tuple <Ticket, IEnumerable <Progress> >(ticket, progress); if (ticket == null) { return(HttpNotFound()); } return(View(model)); }
public void comment(string id, string comment) { if (id != null) { var _context = new AssetManagementEntities(); var ticket = _context.Tickets.Find(int.Parse(id)); var name = _context.Employees.Single(e => e.employeeNumber == User.Identity.Name); var progress = new Progress { ticketid = ticket.ticketid, comment = comment, date = DateTime.Now, employeeNumber = User.Identity.Name, employeeName = name.fullname }; _context.Progresses.Add(progress); _context.SaveChanges(); } }
public ActionResult Login(Authentication login) { using (AssetManagementEntities entities = new AssetManagementEntities()) { var authenticate = entities.UserAuthentication(login.username, login.password); string data = authenticate.FirstOrDefault(); if (data != "User not found !") { //HttpContext.Session["username"] = data; ////HttpContext.Current.Session.Add("__MySessionObject", data); Session["username"] = data; return(RedirectToAction("Index", "Home")); //return Redirect(Request.UrlReferrer.ToString()); } else { //return RedirectToAction("Index", "Login/Index"); ; return(Redirect(Request.UrlReferrer.ToString())); } } }
public List <Asset> Get() { using (AssetManagementEntities entities = new AssetManagementEntities()) { //AssetManagementEntities entities = new AssetManagementEntities(); IEnumerable <Asset> assets = entities.Assets.ToList(); List <AssetNumbers> ass = new List <AssetNumbers>(); foreach (var item in assets) { ass.Add(new AssetNumbers { Asset_Numbers = item.Asset_Number }); } var result = (from item in entities.Assets select item).ToList(); return(result); } }
public IEnumerable <Filter> getBranchList(int companyId) { using (AssetManagementEntities entities = new AssetManagementEntities()) { List <Filter> branchFilter = new List <Filter>(); try { var branches = entities.asm_getBranch(companyId); foreach (var branch in branches) { branchFilter.Add(new Filter { id = branch.Id, text = branch.Name }); } return(branchFilter); } catch (Exception e) { } return(branchFilter); } }
public ActionResult WriteComment(int?id, string comment) { var _context = new AssetManagementEntities(); if (id != null) { var ticket = _context.Tickets.Find(id); var name = _context.Employees.Single(e => e.employeeNumber == User.Identity.Name); var progress = new Progress { ticketid = ticket.ticketid, comment = comment, date = DateTime.Now, employeeNumber = User.Identity.Name, employeeName = name.fullname }; _context.Progresses.Add(progress); _context.SaveChanges(); return(RedirectToAction("Ticket", new { id = ticket.ticketid.ToString() })); } return(View()); }
public IEnumerable <userModel> GetUser(string Id) { List <userModel> getU = new List <userModel>(); try { if (Id != null) { int UserID = Convert.ToInt16(Id); using (AssetManagementEntities entities = new AssetManagementEntities()) { var Users = entities.asm_getUsers1(UserID); foreach (var u in Users) { getU.Add(new userModel { UserID = u.UserID, userName = u.User_Name, password = u.Password, firstName = u.First_Name, lastName = u.Last_Name, Email = u.Email, pin = u.PIN, designation = u.Designation, status = u.Status, actions = u.Actions }); } } return(getU); } } catch (Exception e) { } return(getU); }
public int AddLocation(LocationAdditionModel addLocation) { List <returnID> newID = new List <returnID>(); int ParentID = Convert.ToInt16(addLocation.Parent_ID); int BranchID = Convert.ToInt16(addLocation.Branch_ID); using (AssetManagementEntities entities = new AssetManagementEntities()) { var inserted = entities.asm_addLocation( addLocation.Location_Name, ParentID, BranchID ); foreach (var id in inserted) { newID.Add(new returnID { Id = id.Id }); } return(newID.FirstOrDefault().Id); } }
public IEnumerable <assetModel> getAssetdata(string AssetID) { List <assetModel> getassData = new List <assetModel>(); try { if (AssetID != null) { int assID = Convert.ToInt16(AssetID); using (AssetManagementEntities entities = new AssetManagementEntities()) { var Assets = entities.asm_getAssetdata(assID); foreach (var ass in Assets) { getassData.Add(new assetModel { AssetID = ass.AssetID, BranchID = ass.BranchID, Location_Code = ass.Location_Code, Category_Code = ass.Category_Code, PurchaseID = ass.PurchaseID, RFID_Tag = ass.RFID_Tag, Barcode = ass.Barcode, CreatedOn = ass.CreatedOn, Actions = ass.Actions }); } } return(getassData); } } catch (Exception e) { } return(getassData); }
public IEnumerable <Filter> getLocationList(int Id, int bId) { using (AssetManagementEntities entities = new AssetManagementEntities()) { List <Filter> locationFilter = new List <Filter>(); try { var locations = entities.asm_getLocations(Id, bId); foreach (var loc in locations) { locationFilter.Add(new Filter { id = loc.Id, text = loc.Name }); } return(locationFilter); } catch (Exception e) { } return(locationFilter); } }
public IEnumerable <Filter> getCountryList(int Id) { using (AssetManagementEntities entities = new AssetManagementEntities()) { List <Filter> countryFilter = new List <Filter>(); try { var countries = entities.asm_getCountry(Id); foreach (var con in countries) { countryFilter.Add(new Filter { id = con.Id, text = con.Name }); } return(countryFilter); } catch (Exception e) { } return(countryFilter); } }
public Repository(IDataContext context) { _context = (context as AssetManagementEntities); _dbSet = _context.Set <TEntity>(); }
public Employee GetEmployee(string id) { AssetManagementEntities ams = new AssetManagementEntities(); return(ams.Employees.Find(id)); }
public void DeleteLocation(int Id) { using (AssetManagementEntities entities = new AssetManagementEntities()) { var deleted = entities.asm_deleteLocation(Id); } }
public void userData() { using (AssetManagementEntities entities = new AssetManagementEntities()) { } }