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