// GET: /AddrBkRelation/EditDept
public ActionResult EditDept(Guid id, Guid organizationId, String orgName)
{
var contactBasisId = Utils.GetOrganizationLookUpBasisId(false);
ViewBag.orgName = orgName;
ViewBag.organizationId = organizationId;
ViewBag.MainTitle = Utils.AddrbkDepartment + " / " + orgName;
AddrBk_Relation addrbk_relation = db.AddrBk_Relation.Find(id);
AddrBk_OrganizationUnit addrbk_organizationunit = db.AddrBk_OrganizationUnit.Find(addrbk_relation.RelatedIntOrgID1);
AddrBk_Department addrbk_department = new AddrBk_Department();
addrbk_department.Addrbk_OrganizationUnit = addrbk_organizationunit;
addrbk_department.Addrbk_Relation = addrbk_relation;
addrbk_department.Lookup_AddrBks = db.Lookup_AddrBk.Where(a => a.ActiveRec == true && a.TblColSel == Utils.AB_RelationDept).ToList();
addrbk_department.Lookup_ContactTypes = db.Lookup_ContactType.Where(a => a.ActiveRec == true && a.TblColSel == Utils.AB_RelationContactType && a.ContactBasis_LCID == contactBasisId).ToList();
return PartialView("_EditDept", addrbk_department);
}
public ActionResult EditDept(AddrBk_Department addrbk_department, Guid organizationId, String orgName)
{
var contactBasisId = Utils.GetOrganizationLookUpBasisId(false);
try
{
if (addrbk_department.Addrbk_Relation.RelnToExtToIntOrg_LCID == null || addrbk_department.Addrbk_Relation.RelnToExtToIntOrg_LCID == Guid.Empty)
throw new Exception();
AddrBk_OrganizationUnit addrbk_organization_unit = addrbk_department.Addrbk_OrganizationUnit;
AddrBk_Relation addrbk_relation = addrbk_department.Addrbk_Relation;
addrbk_organization_unit.LastUpdatedDt = addrbk_relation.LastUpdatedDt = DateTime.Now;
db.Entry(addrbk_organization_unit).State = EntityState.Modified;
db.SaveChanges();
db.Entry(addrbk_relation).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("IndexDept", new { organizationId = organizationId, orgName = orgName });
}
catch (DbUpdateConcurrencyException ex)
{
var entry = ex.Entries.Single();
var databaseValues = (AddrBk_Department)entry.GetDatabaseValues().ToObject();
ModelState.AddModelError(string.Empty, Utils.concurrencyMsg);
addrbk_department.Addrbk_OrganizationUnit.Concurrency = databaseValues.Addrbk_OrganizationUnit.Concurrency;
addrbk_department.Addrbk_Relation.Concurrency = databaseValues.Addrbk_Relation.Concurrency;
}
catch
{
ModelState.AddModelError(String.Empty, Utils.errorMsg);
}
ViewBag.orgName = orgName;
ViewBag.organizationId = organizationId;
ViewBag.MainTitle = Utils.AddrbkDepartment + " / " + orgName;
addrbk_department.Lookup_AddrBks = db.Lookup_AddrBk.Where(a => a.ActiveRec == true && a.TblColSel == Utils.AB_RelationDept).ToList();
addrbk_department.Lookup_ContactTypes = db.Lookup_ContactType.Where(a => a.ActiveRec == true && a.TblColSel == Utils.AB_RelationContactType && a.ContactBasis_LCID == contactBasisId).ToList();
return PartialView("_EditDept", addrbk_department);
}
public ActionResult CreateDept(AddrBk_Department addrbk_department, Guid organizationId, String orgName)
{
var contactBasisId = Utils.GetOrganizationLookUpBasisId(false);
try
{
if (addrbk_department.Addrbk_Relation.RelnToExtToIntOrg_LCID == null || addrbk_department.Addrbk_Relation.RelnToExtToIntOrg_LCID == Guid.Empty)
throw new Exception();
addrbk_department.Addrbk_OrganizationUnit.EffDt = addrbk_department.Addrbk_OrganizationUnit.LastUpdatedDt = addrbk_department.Addrbk_OrganizationUnit.CreatedDt = DateTime.Now;
addrbk_department.Addrbk_OrganizationUnit.Id = Guid.NewGuid();
addrbk_department.Addrbk_OrganizationUnit.ActiveRec = true;
addrbk_department.Addrbk_OrganizationUnit.ContactBasis_LCID = contactBasisId;
addrbk_department.Addrbk_OrganizationUnit.IsProspect = false;
db.AddrBk_OrganizationUnit.Add(addrbk_department.Addrbk_OrganizationUnit);
db.SaveChanges();
addrbk_department.Addrbk_Relation.Id = Guid.NewGuid();
addrbk_department.Addrbk_Relation.ContactBasis_LCID = contactBasisId;
addrbk_department.Addrbk_Relation.CreatedDt = addrbk_department.Addrbk_Relation.LastUpdatedDt = DateTime.Now;
addrbk_department.Addrbk_Relation.ActiveRec = true;
addrbk_department.Addrbk_Relation.PrimaryExtOrgID1 = organizationId;
addrbk_department.Addrbk_Relation.RelatedIntOrgID1 = addrbk_department.Addrbk_OrganizationUnit.Id;
db.AddrBk_Relation.Add(addrbk_department.Addrbk_Relation);
db.SaveChanges();
return RedirectToAction("IndexDept", new { organizationId = organizationId, orgName = orgName });
}
catch
{
ModelState.AddModelError(String.Empty, Utils.errorMsg);
}
ViewBag.orgName = orgName;
ViewBag.organizationId = organizationId;
ViewBag.MainTitle = Utils.AddrbkDepartment + " / " + orgName;
addrbk_department.Lookup_AddrBks = db.Lookup_AddrBk.Where(a => a.ActiveRec == true && a.TblColSel == Utils.AB_RelationDept).ToList();
addrbk_department.Lookup_ContactTypes = db.Lookup_ContactType.Where(a => a.ActiveRec == true && a.TblColSel == Utils.AB_RelationContactType && a.ContactBasis_LCID == contactBasisId).ToList();
return PartialView("_CreateDept", addrbk_department);
}