/// <summary> /// Get Organization with sort descending follow point /// </summary> /// <returns>List of Organization</returns> public List <OrganizationBasicInfo> GetOrganizationOrderByDecendingPoint() { List <OrganizationBasicInfo> orgList = new List <OrganizationBasicInfo>(); try { List <int> orgIdList; //Take all organization id and order decending by point using (var db = new Ws_DataContext()) { orgIdList = db.Organizations.OrderByDescending(x => x.Point).Where(x => x.IsVerify == true).Select(x => x.OrganizationId).ToList(); } //Get information for each organization id foreach (int orgId in orgIdList) { OrganizationBasicInfo organization = GetFullOrganizationBasicInformation(orgId); orgList.Add(organization); } } catch (Exception) { //throw; } return(orgList); }
/// <summary> /// Get top of organization sorting by point /// </summary> /// <param name="top"></param> /// <returns></returns> public List <OrganizationBasicInfo> GetTopOrganization(int top) { List <OrganizationBasicInfo> orgList = new List <OrganizationBasicInfo>(); try { List <int> orgIdList; using (var db = new Ws_DataContext()) { orgIdList = db.Organizations.OrderByDescending(x => x.Point).Select(x => x.OrganizationId).Take(top).ToList(); } foreach (int orgId in orgIdList) { OrganizationBasicInfo organization = GetFullOrganizationBasicInformation(orgId); orgList.Add(organization); } } catch (Exception) { //throw; } return(orgList); }
public IHttpActionResult GetOrganizationUsingId(int orgId) { OrganizationBasicInfo currentOrganization = new OrganizationBasicInfo(); try { using (var db = new OrganizationDAL()) { currentOrganization = db.GetFullOrganizationBasicInformation(orgId); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Message = "", Type = "", Data = currentOrganization })); } catch (Exception) { return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.ERROR, Message = "", Type = "" })); } }
public ActionResult Contacts(OrganizationConactInfo ci, string btnPrevious, string btnSave) { var org = GetOrganization(); string viewName = org.IsEdit ? "Edit" : "Create"; if (!string.IsNullOrEmpty(btnPrevious)) { var orgBasicInfo = new OrganizationBasicInfo(); orgBasicInfo.Name = org.Name; orgBasicInfo.VendorNumber = org.VendorNumber; orgBasicInfo.BillingRegion = org.BillingRegion; orgBasicInfo.Id = org.Id; return(View(viewName, orgBasicInfo)); } if (!string.IsNullOrEmpty(btnSave)) { if (ModelState.IsValid) { if (org.IsEdit) { dbContext.Addresses.RemoveRange(org.Addresses.Where(a => a.ForDelete == true)); dbContext.Phones.RemoveRange(org.Phones.Where(p => p.ForDelete == true)); org.UpdateDate = DateTime.Now; dbContext.Entry(org).State = EntityState.Modified; } else { var removeAddresses = org.Addresses.Where(a => a.ForDelete == true); foreach (var address in removeAddresses) { org.Addresses.Remove(address); } var removePhones = org.Phones.Where(p => p.ForDelete == true); foreach (var phone in removePhones) { org.Phones.Remove(phone); } dbContext.Organizations.Add(org); } dbContext.SaveChanges(); return(RedirectToAction("List")); } else { return(View(viewName)); } } return(View()); }
public ActionResult Create(OrganizationBasicInfo bi, string btnSave, string btnNext) { if (ModelState.IsValid) { if (!string.IsNullOrEmpty(btnSave)) { var tmpOrg = dbContext.Organizations.Where(o => o.Name.Equals(bi.Name)).FirstOrDefault(); if (tmpOrg != null) { ModelState.AddModelError("", "Specified organization already exists"); return(View()); } var org = new Organization(); org.CreateDate = DateTime.Now; org.Active = true; org.Name = bi.Name; org.VendorNumber = bi.VendorNumber; org.BillingRegion = bi.BillingRegion; dbContext.Organizations.Add(org); dbContext.SaveChanges(); return(RedirectToAction("List")); } if (!string.IsNullOrEmpty(btnNext)) { var org = GetOrganization(); org.CreateDate = DateTime.Now; org.Active = true; org.Name = bi.Name; org.VendorNumber = bi.VendorNumber; org.BillingRegion = bi.BillingRegion; var oci = new OrganizationConactInfo(); oci.AddressOperationMode = "Read"; oci.Addresses = org.Addresses; oci.Phones = org.Phones; return(View("Contacts", oci)); } } return(View()); }
public ActionResult Edit(int?id) { if (id.Equals(null)) { new HttpStatusCodeResult(System.Net.HttpStatusCode.BadRequest); } var org = dbContext.Organizations.Where(o => o.Id.Equals(id.Value)).FirstOrDefault(); if (org == null) { return(HttpNotFound()); } org.IsEdit = true; Session["Organization"] = org; var tmp = new OrganizationBasicInfo(); tmp.Name = org.Name; tmp.VendorNumber = org.VendorNumber; tmp.BillingRegion = org.BillingRegion; return(View(tmp)); }
/// <summary> /// Get organization have been create less than 30 day /// </summary> /// <returns></returns> public List <OrganizationBasicInfo> GetNewestCreatedOrgzation() { List <OrganizationBasicInfo> newestOrg = new List <OrganizationBasicInfo>(); try { List <int> orgIdList; using (var db = new Ws_DataContext()) { DateTime dateBeforeThrityDay = DateTime.UtcNow.AddDays(-30); orgIdList = db.Organizations.OrderByDescending(x => x.CreatedDate).Where(x => x.CreatedDate >= dateBeforeThrityDay).Select(x => x.OrganizationId).ToList(); foreach (int orgId in orgIdList) { OrganizationBasicInfo organization = GetFullOrganizationBasicInformation(orgId); newestOrg.Add(organization); } } } catch (Exception) { //throw; } return(newestOrg); }
public OrganizationBasicInfo GetFullOrganizationBasicInformation(int orgId) { OrganizationBasicInfo organizationBasic = new OrganizationBasicInfo(); try { Organization org = GetOrganizationById(orgId); organizationBasic.OrganizationId = orgId; if (org != null) { organizationBasic.OrganizationName = org.OrganizationName; organizationBasic.Introduction = org.Introduction; organizationBasic.LogoUrl = org.LogoUrl; organizationBasic.Phone = org.Phone; organizationBasic.Email = org.Email; organizationBasic.Address = org.Address; organizationBasic.IsActive = org.IsActive; organizationBasic.IsVerify = org.IsVerify; organizationBasic.CreatedDate = org.CreatedDate.ToString("H:mm:ss dd/MM/yy"); organizationBasic.Point = org.Point; using (var db = new Ws_DataContext()) { organizationBasic.CreatorName = db.Organizations.Where(x => x.OrganizationId == orgId).SingleOrDefault().Ws_User.UserName; organizationBasic.NumberOfEvent = db.Events.Where(x => x.CreatorID == organizationBasic.OrganizationId).Count(); } WsRanking ranking = new WsRanking(); RankingDTO rank = ranking.RankingWithPoint(org.Point); if (rank.CurrentRank == 0) { organizationBasic.CurrentRank = "Mới"; } else if (rank.CurrentRank == 200) { organizationBasic.CurrentRank = "Đồng"; } else if (rank.CurrentRank == 500) { organizationBasic.CurrentRank = "Bạc"; } else if (rank.CurrentRank == 2000) { organizationBasic.CurrentRank = "Vàng"; } else if (rank.CurrentRank == 5000) { organizationBasic.CurrentRank = "Bạch Kim"; } else if (rank.CurrentRank == 10000) { organizationBasic.CurrentRank = "Kim Cương"; } //get creator using (var db = new UserDAL()) { organizationBasic.Creator = db.GetFullInforOfUserAsBasicUser(orgId); } } } catch (Exception) { //throw; } return(organizationBasic); }