public ActionResult EditRegister(string Register, string ProductId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
SearchPages Se = (SearchPages)Session["SearchPages"];
int EditionId = int.Parse(Se.EditId);
var Division = int.Parse(Se.CountId);
string Registry = Register.Trim();
int Product = int.Parse(ProductId);
var Prod = (from Prods in db.Products
where Prods.ProductId == Product
select Prods);
if (Prod.LongCount() > 0)
{
foreach (Products lb in Prod)
{
lb.Register = Registry;
}
}
db.SaveChanges();
ActivityLog.UpdateRegistry(ApplicationId, Product, UsersId, Registry);
return(View());
}
public ActionResult searchpages(string ProductName)
{
SearchPages S = (SearchPages)Session["SearchPages"];
int country = int.Parse(S.CountId);
int Edition = int.Parse(S.EditId);
int Division = int.Parse(S.DDivisionId);
if (ProductName != null)
{
if (ProductName == string.Empty)
{
return(RedirectToAction("Index"));
}
else
{
int count = 0;
var Prods = (from plm in db.plm_vwProductsByEdition
where plm.EditionId == Edition &&
plm.CountryId == country &&
plm.TypeInEdition == "P" &&
plm.DivisionId == Division
orderby plm.ProductName ascending
select plm);
if (!string.IsNullOrEmpty(ProductName))
{
Prods = Prods.Where(m => m.ProductName.StartsWith(ProductName)).OrderBy(o => o.ProductName);
foreach (plm_vwProductsByEdition J in Prods)
{
count = count + 1;
}
ViewData["Count"] = count;
}
pagessearch pagessearch = new pagessearch(ProductName);
Session["pagessearch"] = pagessearch;
return(View("Index", Prods));
}
}
else if (ProductName == null)
{
pagessearch ps = (pagessearch)Session["pagessearch"];
var Prods = (from plm in db.plm_vwProductsByEdition
where plm.EditionId == Edition &&
plm.CountryId == country &&
plm.TypeInEdition == "P" &&
plm.DivisionId == Division
orderby plm.ProductName ascending
select plm);
if (!string.IsNullOrEmpty(ps.ProductName))
{
Prods = Prods.Where(m => m.ProductName.StartsWith(ps.ProductName)).OrderBy(o => o.ProductName);
}
return(View("Index", Prods));
}
return(View("Index"));
}
public ActionResult Index()
{
SearchPages SearchPages = (SearchPages)Session["SearchPages"];
int EditionId = 23;
int DivisionId = 10;
var plm = (from view in db.plm_vwProductsByEdition
where view.EditionId == EditionId &&
view.DivisionId == DivisionId
select view).ToList();
return(View(plm));
}
public ActionResult UpdatePages(string PharmaForm, string ProductId, string Category, string Page, string DivisionId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
if (Page != "")
{
SearchPages Se = (SearchPages)Session["SearchPages"];
int EditionId = int.Parse(Se.EditId);
int PharmaFormId = int.Parse(PharmaForm);
int ProdId = int.Parse(ProductId);
int CategoryId = int.Parse(Category);
int Division = int.Parse(DivisionId);
var ParticipantP = (from PP in db.ParticipantProducts
where PP.ProductId == ProdId &&
PP.PharmaFormId == PharmaFormId &&
PP.CategoryId == CategoryId &&
PP.EditionId == EditionId &&
PP.DivisionId == Division &&
PP.Page == Page
select PP).ToList();
if (ParticipantP.LongCount() > 0)
{
}
return(View());
}
else if (Page == "")
{
SearchPages Se = (SearchPages)Session["SearchPages"];
int EditionId = int.Parse(Se.EditId);
int PharmaFormId = int.Parse(PharmaForm);
int ProdId = int.Parse(ProductId);
int CategoryId = int.Parse(Category);
int Division = int.Parse(DivisionId);
var ParticipantP = (from PP in db.ParticipantProducts
where PP.ProductId == ProdId &&
PP.PharmaFormId == PharmaFormId &&
PP.CategoryId == CategoryId &&
PP.EditionId == EditionId &&
PP.DivisionId == Division
select PP).ToList();
foreach (ParticipantProducts PP in ParticipantP)
{
PP.Page = null;
}
db.SaveChanges();
ActivityLog.Updatepagesn(EditionId, PharmaFormId, ProdId, CategoryId, ApplicationId, UsersId, Page, Division);
}
return(View());
}
public MiniLockingCachedFindPagesWithCriterion(SearchPages searchPages, PageTypeRepository pageTypeRepository, ISynchronizedObjectInstanceCache synchronizedObjectInstanceCache)
{
_searchPages = searchPages;
_pageTypeRepository = pageTypeRepository;
_synchronizedObjectInstanceCache = synchronizedObjectInstanceCache;
}
public ActionResult Index(string CountryId, string EditionId, string BookId, string DivisionId)
{
SearchPages S = (SearchPages)Session["SearchPages"];
if (CountryId != null)
{
int country = int.Parse(CountryId);
int Edition = int.Parse(EditionId);
int Division = int.Parse(DivisionId);
string CountId = CountryId;
string EditId = EditionId;
string BbookId = BookId;
string DDivisionId = DivisionId;
var ParticipantP = (from plm in db.plm_vwProductsByEdition
where plm.EditionId == Edition &&
plm.CountryId == country &&
plm.TypeInEdition == "P" &&
plm.DivisionId == Division
orderby plm.ProductName ascending
select plm).ToList();
if (ParticipantP.LongCount() > 0)
{
ViewData["CountProds"] = 0;
}
else
{
ViewData["CountProds"] = null;
}
SearchPages SearchPages = new SearchPages(CountId, EditId, BbookId, DDivisionId);
Session["SearchPages"] = SearchPages;
return(View(ParticipantP));
}
else if (S != null)
{
int Division = int.Parse(S.DDivisionId);
int Edition = int.Parse(S.EditId);
int Country = int.Parse(S.CountId);
int Book = int.Parse(S.BbookId);
var ParticipantP = (from plm in db.plm_vwProductsByEdition
where plm.EditionId == Edition &&
plm.CountryId == Country &&
plm.TypeInEdition == "P" &&
plm.DivisionId == Division
orderby plm.ProductName ascending
select plm).ToList();
if (ParticipantP.LongCount() > 0)
{
ViewData["CountProds"] = 0;
}
else
{
ViewData["CountProds"] = null;
}
return(View(ParticipantP));
}
else if (CountryId == null)
{
var ParticipantP = (from plm in db.plm_vwProductsByEdition
where plm.EditionId == 0 &&
plm.Page == null &&
plm.CountryId == 0 &&
plm.DivisionId == 0
select plm).ToList();
return(View(ParticipantP));
}
return(View());
}
