public void loadpersonaldetails()
{
try
{
DataTable dt = new DataTable();
PersonalData objper = new PersonalData();
dt = objper.GetPersonalDetails(hdnpersonalid.Value);
if (dt.Rows.Count > 0)
{
if (Request.QueryString["personalid"] != "" && Request.QueryString["personalid"] != null)
{
txtfirstname.Text = dt.Rows[0]["PERSONAL_FNAME"].ToString();
}
lblHeader.Visible = true;
lblHeader1.Visible = true;
lblHeader.Text = dt.Rows[0]["PERSONAL_FNAME"].ToString() +" " + dt.Rows[0]["PERSONAL_LNAME"].ToString();
lblHeader1.Text = dt.Rows[0]["PERSONAL_TITLE_ID"].ToString();
txtfirstname.Text = dt.Rows[0]["PERSONAL_FNAME"].ToString();
txtlastname.Text = dt.Rows[0]["PERSONAL_LNAME"].ToString();
txtmiddlename.Text = dt.Rows[0]["PERSONAL_MNAME"].ToString();
txtphoneland.Text = dt.Rows[0]["PERSONAL_PHONE_LAND"].ToString();
txtphonecell.Text = dt.Rows[0]["PERSONAL_PHONE_CELL"].ToString();
txtphoneother.Text = dt.Rows[0]["PERSONAL_PHONE_OTHER"].ToString();
ddltitle.SelectedIndex = ddltitle.Items.IndexOf(ddltitle.Items.FindByValue(dt.Rows[0]["PERSONAL_TITLE_ID"].ToString()));
txtfax.Text = dt.Rows[0]["PERSONAL_FAX"].ToString();
txtemail.Text = dt.Rows[0]["PERSONAL_EMAIL"].ToString();
txtcompany.Text = dt.Rows[0]["PERSONAL_COMPANY"].ToString();
ddlemployeetype.SelectedIndex = ddlemployeetype.Items.IndexOf(ddlemployeetype.Items.FindByText(dt.Rows[0]["PERSONAL_EMP_TYPE"].ToString()));
txtdateifhire.Text = dt.Rows[0]["PERSONAL_HIRE_DATE"].ToString();
txttermanitationdate.Text = dt.Rows[0]["PERSONAL_TERM_DATE"].ToString();
ddlemployeestatus.SelectedIndex = ddlemployeestatus.Items.IndexOf(ddlemployeestatus.Items.FindByText(dt.Rows[0]["PERSONAL_EMP_STATUS"].ToString()));
txtdob.Text = dt.Rows[0]["PERSONAL_DOB"].ToString();
txtmaterialstatus.Text = dt.Rows[0]["PERSONAL_MARRIED_STATUS"].ToString();
txtwebpage.Text = dt.Rows[0]["PERSONAL_WEBPAGE"].ToString();
txtfacebook.Text = dt.Rows[0]["PERSONAL_FACEBOOK"].ToString();
txttwitter.Text = dt.Rows[0]["PERSONAL_TWITTER"].ToString();
(ucresidcity.FindControl("txtzipcode") as TextBox).Text = dt.Rows[0]["HOMEZIP"].ToString();
(ucothercity.FindControl("txtzipcode") as TextBox).Text = dt.Rows[0]["OTHERZIP"].ToString();
string City_Zip_H = dt.Rows[0]["HOMEZIP"].ToString();
string City_Zip_O = dt.Rows[0]["OTHERZIP"].ToString();
ucresidcity.fillcitydetails(Convert.ToInt32(dt.Rows[0]["PERSONAL_HOME_CITY_ID"]), dt.Rows[0]["PERSONAL_HOME_STREET"].ToString(), City_Zip_H);
ucothercity.fillcitydetails(Convert.ToInt32(dt.Rows[0]["PERSONAL_OTHER_CITY_ID"]), dt.Rows[0]["PERSONAL_OTHER_STREET"].ToString(), City_Zip_O);
string active_flag = dt.Rows[0]["PERSONAL_ACTIVE_FLAG"].ToString();
string beast_flag = dt.Rows[0]["personal_beast_flag"].ToString();
(this.Master as Site1).show_control(active_flag, pnlpersonal, beast_flag);
if (Request.QueryString["personalid"] != "" && Request.QueryString["personalid"] != null)
{
ucshow.GetPersonalShow(Convert.ToInt32(hdnpersonalid.Value));
ucdocx.GetDocxDetails(Convert.ToInt32(hdnpersonalid.Value), "PERSONAL");
}
}
}
catch (Exception ex)
{
lblerrmsg.Text = "Error: " + ex.Message.ToString();
lblerrmsg.ForeColor = System.Drawing.Color.Red;
}
}
public void DeleteData(string flag)
{
PersonalData objper = new PersonalData();
Int32 personalid = Convert.ToInt32(hdnpersonalid.Value);
string msg = objper.Personal_Delete(personalid, flag);
if (msg == "")
{
divmsg.InnerHtml = (flag == "n") ? "Record deleted successfully!" : "Record undeleted successfully!";
(this.Master as Site1).show_control(flag, pnlpersonal);
}
else
{
lblerrmsg.Text = msg;
}
}
public void GetPersonalShow(Int32 personalid)
{
hdnucpersonalid.Value = personalid.ToString();
PersonalData objper = new PersonalData();
DataTable dt = new DataTable();
dt = objper.GetPersonalShowAssignDetails(personalid);
DataColumn dc = new DataColumn();
dc.ColumnName = "tempid";
dc.DataType = typeof(int);
dc.AutoIncrement = true;
dc.AutoIncrementSeed = 1;
dt.Columns.Add(dc);
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["tempid"] = i + 1;
}
ViewState["temptable"] = dt;
BindShow();
showhidefooter(false);
}
public void SavePersonalShow(Int32 personalid)
{
SaveTempShowDetails();
DataTable dt;
dt = (DataTable)ViewState["temptable"];
PersonalData objper = new PersonalData();
Int32 personalassignshowid;
DateTime assigndate;
Nullable<DateTime> enddate = null;
string assingflag;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["per_assign_id"].ToString() == "0")
{
personalassignshowid = Convert.ToInt32(dt.Rows[i]["showid"]);
assigndate = Convert.ToDateTime(dt.Rows[i]["assigndate"]);
enddate = (dt.Rows[i]["enddate"].ToString() != "") ? Convert.ToDateTime(dt.Rows[i]["enddate"]) : enddate;
assingflag = Convert.ToString(dt.Rows[i]["assignflag"]);
objper.PersonalShowAssign_Insert(personalid, personalassignshowid, assigndate, enddate, assingflag);
}
}
GetPersonalShow(personalid);
}
public static List<string> Getpersonalname(string prefixText)
{
PersonalData objper = new PersonalData();
List<string> personal = objper.searchpersonal(prefixText, "Y");
return personal;
}
public static List<string> Getcompanyname(string prefixText)
{
PersonalData objper = new PersonalData();
List<string> company = objper.GetCompanyName(prefixText);
return company;
}
public void SaveData()
{
CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture;
TextInfo textInfo = cultureInfo.TextInfo;
PersonalData objper = new PersonalData();
string fname, mname, lname, company, employeetype, materialstatus, empstatus, phoneland, phoncell, phoneother, fax, email, webpage, facebook, twitter;
string residstaddress, otherstaddress, homezip, otherzip;
Nullable<Int32> residcityid = null, othercityid = null;
Nullable<Int16> titleid = null;
Nullable<DateTime> dateifhire = null, terminationdate = null, dob = null;
othercityid = ucothercity.InsertCitydetails();
residcityid = ucresidcity.InsertCitydetails();
fname = textInfo.ToTitleCase(txtfirstname.Text.Trim());
mname = textInfo.ToTitleCase(txtmiddlename.Text.Trim());
lname = textInfo.ToTitleCase(txtlastname.Text.Trim());
company = textInfo.ToTitleCase(txtcompany.Text.Trim());
employeetype = ddlemployeetype.SelectedItem.Text.Trim();
materialstatus = txtmaterialstatus.Text.Trim();
empstatus = ddlemployeestatus.SelectedItem.Text;// txtemployeestatus.Text.Trim();
phoneland = txtphoneland.Text.Trim();
phoncell = txtphonecell.Text.Trim();
phoneother = txtphoneother.Text.Trim();
fax = txtfax.Text.Trim();
email = txtemail.Text.Trim();
webpage = txtwebpage.Text.Trim();
facebook = txtfacebook.Text.Trim();
twitter = txttwitter.Text.Trim();
titleid = (ddltitle.SelectedIndex == 0) ? titleid : Convert.ToInt16(ddltitle.SelectedItem.Value);
dateifhire = (txtdateifhire.Text.Trim() == "") ? dateifhire : Convert.ToDateTime(txtdateifhire.Text);
terminationdate = (txttermanitationdate.Text.Trim() == "") ? terminationdate : Convert.ToDateTime(txttermanitationdate.Text);
dob = (txtdob.Text.Trim() == "") ? dob : Convert.ToDateTime(txtdob.Text);
TextBox txtresidaddress = (TextBox)ucresidcity.FindControl("txtaddress");
TextBox txtotheraddress = (TextBox)ucothercity.FindControl("txtaddress");
residstaddress = textInfo.ToTitleCase(txtresidaddress.Text.Trim());
otherstaddress = textInfo.ToTitleCase(txtotheraddress.Text.Trim());
//homezip = (ucresidcity.FindControl("txtzipcode") as TextBox).Text;
//otherzip = (ucothercity.FindControl("txtzipcode") as TextBox).Text;
homezip = ucresidcity.Get_child_zipcode();
otherzip = ucothercity.Get_child_zipcode();
Int32 personalid = 0;
//string msg = "",
string type = "I";
if (string.IsNullOrEmpty(Request.QueryString["personalid"]))
{
personalid = objper.Personaldata_Insert(fname, mname, lname, company, employeetype, materialstatus, empstatus, phoneland, phoncell, phoneother, fax, email, webpage, facebook, twitter, residstaddress, residcityid, otherstaddress, othercityid, titleid, dateifhire, terminationdate, dob, homezip, otherzip);
}
else if (Request.QueryString["personalid"] != "" && Request.QueryString["personalid"] != null)
{
personalid = Convert.ToInt32(Request.QueryString["personalid"]);
objper.Personaldata_Update(personalid, fname, mname, lname, company, employeetype, materialstatus, empstatus, phoneland, phoncell, phoneother, fax, email, webpage, facebook, twitter, residstaddress, residcityid, otherstaddress, othercityid, titleid, dateifhire, terminationdate, dob, homezip, otherzip);
type = "U";
}
if (personalid < 0)
{
lblerrmsg.Text = "Error: Data did not submit. Please contact system administrator!";
lblerrmsg.ForeColor = System.Drawing.Color.Red;
}
else if (personalid > 0)
{
ucshow.SavePersonalShow(personalid);
ucdocx.SaveDocx(personalid, "PERSONAL");
ucshow.showhidefooter(false);
if (string.IsNullOrEmpty(Request.QueryString["form"]) == true)
{
Response.Redirect("~/personal.aspx?personalid=" + personalid.ToString() + "&type=" + type + "");
}
else
{
string prev_form = Request.QueryString["form"];
Int32 pre_or_ven_id = Convert.ToInt32(prev_form.Split('_').GetValue(1));
string pre_or_ven_flg = Convert.ToString(prev_form.Split('_').GetValue(0));
if (pre_or_ven_flg == "p")
{
objpre.PresenterContactperson_Insert(pre_or_ven_id, personalid);
Response.Redirect("~/presenter.aspx?presenterid=" + pre_or_ven_id.ToString() + "&type=I");
}
if (pre_or_ven_flg == "v")
{
VenueDataLayer.VenueData objven = new VenueDataLayer.VenueData();
objven.VenueContactperson_Insert(pre_or_ven_id, personalid);
Response.Redirect("~/venue.aspx?venueid=" + pre_or_ven_id.ToString() + "&type=I");
}
}
}
}
public void loadphonedetails()
{
Label lblfax = (Label)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("lblfax");
Label lblemail = (Label)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("lblemail");
Label lblphone = (Label)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("lblphone");
Label lblTitle = (Label)RepDetails.Controls[RepDetails.Controls.Count - 1].FindControl("lblTitle");
PersonalData objper = new PersonalData();
string phone = "";
DataTable dt = objper.GetPersonalDetails(hdnfirstnameid.Value);
if (dt.Rows.Count > 0)
{
lblfax.Text = dt.Rows[0]["personal_fax"].ToString();
lblemail.Text = dt.Rows[0]["personal_email"].ToString();
phone = dt.Rows[0]["personal_phone_land"].ToString();
lblTitle.Text = dt.Rows[0]["title_name"].ToString();
}
else
{
lblfax.Text = string.Empty;
lblemail.Text = string.Empty;
}
lblphone.Text = phone;
lblphone.Focus();
}
protected void lnkbtnDelete_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
dt = (DataTable)ViewState["temptable"];
foreach (RepeaterItem gr in RepDetails.Items)
{
CheckBox chkdelete = (CheckBox)gr.FindControl("chkdelete");
HiddenField hdntempid = (HiddenField)gr.FindControl("hdntempid");
HiddenField hdnpersonalshowid = (HiddenField)gr.FindControl("hdnpersonalshowid");
if (chkdelete.Checked == true)
{
DataRow[] dr;
dr = dt.Select("tempid='" + hdntempid.Value + "'", "");
dt.Rows.Remove(dr[0]);
if (hdnpersonalshowid.Value != "0")
{
PersonalData objper = new PersonalData();
objper.PersonalShowAssign_Delete(Convert.ToInt32(hdnpersonalshowid.Value));
}
}
}
ViewState["temptable"] = dt;
BindShow();
trfooter.Visible = false;
}
catch (Exception ex)
{
lblerrmsg.Text = "Error: " + ex.Message;
}
}
public void UpdateShowDetails(RepeaterItem ri)
{
TextBox txtassignmentdateE = (TextBox)ri.FindControl("txtassignmentdateE");
TextBox txtenddateE = (TextBox)ri.FindControl("txtenddateE");
DropDownList ddlshownameE = (DropDownList)ri.FindControl("ddlshownameE");
DropDownList ddlcurrentshowE = (DropDownList)ri.FindControl("ddlcurrentshowE");
HiddenField hdnPersonalAssignid = (HiddenField)ri.FindControl("hdnpersonalshowid");
HiddenField hdntempid = (HiddenField)ri.FindControl("hdntempid");
if (ddlshownameE.SelectedIndex > 0)
{
DataTable dt = new DataTable();
dt = (DataTable)ViewState["temptable"];
dt.Columns["assigndate"].ReadOnly = false;
dt.Columns["enddate"].ReadOnly = false;
dt.Columns["assignflagtext"].ReadOnly = false;
dt.Columns["assignflag"].ReadOnly = false;
IEnumerable<DataRow> rows = dt.Rows.Cast<DataRow>().Where(r => r["tempid"].ToString() == hdntempid.Value);
rows.ToList().ForEach(r => r.SetField("showname", ddlshownameE.SelectedItem.Text));
rows.ToList().ForEach(r => r.SetField("assigndate", txtassignmentdateE.Text));
rows.ToList().ForEach(r => r.SetField("enddate", Convert.ToString(txtenddateE.Text)));
rows.ToList().ForEach(r => r.SetField("assignflagtext", ddlcurrentshowE.SelectedItem.Text));
rows.ToList().ForEach(r => r.SetField("assignflag", ddlcurrentshowE.SelectedItem.Value));
ViewState["temptable"] = dt;
if (hdnPersonalAssignid.Value != "0")
{
PersonalData objper = new PersonalData();
Int32 personalassignshowid;
DateTime assigndate;
Nullable<DateTime> enddate = null;
string assingflag;
personalassignshowid = Convert.ToInt32(ddlshownameE.SelectedItem.Value);
assigndate = Convert.ToDateTime(txtassignmentdateE.Text);
enddate = (txtenddateE.Text.ToString() != "") ? Convert.ToDateTime(txtenddateE.Text) : enddate;
assingflag = Convert.ToString(ddlcurrentshowE.SelectedItem.Value);
objper.PersonalShowAssign_Update(Convert.ToInt32(hdnPersonalAssignid.Value), Convert.ToInt32(hdnucpersonalid.Value), personalassignshowid, assigndate, enddate, assingflag);
}
BindShow();
}
}
