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 InsertActiveSubstances(string ActiveSubstanceId, string ProductId, string AppId, string UserId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = 0;
int UsersId = 0;
ApplicationId = p.ApplicationId;
UsersId = p.userId;
ClasificationProds CP1 = (ClasificationProds)Session["ClasificationProds"];
int?PProductId = CP1.PId;
int ProdId = Convert.ToInt32(PProductId);
int ActiveSubstance = int.Parse(ActiveSubstanceId);
PProductSubstances.ActiveSubstanceId = ActiveSubstance;
PProductSubstances.ProductId = ProdId;
db.PProductSubstances.Add(PProductSubstances);
db.SaveChanges();
ActivityLog.ProductSubstances(ApplicationId, ActiveSubstance, ProdId, UsersId);
return(RedirectToAction("Clasification", "Clasification"));
}
public void UserCont(Models.ApplicationUsers user, Models.UserCountries UserCountries1)
{
Functions function = new Functions();
function.Countries(ApplicationUsers);
int userId = ApplicationUsers.UserId;
int ApplicationId = ApplicationUsers.ApplicationId;
var list = function.lcoun;
List <string> var = new List <string>();
List <int> country = new List <int>();
foreach (Countries ce in list)
{
var.Add(ce.ID);
CountriesUsers c = new CountriesUsers(country, var, ApplicationId, userId);
Session["CountriesUsers"] = c;
}
foreach (Countries cu in list)
{
country.Add(cu.CountryId);
CountriesUsers c = new CountriesUsers(country, var, ApplicationId, userId);
Session["CountriesUsers"] = c;
}
}
public ActionResult insertagrochemicaluses(int?Id)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
ClasificationProds CP1 = (ClasificationProds)Session["ClasificationProds"];
int?PProductId = CP1.PId;
int ProdId = Convert.ToInt32(PProductId);
int Use = Convert.ToInt32(Id);
var PAU = from ProdAU in db.PProductAgrochemicalUsesSet
where ProdAU.ProductId == ProdId &&
ProdAU.AgrochemicalUseId == Use
select ProdAU;
if (PAU.LongCount() > 0)
{
MessageBox.Show("El uso ya esta asignado", "Aviso");
return(RedirectToAction("agrochemicaluses", "Clasification"));
}
else
{
PProductAgrochemicalUses.ProductId = ProdId;
PProductAgrochemicalUses.AgrochemicalUseId = Use;
db.PProductAgrochemicalUsesSet.Add(PProductAgrochemicalUses);
db.SaveChanges();
Id = null;
ActivityLog.InsertProductAgrochemicalUses(ApplicationId, Use, ProdId, UsersId);
return(RedirectToAction("agrochemicaluses", "Clasification"));
}
}
public ActionResult deletereferencesidef(string productid, string divisionid, string editionid, string pharmaform, string category)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
int ProdId = int.Parse(productid);
int DivisionId = int.Parse(divisionid);
int EditionId = int.Parse(editionid);
int PharmaFormId = int.Parse(pharmaform);
int CategoryId = int.Parse(category);
var pp = (from _pp in db.ParticipantProducts
where _pp.ProductId == ProdId &&
_pp.DivisionId == DivisionId &&
_pp.EditionId == EditionId &&
_pp.PharmaFormId == PharmaFormId &&
_pp.CategoryId == CategoryId
select _pp).ToList();
if (pp.LongCount() > 0)
{
foreach (ParticipantProducts _pp in pp)
{
_pp.Active = false;
db.SaveChanges();
ActivityLog._deletereferencesidef(ProdId, DivisionId, EditionId, PharmaFormId, CategoryId, ApplicationId, UsersId);
}
}
return(View());
}
public ActionResult deleteagrochemicaluses(string AgrochemicalUseId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
ClasificationProds CP1 = (ClasificationProds)Session["ClasificationProds"];
int?PProductId = CP1.PId;
int ProdId = Convert.ToInt32(PProductId);
int Use = int.Parse(AgrochemicalUseId);
var Act = from AS in db.PProductAgrochemicalUsesSet
where AS.AgrochemicalUseId == Use &&
AS.ProductId == ProdId
select AS;
foreach (PProductAgrochemicalUses PPS in Act)
{
var Delete = DEAQ.PProductAgrochemicalUsesSet.FirstOrDefault(x => x.ProductId == PPS.ProductId && x.AgrochemicalUseId == PPS.AgrochemicalUseId);
DEAQ.PProductAgrochemicalUsesSet.Remove(Delete);
DEAQ.SaveChanges();
ActivityLog.DeleteProductAgrochemicalUses(ApplicationId, Use, ProdId, UsersId);
}
return(RedirectToAction("agrochemicaluses", "Clasification"));
}
public ActionResult editdivs(string DivisionId, string DivisionName, string ShortName, string LabId, string CountryId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
int Division = int.Parse(DivisionId);
string DivisionN = DivisionName.Trim();
string ShortN = ShortName.Trim();
int LaboratoryId = int.Parse(LabId);
int Country = int.Parse(CountryId);
var Div = from Divs in db.Divisions
where Divs.DivisionId == Division
select Divs;
foreach (Divisions D in Div)
{
D.DivisionName = DivisionName.Trim();
D.ShortName = ShortName.Trim();
}
db.SaveChanges();
ActivityLog.editdivision(DivisionN, ShortN, Country, LaboratoryId, ApplicationId, UsersId, Division);
return(View());
}
public ActionResult DeleteChangeProds(string ProductId, string DivisionId, string Category, string EditionId, string PharmaForm, string AppId, string UserId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = int.Parse(AppId);
int UsersId = int.Parse(UserId);
ApplicationId = p.ApplicationId;
UsersId = p.userId;
int PharmaFormId = int.Parse(PharmaForm);
int Division = int.Parse(DivisionId);
int Edition = int.Parse(EditionId);
int Product = int.Parse(ProductId);
int CategoryId = int.Parse(Category);
var pp = db.ParticipantProducts.Where(x => x.CategoryId == CategoryId && x.DivisionId == Division && x.EditionId == Edition && x.PharmaFormId == PharmaFormId && x.ProductId == Product).ToList();
if (pp.LongCount() > 0)
{
foreach (ParticipantProducts PProds in pp)
{
PProds.ContentTypeId = null;
db.SaveChanges();
}
ActivityLog.EditParticipantProductsDeleteChanges(ApplicationId, Product, Division, Edition, PharmaFormId, CategoryId, 0, UsersId);
}
return(View());
}
public ActionResult DeleteProductSeeds(string SeedId, string ProductId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
ClasificationProds CP1 = (ClasificationProds)Session["ClasificationProds"];
int?PProductId = CP1.PId;
int ProdId = Convert.ToInt32(PProductId);
int Seed = int.Parse(SeedId);
var Act = from AS in db.PProductSeeds
where AS.SeedId == Seed &&
AS.ProductId == ProdId
select AS;
foreach (PProductSeeds PPS in Act)
{
var Delete = DEAQ.PProductSeeds.FirstOrDefault(x => x.ProductId == PPS.ProductId && x.SeedId == PPS.SeedId);
DEAQ.PProductSeeds.Remove(Delete);
DEAQ.SaveChanges();
ActivityLog.InsertProductSeeds(ApplicationId, Seed, ProdId, UsersId);
}
return(RedirectToAction("productseeds", "Clasification"));
}
public void UserCont(Models.Users user, Models.ApplicationUsers ApplicationUsers)
{
Functions _functions = new Functions();
_functions.Countries(user);
int userId = user.UserId;
int countryId = _functions._countriesUsers.CountryId;
int ApplicationId = _roWApplicationusers.ApplicationId;
var list = _functions.lcoun;
List <string> var = new List <string>();
List <int> country = new List <int>();
foreach (Countries _eachCountries in list)
{
var.Add(_eachCountries.ID);
CountriesUsers c = new CountriesUsers(country, var, ApplicationId, userId);
Session["CountriesUsers"] = c;
}
foreach (Countries _eachCountry in list)
{
country.Add(_eachCountry.CountryId);
CountriesUsers c = new CountriesUsers(country, var, ApplicationId, userId);
Session["CountriesUsers"] = c;
}
}
public ActionResult DeleteParticipantProducts(string ProductId, string DivisionId, string Category, string EditionId, string PharmaForm, string AppId, string UserId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = int.Parse(AppId);
int UsersId = int.Parse(UserId);
ApplicationId = p.ApplicationId;
UsersId = p.userId;
int Division = int.Parse(DivisionId);
int Edition = int.Parse(EditionId);
int Product = int.Parse(ProductId);
int PharmaFormId = int.Parse(PharmaForm);
int CategoryId = int.Parse(Category);
var pc = db.ProductContents.Where(x => x.CategoryId == CategoryId && x.DivisionId == Division && x.EditionId == Edition && x.PharmaFormId == PharmaFormId && x.ProductId == Product).ToList();
if (pc.LongCount() > 0)
{
foreach (ProductContents _pc in pc)
{
var delete = db.ProductContents.SingleOrDefault(x => x.CategoryId == _pc.CategoryId && x.DivisionId == _pc.DivisionId && x.EditionId == _pc.EditionId && x.PharmaFormId == _pc.PharmaFormId && x.ProductId == _pc.ProductId && x.AttributeId == _pc.AttributeId);
db.ProductContents.Remove(delete);
db.SaveChanges();
ActivityLog._deleteproductcontents(_pc.ProductId, _pc.PharmaFormId, _pc.EditionId, _pc.DivisionId, _pc.CategoryId, _pc.AttributeId, _pc.HTMLContent, _pc.PlainContent, _pc.Content, ApplicationId, UsersId);
}
}
var pp = db.ParticipantProducts.SingleOrDefault(x => x.CategoryId == CategoryId && x.DivisionId == Division && x.EditionId == Edition && x.PharmaFormId == PharmaFormId && x.ProductId == Product);
if (pp != null)
{
db.ParticipantProducts.Remove(pp);
db.SaveChanges();
ActivityLog.DeleteParticipanProducts(Product, PharmaFormId, Division, CategoryId, ApplicationId, UsersId, Edition);
}
var edp = db.EditionDivisionProducts.Where(x => x.CategoryId == CategoryId && x.DivisionId == Division && x.EditionId == Edition && x.PharmaFormId == PharmaFormId && x.ProductId == Product).ToList();
if (edp.LongCount() > 0)
{
foreach (EditionDivisionProducts e in edp)
{
var Del = DEAQ.EditionDivisionProducts.SingleOrDefault(x => x.ProductId == e.ProductId && x.EditionId == e.EditionId && x.PharmaFormId == e.PharmaFormId && x.CategoryId == e.CategoryId && x.DivisionId == e.DivisionId);
DEAQ.EditionDivisionProducts.Remove(Del);
DEAQ.SaveChanges();
ActivityLog.DeleteDivisionProducts(Product, PharmaFormId, Division, CategoryId, ApplicationId, UsersId, Edition);
}
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
public ActionResult createlab(string LabName)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
bool Lab = CreateLab.CreateLabs(LabName, ApplicationId, UsersId);
return(Json(Lab, JsonRequestBehavior.AllowGet));
}
public ActionResult createNewProduct(string Product, string description, string division, string editionid, string pharmaform, string category, string Mentionated, string Participant, string RegisterSanitary, string Country)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
bool d = NewProducts.CreateProduct(Product, description, division, editionid, pharmaform,
category, Mentionated, Participant, RegisterSanitary, ApplicationId, UsersId, Country);
return(Json(d, JsonRequestBehavior.AllowGet));
}
public ActionResult insertinfordiv(string Address, string Suburb, string Location, string ZipCode, string Telephone, string Lada, string Fax,
string Web, string City, string State, string Email, string DivisionId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
bool div = CDI.DivisionInformationC(Address, Suburb, Location, ZipCode, Telephone, Lada, Fax,
Web, City, State, Email, DivisionId, ApplicationId, UsersId);
return(Json(div, JsonRequestBehavior.AllowGet));
}
public ActionResult creatediv(string DivisionN, string ShortName, string Country)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
CountriesSs D = (CountriesSs)Session["CountriesSs"];
int LabId = D.LabId;
bool Div = CreateDiv.CreateDivs(DivisionN, ShortName, Country, LabId, ApplicationId, UsersId);
return(Json(Div, JsonRequestBehavior.AllowGet));
}
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 ActionResult EditProducts(Products Products, string PName, string ProdDescription, string Register, string ProductId, string AppId, string UserId, string CountryId, string DivisionId)
{
try
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
if (ModelState.IsValid)
{
var Division = int.Parse(DivisionId);
var country = int.Parse(CountryId);
int Product = int.Parse(ProductId);
var Divs = db.Divisions.Where(x => x.DivisionId == Division).ToList();
if (Divs.LongCount() > 0)
{
foreach (Divisions _divs in Divs)
{
var prod = db.Products.Where(x => x.LaboratoryId == _divs.LaboratoryId && x.ProductId == Product).ToList();
if (prod.LongCount() > 0)
{
foreach (Products lb in prod)
{
lb.ProductName = PName.Trim();
lb.Description = ProdDescription.Trim();
lb.Register = Register.Trim();
db.SaveChanges();
ActivityLog.EditProducts(ApplicationId, UsersId, PName, ProdDescription, Register, ProductId, _divs.LaboratoryId, country);
}
}
}
}
}
return(View(Products));
}
catch
{
return(View(Products));
}
}
public ActionResult DeleteMentionatedProducts(string ProductId, string DivisionId, string Category, string EditionId, string PharmaForm, string AppId, string UserId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
int Division = int.Parse(DivisionId);
int Edition = int.Parse(EditionId);
int ProdId = int.Parse(ProductId);
int CategoryId = int.Parse(Category);
int PharmaFormId = int.Parse(PharmaForm);
var mp = db.MentionatedProducts.Where(x => x.CategoryId == CategoryId && x.DivisionId == Division && x.EditionId == Edition && x.PharmaFormId == PharmaFormId && x.ProductId == ProdId).ToList();
if (mp.LongCount() > 0)
{
foreach (MentionatedProducts _mp in mp)
{
var delete = db.MentionatedProducts.SingleOrDefault(x => x.CategoryId == _mp.CategoryId && x.DivisionId == Division && x.EditionId == Edition && x.PharmaFormId == PharmaFormId && x.ProductId == ProdId);
if (delete != null)
{
db.MentionatedProducts.Remove(delete);
db.SaveChanges();
}
ActivityLog.DeleteMentionatedProducts(ProdId, PharmaFormId, Division, CategoryId, ApplicationId, UsersId, Edition);
}
}
var edp = db.EditionDivisionProducts.Where(x => x.CategoryId == CategoryId && x.DivisionId == Division && x.EditionId == Edition && x.PharmaFormId == PharmaFormId && x.ProductId == ProdId).ToList();
foreach (EditionDivisionProducts e in edp)
{
var delete = DEAQ.EditionDivisionProducts.SingleOrDefault(x => x.ProductId == e.ProductId && x.EditionId == e.EditionId && x.PharmaFormId == e.PharmaFormId && x.CategoryId == e.CategoryId && x.DivisionId == e.DivisionId);
if (delete != null)
{
DEAQ.EditionDivisionProducts.Remove(delete);
DEAQ.SaveChanges();
ActivityLog.DeleteDivisionProducts(ProdId, PharmaFormId, Division, CategoryId, ApplicationId, UsersId, Edition);
}
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
public ActionResult editlab(string LaboratoryN, string LabId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
int LaboratoryId = int.Parse(LabId);
var EditLab = from Lab in db.Laboratories
where Lab.LaboratoryId == LaboratoryId
select Lab;
foreach (AgroNet.Models.Laboratories l in EditLab)
{
l.LaboratoryName = LaboratoryN;
}
db.SaveChanges();
ActivityLog.updatelab(LaboratoryN, ApplicationId, UsersId, LaboratoryId);
return(View());
}
public ActionResult InsertProductSeeds(string SeedId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
ClasificationProds CP1 = (ClasificationProds)Session["ClasificationProds"];
int?PProductId = CP1.PId;
int ProdId = Convert.ToInt32(PProductId);
int Seed = int.Parse(SeedId);
PProductSeeds.ProductId = ProdId;
PProductSeeds.SeedId = Seed;
db.PProductSeeds.Add(PProductSeeds);
db.SaveChanges();
ActivityLog.InsertProductSeeds(ApplicationId, Seed, ProdId, UsersId);
return(RedirectToAction("productseeds", "Clasification"));
}
public JsonResult Divisions(int country)
{
Divisions Divs = new Divisions();
List <Divisions> LDivs = new List <Models.Divisions>();
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
List <int> Lcountry = p.country;
var Divisions = (from Division in db.Divisions
where Division.CountryId == country &&
Division.ParentId == null
orderby Division.DivisionName ascending
select Division);
foreach (Divisions w in Divisions)
{
Divs = new Divisions();
Divs.DivisionName = w.DivisionName;
Divs.DivisionId = w.DivisionId;
LDivs.Add(Divs);
}
return(Json(LDivs, JsonRequestBehavior.AllowGet));
}
public ActionResult InsertProductCrops(string CropId, string ProductId, string AppId, string UserId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = 0;
int UsersId = 0;
ApplicationId = p.ApplicationId;
UsersId = p.userId;
ClasificationProds CP1 = (ClasificationProds)Session["ClasificationProds"];
int?PProductId = CP1.PId;
int ProdId = Convert.ToInt32(PProductId);
int Crop = int.Parse(CropId);
ProductCrops.CropId = Crop;
ProductCrops.ProductId = ProdId;
db.ProductCrops.Add(ProductCrops);
db.SaveChanges();
ActivityLog.InsertProductCrops(ApplicationId, Crop, ProdId, UsersId);
return(RedirectToAction("productcrops", "Clasification"));
}
public ActionResult productchanges(string ProductId, string DivisionId, string Category, string EditionId, string PharmaForm, string AppId, string UserId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
int PharmaFormId = int.Parse(PharmaForm);
int Division = int.Parse(DivisionId);
int Edition = int.Parse(EditionId);
int Product = int.Parse(ProductId);
int CategoryId = int.Parse(Category);
int ContentType = 0;
var np = db.Newproducts.Where(x => x.CategoryId == CategoryId && x.DivisionId == Division && x.EditionId == Edition && x.PharmaFormId == PharmaFormId && x.ProductId == Product).ToList();
if (np.LongCount() == 0)
{
var pp = db.ParticipantProducts.Where(x => x.CategoryId == CategoryId && x.DivisionId == Division && x.EditionId == Edition && x.PharmaFormId == PharmaFormId && x.ProductId == Product).ToList();
if (pp.LongCount() > 0)
{
foreach (ParticipantProducts P in pp)
{
P.ContentTypeId = 2;
ContentType = 2;
db.SaveChanges();
}
ActivityLog.EditParticipantProducts(ApplicationId, Product, Division, Edition, PharmaFormId, CategoryId, ContentType, UsersId);
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public ActionResult newimages(HttpPostedFileBase file)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
string Size = "";
DivInfoId D = (DivInfoId)Session["DivInfoId"];
int DivisionId = D.DivisionId;
ImagesSizes IMSZ = (ImagesSizes)Session["ImagesSizes"];
int ImageSizeId = IMSZ.SizeId;
string img = Path.GetFileName(file.FileName);
var extension = Path.GetExtension(file.FileName);
string ID = "";
var DI = from DivImg in db.Divisions
where DivImg.DivisionId == DivisionId
select DivImg;
foreach (Divisions Divs in DI)
{
img = Divs.ShortName;
var c = (from country in db.Countries
where country.CountryId == Divs.CountryId
select country).ToList();
foreach (Countries _c in c)
{
ID = _c.ID;
}
}
img = ReplacesImageNames.replaces(img);
var ImagesS = (from ImagesSize in db.ImageSizes
where ImagesSize.ImageSizeId == ImageSizeId
select ImagesSize).ToList();
foreach (ImageSizes IS in ImagesS)
{
Size = IS.Size;
if (IS.ImageSizeId == ImageSizeId)
{
img = img + extension;
var path = Server.MapPath("~/App_Data/DivisionImages/" + ID + "");
if (System.IO.Directory.Exists(path))
{
var root = Path.Combine(path, Size);
if (System.IO.Directory.Exists(root))
{
var rt = Path.Combine(root, img);
file.SaveAs(rt);
}
else
{
var rt = Path.Combine(root, img);
DirectoryInfo Dirs = Directory.CreateDirectory(root);
file.SaveAs(rt);
}
}
else
{
DirectoryInfo Dir = Directory.CreateDirectory(path);
var root = Path.Combine(path, Size);
if (System.IO.Directory.Exists(root))
{
var rt = Path.Combine(root, img);
file.SaveAs(rt);
}
else
{
var rt = Path.Combine(root, img);
DirectoryInfo Dirs = Directory.CreateDirectory(root);
file.SaveAs(rt);
}
}
}
}
bool images = insimage.insertimages(img, DivisionId, ImageSizeId, ApplicationId, UsersId);
return(Json(images, JsonRequestBehavior.AllowGet));
}
public ActionResult newimages(HttpPostedFileBase file, string size, string Product, string PharmaF, string Category, string Division, string Edition)
{
try
{
CountriesUsers pp = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = pp.ApplicationId;
int UsersId = pp.userId;
ProductImages ProductImages = new Models.ProductImages();
int SizeId = int.Parse(size);
int ProductId = int.Parse(Product);
int PharmaFormId = int.Parse(PharmaF);
int CategoryId = int.Parse(Category);
int DivisionId = int.Parse(Division);
int EditionId = int.Parse(Edition);
String FileName = Path.GetFileName(file.FileName);
String extention = Path.GetExtension(file.FileName);
FileName = FileName.Replace(extention, "");
var prods = (from p in db.Products
where p.ProductId == ProductId
select p).ToList();
foreach (Products _prods in prods)
{
FileName = _prods.ProductName.Trim().ToUpper();
}
FileName = ReplacesImageNames.replaces(FileName);
FileName = FileName + extention;
var img = (from _ims in db.ImageSizes
where _ims.ImageSizeId == SizeId
select _ims).ToList();
foreach (ImageSizes _img in img)
{
var root = Path.Combine(Server.MapPath("~/App_Data/uploads/ProductShots"), _img.Size);
var path = Path.Combine(System.Configuration.ConfigurationManager.AppSettings["Path3"], _img.Size);
if (System.IO.Directory.Exists(root))
{
//path = path + "\\" + FileName;
root = root + "\\" + FileName;
//file.SaveAs(path);
file.SaveAs(root);
}
else
{
DirectoryInfo Dir = Directory.CreateDirectory(root);
root = Path.Combine(root, FileName);
file.SaveAs(root);
if (System.IO.Directory.Exists(root))
{
root = root + "\\" + FileName;
file.SaveAs(root);
}
//else
//{
// DirectoryInfo Dirs = Directory.CreateDirectory(root);
// root = Path.Combine(root, FileName);
// file.SaveAs(root);
//}
}
}
var edp = (from _edp in db.ProductCategories
where _edp.CategoryId == CategoryId &&
_edp.DivisionId == DivisionId &&
_edp.PharmaFormId == PharmaFormId &&
_edp.ProductId == ProductId
select _edp).ToList();
if (edp.LongCount() > 0)
{
var eps = (from _eps in db.ProductImages
where _eps.CategoryId == CategoryId &&
_eps.DivisionId == DivisionId &&
_eps.PharmaFormId == PharmaFormId &&
_eps.ProductId == ProductId &&
_eps.ProductShot == FileName
select _eps).ToList();
if (eps.LongCount() == 0)
{
ProductImages.Active = true;
ProductImages.CategoryId = CategoryId;
ProductImages.DivisionId = DivisionId;
ProductImages.PharmaFormId = PharmaFormId;
ProductImages.ProductId = ProductId;
ProductImages.ProductShot = FileName;
ProductImages.BaseURL = null;
db.ProductImages.Add(ProductImages);
db.SaveChanges();
var epss = (from _eps in db.ProductImages
where _eps.CategoryId == CategoryId &&
_eps.DivisionId == DivisionId &&
_eps.PharmaFormId == PharmaFormId &&
_eps.ProductId == ProductId &&
_eps.ProductShot == FileName
select _eps).ToList();
int ProductImageSizeId = 0;
foreach (ProductImages _epss in epss)
{
ProductImageSizeId = _epss.ProductImageId;
var pis = (from _pis in db.ProductImageSizes
where _pis.ImageSizeId == SizeId &&
_pis.ProductImageId == _epss.ProductImageId
select _pis).ToList();
if (pis.LongCount() == 0)
{
ProductImageSizes ProductImageSizes = new ProductImageSizes();
ProductImageSizes.ImageSizeId = Convert.ToByte(SizeId);
ProductImageSizes.ProductImageId = _epss.ProductImageId;
db.ProductImageSizes.Add(ProductImageSizes);
db.SaveChanges();
ActivityLog._insertProductImageSizes(ProductImageSizeId, SizeId, ApplicationId, UsersId);
}
ActivityLog._insertproductimages(ProductId, PharmaFormId, DivisionId, CategoryId, ProductImageSizeId, FileName, ApplicationId, UsersId);
}
}
else
{
var epss = (from _eps in db.ProductImages
where _eps.CategoryId == CategoryId &&
_eps.DivisionId == DivisionId &&
_eps.PharmaFormId == PharmaFormId &&
_eps.ProductId == ProductId &&
_eps.ProductShot == FileName
select _eps).ToList();
int ProductImageSizeId = 0;
foreach (ProductImages _epss in epss)
{
ProductImageSizeId = _epss.ProductImageId;
var pis = (from _pis in db.ProductImageSizes
where _pis.ImageSizeId == SizeId &&
_pis.ProductImageId == _epss.ProductImageId
select _pis).ToList();
if (pis.LongCount() == 0)
{
ProductImageSizes ProductImageSizes = new ProductImageSizes();
ProductImageSizes.ImageSizeId = Convert.ToByte(SizeId);
ProductImageSizes.ProductImageId = _epss.ProductImageId;
db.ProductImageSizes.Add(ProductImageSizes);
db.SaveChanges();
ActivityLog._insertProductImageSizes(ProductImageSizeId, SizeId, ApplicationId, UsersId);
}
}
ProductImages.ProductShot = FileName;
db.SaveChanges();
ActivityLog._updateproductimages(ProductId, PharmaFormId, DivisionId, CategoryId, ProductImageSizeId, FileName, ApplicationId, UsersId);
}
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
String msg = e.Message;
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
/* PRODUCTOS PARTICIPANTES */
public ActionResult InsertParticipantProducts(string ProductId, string DivisionId, string Category, string EditionId, string PharmaForm, string AppId, string UserId)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
int ProdId = int.Parse(ProductId);
int Edition = int.Parse(EditionId);
int PharmaFormId = int.Parse(PharmaForm);
int CategoryId = int.Parse(Category);
int Division = int.Parse(DivisionId);
var mp = db.MentionatedProducts.Where(x => x.CategoryId == CategoryId && x.DivisionId == Division && x.EditionId == Edition && x.PharmaFormId == PharmaFormId && x.ProductId == ProdId).ToList();
if (mp.LongCount() > 0)
{
foreach (MentionatedProducts _mp in mp)
{
var delete = db.MentionatedProducts.SingleOrDefault(x => x.CategoryId == _mp.CategoryId && x.DivisionId == _mp.DivisionId && x.EditionId == _mp.EditionId && x.PharmaFormId == _mp.PharmaFormId && x.ProductId == _mp.ProductId);
if (delete != null)
{
db.MentionatedProducts.Remove(delete);
db.SaveChanges();
ActivityLog.DeleteMentionatedProducts(ProdId, PharmaFormId, Division, CategoryId, ApplicationId, UsersId, Edition);
}
}
}
var edp = db.EditionDivisionProducts.Where(x => x.CategoryId == CategoryId && x.DivisionId == Division && x.EditionId == Edition && x.PharmaFormId == PharmaFormId && x.ProductId == ProdId).ToList();
if (edp.LongCount() == 0)
{
EditionDivisionProducts.EditionId = Edition;
EditionDivisionProducts.ProductId = ProdId;
EditionDivisionProducts.PharmaFormId = PharmaFormId;
EditionDivisionProducts.DivisionId = Division;
EditionDivisionProducts.CategoryId = CategoryId;
DEAQ.EditionDivisionProducts.Add(EditionDivisionProducts);
DEAQ.SaveChanges();
ActivityLog.EditionDivisionProducts(ProdId, PharmaFormId, Division, CategoryId, ApplicationId, UsersId, Edition);
}
var pp = db.ParticipantProducts.Where(x => x.CategoryId == CategoryId && x.DivisionId == Division && x.EditionId == Edition && x.PharmaFormId == PharmaFormId && x.ProductId == ProdId).ToList();
if (pp.LongCount() == 0)
{
ParticipantProducts.CategoryId = CategoryId;
ParticipantProducts.DivisionId = Division;
ParticipantProducts.EditionId = Edition;
ParticipantProducts.PharmaFormId = PharmaFormId;
ParticipantProducts.ProductId = ProdId;
db.ParticipantProducts.Add(ParticipantProducts);
db.SaveChanges();
ActivityLog.ParticipanProducts(ProdId, PharmaFormId, Division, CategoryId, ApplicationId, UsersId, Edition);
}
return(RedirectToAction("Index"));
}
public ActionResult editinfo(string Address, string Suburb, string Location, string ZipCode, string Telephone, string Lada, string Fax,
string Web, string City, string State, string Email, string DivisionId, string DivisionInformation)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
int Division = int.Parse(DivisionId);
int DivisionInformationId = int.Parse(DivisionInformation);
var DI = from DivInf in db.DivisionInformation
where DivInf.DivisionId == Division &&
DivInf.DivisionInformationId == DivisionInformationId
select DivInf;
foreach (DivisionInformation DInf in DI)
{
if (Address != string.Empty)
{
DInf.Address = Address.Trim();
}
else
{
DInf.Address = null;
}
if (Suburb != string.Empty)
{
DInf.Suburb = Suburb.Trim();
}
else
{
DInf.Suburb = null;
}
if (Location != string.Empty)
{
DInf.Location = Location.Trim();
}
else
{
DInf.Location = null;
}
if (ZipCode != string.Empty)
{
DInf.ZipCode = ZipCode.Trim();
}
else
{
DInf.ZipCode = null;
}
if (Telephone != string.Empty)
{
DInf.Telephone = Telephone.Trim();
}
else
{
DInf.Telephone = null;
}
if (Lada != string.Empty)
{
DInf.Lada = Lada.Trim();
}
else
{
DInf.Lada = null;
}
if (Fax != string.Empty)
{
DInf.Fax = Fax.Trim();
}
else
{
DInf.Fax = null;
}
if (Web != string.Empty)
{
DInf.Web = Web.Trim();
}
else
{
DInf.Web = null;
}
if (City != string.Empty)
{
DInf.City = City.Trim();
}
else
{
DInf.City = null;
}
if (State != string.Empty)
{
DInf.State = State.Trim();
}
else
{
DInf.State = null;
}
if (Email != string.Empty)
{
DInf.Email = Email.Trim();
}
else
{
DInf.Email = null;
}
}
db.SaveChanges();
//ActivityLog.editivisioninformation(Address.Trim(), Suburb.Trim(), Location.Trim(), ZipCode.Trim(), Telephone.Trim(),
// Lada.Trim(), Fax.Trim(), Web.Trim(), City.Trim(), State.Trim(), Email.Trim(), Division, DivisionInformationId, ApplicationId, UsersId);
return(RedirectToAction("Index", "DivisionInformation"));
}
