protected void btnPharmacyCommercialAdd_Click(object sender, EventArgs e) { DatabaseDataContext db = new DatabaseDataContext(); PharmacyCommercial newItem = new PharmacyCommercial(); newItem.chemicalName = chemicalName; newItem.company = txtPharmacyCompany.Text; newItem.morph = txtPharmacyMorph.Text; newItem.name = txtPharmacyName.Text; db.PharmacyCommercials.InsertOnSubmit(newItem); db.SubmitChanges(); Response.Redirect(Util.UrlRewriting.encodeUrl("updatePharmacy.aspx?chemicalName=" + chemicalName )); }
private void fillPharamcyCommercial(int PharamacyCommercialCnt, DatabaseDataContext db) { foreach (PharmacyChemical ph in db.PharmacyChemicals) { for (int i=0; i < 50; i++) { if (rad.Next() % 20 == 0) break; try { PharmacyCommercial tmpitem = new PharmacyCommercial(); tmpitem.name = randomName(rad.Next() % 20); tmpitem.morph = randomText(rad.Next() % 10); tmpitem.company = randomName(rad.Next() % 20); tmpitem.PharmacyChemical = ph; db.PharmacyCommercials.InsertOnSubmit(tmpitem); db.SubmitChanges(); if (rad.Next() % 50 == 0) { PharmacyCommercial tmpitem1 = new PharmacyCommercial(); tmpitem1.name = tmpitem.name; tmpitem1.morph = tmpitem.morph; tmpitem1.company = tmpitem.company; tmpitem1.chemicalName = db.PharmacyChemicals.ToList()[rad.Next() % db.PharmacyChemicals.Count()].chemicalName; if ((from phar in db.PharmacyCommercials where (phar.name == tmpitem1.name && phar.morph == tmpitem1.morph && phar.company == tmpitem1.company && phar.chemicalName == tmpitem1.chemicalName) select phar.chemicalName).Count() < 1) { db.PharmacyCommercials.InsertOnSubmit(tmpitem1); db.SubmitChanges(); } } } catch (Exception exp) { Response.Write(exp.Message); Response.Write("<br>"); Response.Flush(); } } } }