public async Task <string> GetDescriptionTextAsync(int id)
{
CompanyDescription description =
await _context.CompanyDescriptions.FirstOrDefaultAsync(d => d.CompanyId == id);
return(description?.Html ?? description?.Text);
}
public async Task <int> CreateOrUpdateDescriptionAsync(int id, CompanyDescriptionViewModel description,
string userId)
{
CompanyDescription current = await _context.CompanyDescriptions.FirstOrDefaultAsync(d => d.CompanyId == id);
if (current is null)
{
current = new CompanyDescription
{
CompanyId = id,
Html = description.Html,
Text = description.Markdown
};
await _context.CompanyDescriptions.AddAsync(current);
}
else
{
current.Html = description.Html;
current.Text = description.Markdown;
}
await _context.SaveChangesWithUserAsync(userId);
return(current.Id);
}
public ActionResult DeleteConfirmed(int id)
{
CompanyDescription companyDescription = db.CompanyDescription.Find(id);
db.CompanyDescription.Remove(companyDescription);
db.SaveChanges();
return(RedirectToAction("Index", "StorageCompany", new { area = "" }));
}
public ActionResult Edit([Bind(Include = "DescriptionID,CompanyID,Description")] CompanyDescription companyDescription)
{
if (ModelState.IsValid)
{
db.Entry(companyDescription).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "StorageCompany", new { area = "" }));
}
return(View(companyDescription));
}
private CompanyDescriptionPoco TranslateFromProto(CompanyDescription proto)
{
return(new CompanyDescriptionPoco
{
Id = Guid.Parse(proto.Id),
Company = Guid.Parse(proto.Company),
LanguageId = proto.LanguageId,
CompanyName = proto.CompanyName,
CompanyDescription = proto.CompDescription
});
}
// GET: CompanyDescriptions/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CompanyDescription companyDescription = db.CompanyDescription.Find(id);
if (companyDescription == null)
{
return(HttpNotFound());
}
return(View(companyDescription));
}
// GET: CompanyDescriptions
// GET: CompanyDescriptions/Create
// GET: CompanyDescriptions/Edit/5
public ActionResult Edit(int?DescriptionID, int CompanyID)
{
if (DescriptionID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CompanyDescription companyDescription = db.CompanyDescription.Find(DescriptionID);
if (companyDescription == null)
{
return(HttpNotFound());
}
return(View(companyDescription));
}
public ActionResult Edit([Bind(Include = "CompanyID,MobileNumber,CompanyName,CompanyRegistrationNumber,BusinessSector,CompanyTelephoneNumber,CompanyEmail,CompanyCountry,TownID,CompanyAddress,CompanySize,YearsInBusiness,Industry,CreateDate,BeeLevel,UpdateDate,imgUrl,CompanyDescription")] StorageCompany StorageCompany)
{
int ErrorCountRecruit = 0;
int ErrorCountCompany = 0;
int ErrorCountSmallB = 0;
ViewBag.CName = "";
ViewBag.CReg = "";
ViewBag.BusSect = "";
ViewBag.MobNum = "";
ViewBag.ComNum = "";
ViewBag.CompAdd = "";
ViewBag.CompSiz = "";
ViewBag.CompDesc = "";
ViewBag.CompBee = "";
ViewBag.YinB = "";
ViewBag.TWID = "";
if (StorageCompany.TownID == 0 || StorageCompany.TownID == null)
{
ErrorCountRecruit = ErrorCountRecruit + 1;
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
ViewBag.TWID = "*";
ViewBag.Provinces = new SelectList(db.Province, "ProvinceID", "ProvinceName");
ViewBag.Region = new SelectList(db.Region, "RegionID", "Region1", "Select Region");
ViewBag.Town = new SelectList(db.Town, "TownID", "Town1", "Select Town");
}
else
{
String TW = Convert.ToString(db.LocationView.Where(x => x.TownID == StorageCompany.TownID).SingleOrDefault().Town.ToString());
String PR = db.LocationView.Where(x => x.TownID == StorageCompany.TownID).SingleOrDefault().ProvinceName.ToString();
String RG = db.LocationView.Where(x => x.TownID == StorageCompany.TownID).SingleOrDefault().Region.ToString();
int TWI = db.LocationView.Where(x => x.TownID == StorageCompany.TownID).SingleOrDefault().TownID;
int?PRI = db.LocationView.Where(x => x.TownID == StorageCompany.TownID).SingleOrDefault().ProvinceID;
int RGI = db.LocationView.Where(x => x.TownID == StorageCompany.TownID).SingleOrDefault().RegionID;
ViewBag.InTown = (TW);
ViewBag.InProvince = PR;
ViewBag.InRegion = RG;
ViewBag.InTownI = TWI;
ViewBag.InProvinceI = PRI;
ViewBag.InRegionI = RGI;
ViewBag.Provinces = new SelectList(db.Province, "ProvinceID", "ProvinceName", PRI);
ViewBag.Region = new SelectList(db.Region.Where(x => x.ProvinceID == PRI), "RegionID", "Region1", RGI);
ViewBag.Town = new SelectList(db.Town.Where(x => x.RegionID == RGI), "TownID", "Town1", TWI);
}
List <SelectListItem> listitem = new List <SelectListItem>();
List <SelectListItem> listitemdrop = new List <SelectListItem>();
DropdownListValues dropSa = new DropdownListValues();
ViewBag.BeeLevel = new SelectList(db.BEELevel, "BEELevelID", "BEELevelName");
ViewBag.Raceset = new SelectList(db.ListRace, "RaceID", "Race");
ViewBag.Genderset = new SelectList(db.Gender, "GenderID", "Gender1");
ViewBag.Disabilityset = new SelectList(db.ListDisability, "DisabilityID", "Disability");
ViewBag.Categoryset = new SelectList(db.ListIndustry, "IndustryID", "Industry");
int DescriptionID = db.CompanyDescription.Where(x => x.CompanyID == StorageCompany.CompanyID).SingleOrDefault().DescriptionID;
CompanyDescription CompanyDesc = db.CompanyDescription.Find(DescriptionID);
CompanyDesc.Description = StorageCompany.CompanyDescription;
StorageCompany.UpdateDate = DateTime.Now;
String UserID = User.Identity.GetUserId();
StorageCompany.CreatedBy = UserID;
if (StorageCompany.CompanyName == null || StorageCompany.CompanyName == "")
{
ViewBag.CName = "*";
ErrorCountRecruit = ErrorCountRecruit + 1;
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.CompanyRegistrationNumber == null || StorageCompany.CompanyRegistrationNumber == "")
{
ViewBag.CReg = "*";
ErrorCountRecruit = ErrorCountRecruit + 1;
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.BusinessSector == null || StorageCompany.BusinessSector == 0)
{
ViewBag.BusSect = "*";
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.MobileNumber == null || StorageCompany.MobileNumber == "")
{
ViewBag.MobNum = "*";;
ErrorCountRecruit = ErrorCountRecruit + 1;
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.CompanyTelephoneNumber == null || StorageCompany.CompanyTelephoneNumber == "")
{
ViewBag.ComNum = "*";
ErrorCountRecruit = ErrorCountRecruit + 1;
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.CompanyAddress == null || StorageCompany.CompanyAddress == "")
{
ViewBag.CompAdd = "*";
ErrorCountRecruit = ErrorCountRecruit + 1;
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.CompanySize == null || StorageCompany.CompanySize == "")
{
ViewBag.CompSiz = "*";
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.CompanyDescription == null || StorageCompany.CompanyDescription == "")
{
ViewBag.CompDesc = "*";
ErrorCountRecruit = ErrorCountRecruit + 1;
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.BeeLevel == null || StorageCompany.BeeLevel == 0)
{
ViewBag.CompBee = "*";
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.YearsInBusiness == null || StorageCompany.YearsInBusiness == 0)
{
ViewBag.YinB = "*";
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (Request.IsAuthenticated && User.IsInRole("Recruitment Agency"))
{
if (ErrorCountRecruit == 0)
{
db.Entry(StorageCompany).State = EntityState.Modified;
db.Entry(CompanyDesc).State = EntityState.Modified;
db.SaveChanges();
int CompanyID = StorageCompany.CompanyID;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View(StorageCompany));
}
}
else if (Request.IsAuthenticated && User.IsInRole("Company"))
{
if (ErrorCountCompany == 0)
{
db.Entry(StorageCompany).State = EntityState.Modified;
db.Entry(CompanyDesc).State = EntityState.Modified;
db.SaveChanges();
int CompanyID = StorageCompany.CompanyID;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View(StorageCompany));
}
}
else if (Request.IsAuthenticated && User.IsInRole("Small Business"))
{
if (ErrorCountSmallB == 0)
{
db.Entry(StorageCompany).State = EntityState.Modified;
db.Entry(CompanyDesc).State = EntityState.Modified;
db.SaveChanges();
int CompanyID = StorageCompany.CompanyID;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View(StorageCompany));
}
}
return(View(StorageCompany));
}
// GET: StorageCompany/Edit/5
public ActionResult Edit(int?CompanyId, string imgUrl)
{
ViewBag.CName = "";
ViewBag.CReg = "";
ViewBag.BusSect = "";
ViewBag.MobNum = "";
ViewBag.ComNum = "";
ViewBag.CompAdd = "";
ViewBag.CompSiz = "";
ViewBag.CompDesc = "";
ViewBag.CompBee = "";
ViewBag.YinB = "";
ViewBag.TWID = "";
//ViewBag.MyRegions = new SelectList(db.Regions, "RegionID", "Region1");
if (CompanyId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StorageCompany StorageCompany = db.StorageCompany.Find(CompanyId);
int DescriptionID = db.CompanyDescription.Where(x => x.CompanyID == CompanyId).SingleOrDefault().DescriptionID;
CompanyDescription CompanyDesc = db.CompanyDescription.Find(DescriptionID);
StorageCompany.CompanyDescription = CompanyDesc.Description;
if (StorageCompany == null)
{
return(HttpNotFound());
}
if (StorageCompany.CreatedBy == User.Identity.GetUserId())
{
String TW = Convert.ToString(db.LocationView.Where(x => x.TownID == StorageCompany.TownID).SingleOrDefault().Town.ToString());
String PR = db.LocationView.Where(x => x.TownID == StorageCompany.TownID).SingleOrDefault().ProvinceName.ToString();
String RG = db.LocationView.Where(x => x.TownID == StorageCompany.TownID).SingleOrDefault().Region.ToString();
int TWI = db.LocationView.Where(x => x.TownID == StorageCompany.TownID).SingleOrDefault().TownID;
int?PRI = db.LocationView.Where(x => x.TownID == StorageCompany.TownID).SingleOrDefault().ProvinceID;
int RGI = db.LocationView.Where(x => x.TownID == StorageCompany.TownID).SingleOrDefault().RegionID;
ViewBag.InTown = (TW);
ViewBag.InProvince = PR;
ViewBag.InRegion = RG;
ViewBag.InTownI = TWI;
ViewBag.InProvinceI = PRI;
ViewBag.InRegionI = RGI;
List <SelectListItem> listitem = new List <SelectListItem>();
List <SelectListItem> listitemdrop = new List <SelectListItem>();
DropdownListValues dropSa = new DropdownListValues();
ViewBag.BeeLevel = new SelectList(db.BEELevel, "BEELevelID", "BEELevelName");
ViewBag.Raceset = new SelectList(db.ListRace, "RaceID", "Race");
ViewBag.Genderset = new SelectList(db.Gender, "GenderID", "Gender1");
ViewBag.Disabilityset = new SelectList(db.ListDisability, "DisabilityID", "Disability");
ViewBag.Provinces = new SelectList(db.Province, "ProvinceID", "ProvinceName", PRI);
ViewBag.Region = new SelectList(db.Region.Where(x => x.ProvinceID == PRI), "RegionID", "Region1", RGI);
ViewBag.Town = new SelectList(db.Town.Where(x => x.RegionID == RGI), "TownID", "Town1", TWI);
ViewBag.Categoryset = new SelectList(db.ListIndustry, "IndustryID", "Industry");
}
else
{
}
return(View(StorageCompany));
}
public ActionResult Create([Bind(Include = "CompanyID,MobileNumber,CompanyName,CompanyRegistrationNumber,BusinessSector,CompanyTelephoneNumber,CompanyEmail,CompanyCountry,TownID,CompanyAddress,CompanySize,YearsInBusiness,Industry,CreateDate,BeeLevel,UpdateDate,CompanyDescription")] StorageCompany StorageCompany)
{
int ErrorCountRecruit = 0;
int ErrorCountCompany = 0;
int ErrorCountSmallB = 0;
ViewBag.CName = "";
ViewBag.CReg = "";
ViewBag.BusSect = "";
ViewBag.MobNum = "";
ViewBag.ComNum = "";
ViewBag.CompAdd = "";
ViewBag.CompSiz = "";
ViewBag.CompDesc = "";
ViewBag.CompBee = "";
ViewBag.YinB = "";
ViewBag.TWID = "";
String UserName = User.Identity.GetUserName();
StorageCompany.CompanyEmail = UserName;
String UserId = User.Identity.GetUserId();
var Companydescriptions = new CompanyDescription();
ViewBag.BeeLevel = new SelectList(db.BEELevel, "BEELevelID", "BEELevelName");
ViewBag.Categoryset = new SelectList(db.ListIndustry, "IndustryID", "Industry");
ViewBag.MyCountries = new SelectList(db.ListCountry, "CountryID", "Country");
ViewBag.Provinces = new SelectList(db.Province, "ProvinceID", "ProvinceName");
ViewBag.Region = new SelectList(db.Region, "RegionID", "Region1");
ViewBag.Town = new SelectList(db.Town, "TownID", "Town1");
ViewBag.Categoryset = new SelectList(db.ListIndustry, "IndustryID", "Industry");
//ViewBag.MyRegions = new SelectList(db.Regions, "RegionID", "Region");
StorageCompany.CreatedBy = User.Identity.GetUserId();
StorageCompany.CreateDate = DateTime.Now;
StorageCompany.UpdateDate = DateTime.Now;
if (StorageCompany.TownID == null || StorageCompany.TownID == 0)
{
ViewBag.TWID = "*";
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
ErrorCountRecruit = ErrorCountRecruit + 1;
}
if (StorageCompany.CompanyName == null || StorageCompany.CompanyName == "")
{
ViewBag.CName = "*";
ErrorCountRecruit = ErrorCountRecruit + 1;
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.CompanyRegistrationNumber == null || StorageCompany.CompanyRegistrationNumber == "")
{
ViewBag.CReg = "*";
ErrorCountRecruit = ErrorCountRecruit + 1;
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.BusinessSector == null || StorageCompany.BusinessSector == 0)
{
ViewBag.BusSect = "*";
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.MobileNumber == null || StorageCompany.MobileNumber == "")
{
ViewBag.MobNum = "*";;
ErrorCountRecruit = ErrorCountRecruit + 1;
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.CompanyTelephoneNumber == null || StorageCompany.CompanyTelephoneNumber == "")
{
ViewBag.ComNum = "*";
ErrorCountRecruit = ErrorCountRecruit + 1;
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.CompanyAddress == null || StorageCompany.CompanyAddress == "")
{
ViewBag.CompAdd = "*";
ErrorCountRecruit = ErrorCountRecruit + 1;
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.CompanySize == null || StorageCompany.CompanySize == "")
{
ViewBag.CompSiz = "*";
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.CompanyDescription == null || StorageCompany.CompanyDescription == "")
{
ViewBag.CompDesc = "*";
ErrorCountRecruit = ErrorCountRecruit + 1;
ErrorCountCompany = ErrorCountCompany + 1;
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.BeeLevel == null || StorageCompany.BeeLevel == 0)
{
ViewBag.CompBee = "*";
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (StorageCompany.YearsInBusiness == null || StorageCompany.YearsInBusiness == 0)
{
ViewBag.YinB = "*";
ErrorCountSmallB = ErrorCountSmallB + 1;
}
if (Request.IsAuthenticated && User.IsInRole("Recruitment Agency"))
{
if (ErrorCountRecruit == 0)
{
db.StorageCompany.Add(StorageCompany);
db.SaveChanges();
int CompanyID = StorageCompany.CompanyID;
Companydescriptions.CompanyID = CompanyID;
Companydescriptions.Description = StorageCompany.CompanyDescription;
db.CompanyDescription.Add(Companydescriptions);
db.SaveChanges();
return(RedirectToAction("Index", "StorageCompany", new { CompanyID = StorageCompany.CompanyID }));
}
else
{
return(View(StorageCompany));
}
}
else if (Request.IsAuthenticated && User.IsInRole("Company"))
{
if (ErrorCountCompany == 0)
{
db.StorageCompany.Add(StorageCompany);
db.SaveChanges();
int CompanyID = StorageCompany.CompanyID;
Companydescriptions.CompanyID = CompanyID;
Companydescriptions.Description = StorageCompany.CompanyDescription;
db.CompanyDescription.Add(Companydescriptions);
db.SaveChanges();
return(RedirectToAction("Index", "StorageCompany", new { CompanyID = StorageCompany.CompanyID }));
}
else
{
return(View(StorageCompany));
}
}
else if (Request.IsAuthenticated && User.IsInRole("Small Business"))
{
if (ErrorCountSmallB == 0)
{
db.StorageCompany.Add(StorageCompany);
db.SaveChanges();
int CompanyID = StorageCompany.CompanyID;
Companydescriptions.CompanyID = CompanyID;
Companydescriptions.Description = StorageCompany.CompanyDescription;
db.CompanyDescription.Add(Companydescriptions);
db.SaveChanges();
return(RedirectToAction("Index", "StorageCompany", new { CompanyID = StorageCompany.CompanyID }));
}
else
{
return(View(StorageCompany));
}
}
return(View(StorageCompany));
}
public Company(int gbRank, string c,
string o)
{
this.GBRank = gbRank;
desc = new CompanyDescription(c, o);
}
public Company(int gbRank, string companyName, string owner)
{
GBRank = gbRank;
desc = new CompanyDescription(companyName, owner);
}
