private void btnSave_Click(object sender, EventArgs e)
{
//declare SQL DB context var
SmartSocialdbDataContext smartsocialDB = new SmartSocialdbDataContext();
ServiceSubscription newServiceSubscriptionsRow = new ServiceSubscription();
try
{
//update selected record in ServiceSubscription table
var subscriptionRow = smartsocialDB.ServiceSubscription.GetByKey(int.Parse(txtID.Text));
subscriptionRow.SubscriptionName = txtName.Text;
subscriptionRow.StartDate = startDate.Value;
subscriptionRow.EndDate = endDate.Value;
subscriptionRow.IsActive = isActive.Checked;
smartsocialDB.SubmitChanges();
smartsocialDB.Connection.Close();
//close this window
this.Close();
}
catch (Exception ex)
{
//show any error message returned by the database
MessageBox.Show(ex.Message);
}
}
public void loadInitialData(int deliveryID)
{
//call function that will load Service Subscriptions
loadServiceSubscriptors();
//declare SQL DB context var
SmartSocialdbDataContext smartsocialDB = new SmartSocialdbDataContext();
ServiceDelivery newServiceDeliveryRow = new ServiceDelivery();
try
{
ServiceDeliveryResponse response = _deliveryService.GetServiceSDeliveryById(deliveryID);
if (response.Acknowledgment)
{
txtID.Text = response.ServiceDelivery.idServiceDelivery.ToString();
startDate.Value = (DateTime)response.ServiceDelivery.DateDelivered;
dtpTo.Value = (DateTime)response.ServiceDelivery.DeliveryDateTo;
cmb_subscription.SelectedValue = response.ServiceDelivery.IdServiceSubscription;
}
else
{
MessageBox.Show(response.Message);
}
}
catch (Exception ex)
{
//show any error message returned by the database
MessageBox.Show(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Context.User.Identity.IsAuthenticated)
{
SlidingZone1.Items.Clear();
//Load Left Split data (ServicesSubscriptions, ServiceDeliveries and Reports)
using (SmartSocialdbDataContext myDB = new SmartSocialdbDataContext())
{
var mySS = myDB.SpGetUserSubscriptions(Context.User.Identity.GetUserId());
//Create a Sliding pane for each Subscription
foreach (var aSubscription in mySS)
{
RadSlidingPane leftSlidingPane1 = new RadSlidingPane();
leftSlidingPane1.Title = aSubscription.SubscriptionName;
leftSlidingPane1.Width = new Unit(200);
leftSlidingPane1.MinWidth = 130;
RadPanelBar aPanelBar = new RadPanelBar();
aPanelBar.Width = Unit.Percentage(100);
var mySD = myDB.SpGetSubscriptionDeliveries(aSubscription.IdServiceSubscription);
//Create a Panel Item under the current Subscription for each Delivery
foreach (var aDelivery in mySD)
{
RadPanelItem aPanelItem = new RadPanelItem();
aPanelItem.Text = aDelivery.DateDelivered.Value.ToString("MMM d, yyyy");
aPanelItem.Value = aDelivery.IdServiceDelivery.ToString();
aPanelItem.ToolTip = aDelivery.DateDelivered.Value.ToLongDateString();
aPanelItem.ImageUrl = "http://icons.iconarchive.com/icons/oxygen-icons.org/oxygen/24/Actions-view-calendar-icon.png";
var mySR = myDB.SpGetDeliveryReports(aDelivery.IdServiceDelivery);
//Create a Panel sub item for the current Delivery for each Report
foreach (var aReport in mySR)
{
RadPanelItem aPanelSubItem = new RadPanelItem();
aPanelSubItem.Text = aReport.ReportName;
aPanelSubItem.Value = aReport.IdSmartReport.ToString();
aPanelSubItem.ImageUrl = "http://icons.iconarchive.com/icons/iconshock/real-vista-text/16/chart-icon.png";
aPanelItem.Items.Add(aPanelSubItem);
}
aPanelBar.Items.Add(aPanelItem);
}
leftSlidingPane1.Controls.Add(aPanelBar);
SlidingZone1.Items.Add(leftSlidingPane1);
}
}
}
}
}
public string SocialPostDatasource(int reportId, int topN, string filter, int rowsSkipped)
{
using (SqlConnection con = new SqlConnection("Data Source='208.43.238.109, 780';Initial Catalog=espriella_SmartSocial;Persist Security Info=True;User ID=espri_admin;Password=SmartSocial00!"))
{
using (SqlCommand cmd = new SqlCommand("spGetChartData_SocialPostXIdXTopNXFilterXSkipRows", con))
{
var filterWhere = "";
using (SmartSocialdbDataContext myDd = new SmartSocialdbDataContext())
{
var filterValues = filter.Split('|');
var filterParameters = filterValues.ElementAt(1).Split(',');
filterWhere = myDd.SmartChart.FirstOrDefault(x => x.IdSmartChart == Convert.ToInt32(filterValues.ElementAt(0))).SocialPostFilter.Replace("SOCIALPOSTPARAM1", filterParameters.ElementAt(0));
if (filterParameters.Count() > 1)
{
filterWhere = filterWhere.Replace("SOCIALPOSTPARAM2", filterParameters.ElementAt(1));
}
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Param1IdSmartReport", SqlDbType.Int).Value = reportId;
cmd.Parameters.Add("@Param2TopN", SqlDbType.Int).Value = topN;// Solo 15
cmd.Parameters.Add("@Param3Filter", SqlDbType.NVarChar).Value = filterWhere;
cmd.Parameters.Add("@Param4SkipRows", SqlDbType.Int).Value = rowsSkipped;
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
var returnPosts = "";
foreach (DataRow dr in dt.Rows)
{
returnPosts += "<li class='list-group-item clearfix comment-info' id='dyn_" + dr["idSocialPost"].ToString() + "'>" +
"<div class='panel-heading'>" +
"<div class='avatar pull-left mr15'>" +
"<img src='" + ProcessImage(dr["SenderProfileImgUrl"].ToString()) + "' alt='avatar' style='width:48px;height:48px'>" +
"</div>" +
"<p class='text-ellipsis'><a href='" + dr["PermaLink"].ToString() + "' target='_blanc'><span class='name strong'>" + ProcessScreenName(dr["SenderScreenName"].ToString()) + ": </span></a>" + dr["Message"].ToString().Replace("<", "<").Replace(">", ">") + " </p>" +
"<span class='date text-muted small pull-left'><img style='width:16px;height:16px' src='" +
ProcessSocialNetwork(dr["SocialNetwork"].ToString()) + "'/> " + Convert.ToDateTime(dr["MessageCreatedDate"].ToString()) + "</span>" +
"<a class='accordion-toggle collapsed see-more small pull-right' style='float:right' data-toggle='collapse' href='#collapse" + dr["idSocialPost"].ToString() + "' aria-expanded='false'>Show More</a>" +
"</h5>" +
"</div>" +
"<div id='collapse" + dr["idSocialPost"].ToString() + "' class='panel-collapse collapse' aria-expanded='false' style='height: 0px;'>" +
"<div class='panel-body'>" +
"<div class='socialPostItem'><div class='SocialPostMessage'>" + dr["Message"].ToString() + "</div></div>" +
"</div>" +
"</div>" +
"</li>";
}
return(returnPosts);
}
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (IsValid)
{
// Validate the user password
var manager = Context.GetOwinContext().GetUserManager <ApplicationUserManager>();
var signinManager = Context.GetOwinContext().GetUserManager <ApplicationSignInManager>();
var user = manager.FindByEmail(txtEmail.Text);
/*if (!manager.IsEmailConfirmed(user.Id))
* {
* Response.Redirect("/Account/NotConfirmed");
* }*/
// This doen't count login failures towards account lockout
// To enable password failures to trigger lockout, change to shouldLockout: true
var result = signinManager.PasswordSignIn(txtEmail.Text, txtPassword.Text, chkRememberMe.Checked, shouldLockout: true);
switch (result)
{
case SignInStatus.Success:
using (SmartSocialdbDataContext myDb = new SmartSocialdbDataContext())
{
var reportId = myDb.AspNetUsers.FirstOrDefault(x => x.Email == txtEmail.Text).IdLastReport;
if (reportId != null)
{
Response.Redirect("~/pages/main?idSmartReport=" + reportId);
}
else
{
Response.Redirect("~/pages/Home");
}
}
//IdentityHelper.RedirectToReturnUrl(Request.QueryString["ReturnUrl"], Response);
break;
case SignInStatus.LockedOut:
Response.Redirect("/Account/Lockout");
break;
case SignInStatus.RequiresVerification:
Response.Redirect(String.Format("/Account/TwoFactorAuthenticationSignIn?ReturnUrl={0}&RememberMe={1}",
Request.QueryString["ReturnUrl"],
chkRememberMe.Checked),
true);
break;
case SignInStatus.Failure:
default:
RadWindowManager1.RadAlert("Invalid login attempt.", 200, 50, "Login failure", "");
break;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
using (SmartSocialdbDataContext myDB = new SmartSocialdbDataContext())
{
using (SqlConnection sqlconnection = new SqlConnection(@"Data Source=208.43.238.109, 780;Initial Catalog=espriella_SmartSocial;Persist Security Info=True;User ID=espri_admin;Password=SmartSocial00!"))
{
sqlconnection.Open();
SqlCommand MyCommand1 = new SqlCommand("SELECT * INTO ##ItemBack1 FROM AspNetUsers", sqlconnection);
SqlCommand MyCommand2 = new SqlCommand("SELECT count(*) from ##ItemBack1", sqlconnection);
MessageBox.Show(MyCommand2.ExecuteScalar().ToString());
sqlconnection.Close();
}
}
}
// Place custom query extensions here.
public static IQueryable <ServiceSubscription> ByUserIdAndActive(this IQueryable <ServiceSubscription> queryable, String userId)
{
//TODO
SmartSocialdbDataContext dbContext = (SmartSocialdbDataContext)queryable.GetDataContext();
var queryByUser = dbContext.UsersXSubscription.ByIdUser(userId);
var queryFinal = queryable.
ByIsActive(true).
ByStartDate(ComparisonOperator.LessThanOrEquals, DateTime.Now).
ByEndDate(ComparisonOperator.GreaterThanOrEquals, DateTime.Now);
return(queryFinal);
}
void loadServiceSubscriptors()
{
using (SmartSocialdbDataContext smartsocialDB = new SmartSocialdbDataContext())
{
//load all service subscriptors that are active
var query = smartsocialDB.ServiceSubscription.ByIsActive(true).ToList();
if (query.Count > 0)
{
//fill the service subscriptors combo with values from the DB
cmb_subscription.DataSource = query;
cmb_subscription.DisplayMember = "SubscriptionName";
cmb_subscription.ValueMember = "IdServiceSubscription";
}
else
{
//no info of service subscriptors available in the DB
cmb_subscription.Items.Clear();
cmb_subscription.Items.Add("no info available");
cmb_subscription.SelectedIndex = 0;
}
}
}
public void loadInitialData(int subscriptionID)
{
//declare SQL DB context var
SmartSocialdbDataContext smartsocialDB = new SmartSocialdbDataContext();
ServiceSubscription newServiceSubscriptionsRow = new ServiceSubscription();
try
{
//load data base on ID passed from main form
txtID.Text = smartsocialDB.ServiceSubscription.GetByKey(subscriptionID).IdServiceSubscription.ToString();
txtName.Text = smartsocialDB.ServiceSubscription.GetByKey(subscriptionID).SubscriptionName;
startDate.Value = (DateTime)smartsocialDB.ServiceSubscription.GetByKey(subscriptionID).StartDate;
endDate.Value = (DateTime)smartsocialDB.ServiceSubscription.GetByKey(subscriptionID).EndDate;
isActive.Checked = (bool)smartsocialDB.ServiceSubscription.GetByKey(subscriptionID).IsActive;
smartsocialDB.Connection.Close();
}
catch (Exception ex)
{
//show any error message returned by the database
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//declare SQL DB context var
SmartSocialdbDataContext smartsocialDB = new SmartSocialdbDataContext();
ServiceDelivery newServiceDeliveryRow = new ServiceDelivery();
try
{
//update selected record in ServiceSubscription table
var deliveryRow = smartsocialDB.ServiceDelivery.GetByKey(int.Parse(txtID.Text));
deliveryRow.DateDelivered = startDate.Value;
deliveryRow.IdServiceSubscription = int.Parse(cmb_subscription.SelectedValue.ToString());
smartsocialDB.SubmitChanges();
smartsocialDB.Connection.Close();
//close this window
this.Close();
}
catch (Exception ex)
{
//show any error message returned by the database
MessageBox.Show(ex.Message);
}
}
protected void FillLeftPane()
{
if (Context.User.Identity.IsAuthenticated)
{
//CompanyHomeLink.HRef = "~/pages/Home";
//Load Left Split data (ServicesSubscriptions, ServiceDeliveries and Reports)
CompanyHomeLink.HRef = "~/pages/Home";
using (SmartSocialdbDataContext myDB = new SmartSocialdbDataContext())
{
var mySS = myDB.SpGetUserSubscriptions(Context.User.Identity.GetUserId());
var user = myDB.AspNetUsers.FirstOrDefault(x => x.Id == Context.User.Identity.GetUserId());
var companyImagePath = "~/images/CompanyImages/" + user.Company1.IdCompany + "/" + user.Company1.LogoFileName;
CompanyImage.Src = companyImagePath;
CompanyName.InnerText = user.Company1.CompanyName;
//Create a Sliding pane for each Subscription
RadPanelBar aPanelBar = new RadPanelBar();
aPanelBar.ItemClick += ReportClick;
aPanelBar.OnClientItemClicking = "PanelParentClicking";
aPanelBar.CssClass = "hidden-sm hidden-xs panel-margin";
aPanelBar.Width = Unit.Percentage(100);
aPanelBar.Skin = "Glow";
RadMenu suscriptionsMenu = new RadMenu();
suscriptionsMenu.Flow = ItemFlow.Vertical;
suscriptionsMenu.CssClass = "hidden-md hidden-lg hidden-xs";
suscriptionsMenu.Width = Unit.Percentage(100);
suscriptionsMenu.Skin = "Glow";
var menuExtraSmall = "<ul class='dropdown-menu multi-level dropdown-menu-left' role='menu' aria-labelledby='dropdownMenu'>";
foreach (var aSubscription in mySS)
{
var mySD = myDB.SpGetSubscriptionDeliveries(aSubscription.IdServiceSubscription);
RadPanelItem grandPanelItem = new RadPanelItem();
grandPanelItem.Text = "<div> <i class='l-ecommerce-graph1'></i> " + aSubscription.SubscriptionName + "</div>";
grandPanelItem.Value = "";
grandPanelItem.Width = Unit.Percentage(100);
grandPanelItem.ToolTip = aSubscription.SubscriptionName;
grandPanelItem.Expanded = true;
RadMenuItem suscriptionItem = new RadMenuItem();
suscriptionItem.Text = "<i class='l-ecommerce-graph1'></i>";
suscriptionItem.ToolTip = aSubscription.SubscriptionName;
menuExtraSmall += "<li class='dropdown-submenu'><a tabindex='-1' href='#'><i class='l-ecommerce-graph1'></i> " + aSubscription.SubscriptionName + "</a>" +
"<ul class='dropdown-menu'>";
//Create a Panel Item under the current Subscription for each Delivery
foreach (var aDelivery in mySD)
{
RadPanelItem aPanelItem = new RadPanelItem();
aPanelItem.Text = "<div> <i class='l-software-layout-header-3columns'></i> " + aDelivery.DateDelivered.Value.ToString("MMM, yyyy") + "</div>";
aPanelItem.Value = "";
aPanelItem.Width = Unit.Percentage(100);
aPanelItem.ToolTip = aDelivery.DateDelivered.Value.ToLongDateString();
aPanelItem.Expanded = true;
RadMenuItem deliveryItem = new RadMenuItem();
deliveryItem.Text = aDelivery.DateDelivered.Value.ToString("MMM, yyyy");
menuExtraSmall += "<li class='dropdown-submenu'>" +
"<li class='dropdown-submenu'>" +
"<a href='#'>" + aDelivery.DateDelivered.Value.ToString("MMM, yyyy") + "</a>" +
"<ul class='dropdown-menu'>";
var mySR = myDB.SpGetDeliveryReports(aDelivery.IdServiceDelivery);
//Create a Panel sub item for the current Delivery for each Report
foreach (var aReport in mySR)
{
RadPanelItem aPanelSubItem = new RadPanelItem();
aPanelSubItem.Text = aReport.ReportName;
aPanelSubItem.Value = aReport.IdSmartReport.ToString();
aPanelSubItem.Width = Unit.Percentage(100);
aPanelItem.Items.Add(aPanelSubItem);
RadMenuItem reportItem = new RadMenuItem();
reportItem.Text = aReport.ReportName;
reportItem.NavigateUrl = "pages/main.aspx?idSmartReport=" + aReport.IdSmartReport.ToString();
deliveryItem.Items.Add(reportItem);
menuExtraSmall += "<li><a href='http://" + HttpContext.Current.Request.Url.Authority + "/pages/main.aspx?idSmartReport=" + aReport.IdSmartReport.ToString() + "' aria-expanded='true' role='menuitem' tabindex='-1'>" + aReport.ReportName + "</a></li>";
}
menuExtraSmall += "</ul></li>";
suscriptionItem.Items.Add(deliveryItem);
grandPanelItem.Items.Add(aPanelItem);
}
menuExtraSmall += "</ul></li>";
aPanelBar.Items.Add(grandPanelItem);
suscriptionsMenu.Items.Add(suscriptionItem);
//SuscriptionsContainer);
}
menuExtraSmall += "</ul>";
MenuXs.Controls.Add(new LiteralControl(menuExtraSmall));
SuscriptionsContainer.Controls.Add(aPanelBar);
SuscriptionsContainer.Controls.Add(suscriptionsMenu);
}
}
else
{
SuscriptionsContainer.Attributes.Add("class", "hidden");
MainDiv.Attributes.Add("class", "col-lg-12 col-md-12 col-sm-12 col-xs-12");
Toogler.Attributes.Add("class", "hidden");
}
}
