public JsonResult GetCountryOrder(string searchStr)
{
using (FirstDatabaseEntities db = new FirstDatabaseEntities())
{
var countries = db.countries.Where(x => x.countryname.Contains(searchStr)).ToList();
return(new JsonResult {
Data = countries, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult GetCountries()
{
using (FirstDatabaseEntities db = new FirstDatabaseEntities())
{
var v = db.countries.OrderBy(a => a.countryname).ToList();
return(new JsonResult {
Data = v, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public ActionResult Autherize(LoginPage.Models.User userModel)
{
using (FirstDatabaseEntities db = new FirstDatabaseEntities())
{
var userDetails = db.Users.Where(x => x.UserName == userModel.UserName && x.password == userModel.password).FirstOrDefault();
if (userDetails == null)
{
userModel.LoginErrorMessage = "Worng username or password";
return(View("Index", userModel));
}
else
{
Session["UserID"] = userDetails.UserID;
Session["UserName"] = userDetails.UserName;
return(RedirectToAction("Index", "Home"));
}
}
}
public ActionResult GetSampleData(int page)
{
List <student1> list = new List <student1>();
using (FirstDatabaseEntities db = new FirstDatabaseEntities())
{
int totalPage = 0;
int totalRecord = 0;
int pageSize = 20;
var TableList = db.student1.ToList();
totalRecord = TableList.Count;
totalPage = (totalRecord / pageSize) + ((totalRecord % pageSize) > 0 ? 1 : 0);
list = TableList.Skip((page - 1) * pageSize).Take(pageSize).ToList();
return(new JsonResult {
Data = new { List = list, currentpage = page, totalPage = totalPage }, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult ExcelSaveData(List <string> preferredData)
{
string requiredString = string.Join("", preferredData);
ExcelViewModel[] modelCollection = JsonConvert.DeserializeObject <ExcelViewModel[]>(requiredString);
FirstDatabaseEntities db = new FirstDatabaseEntities();
foreach (var item in modelCollection)
{
TBL_Excel_File model = new TBL_Excel_File();
model.Category = item.Category;
model.Functionality = item.Functionality;
model.Description = item.Description;
model.New = item.New;
model.HelpTopic = item.HelpTopic;
db.TBL_Excel_File.Add(model);
db.SaveChanges();
}
bool status = false;
return(new JsonResult {
Data = new { status = status }
});
}
