public ActionResult DeleteAdvertCategory(Guid id)
{
AdvertCategory advertCategory = new AdvertCategory();
string email = Request.Headers["Email"];
var tenantId = catalog.GetTenantIDFromClientURL(email);
DateTime dt = DateTime.Now;
try
{
if (tenantId == null)
{
return(Json(new
{
success = false,
message = "TenantId is null",
data = new { }
}, JsonRequestBehavior.AllowGet));
}
advertCategory = db.AdvertCategory.Find(id);
db.AdvertCategory.Remove(advertCategory);
db.SaveChanges();
return(SentAdvertCategoryJson(advertCategory));
}
catch (Exception ex)
{
LogHelper.Log(Log.Event.DELETE_ADVERTCATEGORY, ex.Message);
return(Json(new
{
success = false,
message = "" + ex.Message,
data = new { }
}, JsonRequestBehavior.AllowGet));
}
}
public ActionResult EditAdvertCategory(AdvertCategory advertCategory)
{
string email = Request.Headers["Email"];
var tenantId = catalog.GetTenantIDFromClientURL(email);
DateTime dt = DateTime.Now;
try
{
if (tenantId == null)
{
return(Json(new
{
success = false,
message = "TenantId is null",
data = new { }
}, JsonRequestBehavior.AllowGet));
}
AdvertCategory EditAdvertCategoryData = db.AdvertCategory.SingleOrDefault(x => x.AdvertCategoryID == advertCategory.AdvertCategoryID);
EditAdvertCategoryData.AdvertCategory1 = advertCategory.AdvertCategory1;
EditAdvertCategoryData.DateModified = dt;
db.SaveChanges();
return(SentAdvertCategoryJson(advertCategory));
}
catch (Exception ex)
{
LogHelper.Log(Log.Event.EDIT_ADVERTCATEGORY, ex.Message);
return(Json(new
{
success = false,
message = "" + ex.Message,
data = new { }
}, JsonRequestBehavior.AllowGet));
}
}
private IQueryable <Advert> GetAllTheAdverts()
{
var category = new AdvertCategory()
{
Id = 48,
Name = "Camera"
};
var owner = new User()
{
FirstName = "Gosho",
LastName = "Losho",
};
var adverts = new List <Advert>()
{
new Advert()
{
Id = 64,
Category = category,
CategoryId = category.Id,
Delivery = Delivery.BySalesman.ToString(),
Description = "opisanieeeeeee",
Price = 1245,
Title = "zaglavieee",
ProductState = ProductState.New.ToString(),
Owner = owner,
OwnerEmail = "*****@*****.**",
OwnerId = "346",
OwnerPhone = "346899"
}
};
return(adverts.AsQueryable());
}
public void Category_ShouldBeOfOfTypeAdvertCategory()
{
//Arrange & Act
var category = new AdvertCategory();
//Assert
Assert.IsInstanceOf <AdvertCategory>(category);
}
public void Category_ShouldNotBeNull()
{
//Arrange & Act
var category = new AdvertCategory();
//Assert
Assert.IsNotNull(category);
}
public void DeleteCategory(int id)
{
AdvertCategory adToBeDeleted = this.GetById(id);
this.repository.Delete(adToBeDeleted);
this.unitOfWork.Commit();
}
public void UpdateCategory(AdvertCategory c)
{
AdvertCategory categoryToBeUpdated = this.GetById(c.Id);
categoryToBeUpdated = c;
this.unitOfWork.Commit();
}
public void Category_AdvertsShouldBeInstanceOfICollectionOfAdverts()
{
//Arrange & Act
var category = new AdvertCategory();
var adverts = category.Adverts;
//Assert
Assert.IsInstanceOf <ICollection <Advert> >(adverts);
}
public void Category_AdvertsOfCategoryShouldNotBeNull()
{
//Arrange & Act
var category = new AdvertCategory();
var adverts = category.Adverts;
//Assert
Assert.IsNotNull(adverts);
}
private void View_OnCreateNewCategory(object sender, EventArgs e)
{
AdvertCategory newCategory = new AdvertCategory();
this.View.TryUpdateModel(newCategory);
if (this.View.ModelState.IsValid)
{
this.advertCategoryService.CreateNewCategory(newCategory);
}
}
public ActionResult PutAdvertJson()
{
try
{
AdvertCategory AdvertCategory = new AdvertCategory();
string email = Request.Headers["Email"];
var tenantId = catalog.GetTenantIDFromClientURL(email);
return(Json(new
{
success = true,
message = "Advert details",
data = new
{
Adverts = db.Adverts.Where(x => x.TenantID == tenantId).Select(x => new
{
x.AdvertID,
x.AdvertStatusID,
x.Headline,
x.Introduction,
x.ScopeOfWork,
x.EligibiltyRequirement,
x.CollectionOfTenderDocument,
x.BidSubmission,
x.OtherImportantInformation,
BidOpeningDate = x.BidOpeningDate.Value.ToString(),
BidClosingDate = x.BidClosingDate.Value.ToString(),
DepartmentName = db.AdvertLotNumber.Where(y => y.AdvertID == x.AdvertID).Select(y => y.Procurements.Department.DepartmentName).FirstOrDefault(),
BudgetYear = db.BudgetYear.Where(y => y.BudgetYearID == x.BudgetYearID).Select(y => y.BudgetYear1.Value.Year).FirstOrDefault(),
AdvertCategory = db.AdvertLotNumber.Where(z => z.AdvertID == x.AdvertID).Select(z => new
{
z.ProcurementID,
ProjectCategoryID = db.Procurements.Where(a => a.ProcurementID == z.ProcurementID).Select(a => a.ProjectCategoryID).FirstOrDefault(),
CategoryName = db.Procurements.Where(a => a.ProcurementID == z.ProcurementID).Select(a => a.ProjectCategory.Name).FirstOrDefault(),
CategoryLotCode = db.AdvertCategoryNumber.Where(a => a.CategoryLotCode == z.LotCode).Select(a => a.CategoryLotCode).FirstOrDefault(),
z.Procurements.ProjectName,
Deleted = false
})
})
}
}, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogHelper.Log(Log.Event.GET_ADVERT, ex.Message);
return(Json(new
{
success = false,
message = "" + ex.Message,
data = new { }
}, JsonRequestBehavior.AllowGet));
}
}
private ActionResult SentAdvertCategoryJson(AdvertCategory advertCategory)
{
return(Json(new
{
success = true,
message = "Ok",
data = db.AdvertCategory.Select(x => new
{
x.AdvertCategoryID,
x.AdvertCategory1,
})
}, JsonRequestBehavior.AllowGet));
}
private void View_OnUpdateCategory(object sender, IdEventArgs e)
{
AdvertCategory category = this.advertCategoryService.GetById(e.Id);
if (category == null)
{
this.View.ModelState.AddModelError("", string.Format("Category with id {0} does not exist", e.Id));
return;
}
this.View.TryUpdateModel(category);
if (this.View.ModelState.IsValid)
{
this.advertCategoryService.UpdateCategory(category);
}
}
public ActionResult AddAdvertCategory(AdvertCategory advertCategory)
{
string email = Request.Headers["Email"];
var tenantId = catalog.GetTenantIDFromClientURL(email);
DateTime dt = DateTime.Now;
try
{
if (tenantId == null)
{
return(Json(new
{
success = false,
message = "TenantId is null",
data = new { }
}, JsonRequestBehavior.AllowGet));
}
advertCategory.AdvertCategoryID = Guid.NewGuid();
advertCategory.CreatedBy = "MDA Administrator";
advertCategory.DateCreated = dt;
advertCategory.DateModified = dt;
db.AdvertCategory.Add(advertCategory);
db.SaveChanges();
return(SentAdvertCategoryJson(advertCategory));
}
catch (Exception ex)
{
LogHelper.Log(Log.Event.ADD_ADVERTCATEGORY, ex.Message);
return(Json(new
{
success = false,
message = "" + ex.Message,
data = new { }
}, JsonRequestBehavior.AllowGet));
}
}
public void CreateNewCategory(AdvertCategory adCategory)
{
this.repository.Add(adCategory);
this.unitOfWork.Commit();
}
