public List <SelectListItem> Areas()
{
MultiplyingEyesEntities dbContext = new MultiplyingEyesEntities();
List <SelectListItem> ObjList = new List <SelectListItem>()
{
new SelectListItem {
Text = "--Select Area--", Value = "0"
},
};
try
{
List <Area> Area = dbContext.Areas.ToList();
foreach (var data in Area)
{
ObjList.Add(new SelectListItem
{
Text = data.Name,
Value = data.AreaId.ToString()
});
}
return(ObjList);
}
catch (Exception ex)
{
return(ObjList);
}
}
public List <SelectListItem> AreasLoad()
{
MultiplyingEyesEntities dbContext = new MultiplyingEyesEntities();
List <SelectListItem> ObjList = new List <SelectListItem>()
{
new SelectListItem {
Text = "--Select Type--", Value = "0"
},
};
//string options = "< option value = \"0\" > --Select City-- </ option >";
try
{
List <Area> Area = dbContext.Areas.ToList();
foreach (var data in Area)
{
ObjList.Add(new SelectListItem
{
Text = data.Name,
Value = data.AreaId.ToString()
});
}
return(ObjList);
}
catch (Exception ex)
{
return(ObjList);
}
}
public List <SelectListItem> DepartmentLoad()
{
MultiplyingEyesEntities dbContext = new MultiplyingEyesEntities();
List <SelectListItem> ObjList = new List <SelectListItem>()
{
new SelectListItem {
Text = "--Select Department--", Value = "0"
},
};
//string options = "< option value = \"0\" > --Select City-- </ option >";
try
{
List <Department> dept = dbContext.Departments.ToList();
foreach (var data in dept)
{
ObjList.Add(new SelectListItem
{
Text = data.Name,
Value = data.DepartmentId.ToString()
});
}
return(ObjList);
}
catch (Exception ex)
{
return(ObjList);
}
}
public List <SelectListItem> loadCategory()
{
MultiplyingEyesEntities dbContext = new MultiplyingEyesEntities();
List <SelectListItem> ObjList = new List <SelectListItem>()
{
new SelectListItem {
Text = "--Select Category", Value = "0"
},
};
//string options = "< option value = \"0\" > --Select City-- </ option >";
try
{
List <Category> Category = dbContext.Categories.ToList();
foreach (var data in Category)
{
ObjList.Add(new SelectListItem
{
Text = data.Name,
Value = data.CategoryId.ToString()
});
}
return(ObjList);
}
catch (Exception ex)
{
return(ObjList);
}
}
public bool forgetPassword(User u)
{
using (var db = new MultiplyingEyesEntities())
{
db.Users.Attach(u);
db.Entry(u).Property(x => x.Password).IsModified = true;
db.SaveChanges();
}
return(true);
}
string filePath = @"C:\Inetpub\vhosts\totaldevportal.com\me.totaldevportal.com\Assets\HelpImages\";//live db
//string mobileImagePath = "me.totaldevportal.com/Assets/HelpImages/";
//string filePath = @"F:\Ahsan\Total\Multiplying Eyes\Code\ME\ME\Assets\HelpImages\";
public HomeDAL(MultiplyingEyesEntities dbContext)
{
this.dbContext = dbContext;
}
