public IHttpActionResult ChangePassword([FromBody]Login login)
{
//1. Get student from DB
Login loginGetdata = new Login();
using (var ctx = new InventoryManagementDBEntities())
{
loginGetdata = ctx.Logins.Where(s => s.user_name == login.user_name).FirstOrDefault<Login>();
}
//2. change student name in disconnected mode (out of ctx scope)
if (loginGetdata != null)
{
loginGetdata.password = login.password;
}
//save modified entity using new Context
using (var dbCtx = new InventoryManagementDBEntities())
{
//3. Mark entity as modified
dbCtx.Entry(loginGetdata).State = System.Data.Entity.EntityState.Modified;
//4. call SaveChanges
dbCtx.SaveChanges();
return Ok(login);
}
}
public Boolean UpdateData(Login login)
{
//1. Get student from DB
Login loginGetdata = new Login();
using (var ctx = new InventoryManagementDBEntities())
{
loginGetdata = ctx.Logins.Where(s => s.User_ID == login.User_ID).FirstOrDefault<Login>();
}
//2. change student name in disconnected mode (out of ctx scope)
if (loginGetdata != null)
{
loginGetdata.user_name = login.user_name;
}
//save modified entity using new Context
using (var dbCtx = new InventoryManagementDBEntities())
{
//3. Mark entity as modified
dbCtx.Entry(loginGetdata).State = System.Data.Entity.EntityState.Modified;
//4. call SaveChanges
dbCtx.SaveChanges();
}
return true;
}
public Boolean GetUserName([FromUri]Login login)
{
Login loginGetdata = new Login();
using (var ctx = new InventoryManagementDBEntities())
{
loginGetdata = ctx.Logins.Where(s => s.user_name == login.user_name) .FirstOrDefault();
}
//2. change student name in disconnected mode (out of ctx scope)
if (loginGetdata != null)
{
return true;
}
else
{
return false;
}
}
public IHttpActionResult Savedata1(Login login)
{
// create new Student entity object in disconnected scenario (out of the scope of DbContext)
//var login = new Login();
//set student name
//login.Name = "testing";
//create DBContext object
using (var dbCtx = new InventoryManagementDBEntities())
{
//Add Student object into Students DBset
dbCtx.Logins.Add(login);
// call SaveChanges method to save student into database
dbCtx.SaveChanges();
}
return Ok(login);
}
public IHttpActionResult GetLoginsSucessUserID([FromUri]Login login)
{
Login loginGetdata = new Login();
using (var ctx = new InventoryManagementDBEntities())
{
loginGetdata = ctx.Logins.Where(s => s.password == login.password && s.user_name == login.user_name).FirstOrDefault();
}
//2. change student name in disconnected mode (out of ctx scope)
if (loginGetdata != null)
{
login.User_ID = loginGetdata.User_ID;
return Ok(login);
}
else
{
return Ok(login);
}
}