protected void btnSubmit_Click(object sender, EventArgs e)
{
DatabaseDataContext db = new DatabaseDataContext();
PharmacyChemical tmpitem = new PharmacyChemical();
tmpitem.chemicalName = txtInputChemicalName.Text;
tmpitem.subCategoryName = (from sub in db.SubCategories
where sub.subCategoryName == txtInputSubCategory.SelectedItem.Text
select sub.subCategoryName).First();
db.PharmacyChemicals.InsertOnSubmit(tmpitem);
db.SubmitChanges();
Response.Redirect(Util.UrlRewriting.encodeUrl("updatePharmacy.aspx?chemicalName=" + tmpitem.chemicalName));
}
private void fillPharmacyChemical(int PharamacyChemicalCnt, DatabaseDataContext db)
{
for (int i = 0; i < PharamacyChemicalCnt; i++)
{
try
{
PharmacyChemical tmpitem = new PharmacyChemical();
tmpitem.chemicalName = randomName(rad.Next() % 20);
tmpitem.greekName = randomGreekName(rad.Next() % 20);
tmpitem.dose = randomText(rad.Next() % 30);
tmpitem.indication = randomText(rad.Next() % 400);
tmpitem.contraIndication = randomText(rad.Next() % 400);
tmpitem.undesirableReactions = randomText(rad.Next() % 400);
tmpitem.interactionGeneral = randomText(rad.Next() % 400);
tmpitem.subCategoryName = db.SubCategories.ToList()[rad.Next() % db.SubCategories.Count()].subCategoryName;
db.PharmacyChemicals.InsertOnSubmit(tmpitem);
db.SubmitChanges();
}
catch (Exception exp)
{
Response.Write(exp.Message);
Response.Write("<br>");
Response.Flush();
}
}
}
private static int countPharmacyComercials(DatabaseDataContext db, PharmacyChemical chem1)
{
int cnt = 0;
var query = (from phar in db.PharmacyCommercials
where phar.chemicalName == chem1.chemicalName
select phar);
cnt = query.Count();
return cnt;
}
