protected void btnedit_click(object sender, EventArgs e)
{
string value = hfdselid.Value;
tbl_Licensing_Journal_Detail obj = Utilities_Licensing.EditJournal(Convert.ToInt32(value));
hfdjournalid.Value = obj.Journal_Id.ToString();
string journal = "";
journal = obj.Journal_Type_Id.ToString();
if (ddlJournalType.Items[0].Text != journal)
{
ddlJournalType.Items[0].Selected = false;
if (ddlJournalType.Items.FindByValue(journal) != null)
{
ddlJournalType.Items.FindByValue(journal).Selected = true;
}
}
//ddlJournalType.SelectedValue = obj.Journal_Type_ID.ToString();
string isalerts = obj.Is_Alert.ToString();
if (isalerts == "True")
{
ChkjournalAlert.Checked = true;
}
else
{
ChkjournalAlert.Checked = false;
}
txtjournaltype.Text = obj.Description;
Page.RegisterStartupScript("scr", "<script>Popup();</script>");
}
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);
}
}
protected void btndel_click(object sender, EventArgs e)
{
string value = hfdselid.Value;
tbl_Licensing_Journal_Detail obj = new tbl_Licensing_Journal_Detail();
obj.Journal_Id = Convert.ToInt32(value);
Person_Details.Licensing_Details.DeleteJournal(obj);
altbox("Record deleted successfully.");
}
protected void btn_submit_Click(object sender, EventArgs e)
{
if (hfdjournalid.Value == "0")
{
string isalert;
if (ChkjournalAlert.Checked == true)
{
isalert = "true";
}
else
{
isalert = "false";
}
tbl_Licensing_Journal_Detail pjd = new tbl_Licensing_Journal_Detail();
pjd.Journal_Id = Convert.ToInt32(hfdjournalid.Value);
pjd.Person_Id = Convert.ToInt32(hfdpid.Value);
pjd.Journal_Type_Id = Convert.ToInt32(ddlJournalType.SelectedValue);
pjd.Is_Alert = Convert.ToBoolean(isalert);
pjd.Description = txtjournaltype.Text.ToString();
pjd.Isce = Convert.ToInt32(hfdisce.Value);
pjd.Createdby = Session["UID"].ToString();
pjd.CreatedDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
Person_Details.Licensing_Details.InsertJournal(pjd);
altbox("Record inserted successfully.");
}
else
{
string isalert;
if (ChkjournalAlert.Checked == true)
{
isalert = "true";
}
else
{
isalert = "false";
}
tbl_Licensing_Journal_Detail pjd = new tbl_Licensing_Journal_Detail();
pjd.Journal_Id = Convert.ToInt32(hfdjournalid.Value);
pjd.Person_Id = Convert.ToInt32(hfdpid.Value);
pjd.Journal_Type_Id = Convert.ToInt32(ddlJournalType.SelectedValue);
pjd.Is_Alert = Convert.ToBoolean(isalert);
pjd.Description = txtjournaltype.Text.ToString();
pjd.Isce = Convert.ToInt32(hfdisce.Value);
pjd.Createdby = Session["UID"].ToString();
pjd.CreatedDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
Person_Details.Licensing_Details.UpdateJournal(pjd);
altbox("Record updated successfully.");
}
Clear();
}
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);
}
}
