protected void btnSubmit_Click(object sender, EventArgs e) { DatabaseDataContext db = new DatabaseDataContext(); if (InterChemicalName2 != "") { InteractionPharmacyPharmacy tmpItem = new InteractionPharmacyPharmacy(); tmpItem.pharmacyname1 = InterChemicalName; tmpItem.pharmacyname2 = InterChemicalName2; tmpItem.comment = txtInterComment.Text; db.InteractionPharmacyPharmacies.InsertOnSubmit(tmpItem); } else if (InterSubCategoryName != null) { InteractionPharmacySubCategory tmpItem = new InteractionPharmacySubCategory(); tmpItem.chemicalName = InterChemicalName; tmpItem.subCategoryName = InterSubCategoryName; tmpItem.comment = txtInterComment.Text; db.InteractionPharmacySubCategories.InsertOnSubmit(tmpItem); } db.SubmitChanges(); Response.Redirect(Util.UrlRewriting.encodeUrl("updateInteraction.aspx?chemicalName="+InterChemicalName)); }
private void fillInteractionsSubCategory(DatabaseDataContext db) { PharmacyChemical[] pharms = db.PharmacyChemicals.ToArray(); for (int i = 0; i < pharms.Count(); i++) { for (int j = 0; j < 5; j++) { if (rad.Next() % 3 != 0) break; try { InteractionPharmacySubCategory tmpitem = new InteractionPharmacySubCategory(); tmpitem.chemicalName = pharms[i].chemicalName; tmpitem.subCategoryName = pharms[rad.Next() % pharms.Count()].subCategoryName; tmpitem.comment = randomText(rad.Next() % 100); if ((from inter in db.InteractionPharmacySubCategories where (inter.chemicalName == tmpitem.chemicalName && inter.subCategoryName == tmpitem.subCategoryName) select inter.chemicalName).Count() < 1) { db.InteractionPharmacySubCategories.InsertOnSubmit(tmpitem); db.SubmitChanges(); } } catch (Exception exp) { Response.Write(exp.Message); Response.Write("<br>"); Response.Flush(); } } } }