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