public JsonResult UpdateUserIMS(CreateUserEditIMSModel createUserModel)
{
string message = "";
if (ModelState.IsValid)
{
using (var context = new INVENTORYEntities())
{
AdminRegister adminRegisterWBS = new AdminRegister();
//int UserID = adminRegisterWBS.UserId;
adminRegisterWBS.UserId = createUserModel.UserId;
adminRegisterWBS.UserName = createUserModel.UserName;
adminRegisterWBS.Email = createUserModel.Email;
adminRegisterWBS.Password = createUserModel.Password;
adminRegisterWBS.RetypePassword = createUserModel.RetypePassword;
context.Entry(adminRegisterWBS).State = System.Data.Entity.EntityState.Modified;
//context.AssetDetails.Add(assetNameKey);
context.SaveChanges();
message = "User Name " + "<b>" + createUserModel.UserName + "</b>" + " Updated Successfully";
}
}
return(Json(new { message = message }, JsonRequestBehavior.AllowGet));
}
//public string UniqueDetailsAssets(AssetDetailsFileIdModel assetDetailsModel)
//{
// using (var context = new INVENTORYEntities())
// {
// AssetID assetID = new AssetID();
// assetID.emp_id = assetDetailsModel._EmpId;
// assetID.assetid1 = assetDetailsModel._AssetId;//unique asset id add to ASSETID TABLE
// // byte[] uploadedFile = new byte[assetDetailsModel.UploadAgreement.InputStream.Length];
// // assetDetailsModel.UploadAgreement.InputStream.Read(uploadedFile, 0, uploadedFile.Length);
// // assetID.ContentType = uploadedFile;//FILE UPLOAD AS VARBINARY MAX IN ASSSETID TABLE
// //string fileName = Path.GetFileName(assetDetailsModel.UploadAgreement.FileName);
// //assetID.filename1 = fileName;//FILE NAME IN ASSETID TABLE
// //string fullpath = "~/Agreement_Files/";
// //assetDetailsModel.FullPath = fullpath + fileName;
// //assetID.filePath = assetDetailsModel.FullPath;//FULL PATH ADD IN ASSETID TABLE
// context.AssetID.Add(assetID);//ADD TO TABLE
// context.SaveChanges();//SAVE CHANGES IN TABLE
// return assetID.emp_id;
// }
//}
public string AddNewAsset(AssetDetailsModel assetDetailsModel)
{
using (var context = new INVENTORYEntities())
{
AssetDetails assetNameKey = new AssetDetails();
assetNameKey.emp_id = assetDetailsModel.EmpId;
//assetNameKey.asset_id = assetDetailsModel.AssetId;
assetNameKey.asset_id_sub = assetDetailsModel.AssetId_unique;
assetNameKey.asset_name = assetDetailsModel.AssetName;
assetNameKey.serial_no = assetDetailsModel.SerialNo;
assetNameKey.ip_address = assetDetailsModel.IpAddress;
assetNameKey.mac_address = assetDetailsModel.MacAddress;
assetNameKey.Processor = assetDetailsModel.Processor;
assetNameKey.hdd = assetDetailsModel.HDD;
assetNameKey.ram = assetDetailsModel.RAM;
assetNameKey.warranty_start = assetDetailsModel.WarrantyStart;
assetNameKey.warranty_end = assetDetailsModel.WarrantyEnd;
assetNameKey.Dateofissue = assetDetailsModel.DateOfIssue;
context.AssetDetails.Add(assetNameKey);
context.SaveChanges();
return(assetNameKey.emp_id);
}
}
public JsonResult ShowEmployeeAssets1(string EmployeeId)
{
using (var context = new INVENTORYEntities())
{
var GetDetails = (from user in context.UserGmda
join asset in context.AssetDetails on user.emp_id equals asset.emp_id
into t
from rt in t
where rt.emp_id == EmployeeId
select new
{
rt.emp_id,
rt.asset_id_sub,
rt.asset_name,
rt.Dateofissue,
rt.hdd,
rt.ram,
rt.serial_no,
rt.warranty_start,
rt.warranty_end,
rt.ip_address,
rt.mac_address,
user.email,
user.department,
user.designation,
user.DOB,
user.DOJ,
user.emp_name
}).ToList();
return(Json(GetDetails, JsonRequestBehavior.AllowGet));
}
}
public JsonResult EditAssetDetails(AssetDetailsModel_Edit assetDetailsModel)
{
string message = "";
if (ModelState.IsValid)
{
using (var context = new INVENTORYEntities())
{
AssetDetails assetNameKey = new AssetDetails();
assetNameKey.emp_id = assetDetailsModel.EmpId;
assetNameKey.asset_id_sub = assetDetailsModel.AssetId_unique;
assetNameKey.asset_name = assetDetailsModel.AssetName;
assetNameKey.serial_no = assetDetailsModel.SerialNo;
assetNameKey.ip_address = assetDetailsModel.IpAddress;
assetNameKey.mac_address = assetDetailsModel.MacAddress;
assetNameKey.Processor = assetDetailsModel.Processor;
assetNameKey.hdd = assetDetailsModel.HDD;
assetNameKey.ram = assetDetailsModel.RAM;
assetNameKey.warranty_start = assetDetailsModel.WarrantyStart;
assetNameKey.warranty_end = assetDetailsModel.WarrantyEnd;
assetNameKey.Dateofissue = assetDetailsModel.DateOfIssue;
context.Entry(assetNameKey).State = System.Data.Entity.EntityState.Modified;
//context.AssetDetails.Add(assetNameKey);
context.SaveChanges();
message = "Asset ID " + "<b>" + assetDetailsModel.AssetId_unique + "</b>" + " Updated Successfully";
}
}
return(Json(new { message = message }, JsonRequestBehavior.AllowGet));
}
public int AddWaterDetailsModel(WaterBoostingInventory waterBoosting)
{
using (var context = new INVENTORYEntities())
{
WaterPumpAssetDetails waterAssetDetailsTable = new WaterPumpAssetDetails();
waterAssetDetailsTable.id = waterBoosting.Id;
//assetNameKey.asset_id = assetDetailsModel.AssetId;
waterAssetDetailsTable.location = waterBoosting.Location;
waterAssetDetailsTable.itemType = waterBoosting.ItemType;
waterAssetDetailsTable.category = waterBoosting.Category;
waterAssetDetailsTable.itemName = waterBoosting.ItemName;
waterAssetDetailsTable.pumphousename = waterBoosting.PumpHouseName;
waterAssetDetailsTable.pumphouseWTP = waterBoosting.PumpHouseWTP;
waterAssetDetailsTable.pumpreferencename = waterBoosting.PumpReferenceName;
waterAssetDetailsTable.reatedhead = waterBoosting.RatedHead;
waterAssetDetailsTable.retedpower = waterBoosting.RatedPower;
waterAssetDetailsTable.reatedflow = waterBoosting.RatedFlow;
waterAssetDetailsTable.typeofpump = waterBoosting.TypeOfPump;
waterAssetDetailsTable.make = waterBoosting.Make;
waterAssetDetailsTable.Quantity = waterBoosting.Quantity;
waterAssetDetailsTable.UOM = waterBoosting.UOM;
waterAssetDetailsTable.descript = waterBoosting.Description;
context.WaterPumpAssetDetails.Add(waterAssetDetailsTable);
context.SaveChanges();
return(waterAssetDetailsTable.id);
}
}
private bool ValidateUser(string Email, string Password, string UserName)
{
bool isValid = false;
using (var db = new INVENTORYEntities())
{
var User = db.AdminRegister.FirstOrDefault(u => u.Email == Email);
var ut = db.AdminRegister.FirstOrDefault(t => t.Password == User.Password);
var UN = db.AdminRegister.FirstOrDefault(user => user.UserName == User.UserName);
if (User != null)
{
if (User.Password == Password)
{
Session["Name"] = User.UserName;
Session["Email"] = User.Email;
Session["UserName"] = User.UserName;
isValid = true;
}
}
}
return(isValid);
}
public int PumpiingMachineryMotor1(PumpingMachineryMotorModel pumpingMachineryMotor)
{
using (var context = new INVENTORYEntities())
{
PumpingMachineryMotor pumpingMachinery = new PumpingMachineryMotor();
pumpingMachinery.location = pumpingMachineryMotor.Location;
pumpingMachinery.itemname = pumpingMachineryMotor.ItemName;
pumpingMachinery.BHP = pumpingMachineryMotor.BHP;
pumpingMachinery.make = pumpingMachineryMotor.Make;
pumpingMachinery.ItemType = pumpingMachineryMotor.Itemtype;
pumpingMachinery.qty = pumpingMachineryMotor.Quantity;
pumpingMachinery.discription = pumpingMachineryMotor.Description;
pumpingMachinery.status = pumpingMachineryMotor.Status;
pumpingMachinery.UserName = UserNameSessionData;
context.PumpingMachineryMotor.Add(pumpingMachinery);
context.SaveChanges();
return(pumpingMachinery.itemcode);
}
}
public JsonResult ManageUserIMSDetails()
{
using (var context = new INVENTORYEntities())
{
List <AdminRegister> GetUserDetails = context.AdminRegister.Where(x => x.location == null && x.Role == null).ToList <AdminRegister>();
//if (GetUserDetails.Count > 0)
//{
// string Location = context.AdminRegister.Where(x => x.location != null).ToList<AdminRegister>().FirstOrDefault().location;
// string Role = context.AdminRegister.Where(x => x.Role != null).ToList<AdminRegister>().FirstOrDefault().Role;
var GetDetails = (from c in GetUserDetails
select new
{
Username = c.UserName,
email = c.Email,
password = c.Password,
ConfirmPassword = c.RetypePassword,
accountCreateOn = c.AccountCreateOn,
}).ToList();
// }
return(Json(GetDetails, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetDetailsPrint1(string ErpID)
{
Repositories repository = new Repositories();
using (var context = new INVENTORYEntities())
{
var AssetDetailsList = (from g in context.UserGmda
join c in context.AssetDetails on g.emp_id equals c.emp_id
//join e in context.AssetDetails
// on c.emp_id equals e.emp_id
select new
{
EmpName = g.emp_name,
Email = g.email,
Department = g.department,
Designation = g.designation,
Mobile = g.mobile,
ErpId = c.emp_id,
// AssetId_unique=c.assetid1,
AssetId = c.asset_id_sub,
AssetName = c.asset_name,
SerialNo = c.serial_no,
// WarrantyStart=e.warranty_start.ToString(),
// WarrantyEnd = e.warranty_end.ToString(),
// Issuedate=e.Dateofissue.ToString(),
MacId = c.mac_address
}).Where(x => x.ErpId == ErpID).ToList();
//var AssetDetailsList = context.AssetNameKey
// .SqlQuery("Select * from AssetNameKey where emp_id")
// .ToList<AssetNameKey>();
return(Json(AssetDetailsList, JsonRequestBehavior.AllowGet));
}
}
public JsonResult EditGetDetails(string AssetId)
{
using (INVENTORYEntities context = new INVENTORYEntities())
{
var result = (from c in context.AssetDetails
where c.asset_id_sub == AssetId
select new
{
EmployeeId = c.emp_id,
AssetId = c.asset_id_sub,
AssetName = c.asset_name,
SerialNo = c.serial_no,
IP = c.ip_address,
HDD = c.hdd,
RAM = c.ram,
processor = c.Processor,
MAC = c.mac_address,
WarrantyStart = c.warranty_start,
WarrantyEnd = c.warranty_end,
DateOfIssue = c.Dateofissue
}).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public int CreateItem(CreateItemModel createItem)
{
using (var context = new INVENTORYEntities())
{
CreateItemTable createItemTable = new CreateItemTable();
createItemTable.id = createItem.id;
createItemTable.ItemCode = createItem.ItemCode;
createItemTable.locationzone = createItem.Location;
createItemTable.ItemType = createItem.ItemType;
createItemTable.Category = createItem.Category;
createItemTable.ItemName = createItem.ItemName;
createItemTable.Make = createItem.Make;
createItemTable.Quantity = createItem.Quantity;
createItemTable.UOM = createItem.UOM;
createItemTable.descript = createItem.Description;
createItemTable.Status = createItem.Status;
context.CreateItemTable.Add(createItemTable);
context.SaveChanges();
return(createItemTable.id);
}
}
public int PumpingMachineryPumpSet(PumpingMachineryPumpSetModel pumpingMachineryPumpSet)
{
using (var context = new INVENTORYEntities())
{
PumpingMachineryPumpset machineryPumpset = new PumpingMachineryPumpset();
machineryPumpset.location = pumpingMachineryPumpSet.Location;
machineryPumpset.itemname = pumpingMachineryPumpSet.ItemName;
machineryPumpset.SubLocation = pumpingMachineryPumpSet.SubLocation;
machineryPumpset.discharge = pumpingMachineryPumpSet.Discharge;
machineryPumpset.head = pumpingMachineryPumpSet.Head;
machineryPumpset.make = pumpingMachineryPumpSet.Make;
machineryPumpset.qty = pumpingMachineryPumpSet.Quantity;
machineryPumpset.discription = pumpingMachineryPumpSet.Description;
machineryPumpset.status = pumpingMachineryPumpSet.Status;
machineryPumpset.UserName = UserNameSessionData;
context.PumpingMachineryPumpset.Add(machineryPumpset);
context.SaveChanges();
return(machineryPumpset.itemcode);
}
}
public int Valve(ValveModel valveModel)
{
using (var context = new INVENTORYEntities())
{
Valve valve = new Valve();
valve.location = valveModel.Location;
valve.itemname = valveModel.ItemName;
valve.SubLocation = valveModel.SubLocation;
valve.valveType = valveModel.ValveType;
valve.size = valveModel.Size;
valve.make = valveModel.Make;
valve.qty = valveModel.Quantity;
// valve.status = valveModel.Status;
valve.discription = valveModel.Description;
valve.UserName = UserNameSessionData;
context.Valve.Add(valve);
context.SaveChanges();
return(valve.itemcode);
}
}
public JsonResult ShowTabletDetails()
{
using (INVENTORYEntities context = new INVENTORYEntities())
{
var result = (from c in context.UserGmda
join e in context.AssetDetails
on c.emp_id equals e.emp_id
where e.asset_name == "Tablet"
select new
{
EmployeeId = c.emp_id,
EmployeeName = c.emp_name,
AssetId = e.asset_id_sub,
Designation = c.designation,
Department = c.department,
AssetName = e.asset_name,
SerialNo = e.serial_no,
IP = e.ip_address,
Mac = e.mac_address
}).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public JsonResult AssetCountDetails()
{
using (INVENTORYEntities context = new INVENTORYEntities())
{
var countCPU = context.AssetDetails.Where(i => i.asset_name == "Desktop").Count();
return(Json(countCPU, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Login(LoginModel model)
{
using (var context = new INVENTORYEntities())
{
List <AdminRegister> GetUserDetails = context.AdminRegister.Where(x => x.Email.Equals(model.Email) && x.Password.Equals(model.Password)).ToList <AdminRegister>();
if (GetUserDetails.Count > 0)
{
string Location = context.AdminRegister.Where(x => x.Email.Equals(model.Email)).ToList <AdminRegister>().FirstOrDefault().location;
string UserName = context.AdminRegister.Where(x => x.Email.Equals(model.Email)).ToList <AdminRegister>().FirstOrDefault().UserName;
string UserType = context.AdminRegister.Where(x => x.Email.Equals(model.Email)).ToList <AdminRegister>().FirstOrDefault().Role;
Session["UserName"] = UserName;
if (Location != null && UserType != null)
{
if (UserType == "User")
{
Session["Role"] = UserType;
Session["location"] = Location;
FormsAuthentication.SetAuthCookie(UserName, false);
return(RedirectToAction("WBSAssetDetails", "WBS"));
}
else if (UserType == "Super Admin" && Location == "GMDA")
{
FormsAuthentication.SetAuthCookie(UserName, false);
return(RedirectToAction("AddDetailsAdmin", "WBSAdmin"));
}
else
{
Session["Role"] = UserType;
Session["location"] = Location;
FormsAuthentication.SetAuthCookie(UserName, false);
return(RedirectToAction("Index", "WBSAdmin"));
}
}
else if (UserType == "Super Admin" && Location == "GMDA")
{
FormsAuthentication.SetAuthCookie("Super Admin", false);
return(RedirectToAction("ManageUserIMS", "Admin"));
}
else
{
FormsAuthentication.SetAuthCookie(UserName, false);
return(RedirectToAction("Index", "Admin"));
}
}
else
{
ViewBag.Message = "User name Or password is incorrect";
ModelState.AddModelError("InvalidLogin", "User name and password is incorrect");
return(View());
}
}
}
public JsonResult AssetCountDetailsWS()
{
using (INVENTORYEntities context = new INVENTORYEntities())
{
var countWS = context.AssetDetails.Where(i => i.asset_name == "Workstation").Count();
return(Json(countWS, JsonRequestBehavior.AllowGet));
}
}
public FileResult ExportSpeardSheetAssetDetails()
{
INVENTORYEntities entities = new INVENTORYEntities();
DataTable dt = new DataTable("GmdaAssetDetails");
dt.Columns.AddRange(new DataColumn[11] {
new DataColumn("ERP Id"),
new DataColumn("Employee Name"),
new DataColumn("Departmet"),
new DataColumn("Designation"),
new DataColumn("Asset ID"),
new DataColumn("Asset Name"),
new DataColumn("Serial No"),
new DataColumn("MAC Address"),
new DataColumn("Warranty Start"),
new DataColumn("Warranty End"),
new DataColumn("Date Of Issue")
});
// var SessionLocationData = Session["location"].ToString();
var GetDetails = (from g in entities.UserGmda
join e in entities.AssetDetails
on g.emp_id equals e.emp_id
select new
{
ErpId = g.emp_id,
EmpName = g.emp_name,
Department = g.department,
Designation = g.designation,
AssetId = e.asset_id_sub,
AssetName = e.asset_name,
SerialNo = e.serial_no,
MacId = e.mac_address,
WarrantyStart = e.warranty_start.ToString(),
WarrantyEnd = e.warranty_end.ToString(),
Issuedate = e.Dateofissue.ToString(),
}).ToList();
foreach (var GetColumn in GetDetails)
{
dt.Rows.Add(GetColumn.ErpId, GetColumn.EmpName, GetColumn.Department, GetColumn.Designation, GetColumn.AssetId, GetColumn.AssetName, GetColumn.SerialNo, GetColumn.MacId, GetColumn.WarrantyStart, GetColumn.WarrantyEnd, GetColumn.Issuedate);
}
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(dt);
using (MemoryStream stream = new MemoryStream())
{
wb.SaveAs(stream);
return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "GMDA_AssetDetails.xlsx"));
}
}
}
public JsonResult AddFileDetailsSubmission(AssetDetailsFileIdModel model, HttpPostedFileBase File)
{
var result = "";
if (ModelState.IsValid)
{
// var AssetIdExist = AssetId_Exist(model._AssetId);
var EmployeeExist = Employee_Exist(model._EmpId);
var UserEmpExist = CheckEmployeeExist(model._EmpId);
if (UserEmpExist == true)
{
result = "Employee not exist in GMDA";
return(Json(new { result = result }));
}
else if (EmployeeExist == true)
{
result = "Please Add New Asset Details First !!";
return(Json(new { result = result }));
}
else if (EmployeeExist == false)
{
if (File != null || File.ContentLength > 0)
{
var FileName = Path.GetFileName(File.FileName);
var FileNameWithoutExtension = Path.GetFileNameWithoutExtension(File.FileName);
var FilePath = Path.Combine(Server.MapPath("~/App_Data/Agreement_Files/"), FileName);
File.SaveAs(FilePath);
using (var context = new INVENTORYEntities())
{
AssetID assetID = new AssetID();
assetID.emp_id = model._EmpId;
//assetID.assetid1 = model._AssetId;
assetID.filename1 = FileName;
var path = "~/App_Data/Agreement_Files/";
assetID.filePath = path + FileName;
context.AssetID.Add(assetID);//ADD TO TABLE
context.SaveChanges();
result = "Asset Added Successfully";
}
}
else
{
result = "Upload File First";
return(Json(new { result = result }, JsonRequestBehavior.AllowGet));
}
}
}
return(Json(new { result = result }, JsonRequestBehavior.AllowGet));
}
public AdminController()
{
repositories = new Repositories();
dynamic MyModel = new ExpandoObject();
using (INVENTORYEntities context = new INVENTORYEntities())
{
List <AssetNameList> list = context.AssetNameList.ToList();
ViewBag.AssetList = new SelectList(list, "AssetName", "AssetName");
}
}
public ActionResult ShowAssetDetails1()
{
using (var context = new INVENTORYEntities())
{
List <AssetDetailsModel> contentModel = context.AssetDetails.Take(15).Select(item => new AssetDetailsModel()
{
EmpId = item.emp_id,
// AssetId = item.asset_id,
AssetName = item.asset_name,
SerialNo = item.serial_no
}).ToList();
return(View(contentModel));
}
}
public int ContactUs(ContactUsDetailsModal contactUsDetailsModal)
{
using (var context = new INVENTORYEntities())
{
CONTACTUS ContactUs = new CONTACTUS();
ContactUs.FNAME = contactUsDetailsModal.FirstName;
ContactUs.LNAME = contactUsDetailsModal.LastName;
ContactUs.EMAIL = contactUsDetailsModal.Email;
ContactUs.MOBILE = contactUsDetailsModal.Mobile;
ContactUs.REMARK = contactUsDetailsModal.Description;
context.CONTACTUS.Add(ContactUs);
context.SaveChanges();
return(ContactUs.ID);
}
}
public int AddItemName(AddItemWBS addItemWBS)
{
using (var context = new INVENTORYEntities())
{
ItemListTable itemListTable = new ItemListTable();
itemListTable.ItemName = addItemWBS.ItemName;
context.ItemListTable.Add(itemListTable);
context.SaveChanges();
return(itemListTable.Id);
}
}
public int AddLocation(AddLocation addLocation)
{
using (var context = new INVENTORYEntities())
{
LocationZone locationZone = new LocationZone();
locationZone.locationZone1 = addLocation.LocationName;
context.LocationZone.Add(locationZone);
context.SaveChanges();
return(locationZone.id);
}
}
public int AdminReg(AdminRegisterModel registrationModel)
{
using (var context = new INVENTORYEntities())
{
AdminRegister adminRegister = new AdminRegister();
adminRegister.UserName = registrationModel.UserName;
adminRegister.Email = registrationModel.Email;
adminRegister.Password = registrationModel.Password;
adminRegister.RetypePassword = registrationModel.RetypePassword;
context.AdminRegister.Add(adminRegister);
context.SaveChanges();
return(adminRegister.UserId);
}
}
public JsonResult GetDetails(string EmployeeId)
{
using (INVENTORYEntities context = new INVENTORYEntities())
{
var result = (from c in context.AssetID
join e in context.AssetDetails
on c.emp_id equals e.emp_id
where c.emp_id == EmployeeId
select new
{
EmployeeId = c.emp_id,
}).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public ActionResult _ShowEmployeeAssets1()
{
using (var context = new INVENTORYEntities())
{
//List<AssetDetailsModel> EmpAssetInfo = context.AssetDetails.ToList();
List <AssetDetailsModel> List = context.AssetDetails.Select(x => new AssetDetailsModel
{
EmpId = x.emp_id,
// AssetId = x.asset_id,
AssetName = x.asset_name,
SerialNo = x.serial_no
}).ToList();
return(View(List));
}
}
public int CreateUserWBS(CreateUserModel createUserModel)
{
using (var context = new INVENTORYEntities())
{
AdminRegister adminRegister = new AdminRegister();
adminRegister.UserName = createUserModel.UserName;
adminRegister.Email = createUserModel.Email;
adminRegister.Password = createUserModel.Password;
adminRegister.RetypePassword = createUserModel.RetypePassword;
adminRegister.location = createUserModel.Location;
adminRegister.Role = createUserModel.Role;
context.AdminRegister.Add(adminRegister);
context.SaveChanges();
return(adminRegister.UserId);
}
}
public JsonResult DeleteUserWBS(string Email)
{
string message = "";
if (ModelState.IsValid)
{
using (var context = new INVENTORYEntities())
{
var GetDetails = (from c in context.AdminRegister
where c.Email == Email
select c).FirstOrDefault();
context.AdminRegister.Remove(GetDetails);
context.SaveChanges();
message = "User Name " + "<b>" + GetDetails.UserName + "</b>" + " Deleted Successfully";
}
}
return(Json(new { message = message }, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateOwnership(string AssetId, string EmployeeId)
{
var result = "";
// string message = "";
using (var context = new INVENTORYEntities())
{
var EditOwnership = context.AssetDetails.FirstOrDefault(x => x.asset_id_sub == AssetId);
EditOwnership.emp_id = EmployeeId;
context.SaveChanges();
//result = "Asset ID " + "<b>" + AssetId + "</b>" + " Transfered to " + "<b>" + EmployeeId + "</b>";
result = EditOwnership.emp_id;;
}
return(Json(new { result = result, AssetId = AssetId }, JsonRequestBehavior.AllowGet));
}
