/// <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);
}
