public ActionResult Add(OrganizationVM organizationVm)
{
if (organizationVm.ImageFile != null)
{
string fileName = Path.GetFileNameWithoutExtension(organizationVm.ImageFile.FileName);
string extension = Path.GetExtension(organizationVm.ImageFile.FileName);
organizationVm.ImagePath = fileName + extension;
fileName = Path.Combine(Server.MapPath("~/images/"), organizationVm.ImagePath);
organizationVm.ImageFile.SaveAs(fileName);
}
Organization organization = Mapper.Map <Organization>(organizationVm);
if (ModelState.IsValid)
{
try
{
if (_organizationManager.Add(organization))
{
TempData["success"] = "Add successfully!";
return(RedirectToAction("Add"));
}
}
catch (Exception e)
{
TempData["exception"] = "Failed to add!" + e.Message;
}
}
OrganizationVM org = new OrganizationVM()
{
Organizations = _organizationManager.GetAll()
};
return(View(org));
}
// GET: Organization
public ActionResult Add()
{
OrganizationVM organizationVm = new OrganizationVM();
organizationVm.Organizations = _organizationManager.GetAll();
return(View(organizationVm));
}
public ActionResult Edit(OrganizationVM organizationVM)
{
try
{
if (ModelState.IsValid)
{
Organization organization = new Organization();
organization.Id = organizationVM._Id;
if (organizationVM._name != null)
{
organization.name = organizationVM._name;
}
if (organizationVM._status == true)
{
organization.status = 1;
}
else
{
organization.status = 0;
}
db.Entry(organization).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(organizationVM));
}
catch
{
return(View("Error"));
}
}
public ActionResult Update(OrganizationVM organizationVm)
{
string prevName = organizationVm.PrevName;
string prevCode = organizationVm.PrevCode;
string prevContactNo = organizationVm.PrevContactNo;
if (organizationVm.ImageFile != null)
{
string fileName = Path.GetFileNameWithoutExtension(organizationVm.ImageFile.FileName);
string extension = Path.GetExtension(organizationVm.ImageFile.FileName);
organizationVm.ImagePath = fileName + extension;
fileName = Path.Combine(Server.MapPath("~/images/"), organizationVm.ImagePath);
organizationVm.ImageFile.SaveAs(fileName);
}
Organization organization = Mapper.Map <Organization>(organizationVm);
if (ModelState.IsValid)
{
try
{
_organizationManager.Update(organization, prevName, prevCode, prevContactNo);
TempData["success"] = "Updated successfully";
return(RedirectToAction("Add"));
}
catch (Exception e)
{
TempData["exception"] = e.Message;
}
}
TempData["failed"] = "Failed to Update";
return(View("Add"));
}
public static List <OrganizationVM> BuildOrganizationsTree(IEnumerable <Organization> organizations)
{
List <OrganizationVM> result = new List <OrganizationVM>();
var rootOrganizations = organizations.Where(x => x.Id == x.ParentId).ToList();
if (rootOrganizations.Count == 0)
{
return(result);
}
foreach (var org in rootOrganizations)
{
var orgVM = new OrganizationVM()
{
OrganizationID = org.Id,
OrganizationName = org.Name,
ParentID = org.ParentId,
ActiveFlag = org.ActiveFlag,
ReportDataSetID = org.ReportDataSetID
};
orgVM.hasChildren = BuildChildren(orgVM, organizations).Count > 0 ? true : false;
result.Add(orgVM);
}
return(result);
}
public bool IsOrganizationSaved(OrganizationVM itemVm)
{
Organization item = new Organization()
{
Name = itemVm.Name,
Code = itemVm.Code,
Contact = itemVm.Contact,
Address = itemVm.Address,
Image = itemVm.Image,
Date = itemVm.Date
};
dbContext.Organizations.Add(item);
var isAdded = dbContext.SaveChanges();
if (isAdded > 0)
{
return(true);
}
else
{
return(false);
}
return(false);
}
private static List <OrganizationVM> BuildChildren(OrganizationVM parent, IEnumerable <Organization> organizations)
{
List <OrganizationVM> result = new List <OrganizationVM>();
//this is the leaf
if (organizations.Where(x => x.ParentId == parent.OrganizationID && x.Id != parent.OrganizationID).Count() == 0)
{
return(new List <OrganizationVM>());
}
else
{
var children = organizations.Where(x => x.ParentId == parent.OrganizationID && x.Id != parent.OrganizationID).ToList();
foreach (var child in children)
{
var childVM = new OrganizationVM()
{
OrganizationID = child.Id,
OrganizationName = child.Name,
ParentID = child.ParentId,
ActiveFlag = child.ActiveFlag,
ReportDataSetID = child.ReportDataSetID
};
childVM.hasChildren = BuildChildren(childVM, organizations).Count > 0 ? true : false;
result.Add(childVM);
}
}
return(result);
}
public void UpdateOrganization(OrganizationVM organization)
{
if (organization == null)
{
return;
}
sampling.MemberId = organization.Id;
this.OrganizationName = organization.OrganizationName;
}
public void SelectOrganization()
{
SelectObjectWindowVM <OrganizationVM> vm = new SelectObjectWindowVM <OrganizationVM>(StudyUnit.Organizations, "OrganizationName");
SelectObjectWindow window = new SelectObjectWindow(vm);
OrganizationVM organization = SelectObjectWindow.Select(Resources.SelectMember, vm) as OrganizationVM;
if (organization != null)
{
UpdateOrganization(organization);
}
}
public ActionResult Edit(OrganizationVM itemVm)
{
if (ModelState.IsValid)
{
if (organizationDa.IsOrganizationUpdated(itemVm))
{
return(RedirectToAction("Index"));
}
}
return(View(itemVm));
}
public static object Update(OrganizationVM organizationObject, bool validateOnly)
{
try
{
organizationObject.PortalUsersID = Utils.LoggedUser.PortalUserId;
var result = organizationManager.Update(ref organizationObject, Utils.LoggedUser.UserId);
return(Utils.ServiceResponse(pageCode, result));
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ActionResult Create(OrganizationVM itemVm, HttpPostedFileBase ItemCategoryFile)
{
itemVm.Date = DateTime.Now;
itemVm.Image = imageData.ImageConvertToByte(ItemCategoryFile);
if (ModelState.IsValid)
{
if (organizationDa.IsOrganizationSaved(itemVm))
{
return(RedirectToAction("Index"));
}
}
ModelVm.Code = organizationDa.GetOrganizationCode();
return(View(ModelVm));
}
// public string Method
// {
// //Make in use of Codebook output
// get
// {
// return Option.FindLabel(samplingMethods, MethodCode);
// }
// }
public void GenerateCollector()
{
StudyUnitVM studyUnit = StudyUnit;
MemberFormVM memberForm = studyUnit.MemberForm;
if (IsCollectorTypeIndividual)
{
MemberVM newMember = memberForm.AppendMember(sampling.MemberId, this.LastName, this.FirstName, this.OrganizationName, this.Position);
UpdateIndividual(newMember);
}
else
{
OrganizationVM organization = memberForm.AppendOrganization(sampling.MemberId, this.OrganizationName);
UpdateOrganization(organization);
}
}
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ModelVm = organizationDa.FindOrganization(id);
if (ModelVm == null)
{
return(HttpNotFound());
}
return(View(ModelVm));
}
// GET: Organization/Edit/5
public ActionResult Edit(int?id)
{
try
{
int orgId = 0;
orgId = (int)id;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Organization organization = new Organization();
OrganizationVM organizationVM = new OrganizationVM();
ReturnStatus rs = Repository.GetOrganizationById(orgId);
if (rs.errorCode != 0)
{
ViewBag.status = "Sorry, something went wrong while retrieving information. System is down. If problem persists, contact Support.";
return(View());
}
organization = (Organization)rs.data;
organizationVM._Id = organization.Id;
organizationVM._name = organization.name;
if (organization.status == 1)
{
organizationVM._status = true;
}
else
{
organizationVM._status = false;
}
if (organizationVM == null)
{
return(HttpNotFound());
}
return(View(organizationVM));
}
catch
{
return(View("Error"));
}
}
public bool IsOrganizationUpdated(OrganizationVM itemVm)
{
Organization item = new Organization()
{
Id = itemVm.Id,
Name = itemVm.Name,
Code = itemVm.Code,
Contact = itemVm.Contact,
Address = itemVm.Address,
Image = itemVm.Image,
Date = itemVm.Date
};
dbContext.Entry(item).State = EntityState.Modified;
var isUpdated = dbContext.SaveChanges() > 0;
return(isUpdated);
}
public void CompleteMember()
{
foreach (SamplingVM sampling in Samplings)
{
MemberVM member = FindMember(sampling.MemberId);
if (member != null)
{
sampling.UpdateIndividual(member);
}
else
{
OrganizationVM organization = FindOrganization(sampling.MemberId);
if (organization != null)
{
sampling.UpdateOrganization(organization);
}
}
}
}
public OrganizationVM FindOrganization(long?id)
{
var item = dbContext.Organizations.Find(id);
OrganizationVM itemVm = null;
if (item != null)
{
itemVm = new OrganizationVM()
{
Name = item.Name,
Code = item.Code,
Contact = item.Contact,
Address = item.Address,
Image = item.Image,
Date = item.Date
};
}
return(itemVm);
}
//public ActionResult GetOrganizations()
//{
// return View();
//}
// GET: Organization
//public ActionResult Index()
//{
// return View(db.organizations.ToList());
//}
// GET: Organization/Details/5
public ActionResult Details(int?id)
{
try
{
int orgId = 0;
orgId = (int)id;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Organization organization = new Organization();
OrganizationVM organizationVM = new OrganizationVM();
//TODO: add error checking
organization = (Organization)Repository.GetOrganizationById(orgId).data;
organizationVM._Id = organization.Id;
organizationVM._name = organization.name;
if (organization.status == 1)
{
organizationVM._status = true;
}
else
{
organizationVM._status = false;
}
if (organizationVM == null)
{
return(HttpNotFound());
}
return(View(organizationVM));
}
catch
{
return(View("Error"));
}
}
private static void PopulateRecord(ref OrganizationDetail orgDet, OrganizationVM vm, decimal?portalUsersId)
{
if (portalUsersId.HasValue)
{
orgDet.PortalUsersID = portalUsersId.Value;
}
orgDet.OrganizationLogoPath = vm.OrganizationLogoPath;
orgDet.OrganizationSize = vm.OrganizationSize;
orgDet.CountryID = vm.CountryID;
orgDet.CityID = vm.CityID;
orgDet.ZipPostalCode = vm.ZipPostalCode;
orgDet.Telephone = vm.Telephone;
orgDet.OrganizationWebsite = vm.OrganizationWebsite;
orgDet.OrganizationProfilePath = vm.OrganizationProfilePath;
orgDet.EconomicActivity = vm.EconomicActivity;
orgDet.IndustryType = vm.IndustryType;
orgDet.YearsofExperienceID = vm.YearsofExperienceID;
orgDet.EstablishmentDate = vm.EstablishmentDate;
orgDet.RegistrationNumberWithITC = vm.RegistrationNumberWithITC;
orgDet.Is_Approved = vm.Is_Approved;
orgDet.IsDiscalaimerApproved = vm.IsDiscalaimerApproved;
}
public static object Post(OrganizationVM organizationObject, bool validateOnly)
{
try
{
var manager = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>();
manager.UserValidator = new UserValidator <ApplicationUser>(manager)
{
AllowOnlyAlphanumericUserNames = false,
RequireUniqueEmail = true
};
manager.PasswordValidator = new PasswordValidator()
{
RequiredLength = 3,
RequireNonLetterOrDigit = false,
RequireDigit = false,
RequireLowercase = false,
RequireUppercase = false
};
IdentityResult userResult;
var user = new ApplicationUser()
{
UserName = organizationObject.User.UserName, Email = organizationObject.User.Email, PhoneNumber = organizationObject.User.PhoneNumber
};
userResult = manager.Create(user, organizationObject.User.Password);
ModelResponse mr = null;
if (userResult.Succeeded)
{
var result = userManager.GetUsersAdmin();
mr = organizationManager.Post(ref organizationObject, user.Id);
}
return(Utils.ServiceResponse(pageCode, mr));
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ModelResponse Update(ref OrganizationVM vm, string userId)
{
Repo.Update(ref vm, userId);
return(new ModelResponse(0, userId));
}
public ActionResult Details(long id)
{
OrganizationVM itemVm = organizationDa.FindOrganization(id);
return(PartialView("_Details", itemVm));
}
public void Post(ref OrganizationVM vm, string userId)
{
var dbContext = new LMISEntities();
#region 1st: Add portal user
var portalUser = new PortalUser
{
PortalUsersID = vm.PortalUser.PortalUsersID,
IDType = vm.PortalUser.IDType,
IDNumber = vm.PortalUser.IDNumber,
UserCategory = vm.PortalUser.UserCategory,
UserSubCategory = vm.PortalUser.UserSubCategory,
TrainingProvider = vm.PortalUser.TrainingProvider,
Employer = vm.PortalUser.Employer,
JobSeeker = vm.PortalUser.JobSeeker,
TrainingSeeker = vm.PortalUser.TrainingSeeker,
Researcher = vm.PortalUser.Researcher,
Internal = vm.PortalUser.Internal,
IsSubscriper = vm.PortalUser.IsSubscriper
};
dbContext.PortalUsers.Add(portalUser);
dbContext.SaveChanges();
#endregion
#region 2nd: Add AspNetUser
// var user = organizationVM.ContactPersons.FirstOrDefault().User;
// AspNetUser aspNetUser = new AspNetUser
// {
// Id = Guid.NewGuid().ToString(),
// Email = user.Email,
// EmailConfirmed = false,
// PasswordHash = user.PasswordHash,
// SecurityStamp = user.SecurityStamp,
// PhoneNumber = user.PhoneNumber,
// PhoneNumberConfirmed = false,
// TwoFactorEnabled = user.TwoFactorEnabled,
// LockoutEnabled = false,
// AccessFailedCount = 0,
// UserName = user.Email
// };
// dbContext.AspNetUsers.Add(aspNetUser);
// dbContext.SaveChanges();
#endregion
using (var transaction = dbContext.Database.BeginTransaction())
{
#region 3rd: Populate Organization object
var organizationObject = new OrganizationDetail();
PopulateRecord(ref organizationObject, vm, portalUser.PortalUsersID);
organizationObject.PostDate = DateTime.UtcNow;
organizationObject.PostUserID = userId;
#endregion
#region 4th: Add translations
foreach (var translation in vm.Translation.Where(t => t.OrganizationName != null || t.Address != null || t.OtherIndustryType != null))
{
OrganizationDetails_Det translationObject = new OrganizationDetails_Det
{
PortalUsersID = portalUser.PortalUsersID,
LanguageID = translation.LanguageID,
OrganizationName = translation.OrganizationName,
Address = translation.Address,
OtherIndustryType = translation.OtherIndustryType
};
organizationObject.OrganizationDetails_Det.Add(translationObject);
}
#endregion
#region 5th: Add Contact persons
foreach (var person in vm.ContactPersons)
{
var contactPerson = new OrganizationContact_Info
{
OrganizationContactID = person.OrganizationContactID,
PortalUsersID = portalUser.PortalUsersID,
JobTitleID = person.JobTitleID,
Telephone = person.Telephone,
Mobile = person.Mobile,
Fax = person.Fax,
Email = person.Email,
AuthorizationletterPath = person.AuthorizationletterPath,
IsApproved = person.IsApproved,
RejectReason = person.RejectReason,
IsDeleted = person.IsDeleted,
DeleteReason = person.DeleteReason,
PostDate = DateTime.Now,
PostUSerID = userId,
UserID = userId,
};
organizationObject.OrganizationContact_Info.Add(contactPerson);
#region 6th: Add translations to contact person
foreach (var translation in person.Translation.Where(t => t.ContactFullName != null && t.Department != null))
{
var translationObject = new OrganizationContactInfoDetail
{
OrganizationContactID = contactPerson.OrganizationContactID,
LanguageID = translation.LanguageID,
ContactFullName = translation.ContactFullName,
Department = translation.Department
};
contactPerson.OrganizationContactInfoDetails.Add(translationObject);
}
#endregion
}
#endregion
#region 6th: Save Organization object
dbContext.OrganizationDetails.Add(organizationObject);
dbContext.SaveChanges();
transaction.Commit();
#endregion
}
}
public void Update(ref OrganizationVM vm, string userId)
{
var dbContext = new LMISEntities();
var portalUserId = vm.PortalUsersID;
#region 1st: Update portal user
var portalUser = dbContext.PortalUsers.Single(pu => pu.PortalUsersID == portalUserId);
// portalUser.PortalUsersID = organizationVM.PortalUser.PortalUsersID;
portalUser.IDType = vm.PortalUser.IDType;
portalUser.IDNumber = vm.PortalUser.IDNumber;
portalUser.UserCategory = vm.PortalUser.UserCategory;
portalUser.UserSubCategory = vm.PortalUser.UserSubCategory;
portalUser.TrainingProvider = vm.PortalUser.TrainingProvider;
portalUser.Employer = vm.PortalUser.Employer;
portalUser.JobSeeker = vm.PortalUser.JobSeeker;
portalUser.TrainingSeeker = vm.PortalUser.TrainingSeeker;
portalUser.Researcher = vm.PortalUser.Researcher;
portalUser.Internal = vm.PortalUser.Internal;
portalUser.IsSubscriper = vm.PortalUser.IsSubscriper;
dbContext.Entry(portalUser).State = EntityState.Modified;
dbContext.SaveChanges();
#endregion
using (var transaction = dbContext.Database.BeginTransaction())
{
#region 3rd: Populate Organization object
var organizationObject = dbContext.OrganizationDetails.Single(org => org.PortalUsersID == portalUserId);
PopulateRecord(ref organizationObject, vm, vm.PortalUsersID);
organizationObject.UpdateDate = DateTime.UtcNow;
organizationObject.UpdateUserID = userId;
#endregion
#region remove old translations
var details = dbContext.OrganizationDetails_Det
.Where(r => r.PortalUsersID == portalUserId)
.ToList();
foreach (var row in details)
{
organizationObject.OrganizationDetails_Det.Remove(row);
}
dbContext.OrganizationDetails_Det.RemoveRange(details);
//dbContext.SaveChanges();
#endregion
#region 4th: Add translations
foreach (var translation in vm.Translation.Where(t => t.OrganizationName != null || t.Address != null || t.OtherIndustryType != null))
{
var translationObject = new OrganizationDetails_Det
{
PortalUsersID = portalUser.PortalUsersID,
LanguageID = translation.LanguageID,
OrganizationName = translation.OrganizationName,
Address = translation.Address,
OtherIndustryType = translation.OtherIndustryType
};
organizationObject.OrganizationDetails_Det.Add(translationObject);
}
#endregion
#region 6th: Save Organization object
organizationObject.UpdateUserID = userId;
organizationObject.UpdateDate = DateTime.UtcNow;
dbContext.Entry(organizationObject).State = EntityState.Modified;
dbContext.SaveChanges();
transaction.Commit();
#endregion
}
}
public OrganizationVM FindOrganization(string organizationId)
{
return(OrganizationVM.FindById(Organizations, organizationId));
}
