public ActionResult Save(Organization emp)
{
bool status = false;
if (ModelState.IsValid)
{
using (OdoEntities dc = new OdoEntities())
{
if (emp.OrganizationId > 0)
{
//Edit
var v = dc.Organizations.Where(a => a.OrganizationId == emp.OrganizationId).FirstOrDefault();
if (v != null)
{
v.Name = emp.Name;
v.Address = emp.Address;
}
}
else
{
//Save
dc.Organizations.Add(emp);
}
dc.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult Delete(string organizationId)
{
bool status = false;
using (OdoEntities oe = new OdoEntities())
{
int temp;
if (int.TryParse(organizationId, out temp))
{
var organizationobject = oe.Organizations.Where(a => a.OrganizationId == temp).FirstOrDefault();
if (organizationobject != null)
{
oe.Organizations.Remove(organizationobject);
}
oe.SaveChanges();
status = true;
}
}
if (status)
{
return(View("Index"));
}
else
{
return(Json("Somethig went wrong !", JsonRequestBehavior.AllowGet));
}
}
public ActionResult Save(int id)
{
using (OdoEntities oe = new OdoEntities())
{
var organizationObject = oe.Organizations.Where(org => org.OrganizationId == id).FirstOrDefault();
return(View(organizationObject));
}
}
public ActionResult Save(int id)
{
using (OdoEntities oe = new OdoEntities())
{
var userObject = oe.Users.Where(a => a.UserId == id).FirstOrDefault();
return(View());
}
}
public ActionResult GetOrganizations()
{
List <Organization> organizationList;
using (OdoEntities oe = new OdoEntities())
{
organizationList = oe.Organizations.OrderBy(a => a.OrganizationId).ToList();
}
return(Json(organizationList, JsonRequestBehavior.AllowGet));
}
public ActionResult GetUsers()
{
List <User> users = null;
using (OdoEntities oe = new OdoEntities())
{
users = oe.Users.OrderBy(a => a.UserId).ToList();
}
return(Json(users, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(Organization org)
{
using (OdoEntities oe = new OdoEntities())
{
var organizationObject = oe.Organizations.Where(a => a.OrganizationId == org.OrganizationId).FirstOrDefault();
if (organizationObject != null)
{
organizationObject.Name = org.Name;
organizationObject.Address = org.Address;
}
oe.SaveChanges();
}
return(View("index"));
}
public ActionResult Delete(string userid)
{
int temp = 0;
if (int.TryParse(userid, out temp))
{
using (OdoEntities oe = new OdoEntities())
{
var userobject = oe.Users.Where(a => a.UserId == temp).FirstOrDefault();
oe.Users.Remove(userobject);
oe.SaveChanges();
}
}
return(View("index"));
}
public ActionResult Save(User usr)
{
using (OdoEntities oe = new OdoEntities())
{
if (usr.UserId > 0)
{
var UserObject = oe.Users.Where(a => a.UserId == usr.UserId).FirstOrDefault();
UserObject.FirstName = usr.FirstName;
UserObject.LastName = usr.LastName;
UserObject.Email = usr.Email;
UserObject.Address = usr.Address;
UserObject.LastActive = usr.LastActive;
}
else
{
oe.Users.Add(usr);
}
oe.SaveChanges();
}
return(View("index"));
}
