public static int Edit_USCitizen(int personid, string isuscitizen, string citizenexpiratinondate, string modifiedby, string modifieddate)
{
using (License_ConnectionDataContext pdetalinsert = new License_ConnectionDataContext())
{
tbl_PersonDetail persondetail;
if (personid == 0)
{
persondetail = new tbl_PersonDetail();
}
else
{
persondetail = pdetalinsert.tbl_PersonDetails.Where(c => c.Person_ID == personid).SingleOrDefault();
}
persondetail.Person_ID = personid;
persondetail.IS_US_Citizen = isuscitizen;
if (citizenexpiratinondate != "")
{
persondetail.Citizen_Expiration_Date = Convert.ToDateTime(citizenexpiratinondate);
}
else
{
persondetail.Citizen_Expiration_Date = null;
}
persondetail.Modified_By = modifiedby;
persondetail.Modified_Date = Convert.ToDateTime(modifieddate);
if (personid == 0)
{
pdetalinsert.tbl_PersonDetails.InsertOnSubmit(persondetail);
}
pdetalinsert.SubmitChanges();
return(persondetail.Person_ID);
}
}
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();
}
public static void BindSubobjvalues(DropDownList ddlfee, string pid)
{
int revobjid = 1;
using (Person_Details.Person_LicenseDataContext ldb = new Person_Details.Person_LicenseDataContext())
{
tbl_PersonDetail per = ldb.tbl_PersonDetails.Where(c => c.Person_ID == Convert.ToInt32(pid)).SingleOrDefault();
if (per.object_type != 1)
{
revobjid = 2;
}
}
if (revobjid == 1)
{
ddlfee.DataSource = Person_Details.Licensing_Details.Get_subobjValues().Where(c => c.Rev_obj_Id == 1);
}
else
{
ddlfee.DataSource = Person_Details.Licensing_Details.Get_subobjValues().Where(c => c.Rev_obj_Id == 2);
}
ddlfee.DataValueField = "Subobj_Id";
ddlfee.DataTextField = "Description";
ddlfee.DataBind();
ddlfee.Items.Insert(0, new ListItem("Select Fee Type", "-1"));
}
public static int Edit_businessInfo(int personid, string businessname, string ownersname, string dob, string fein, string dea, string modifiedby, string modifieddate, string skippayment, string eprofile)
{
using (License_ConnectionDataContext pdetalinsert = new License_ConnectionDataContext())
{
tbl_PersonDetail persondetail;
if (personid == 0)
{
persondetail = new tbl_PersonDetail();
}
else
{
persondetail = pdetalinsert.tbl_PersonDetails.Where(c => c.Person_ID == personid).SingleOrDefault();
}
if (persondetail.Business != businessname || persondetail.FEIN != fein)
{
tbl_Name_History obj = new tbl_Name_History();
obj.Person_ID = personid.ToString();
obj.Last_Name = persondetail.Business;
obj.SSN = persondetail.FEIN;
obj.CreatedBy = persondetail.Created_By;
obj.CreatedDate = persondetail.Created_Date;
obj.ModifiedBy = modifiedby;
obj.ModifiedDate = Convert.ToDateTime(modifieddate);
pdetalinsert.tbl_Name_Histories.InsertOnSubmit(obj);
tbl_Licensing_Journal_Detail jour = new tbl_Licensing_Journal_Detail();
jour.Person_Id = personid;
jour.Journal_Type_Id = 573;
jour.Is_Alert = false;
jour.Isce = 0;
jour.Description = "Name Changed on " + DateTime.Now.ToShortDateString();
jour.Createdby = modifiedby;
jour.CreatedDate = Convert.ToDateTime(modifieddate);
pdetalinsert.tbl_Licensing_Journal_Details.InsertOnSubmit(jour);
}
persondetail.Person_ID = personid;
persondetail.Business = businessname;
persondetail.Ownersifdiff = ownersname;
if (dob != "")
{
persondetail.DOB = Convert.ToDateTime(dob);
}
persondetail.FEIN = fein;
persondetail.DEA = dea;
persondetail.Modified_By = modifiedby;
persondetail.Modified_Date = Convert.ToDateTime(modifieddate);
persondetail.SkipPayment = skippayment;
persondetail.NABP_E_Profile_Number = eprofile;
if (personid == 0)
{
pdetalinsert.tbl_PersonDetails.InsertOnSubmit(persondetail);
}
pdetalinsert.SubmitChanges();
return(persondetail.Person_ID);
}
}
public static int Edit_AddressInfo(int personid, string address1, string address2, string city, string state, string country, string zip, string modifiedby, string modifieddate)
{
using (License_ConnectionDataContext pdetalinsert = new License_ConnectionDataContext())
{
tbl_PersonDetail persondetail;
if (personid == 0)
{
persondetail = new tbl_PersonDetail();
}
else
{
persondetail = pdetalinsert.tbl_PersonDetails.Where(c => c.Person_ID == personid).SingleOrDefault();
}
if (persondetail.Address1 != address1 || persondetail.Address2 != address2 || persondetail.City != city || persondetail.State != state || persondetail.County != country || persondetail.Zip != zip)
{
tbl_Address_History obj = new tbl_Address_History();
obj.Address1 = persondetail.Address1;
obj.Address2 = persondetail.Address2;
obj.Person_ID = personid.ToString();
obj.City = persondetail.City;
obj.State = persondetail.State;
obj.County = persondetail.County;
obj.Zip = persondetail.Zip;
obj.CreatedBy = persondetail.Created_By;
obj.CreatedDate = persondetail.Created_Date;
obj.ModifiedBy = modifiedby;
obj.ModifiedDate = Convert.ToDateTime(modifieddate);
pdetalinsert.tbl_Address_Histories.InsertOnSubmit(obj);
tbl_Licensing_Journal_Detail jour = new tbl_Licensing_Journal_Detail();
jour.Person_Id = personid;
jour.Journal_Type_Id = 572;
jour.Is_Alert = false;
jour.Isce = 0;
jour.Description = "Address Changed on " + DateTime.Now.ToShortDateString();
jour.Createdby = modifiedby;
jour.CreatedDate = Convert.ToDateTime(modifieddate);
pdetalinsert.tbl_Licensing_Journal_Details.InsertOnSubmit(jour);
}
persondetail.Person_ID = personid;
persondetail.Address1 = address1;
persondetail.Address2 = address2;
persondetail.City = city;
persondetail.State = state;
persondetail.County = country;
persondetail.Zip = zip;
persondetail.Modified_By = modifiedby;
persondetail.Modified_Date = Convert.ToDateTime(modifieddate);
if (personid == 0)
{
pdetalinsert.tbl_PersonDetails.InsertOnSubmit(persondetail);
}
pdetalinsert.SubmitChanges();
return(persondetail.Person_ID);
}
}
public static int EditDemographicsUpdate(int personid, string fname, string mname, string lname, string maidenname, string gender, string dob, string ssn, string age, string address1, string address2, string city, string state, string country, string zip, string phtype, string phone, string altphtype, string altphone, string maritalstatus, string fax, string email, string isuscitizen, string status, string createdby, string createddate, string modifiedby, string modifieddate)
{
using (License_ConnectionDataContext pdetalinsert = new License_ConnectionDataContext())
{
tbl_PersonDetail persondetail;
if (personid == 0)
{
persondetail = new tbl_PersonDetail();
}
else
{
persondetail = pdetalinsert.tbl_PersonDetails.Where(c => c.Person_ID == personid).SingleOrDefault();
}
persondetail.Person_ID = personid;
persondetail.First_Name = fname;
persondetail.Middle_Name = mname;
persondetail.Last_Name = lname;
persondetail.Madian_Name = maidenname;
persondetail.Gender = gender;
persondetail.DOB = Convert.ToDateTime(dob);
persondetail.SSN = ssn;
persondetail.Age = age;
persondetail.Address1 = address1;
persondetail.Address2 = address2;
persondetail.City = city;
persondetail.State = state;
persondetail.County = country;
persondetail.Zip = zip;
persondetail.PhoneType = phtype;
persondetail.Phone = phone;
persondetail.Alternate_PhoneType = altphtype;
persondetail.Alternate_Phone = altphone;
persondetail.Martial_Status = maritalstatus;
persondetail.Fax = fax;
persondetail.Email = email;
persondetail.IS_US_Citizen = isuscitizen;
persondetail.Status = status;
persondetail.Created_By = createdby;
persondetail.Created_Date = Convert.ToDateTime(createddate);
persondetail.Modified_By = modifiedby;
persondetail.Modified_Date = Convert.ToDateTime(modifieddate);
if (personid == 0)
{
pdetalinsert.tbl_PersonDetails.InsertOnSubmit(persondetail);
}
pdetalinsert.SubmitChanges();
return(persondetail.Person_ID);
}
}
public static int Edit_ContactInfo(int personid, string phone, string altphtype, string fax, string email, string modifiedby, string modifieddate)
{
using (License_ConnectionDataContext pdetalinsert = new License_ConnectionDataContext())
{
tbl_PersonDetail persondetail;
if (personid == 0)
{
persondetail = new tbl_PersonDetail();
}
else
{
persondetail = pdetalinsert.tbl_PersonDetails.Where(c => c.Person_ID == personid).SingleOrDefault();
}
if (persondetail.Phone != phone || persondetail.Alternate_PhoneType != altphtype || persondetail.Email != email)
{
tbl_Contact_History obj = new tbl_Contact_History();
obj.Person_ID = personid.ToString();
obj.Phone = persondetail.Phone;
obj.Alt_Phone = persondetail.Alternate_Phone;
obj.Email = persondetail.Email;
obj.CreatedBy = persondetail.Created_By;
obj.CreatedDate = persondetail.Created_Date;
obj.ModifiedBy = modifiedby;
obj.ModifiedDate = Convert.ToDateTime(modifieddate);
pdetalinsert.tbl_Contact_Histories.InsertOnSubmit(obj);
}
persondetail.Person_ID = personid;
persondetail.Phone = phone;
persondetail.Alternate_Phone = altphtype;
persondetail.Fax = fax;
persondetail.Email = email;
persondetail.Modified_By = modifiedby;
persondetail.Modified_Date = Convert.ToDateTime(modifieddate);
if (personid == 0)
{
pdetalinsert.tbl_PersonDetails.InsertOnSubmit(persondetail);
}
pdetalinsert.SubmitChanges();
return(persondetail.Person_ID);
}
}
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;
}
}
}
public static int Edit_PersonalInfo(int personid, string fname, string mname, string lname, string maidenname, string gender, string dob, string ssn, string age, string cpe, string maritalstatus, string status, string modifiedby, string modifieddate, string ethincity, string triningcompleted)
{
using (License_ConnectionDataContext pdetalinsert = new License_ConnectionDataContext())
{
tbl_PersonDetail persondetail;
if (personid == 0)
{
persondetail = new tbl_PersonDetail();
}
else
{
persondetail = pdetalinsert.tbl_PersonDetails.Where(c => c.Person_ID == personid).SingleOrDefault();
}
if (persondetail.First_Name != fname || persondetail.Middle_Name != mname || persondetail.Last_Name != lname || persondetail.DOB != Convert.ToDateTime(dob) || persondetail.SSN != ssn)
{
tbl_Name_History obj = new tbl_Name_History();
obj.Person_ID = personid.ToString();
obj.First_Name = persondetail.First_Name;
obj.Last_Name = persondetail.Last_Name;
obj.Middle_Name = persondetail.Middle_Name;
obj.DOB = persondetail.DOB;
obj.SSN = persondetail.SSN;
obj.CreatedBy = persondetail.Created_By;
obj.CreatedDate = persondetail.Created_Date;
obj.ModifiedBy = modifiedby;
obj.ModifiedDate = Convert.ToDateTime(modifieddate);
pdetalinsert.tbl_Name_Histories.InsertOnSubmit(obj);
tbl_Licensing_Journal_Detail jour = new tbl_Licensing_Journal_Detail();
jour.Person_Id = personid;
jour.Journal_Type_Id = 573;
jour.Is_Alert = false;
jour.Isce = 0;
jour.Description = "Name Changed on " + DateTime.Now.ToShortDateString();
jour.Createdby = modifiedby;
jour.CreatedDate = Convert.ToDateTime(modifieddate);
pdetalinsert.tbl_Licensing_Journal_Details.InsertOnSubmit(jour);
}
persondetail.Person_ID = personid;
persondetail.First_Name = fname;
persondetail.Middle_Name = mname;
persondetail.Last_Name = lname;
persondetail.Ethincity = ethincity;
persondetail.Madian_Name = maidenname;
persondetail.Gender = gender;
persondetail.DOB = Convert.ToDateTime(dob);
persondetail.SSN = ssn;
persondetail.Age = age;
persondetail.CPE = cpe;
persondetail.Training_Completed = triningcompleted;
persondetail.Martial_Status = maritalstatus;
persondetail.Status = status;
persondetail.Modified_By = modifiedby;
persondetail.Modified_Date = Convert.ToDateTime(modifieddate);
if (personid == 0)
{
pdetalinsert.tbl_PersonDetails.InsertOnSubmit(persondetail);
}
pdetalinsert.SubmitChanges();
return(persondetail.Person_ID);
}
}
