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())
{
}
}
