protected void btn_submit_Click(object sender, EventArgs e) { string filename = ""; string docpath = ""; string licensename = ""; string licno = ""; using (Person_Details.Person_LicenseDataContext pldc = new Person_LicenseDataContext()) { tbl_PersonDetail obj = new tbl_PersonDetail(); obj = pldc.tbl_PersonDetails.Where(c => c.Person_ID == Convert.ToInt32(hfdperid.Value)).SingleOrDefault(); licensename = obj.First_Name + ' ' + obj.Middle_Name + ' ' + obj.Last_Name; tbl_license lic = pldc.tbl_licenses.Where(c => c.Person_ID == Convert.ToInt32(hfdperid.Value)).FirstOrDefault(); if (lic != null) { tbl_license lic1 = pldc.tbl_licenses.Where(c => c.Person_ID == Convert.ToInt32(hfdperid.Value)).OrderByDescending(c => c.License_ID).First(); licno = lic1.Lic_no; } } JavaScriptSerializer js = new JavaScriptSerializer(); var docdata = js.Deserialize <List <string> >(hfddocument.Value); foreach (string t in docdata) { string[] fdata = t.Split('~'); string url = System.Configuration.ConfigurationManager.AppSettings["lmsdoclink"].ToString() + DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + fdata[0]; int docid = Person_Details.Licensing_Details.InsertWellnessDocument(Convert.ToInt32(hfddocid.Value), hfdperid.Value, ddl_doctype.SelectedValue, url, fdata[1], txtdoccomments.Text, Session["UID"].ToString(), Convert.ToDateTime(DateTime.Now.ToShortDateString())); } altbox("Record inserted successfully."); Clear(); }
protected void btnsubmitall_Click(object sender, EventArgs e) { string licensename = ""; string licno = ""; using (Person_Details.Person_LicenseDataContext pldc = new Person_LicenseDataContext()) { tbl_PersonDetail obj = new tbl_PersonDetail(); obj = pldc.tbl_PersonDetails.Where(c => c.Person_ID == Convert.ToInt32(hfdperid.Value)).SingleOrDefault(); licensename = obj.First_Name + ' ' + obj.Middle_Name + ' ' + obj.Last_Name; tbl_license lic = pldc.tbl_licenses.Where(c => c.Person_ID == Convert.ToInt32(hfdperid.Value)).FirstOrDefault(); if (lic != null) { tbl_license lic1 = pldc.tbl_licenses.Where(c => c.Person_ID == Convert.ToInt32(hfdperid.Value)).OrderByDescending(c => c.License_ID).First(); licno = lic1.Lic_no; } var query = pldc.tbl_Person_wellness_Documents.Where(c => c.Person_ID == hfdperid.Value).ToList(); if (query.Count != 0) { foreach (tbl_Person_wellness_Document ac in query) { ac.AllDocumentsReceived = chkalldocumentsreceived.Checked; ac.Modified_By = Session["UID"].ToString(); ac.Modified_Date = Convert.ToDateTime(DateTime.Now.ToShortDateString()); } pldc.SubmitChanges(); if (chkalldocumentsreceived.Checked) { Mail.SendMail("", "[email protected];[email protected];[email protected];[email protected];[email protected]", "", "Wellness Docs Marked Complete", "Name : " + licensename + "</br>License #: : " + licno); } } else { string js = " altbox('No documents found.');"; ScriptManager.RegisterStartupScript(Page, GetType(), "scr", js, true); chkalldocumentsreceived.Checked = false; } } }