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 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 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 ActionResult substances(int?ProductId, int?PharmaFormId, int?CategoryId, string ActiveSubstanceName)
{
Search search = (Search)Session["Search"];
if (ProductId != null)
{
int?PId = ProductId;
int?PFId = PharmaFormId;
int?CatId = CategoryId;
ClasificationProds ClasificationProds = new ClasificationProds(PId, PFId, CatId);
Session["ClasificationProds"] = ClasificationProds;
var aA = db.Database.SqlQuery <ActiveSubstances>("plm_spGetPActiveSubstances @ProductId=" + PId + "").ToList();
//ViewData["Subs"] = false;
ViewData["Count"] = null;
return(View(aA));
}
else
{
ClasificationProds CP1 = (ClasificationProds)Session["ClasificationProds"];
int?PId = CP1.PId;
var aA = db.Database.SqlQuery <ActiveSubstances>("plm_spGetPActiveSubstances @ProductId=" + PId + "").ToList();
ViewData["Subs"] = true;
ViewData["Count"] = null;
return(View(aA));
}
}
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 ActionResult productseeds()
{
ClasificationProds CPPC = (ClasificationProds)Session["ClasificationProds"];
int?ProdIdC = CPPC.PId;
var PSeeds = db.Database.SqlQuery <Seeds>("plm_spGetPProductSeeds @ProductId=" + ProdIdC + "").ToList();
ViewData["Count"] = null;
return(View(PSeeds));
}
public ActionResult searchcrop(string CropName)
{
int count = 0;
if (CropName != null)
{
if (CropName == string.Empty)
{
return(RedirectToAction("productcrops"));
}
else
{
ClasificationProds CPPC = (ClasificationProds)Session["ClasificationProds"];
int?ProdIdC = CPPC.PId;
var PCrops = db.Database.SqlQuery <Crops>("plm_spGetPPCropsSearch @ProductId=" + ProdIdC + ", @param='" + CropName + "'").ToList();
foreach (Crops C in PCrops)
{
count = count + 1;
}
ViewData["Count"] = count;
SearchCrop searchCrop = new SearchCrop(CropName);
Session["searchCrop"] = searchCrop;
return(View("productcrops", PCrops));
}
}
else if (CropName == null)
{
SearchCrop Sr = (SearchCrop)Session["searchCrop"];
var Ind = from Crop in db.Crops
select Crop;
if (!string.IsNullOrEmpty(Sr.CropName))
{
Ind = Ind.Where(s => s.CropName.StartsWith(Sr.CropName));
foreach (Crops J in Ind)
{
count = count + 1;
}
ViewData["Count"] = count;
}
return(View("productcrops", Ind));
}
return(View());
}
public ActionResult searchs(string SeedName)
{
int count = 0;
if (SeedName != null)
{
if (SeedName == string.Empty)
{
return(RedirectToAction("productseeds"));
}
else
{
ClasificationProds CPPC = (ClasificationProds)Session["ClasificationProds"];
int?ProdIdC = CPPC.PId;
var PSeeds = db.Database.SqlQuery <Seeds>("plm_spGetPPSeedsSearch @ProductId=" + ProdIdC + ", @param='" + SeedName + "'").ToList();
foreach (Seeds S in PSeeds)
{
count = count + 1;
}
ViewData["Count"] = count;
SearchSeeds searchseed = new SearchSeeds(SeedName);
Session["searchseed"] = searchseed;
return(View("productseeds", PSeeds));
}
}
else if (SeedName == null)
{
SearchSeeds Sr = (SearchSeeds)Session["searchseed"];
var Ind = from seed in db.Seeds
select seed;
if (!string.IsNullOrEmpty(Sr.SeedName))
{
Ind = Ind.Where(s => s.SeedName.StartsWith(Sr.SeedName));
foreach (Seeds J in Ind)
{
count = count + 1;
}
ViewData["Count"] = count;
}
return(View("productseeds", Ind));
}
return(View());
}
public ActionResult searchsubstance(string ActiveSubstanceName)
{
int count = 0;
if (ActiveSubstanceName != null)
{
if (ActiveSubstanceName == string.Empty)
{
return(RedirectToAction("Clasification"));
}
else
{
ClasificationProds CPPC = (ClasificationProds)Session["ClasificationProds"];
int?ProdIdC = CPPC.PId;
var PSubs = db.Database.SqlQuery <ActiveSubstances>("plm_spGetPPSubstancesSearch @ProductId=" + ProdIdC + ", @param='" + ActiveSubstanceName + "'").ToList();
foreach (ActiveSubstances A in PSubs)
{
count = count + 1;
}
ViewData["Count"] = count;
SearchSubstance SearchSubs = new SearchSubstance(ActiveSubstanceName);
Session["SearchSubs"] = SearchSubs;
return(View("Clasification", PSubs));
}
}
else if (ActiveSubstanceName == null)
{
SearchSubstance Sr = (SearchSubstance)Session["SearchSubs"];
var Ind = from ActSubs in db.ActiveSubstances
select ActSubs;
if (!string.IsNullOrEmpty(Sr.ActiveSubstance))
{
Ind = Ind.Where(s => s.ActiveSubstanceName.StartsWith(Sr.ActiveSubstance));
foreach (ActiveSubstances J in Ind)
{
count = count + 1;
}
ViewData["Count"] = count;
}
return(View("Clasification", Ind));
}
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 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 Clasification(int?ProductId, int?PharmaFormId, int?CategoryId)
{
ViewData["Subs"] = false;
if (ProductId == null)
{
ClasificationProds CP1 = (ClasificationProds)Session["ClasificationProds"];
int?PId = CP1.PId;
var aA = db.Database.SqlQuery <ActiveSubstances>("plm_spGetPActiveSubstances @ProductId=" + PId + "").ToList();
//ViewData["Subs"] = true;
return(View(aA));
}
else
{
int?PId = ProductId;
int?PFId = PharmaFormId;
int?CatId = CategoryId;
ClasificationProds ClasificationProds = new ClasificationProds(PId, PFId, CatId);
Session["ClasificationProds"] = ClasificationProds;
var aA = db.Database.SqlQuery <ActiveSubstances>("plm_spGetPActiveSubstances @ProductId=" + PId + "").ToList();
//ViewData["Subs"] = false;
return(View(aA));
}
}
