public string UpdateUser(SignUp log)
{
if (log != null)
{
using (LogDatabaseEntities1 dataContext = new LogDatabaseEntities1())
{
int no = Convert.ToInt32(log.Id);
var logList = dataContext.SignUps.Where(x => x.Id == no).FirstOrDefault();
//logList.Id = log.Id;
logList.FirstName = log.FirstName;
logList.LastName = log.LastName;
logList.UserName = log.UserName;
logList.Email = log.Email;
logList.MobileNo = log.MobileNo;
logList.Password = log.Password;
logList.Sex = log.Sex;
logList.DateOfBirth = log.DateOfBirth;
dataContext.SaveChanges();
return("User Updated");
}
}
else
{
return("Invalid User");
}
}
public JsonResult getAll()
{
using (LogDatabaseEntities1 dataContext = new LogDatabaseEntities1())
{
var logList = dataContext.SignUps.ToList();
return(Json(logList, JsonRequestBehavior.AllowGet));
}
}
public JsonResult getUserId(string getId)
{
using (LogDatabaseEntities1 dataContext = new LogDatabaseEntities1())
{
int no = Convert.ToInt32(getId);
var logList = dataContext.SignUps.Find(no);
return(Json(logList, JsonRequestBehavior.AllowGet));
}
}
public string AddUser(SignUp log)
{
if (log != null)
{
using (LogDatabaseEntities1 dataContext = new LogDatabaseEntities1())
{
dataContext.SignUps.Add(log);
dataContext.SaveChanges();
return("User Added");
}
}
else
{
return("Invalid User");
}
}
public string DeleteUser(SignUp log)
{
if (log != null)
{
using (LogDatabaseEntities1 dataContext = new LogDatabaseEntities1())
{
int no = Convert.ToInt32(log.Id);
var UserList = dataContext.SignUps.Where(x => x.Id == no).FirstOrDefault();
dataContext.SignUps.Remove(UserList);
dataContext.SaveChanges();
return("User Deleted");
}
}
else
{
return("Invalid User");
}
}
