public JsonResult GetAllOrganization()
{
var db = new AssetTrackingManagementDbContext();
var organizations = db.Organizations.ToList();
return(Json(organizations, JsonRequestBehavior.AllowGet));
}
public JsonResult GetOrganizationById(int id)
{
var db = new AssetTrackingManagementDbContext();
Organization organization = null;
organization = db.Organizations.Find(id);
return(Json(organization, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(Branch branch)
{
PartialMenuView();
ViewBag.OrganizationList = GetOrganizations();
if (ModelState.IsValid && branch != null)
{
try
{
using (var db = new AssetTrackingManagementDbContext())
{
var BranchList = new List <Branch>(db.Branches);
int BranchExist = BranchList
.Where(c => c.OrganizationId == branch.OrganizationId)
.Where(c => c.ShortName == branch.ShortName)
.Count();
if (BranchExist > 0)
{
branch.ShortName = null;
ModelState.AddModelError("ShortName",
"Short name for the branch already exists for the organization");
}
else
{
db.Branches.Add(branch);
int successCount = db.SaveChanges();
if (successCount > 0)
{
//make partial view for success msg
return(View(new Branch()));
}
}
}
}
catch (Exception exception)
{
using (var db = new AssetTrackingManagementDbContext())
{
int BranchNameExist = db.Branches.Where(c => c.Name == branch.Name).Count();
if (BranchNameExist > 0)
{
branch.Name = null;
ModelState.AddModelError("Name", "Branch name already exists");
}
}
}
}
return(View(branch));
}
public ActionResult Create(Organization organization)
{
PartialMenuView();
if (ModelState.IsValid && organization != null)
{
try
{
var db = new AssetTrackingManagementDbContext();
db.Organizations.Add(organization);
int successCount = db.SaveChanges();
if (successCount > 0)
{
// make partialView for success
return(View(new Organization()));
}
}
catch (Exception exception)
{
using (var db = new AssetTrackingManagementDbContext())
{
int NameExist = db.Organizations.Where(c => c.Name.Equals(organization.Name)).Count();
if (NameExist > 0)
{
organization.Name = null;
ModelState.AddModelError("Name", "Organization name already exists.");
}
int ShortNameExits = db.Organizations.Where(c => c.ShortName == organization.ShortName).Count();
if (ShortNameExits > 0)
{
organization.ShortName = null;
ModelState.AddModelError("ShortName", "Short name already exists");
}
}
}
}
return(View(organization));
}
private List <SelectListItem> GetOrganizations()
{
var db = new AssetTrackingManagementDbContext();
var organizationList = db.Organizations;
var organizationDropDownList = new List <SelectListItem>();
foreach (var organization in organizationList)
{
var item = new SelectListItem()
{
Text = organization.Name, Value = organization.Id.ToString()
};
organizationDropDownList.Add(item);
}
organizationDropDownList.Insert(0, new SelectListItem()
{
Text = "Select Organization", Value = string.Empty
});
return(organizationDropDownList);
}
