protected void Page_Init(object sender, EventArgs e)
{
AddTab("calvin-and-hobbes");
AddPageView(RadTabStrip1.FindTabByText("calvin-and-hobbes"));
AddTab("dilbert");
RadTabStrip1.OnClientTabSelecting = "onTabSelecting";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
RadTabStrip1.FindTabByText("Report").Enabled = false;
}
else
{
string ModeData = ModeDD.SelectedValue;
var dt = GetData(ModeData);
var objectDataSource = new ObjectDataSource {
DataSource = dt
};
var report = new RptCustomer {
DataSource = objectDataSource
};
report.DataSource = objectDataSource;
var table = report.Items.Find("table1", true)[0] as Telerik.Reporting.Table;
table.ColumnHeadersPrintOnEveryPage = true;
table.DataSource = dt;
var clientReportSource = new InstanceReportSource {
ReportDocument = report
};
ReportViewer1.ReportSource = clientReportSource;
ReportViewer1.DataBind();
ReportViewer1.RefreshReport();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
RadTabStrip1.FindTabByText("Report").Enabled = false;
}
else
{
DateTime datefroms = Convert.ToDateTime(datefrom.SelectedDate);
DateTime datetos = Convert.ToDateTime(dateto.SelectedDate);
string convertedfrom = datefroms.ToString("yyyy-MM-dd");
string convertedto = datetos.ToString("yyyy-MM-dd");
var dt = GetData(convertedfrom, convertedto);
var objectDataSource = new ObjectDataSource {
DataSource = dt
};
var report = new RptTransIn {
DataSource = objectDataSource
};
report.DataSource = objectDataSource;
var table = report.Items.Find("table1", true)[0] as Telerik.Reporting.Table;
table.ColumnHeadersPrintOnEveryPage = true;
table.DataSource = dt;
var clientReportSource = new InstanceReportSource {
ReportDocument = report
};
ReportViewer1.ReportSource = clientReportSource;
ReportViewer1.DataBind();
ReportViewer1.RefreshReport();
}
}
protected void Page_Init(object sender, EventArgs e)
{
AddTab("privacy");
AddPageView(RadTabStrip1.FindTabByText("privacy"));
AddTab("account-settings");
RadTabStrip1.OnClientTabSelecting = "onTabSelecting";
}
protected void submit_Click(object sender, EventArgs e)
{
DateTime datez = Convert.ToDateTime(dates.SelectedDate);
string convertedDate = datez.ToString("yyyy-MM-dd");
string selectedid = RadCmbTrans.SelectedValue;
var dt = GetData(convertedDate, selectedid);
var objectDataSource = new ObjectDataSource {
DataSource = dt
};
var report = new LabelRpt {
DataSource = objectDataSource
};
report.DataSource = objectDataSource;
var table = report.Items.Find("table1", true)[0] as Telerik.Reporting.Table;
table.ColumnHeadersPrintOnEveryPage = true;
table.DataSource = dt;
var clientReportSource = new InstanceReportSource {
ReportDocument = report
};
ReportViewer1.ReportSource = clientReportSource;
ReportViewer1.DataBind();
ReportViewer1.RefreshReport();
RadTabStrip1.FindTabByText("Report").Enabled = true;
RadTab tab1 = RadTabStrip1.Tabs.FindTabByText("Report");
tab1.Selected = true;
tab1.PageView.Selected = true;
}
protected void Page_Init(object sender, EventArgs e)
{
AddTab("Box");
AddPageView(RadTabStrip1.FindTabByText("Box"));
AddTab("Following");
AddTab("Browse-Intrests");
AddTab("Help");
}
protected void submit_Click(object sender, EventArgs e)
{
RadTabStrip1.FindTabByText("Report").Enabled = true;
RadTab tab1 = RadTabStrip1.Tabs.FindTabByText("Report");
tab1.Selected = true;
tab1.PageView.Selected = true;
}
protected void Page_Init(object sender, EventArgs e)
{
AddTab("Inbox");
AddPageView(RadTabStrip1.FindTabByText("Inbox"));
AddTab("Compose");
AddTab("Sent-Messages");
RadTabStrip1.OnClientTabSelecting = "onTabSelecting";
}
protected void Page_Init(object sender, EventArgs e)
{
//RadTabStrip1.Attributes.Add("OnClientTabSelecting", "onTabSelecting");
AddTab("Box");
AddPageView(RadTabStrip1.FindTabByText("Box"));
AddTab("Following");
AddTab("Suggestions");
AddTab("Help");
RadTabStrip1.OnClientTabSelecting = "onTabSelecting";
}
protected void Page_Init(object sender, EventArgs e)
{
AddTab("connect-req");
AddPageView(RadTabStrip1.FindTabByText("connect-req"));
AddTab("my-connects");
AddTab("find");
AddTab("invite");
RadTabStrip1.OnClientTabSelecting = "onTabSelecting";
}
protected void Page_Init(object sender, EventArgs e)
{
RadTabStrip1.OnClientTabSelecting = "onTabSelecting";
AddTab("feednections");
AddPageView(RadTabStrip1.FindTabByText("feednections"));
AddTab("follow-box");
AddTab("conversations");
AddTab("my-albums");
AddTab("labs");
AddTab("breaktime");
AddTab("video-galla");
}
protected void btnSkillsBack(object sender, EventArgs e)
{
hndSklID.Value = txtSkills.Text = string.Empty;
cbSkillProficiency.SelectedValue = "0";
RadTab lanTab = RadTabStrip1.FindTabByText("Languages");
lanTab.Selected = true;
lanTab.Enabled = true;
RadTab sklTab = RadTabStrip1.FindTabByText("Skills");
sklTab.Enabled = false;
RadMultiPage1.SelectedIndex = 3;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string urlWithSessionID = Response.ApplyAppPathModifier(Request.Url.PathAndQuery);
RadTab tab = RadTabStrip1.FindTabByUrl(urlWithSessionID);
if (tab != null)
{
tab.SelectParents();
tab.PageView.Selected = true;
}
}
}
protected void btnReferencesBack(object sender, EventArgs e)
{
hndRefID.Value = txtReferenceName.Text = txtReferenceJob.Text = txtReferenceCompany.Text = txtReferenceContact.Text =
txtReferenceEmail.Text = string.Empty;
RadTab sklTab = RadTabStrip1.FindTabByText("Skills");
sklTab.Selected = true;
sklTab.Enabled = true;
RadTab refTab = RadTabStrip1.FindTabByText("References");
refTab.Enabled = false;
RadMultiPage1.SelectedIndex = 4;
}
protected void btnLanguagesBack(object sender, EventArgs e)
{
hndLngID.Value = txtLanguage.Text = string.Empty;
cbLanguageProficiency.SelectedValue = "0";
RadTab expTab = RadTabStrip1.FindTabByText("Experience");
expTab.Selected = true;
expTab.Enabled = true;
RadTab lanTab = RadTabStrip1.FindTabByText("Languages");
lanTab.Enabled = false;
RadMultiPage1.SelectedIndex = 2;
}
protected void btnSkills(object sender, EventArgs e)
{
hndSklID.Value = txtSkills.Text = string.Empty;
cbSkillProficiency.SelectedValue = "0";
RadTab refTab = RadTabStrip1.FindTabByText("References");
refTab.Enabled = true;
refTab.Selected = true;
RadMultiPage1.SelectedIndex = 5;
RadTab sklTab = RadTabStrip1.FindTabByText("Skills");
sklTab.Enabled = false;
}
protected void btnLanguages(object sender, EventArgs e)
{
hndLngID.Value = txtLanguage.Text = string.Empty;
cbLanguageProficiency.SelectedValue = "0";
RadTab sklTab = RadTabStrip1.FindTabByText("Skills");
sklTab.Enabled = true;
sklTab.Selected = true;
RadMultiPage1.SelectedIndex = 4;
RadTab lanTab = RadTabStrip1.FindTabByText("Languages");
lanTab.Enabled = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if ((!object.Equals(Request.Cookies["RFriend_Email"], null)) && (!object.Equals(Request.Cookies["RFriend_PWD"], null)) && (!object.Equals(Request.Cookies["RFriend_UID"], null)))
{
if ((!object.Equals(Request.Cookies["RFriend_Email"].Value, "")) && (!object.Equals(Request.Cookies["RFriend_PWD"].Value, "")) && (!object.Equals(Request.Cookies["RFriend_UID"], "")))
{
Session["UserEmail"] = Request.Cookies["RFriend_Email"].Value;
Session["Password"] = Request.Cookies["RFriend_PWD"].Value;
Session["UserId"] = Request.Cookies["RFriend_UID"].Value;
}
else
{
}
}
else
{
Response.Redirect(ResolveUrl("~/Login.aspx"));
}
if (!Page.IsPostBack)
{
dt = new DataTable();
string getuname = "select [uname] from [User] where id=" + Session["UserId"] + "";
dt = dbc.ReturnDT(getuname);
string uname = dt.Rows[0]["uname"].ToString();
RadTabStrip2.Tabs.FindTabByValue("profile").NavigateUrl = "~/Menu/profile.aspx?uname=" + uname + "";
if (Request.QueryString["menu"] == null)
{
AddTab("Home");
AddPageView(RadTabStrip1.FindTabByText("Home"));
RadTabStrip1.SelectedIndex = 0;
AddTab("connects");
AddTab("settings");
}
else
{
string menu = Request.QueryString["menu"].ToString();
AddTab("Home");
AddTab("connects");
AddTab("settings");
AddPageView(RadTabStrip1.FindTabByText(menu));
RadTabStrip1.FindTabByText(menu).Selected = true;
}
}
}
protected void btnEducationBack(object sender, EventArgs e)
{
hndEduID.Value = txtInstitute.Text = txtMajorSubjects.Text = txtEduCity.Text = txtObtainMarks.Text =
txtTotalMarks.Text = txtPercentage.Text = string.Empty;
cbDegree.SelectedValue = "0";
cbEduCountry.SelectedValue = "0";
ddlCompletionYear.ClearSelection();
RadTab perTab = RadTabStrip1.FindTabByText("Personal");
perTab.Selected = true;
perTab.Enabled = true;
RadTab eduTab = RadTabStrip1.FindTabByText("Education");
eduTab.Enabled = false;
RadMultiPage1.SelectedIndex = 0;
}
protected void btnExperienceBack(object sender, EventArgs e)
{
hndExpID.Value = txtCompanyName.Text = txtDescription.Text = txtLeavingReason.Text = string.Empty;
cbCompanyType.SelectedValue = "0";
cbRole.SelectedValue = "0";
cbExperienceCountry.SelectedValue = "0";
dtStartDate.Clear();
dtEndDate.Clear();
chkPresent.Checked = false;
RadTab eduTab = RadTabStrip1.FindTabByText("Education");
eduTab.Selected = true;
eduTab.Enabled = true;
RadTab expTab = RadTabStrip1.FindTabByText("Experience");
expTab.Enabled = false;
RadMultiPage1.SelectedIndex = 1;
}
/// <summary>
/// Handles the Load event of the Page control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
protected void Page_Load(object sender, EventArgs e)
{
Title = "Шаблон процесса - LeadForce";
access = Access.Check();
if (!access.Write)
{
lbtnSave.Visible = false;
}
dprReminder.RegisterSkipCheckingTrigger(lbtnSave);
if (Page.RouteData.Values["id"] != null)
{
_workflowTemplateId = Guid.Parse(Page.RouteData.Values["id"] as string);
}
hlCancel.NavigateUrl = UrlsData.AP_WorkflowTemplates();
ucWorkflowTemplateGoal.WorkflowTemplateId = _workflowTemplateId;
ucWorkflowTemplateMaterial.WorkflowTemplateId = _workflowTemplateId;
if (!Page.IsPostBack)
{
BindData();
SLObejct(false);
}
if (CurrentUser.Instance.IsTemplateSite)
{
RadTabStrip1.FindTabByValue("Materials").Visible = true;
}
radAjaxManager = RadAjaxManager.GetCurrent(Page);
radAjaxManager.AjaxSettings.AddAjaxSetting(ddlStatus, ucNotificationMessage);
radAjaxManager.AjaxSettings.AddAjaxSetting(ddlModule, ucWorkflowTemplateParameter);
radAjaxManager.AjaxSettings.AddAjaxSetting(RadTabStrip1, ucWorkflowTemplateGoal);
}
protected void btnPersonalInfo(object sender, EventArgs e)
{
try
{
string id = string.IsNullOrEmpty((hndID.Value)) ? "0" : hndID.Value;
DateTime dob = Convert.ToDateTime(ddlYear.Text + "-" + ddlMonth.Text + "-" + ddlDay.Text);
string employerID = "";
string desc = CLOVA.AddUpdateEmployerInfo(Convert.ToInt32(id), Convert.ToInt32(hndUserID.Value), txtFirstName.Text,
txtMiddleName.Text, txtLastName.Text, txtArabicName.Text, txtFatherName.Text, Convert.ToInt32(cbEmployeesGender.SelectedValue),
Convert.ToInt32(cbMaritialStatus.SelectedValue), dob, txtEmail.Text, txtMobile.Text, txtCity.Text,
Convert.ToInt32(cbCountry.SelectedValue), txtPresentAddress.Text, txtPermanentAddress.Text, "", txtSpecilization.Text, txtObjective.Text, Convert.ToInt32(rdIqamaTransfer.SelectedValue), txtExperience.Text, Convert.ToInt32(hndUserID.Value),
Convert.ToInt32(hndUserID.Value), out employerID);
Session["employerID"] = employerID;
hndID.Value = employerID;
if (desc.ToLower().Contains("success"))
{
RadTab eduTab = RadTabStrip1.FindTabByText("Education");
eduTab.Enabled = true;
eduTab.Selected = true;
RadMultiPage1.SelectedIndex = 1;
RadTab perTab = RadTabStrip1.FindTabByText("Personal");
perTab.Enabled = false;
hndEduID.Value = hndExpID.Value = hndLngID.Value = hndSklID.Value = hndRefID.Value = "";
}
else
{
Session["Error"] = desc;
return;
}
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "btnPersonalInfo", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "CreateProfile");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
/// <summary>
/// Binds the data.
/// </summary>
protected void BindData()
{
RadFilter1.Culture = new CultureInfo("ru-RU");
ucWorkflowTemplateConditionEvent.WorkflowTemplateId = _workflowTemplateId;
ucWorkflowTemplateParameter.WorkflowTemplateId = _workflowTemplateId;
////ucWorkflowTemplateElement.WorkflowTemplateId = _workflowTemplateId;
////ucWorkflowTemplateElementRelation.WorkflowTemplateId = _workflowTemplateId;
//var modules = DataManager.Module.SelectAll();
var moduleContacts = DataManager.Module.SelectByName("Contacts");
ddlModule.Items.Add(new ListItem("Выберите значение", ""));
ddlModule.Items.Add(new ListItem(moduleContacts.Title, moduleContacts.ID.ToString()));
EnumHelper.EnumToDropDownList <WorkflowTemplateStatus>(ref ddlStatus, false);
EnumHelper.EnumToDropDownList <WorkflowTemplateAutomaticMethod>(ref ddlAutomaticMethod, false);
EnumHelper.EnumToDropDownList <WorkflowTemplateEvent>(ref ddlEvent);
EnumHelper.EnumToDropDownList <WorkflowTemplateCondition>(ref ddlCondition);
var workflowTemplate = DataManager.WorkflowTemplate.SelectById(SiteId, _workflowTemplateId);
if (workflowTemplate != null)
{
txtName.Text = workflowTemplate.Name;
ucAuthor.SelectedValue = workflowTemplate.ContactID;
if (workflowTemplate.ModuleID != null)
{
ddlModule.Items.FindByValue(workflowTemplate.ModuleID.ToString()).Selected = true;
}
ddlStatus.Items.FindByValue(workflowTemplate.Status.ToString()).Selected = true;
rdpStartDate.SelectedDate = workflowTemplate.StartDate;
rdpEndDate.SelectedDate = workflowTemplate.EndDate;
txtDescription.Text = workflowTemplate.Description;
cbManualStart.Checked = workflowTemplate.ManualStart;
ddlAutomaticMethod.Items.FindByValue(workflowTemplate.AutomaticMethod.ToString()).Selected = true;
txtFrequency.Text = workflowTemplate.Frequency.ToString();
cbDenyMultipleRun.Checked = workflowTemplate.DenyMultipleRun;
switch ((WorkflowTemplateAutomaticMethod)workflowTemplate.AutomaticMethod)
{
case WorkflowTemplateAutomaticMethod.EditRecord:
ddlEvent.Items.FindByValue(workflowTemplate.Event.ToString()).Selected = true;
pnlEditRecord.Visible = true;
/*if (workflowTemplate.ModuleID != null)
* pnlFilter.Visible = true;*/
break;
case WorkflowTemplateAutomaticMethod.ActivityContact:
ddlCondition.Items.FindByValue(workflowTemplate.Condition.ToString()).Selected = true;
if ((WorkflowTemplateCondition)workflowTemplate.Condition == WorkflowTemplateCondition.NEvent)
{
pnlActivityCount.Visible = true;
txtActivityCount.Text = workflowTemplate.ActivityCount.ToString();
}
pnlActivityContact.Visible = true;
break;
}
var workflowCount = DataManager.Workflow.SelectByWorkflowTemplateId(_workflowTemplateId).ToList().Count;
ddlStatus.Attributes.Add("onchange", "ConfirmInPlans();");
if (workflowCount > 0 && (WorkflowTemplateStatus)workflowTemplate.Status != WorkflowTemplateStatus.InPlans)
{
IsEditable = false;
ucNotificationMessage.Visible = true;
ddlModule.Enabled = false;
RadTabStrip1.FindTabByValue("SilverlightMapConversion").Visible = true;
SLObejct(true);
}
xmlWorkflow.Value = workflowTemplate.WorkflowXml ?? "";
var elements = DataManager.WorkflowTemplateElement.SelectAllMap(_workflowTemplateId);
jsonElements.Value = JsonConvert.SerializeObject(elements);
var elementRelations = DataManager.WorkflowTemplateElementRelation.SelectAllMap(_workflowTemplateId);
jsonElementRelations.Value = JsonConvert.SerializeObject(elementRelations);
}
else
{
if (CurrentUser.Instance.ContactID.HasValue)
{
ucAuthor.SelectedValue = CurrentUser.Instance.ContactID;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request.QueryString["id"].ToString();
string myd = Session["UserId"].ToString();
string checkboxreq = @"SELECT MyID, SID, FollowDate, FollowStatus, ID
FROM Box
WHERE (MyID = " + myd + ") AND (SID = " + id + ")";
DataTable chboc = new DataTable();
chboc = profile.ReturnDT(checkboxreq);
if (chboc.Rows.Count != 0)
{
RadButton addbox = (RadButton)RadPanelBar1.FindItemByValue("buttons").FindControl("addbox");
addbox.Text = "Remove From Box";
addbox.CommandName = "rfb";
}
string asked2connect = @"SELECT * FROM Friends
WHERE (MyID = " + Session["UserId"] + ") AND (FriendID = " + id + ") AND (FriendStatus = 0) ";
DataTable dt3 = new DataTable();
dt3 = profile.ReturnDT(asked2connect);
if (dt3.Rows.Count > 0)
{
RadButton editprofile = (RadButton)RadPanelBar1.FindItemByValue("buttons").FindControl("friendreq");
editprofile.CommandName = "rempen";
editprofile.Text = "Cancel Pending Connect Req?";
}
string chkfriendRequest = @"SELECT * FROM Friends WHERE (MyId=" + id + " and FriendId=" + Session["UserId"].ToString() + ")";
DataTable dt1 = new DataTable();
dt1 = profile.ReturnDT(chkfriendRequest);
if (dt1.Rows.Count > 0)
{
if (id == Session["UserId"].ToString())
{
RadPanelBar1.FindItemByValue("connect").Text = "Personalize Profile";
RadButton editprofile = (RadButton)RadPanelBar1.FindItemByValue("buttons").FindControl("friendreq");
editprofile.Text = "Edit Your Profile";
editprofile.CommandName = "ep";
RadButton addbox = (RadButton)RadPanelBar1.FindItemByValue("buttons").FindControl("addbox");
addbox.Text = "Change Profile Picture";
addbox.CommandName = "cpp";
RadButton message = (RadButton)RadPanelBar1.FindItemByValue("buttons").FindControl("message");
message.Text = "Privacy Settings";
message.CommandName = "pst";
}
else if (dt1.Rows[0]["FriendStatus"].ToString() == "1")
{
RadButton editprofile = (RadButton)RadPanelBar1.FindItemByValue("buttons").FindControl("friendreq");
editprofile.Text = "Remove Connection";
editprofile.CommandName = "unfriend";
RadButton addbox = (RadButton)RadPanelBar1.FindItemByValue("buttons").FindControl("addbox");
addbox.Visible = false;
RadButton message = (RadButton)RadPanelBar1.FindItemByValue("buttons").FindControl("message");
message.Text = "Message";
message.CommandName = "ms";
}
else if (dt1.Rows[0]["FriendStatus"].ToString() == "0")
{
RadButton editprofile = (RadButton)RadPanelBar1.FindItemByValue("buttons").FindControl("friendreq");
editprofile.Text = "Accept Connection";
editprofile.CommandName = "befriend";
RadButton addbox = (RadButton)RadPanelBar1.FindItemByValue("buttons").FindControl("addbox");
RadButton message = (RadButton)RadPanelBar1.FindItemByValue("buttons").FindControl("message");
message.Text = "Message";
message.CommandName = "ms";
}
}
DataSet udet = new DataSet();
string urprofile = @"SELECT Name,City, ID, Country, College, School, Company, Gender, Degree, uname, Designation, BirthDate
FROM [User]
WHERE (ID =" + id + ")";
udet = profile.ReturnDS(urprofile);
Label name = (Label)RadPanelBar1.FindItemByValue("bi").FindControl("nm");
Label dob = (Label)RadPanelBar1.FindItemByValue("bi").FindControl("dob");
Label gen = (Label)RadPanelBar1.FindItemByValue("bi").FindControl("gen");
Label born = (Label)RadPanelBar1.FindItemByValue("bi").FindControl("born");
name.Text = udet.Tables[0].Rows[0]["Name"].ToString();
dob.Text = udet.Tables[0].Rows[0]["BirthDate"].ToString();
gen.Text = udet.Tables[0].Rows[0]["Gender"].ToString();
born.Text = udet.Tables[0].Rows[0]["City"].ToString();
//Education And Work ...
if (udet.Tables[0].Rows[0]["College"] is DBNull && udet.Tables[0].Rows[0]["School"] is DBNull && udet.Tables[0].Rows[0]["Designation"] is DBNull && udet.Tables[0].Rows[0]["Company"] is DBNull && udet.Tables[0].Rows[0]["Degree"] is DBNull)
{
eduwork.Visible = false;
RadTabStrip1.FindTabByText("Education and Work").Visible = false;
}
else
{
if (udet.Tables[0].Rows[0]["School"] is DBNull)
{
school.Text = ": Not disclosed by user";
}
else
{
school.Text = ": " + udet.Tables[0].Rows[0]["School"].ToString();
}
if (udet.Tables[0].Rows[0]["College"] is DBNull)
{
collegea.Text = ": Not disclosed by user";
}
else
{
collegea.Text = ": " + udet.Tables[0].Rows[0]["College"].ToString();
}
if (udet.Tables[0].Rows[0]["Degree"] is DBNull)
{
degree.Text = ": Not disclosed by user";
}
else
{
degree.Text = ": " + udet.Tables[0].Rows[0]["Degree"].ToString();
}
if (udet.Tables[0].Rows[0]["Company"] is DBNull)
{
company.Text = ": Not disclosed by user";
}
else
{
company.Text = ": " + udet.Tables[0].Rows[0]["Company"].ToString();
}
if (udet.Tables[0].Rows[0]["Designation"] is DBNull)
{
college.Text = ": Not disclosed by user";
}
else
{
college.Text = ": " + udet.Tables[0].Rows[0]["Designation"].ToString();
}
}
DataSet profilepic = new DataSet();
string propicsql = @"SELECT Image
FROM Propic
WHERE (UID = " + id + ") AND ([Current] = 1)";
profilepic = profile.ReturnDS(propicsql);
RadBinaryImage prop = (RadBinaryImage)RadPanelBar1.FindItemByValue("bi").FindControl("profilepicture");
if (profilepic.Tables[0].Rows[0]["Image"] is DBNull == false)
{
prop.DataValue = (byte[])profilepic.Tables[0].Rows[0]["Image"];
}
else
{
prop.Visible = false;
}
DataSet mimage = new DataSet();
string mimagesql = @"SELECT Image, Desciption
FROM Mimage
WHERE (UID = " + id + ")";
mimage = profile.ReturnDS(mimagesql);
if (mimage.Tables[0].Rows[0]["Image"] is DBNull)
{
mimageandpic.Visible = false;
RadTabStrip1.FindTabByText("Mimage").Visible = false;
}
else
{
mmimage.DataValue = (byte[])mimage.Tables[0].Rows[0]["Image"];
}
string getallbumsofuser = @"SELECT Name, UID, ID
FROM Albums
WHERE (UID = " + id + ")";
/*
* string getalbums = @"SELECT TOP (1) Albums.Name, Albums.UID, Albums.ID, Photos.Photo
* FROM Albums INNER JOIN
* Photos ON Albums.ID = Photos.AlbumID
* WHERE (Albums.UID = " +id+")";
* DataSet displaypics = new DataSet();
* displaypics = profile.ReturnDS(getalbums);
*
* RadBinaryImage A01 = new RadBinaryImage();
* A01.DataValue = (byte[])displaypics.Tables[0].Rows[0]["Photo"];
* A01.Width = 150;
* A01.Height = 150;
* A01.ResizeMode = BinaryImageResizeMode.Fit;
* photos.Controls.Add(A01);
*/
/* DataTable evntsofmylife = new DataTable();
* string evntoflifesql = @"SELECT ID, EventName, Description, UID, Image
* FROM Events
* WHERE (UID = "+id+")";
* evntsofmylife = profile.ReturnDT(evntoflifesql);
* if (evntsofmylife.Rows.Count > 0)
* {
* Repeater1.DataSource = evntsofmylife;
* Repeater1.DataBind();
*
* }
* else
* {
* eventlife.Visible = false;
* RadTabStrip1.FindTabByText("Events in Life").Visible = false;
* }
*/
DataSet philo = new DataSet();
string philosql = @"SELECT Religion, Life, Political, Quote
FROM Political
WHERE (UID = " + id + ")";
philo = profile.ReturnDS(philosql);
if (philo.Tables[0].Rows[0]["Religion"] is DBNull && philo.Tables[0].Rows[0]["Life"] is DBNull && philo.Tables[0].Rows[0]["Quote"] is DBNull && philo.Tables[0].Rows[0]["Political"] is DBNull)
{
philosophy.Visible = false;
RadTabStrip1.FindTabByText("Philosophy").Visible = false;
}
else
{
if (philo.Tables[0].Rows[0]["Religion"] is DBNull)
{
rel.Text = ": Not disclosed by user";
}
else
{
rel.Text = ": " + philo.Tables[0].Rows[0]["Religion"].ToString();
}
if (philo.Tables[0].Rows[0]["Life"] is DBNull)
{
life.Text = ": Not disclosed by user";
}
else
{
life.Text = ": " + philo.Tables[0].Rows[0]["Life"].ToString();
}
if (philo.Tables[0].Rows[0]["Quote"] is DBNull)
{
qute.Text = ": Not disclosed by user";
}
else
{
qute.Text = ": " + philo.Tables[0].Rows[0]["Quote"].ToString();
}
if (philo.Tables[0].Rows[0]["Political"] is DBNull)
{
politics.Text = ": Not disclosed by user";
}
else
{
politics.Text = ": " + philo.Tables[0].Rows[0]["Political"].ToString();
}
}
DataSet eement = new DataSet();
string ementsql = @"SELECT Movies, Sports, Television, Music, Books
FROM Ement
WHERE (UID = " + id + ")";
eement = profile.ReturnDS(ementsql);
if (eement.Tables[0].Rows[0]["Sports"] is DBNull && eement.Tables[0].Rows[0]["Television"] is DBNull && eement.Tables[0].Rows[0]["Music"] is DBNull && eement.Tables[0].Rows[0]["Books"] is DBNull)
{
ement.Visible = false;
RadTabStrip1.FindTabByText("Entertainment and Intrests").Visible = false;
}
else
{
if (eement.Tables[0].Rows[0]["Movies"] is DBNull)
{
movies.Text = ": Not disclosed by user";
}
else
{
movies.Text = ": " + eement.Tables[0].Rows[0]["Movies"].ToString();
}
if (eement.Tables[0].Rows[0]["Books"] is DBNull)
{
books.Text = ": Not disclosed by user";
}
else
{
books.Text = ": " + eement.Tables[0].Rows[0]["Books"].ToString();
}
if (eement.Tables[0].Rows[0]["Music"] is DBNull)
{
music.Text = ": Not disclosed by user";
}
else
{
music.Text = ": " + eement.Tables[0].Rows[0]["Music"].ToString();
}
if (eement.Tables[0].Rows[0]["Television"] is DBNull)
{
tel.Text = ": Not disclosed by user";
}
else
{
tel.Text = ": " + eement.Tables[0].Rows[0]["Television"].ToString();
}
if (eement.Tables[0].Rows[0]["Sports"] is DBNull)
{
sports.Text = ": Not disclosed by user";
}
else
{
sports.Text = ": " + eement.Tables[0].Rows[0]["Sports"].ToString();
}
}
DataSet achievve = new DataSet();
string achievesql = @"SELECT Achievement
FROM Achieve
WHERE (UID = " + id + ")";
achievve = profile.ReturnDS(achievesql);
if (achievve.Tables[0].Rows[0]["Achievement"] is DBNull)
{
achieve.Visible = false;
RadTabStrip1.FindTabByText("Achievements").Visible = false;
}
else
{
achievements.Text = achievve.Tables[0].Rows[0]["Achievement"].ToString();
}
DataSet coninfo = new DataSet();
string coninfosql = @"SELECT Website, Phone, Email, Address
FROM Contact
WHERE (UID = " + id + ")";
coninfo = profile.ReturnDS(coninfosql);
if (coninfo.Tables[0].Rows[0]["Website"] is DBNull && coninfo.Tables[0].Rows[0]["Phone"] is DBNull && coninfo.Tables[0].Rows[0]["Email"] is DBNull && coninfo.Tables[0].Rows[0]["Address"] is DBNull)
{
contactme.Visible = false;
RadTabStrip1.FindTabByText("Contact Information").Visible = false;
}
else
{
if (coninfo.Tables[0].Rows[0]["Website"] is DBNull)
{
web.Text = ": Not disclosed by user";
}
else
{
web.Text = ": <a class='someclasslink' href='" + coninfo.Tables[0].Rows[0]["Website"].ToString() + "' target='_blank'>" + coninfo.Tables[0].Rows[0]["Website"].ToString() + "</a>";
}
if (coninfo.Tables[0].Rows[0]["Phone"] is DBNull)
{
phone.Text = ": Not disclosed by user";
}
else
{
phone.Text = ": " + coninfo.Tables[0].Rows[0]["Phone"].ToString();
}
if (coninfo.Tables[0].Rows[0]["Address"] is DBNull)
{
add.Text = ": Not disclosed by user";
}
else
{
add.Text = ": " + coninfo.Tables[0].Rows[0]["Address"].ToString();
}
if (coninfo.Tables[0].Rows[0]["Email"] is DBNull)
{
email.Text = ": Not disclosed by user";
}
else
{
email.Text = ": <a class='someclasslink' href='mailto:" + coninfo.Tables[0].Rows[0]["Email"].ToString() + "'>" + coninfo.Tables[0].Rows[0]["Email"].ToString() + "</a>";
}
}
}
protected void Page_Init(object sender, EventArgs e)
{
AddTab("Status");
AddTab("Photo");
AddPageView(RadTabStrip1.FindTabByText("Status"));
}
