public void GetAssignRole() { if (ViewState["intGroupId"] != null) { objgrp.intRegistrationId = Convert.ToInt32(ViewState["UserID"]); objgrp.inGroupId = Convert.ToInt32(ViewState["intGroupId"]); DataSet dschk = objgrpDB.GetDataSet(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.ViewGrpAssignUser); string Status = string.Empty; DataTable dtGrpOpt = objgrpDB.GetDataTable(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.ChkGroupOption); if (Convert.ToString(dtGrpOpt.Rows[0]["strAccess"]) == "A") { GetAccessModuleDetails(); if (Convert.ToString(dschk.Tables[0].Rows[0][0]) == "0") { lnkEdit.Visible = false; } else { lnkEdit.Visible = true; } if (dschk.Tables[3].Rows.Count > 0) { if (Convert.ToString(dschk.Tables[3].Rows[0][0]) == Convert.ToString(ViewState["UserID"])) { divSecondWall.Style.Add("display", "block"); DivHome.Style.Add("display", "block"); DivForumTab.Style.Add("display", "block"); DivUploadTab.Style.Add("display", "block"); DivPollTab.Style.Add("display", "block"); DivEventTab.Style.Add("display", "block"); DivMemberTab.Style.Add("display", "block"); } } } else { if (Convert.ToString(dschk.Tables[0].Rows[0][0]) != "0") { divSecondWall.Style.Add("display", "block"); DivHome.Style.Add("display", "block"); DivForumTab.Style.Add("display", "block"); DivUploadTab.Style.Add("display", "block"); DivPollTab.Style.Add("display", "block"); DivEventTab.Style.Add("display", "block"); DivMemberTab.Style.Add("display", "block"); } else { lnkEdit.Visible = false; divSecondWall.Style.Add("display", "block"); GetAccessModuleDetails(); } } } }
protected void GetAccessModuleDetails() { objgrp.intUserId = Convert.ToInt32(ViewState["UserID"]); objgrp.inGroupId = Convert.ToInt32(ViewState["intGroupId"]); dt = objgrpDB.GetDataTable(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetGrpModuleDetailsAcces); //Profile,Home=Wall,Uploads=Uploads,Events=Events,Discussion=Forum,Polls=Polls,Jobs=Jobs,Members=Members if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string ModuleName = Convert.ToString(dt.Rows[i]["strModuleName"]); switch (ModuleName) { case "Wall": DivHome.Style.Add("display", "block"); break; case "Uploads": DivUploadTab.Style.Add("display", "block"); break; case "Events": DivEventTab.Style.Add("display", "block"); break; case "Discussion": DivForumTab.Style.Add("display", "block"); break; case "Polls": DivPollTab.Style.Add("display", "block"); break; case "Members": DivMemberTab.Style.Add("display", "block"); break; } } } }
protected void AccessModulePermisssion() { objDO.intUserId = Convert.ToInt32(ViewState["UserID"]); objDO.inGroupId = Convert.ToInt32(ViewState["intGroupId"]); objgrp.intRegistrationId = Convert.ToInt32(ViewState["UserID"]); DataSet dschk = objgrpDB.GetDataSet(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.ViewGrpAssignUser); DataTable dtRoleAP = objDA.GetDataTable(objDO, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetGrpRoleRequestPermission); if (dschk.Tables[3].Rows.Count > 0) { if (dschk.Tables[3].Rows[0][0].ToString() == Convert.ToString(ViewState["UserID"])) { divSecondWall.Style.Add("display", "block"); DivHome.Style.Add("display", "block"); DivForumTab.Style.Add("display", "block"); DivUploadTab.Style.Add("display", "block"); DivPollTab.Style.Add("display", "block"); DivEventTab.Style.Add("display", "block"); DivMemberTab.Style.Add("display", "block"); return; } } if (dtRoleAP.Rows.Count > 0) { if (dtRoleAP.Rows[0]["IsAccepted"].ToString() != "0" && dtRoleAP.Rows[0]["IsAccepted"].ToString() != "2") { divSecondWall.Style.Add("display", "block"); DivHome.Style.Add("display", "block"); DivForumTab.Style.Add("display", "block"); DivUploadTab.Style.Add("display", "block"); DivPollTab.Style.Add("display", "block"); DivEventTab.Style.Add("display", "block"); DivMemberTab.Style.Add("display", "block"); return; } } lnkProfile.Style.Add("width", "25%"); DivHome.Style.Add("display", "none"); DivForumTab.Style.Add("display", "none"); DivUploadTab.Style.Add("display", "none"); DivPollTab.Style.Add("display", "none"); DivEventTab.Style.Add("display", "none"); DivMemberTab.Style.Add("display", "none"); }
private void BindScrl_UserGroupDetailTblList(int userid) { DO_Scrl_UserGroupDetailTbl objDO = new DO_Scrl_UserGroupDetailTbl(); DA_Scrl_UserGroupDetailTbl objDA = new DA_Scrl_UserGroupDetailTbl(); objDO.intAddedBy = userid; dtlScrl_UserGroupDetailTbl.DataSource = objDA.GetDataTable(objDO, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.AllRecords); dtlScrl_UserGroupDetailTbl.DataBind(); }
protected void AccessModulePermisssion() { objDOG.intUserId = Convert.ToInt32(ViewState["UserID"]); objDOG.inGroupId = Convert.ToInt32(ViewState["intGroupId"]); objgrp.inGroupId = Convert.ToInt32(ViewState["intGroupId"]); objgrp.intRegistrationId = Convert.ToInt32(ViewState["UserID"]); DataSet dschk = objgrpDB.GetDataSet(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.ViewGrpAssignUser); DataTable dtRoleAP = objDAG.GetDataTable(objDOG, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetGrpRoleRequestPermission); if (dschk.Tables[3].Rows.Count > 0) { if (dschk.Tables[3].Rows[0][0].ToString() == ViewState["UserID"].ToString()) { DivHome.Style.Add("display", "block"); DivForumTab.Style.Add("display", "block"); DivUploadTab.Style.Add("display", "block"); DivPollTab.Style.Add("display", "block"); DivEventTab.Style.Add("display", "block"); DivMemberTab.Style.Add("display", "block"); return; } } if (dtRoleAP.Rows.Count > 0) { if (dtRoleAP.Rows[0]["IsAccepted"].ToString() != "0" && dtRoleAP.Rows[0]["IsAccepted"].ToString() != "2") { DivHome.Style.Add("display", "block"); DivForumTab.Style.Add("display", "block"); DivUploadTab.Style.Add("display", "block"); DivPollTab.Style.Add("display", "block"); DivEventTab.Style.Add("display", "block"); DivMemberTab.Style.Add("display", "block"); } else { Response.Redirect("Group-Profile.aspx?GrpId=" + ViewState["intGroupId"]); } } else { Response.Redirect("Group-Profile.aspx?GrpId=" + ViewState["intGroupId"]); } }
private void BindRole() { objDO.inGroupId = Convert.ToInt32(Request.QueryString["GrpId"]); if (Request.QueryString["AccRegId"] != null) { dt = objDA.GetDataTable(objDO, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.BindRoleByGrpID); } else { dt = objDA.GetOrgDataTable(objDO, DA_Scrl_UserGroupDetailTbl.Scrl_OrgGroupDetailTbl.BindRoleByGrpID); } if (dt.Rows.Count > 0) { ddlRoleDetails.DataTextField = "strRoleName"; ddlRoleDetails.DataValueField = "intGrpRoleId"; ddlRoleDetails.DataSource = dt; ddlRoleDetails.DataBind(); ddlRoleDetails.Items.Insert(0, "Select Role"); } else { ddlRoleDetails.Items.Insert(0, "Select Role"); } }
protected void dtlScrl_UserGroupDetailTbl_ItemCommand(object sender, ListViewCommandEventArgs e) { lblId.Text = ""; DataTable dtScrl_UserGroupDetailTbl; if (e.CommandName == "Edit") { int index = e.Item.DataItemIndex; ListViewDataItem item = (ListViewDataItem)e.Item; HiddenField hdninGroupId = e.Item.FindControl("hdninGroupId") as HiddenField; int inGroupId = Convert.ToInt32(hdninGroupId.Value); PanlShow(); DO_Scrl_UserGroupDetailTbl objDO = new DO_Scrl_UserGroupDetailTbl(); DA_Scrl_UserGroupDetailTbl objDA = new DA_Scrl_UserGroupDetailTbl(); lblId.Text = Convert.ToString(inGroupId); objDO.inGroupId = inGroupId; dtScrl_UserGroupDetailTbl = objDA.GetDataTable(objDO, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.SingleRecord); txtGroupName.Text = Convert.ToString(dtScrl_UserGroupDetailTbl.Rows[0]["strGroupName"]); txtSummary.Text = Convert.ToString(dtScrl_UserGroupDetailTbl.Rows[0]["strSummary"]); // drpGroupType.Text=Convert.ToString(dtScrl_UserGroupDetailTbl.Rows[0]["strGroupType"]); drpGroupType.ClearSelection(); BindGroupType(); try { drpGroupType.Items.FindByValue(dtScrl_UserGroupDetailTbl.Rows[0]["strGroupType"].ToString()).Selected = true; } catch { } RdBList_Access.ClearSelection(); RdBList_Access.Items.FindByValue(dtScrl_UserGroupDetailTbl.Rows[0]["strAccess"].ToString()).Selected = true; if (dtScrl_UserGroupDetailTbl.Rows[0]["bitPrivatePublic"].ToString() == "True") { RdblistPrivPub.ClearSelection(); RdblistPrivPub.Items.FindByValue("1").Selected = true; } else if (dtScrl_UserGroupDetailTbl.Rows[0]["bitPrivatePublic"].ToString() == "False") { RdblistPrivPub.ClearSelection(); RdblistPrivPub.Items.FindByValue("0").Selected = true; } else { RdblistPrivPub.ClearSelection(); } txtDescription.Text = Convert.ToString(dtScrl_UserGroupDetailTbl.Rows[0]["strDescription"]); // txtAccess.Text=Convert.ToString(dtScrl_UserGroupDetailTbl.Rows[0]["strAccess"]); // txtLogoPath.Text=Convert.ToString(dtScrl_UserGroupDetailTbl.Rows[0]["strLogoPath"]); } else if (e.CommandName == "Delete") { int index = e.Item.DataItemIndex; ListViewDataItem item = (ListViewDataItem)e.Item; HiddenField hdninGroupId = e.Item.FindControl("hdninGroupId") as HiddenField; int inGroupId = Convert.ToInt32(hdninGroupId.Value); DO_Scrl_UserGroupDetailTbl objDO = new DO_Scrl_UserGroupDetailTbl(); DA_Scrl_UserGroupDetailTbl objDA = new DA_Scrl_UserGroupDetailTbl(); objDO.inGroupId = inGroupId; dtScrl_UserGroupDetailTbl = objDA.GetDataTable(objDO, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.Delete); lblMessage.Text = "Record deleted successfully"; lblMessage.CssClass = "GreenErrormsg"; BindScrl_UserGroupDetailTblList(Convert.ToInt32(ViewState["UserID"])); } }
private void SendMailGroup() { try { SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); string mailfrom = ConfigurationManager.AppSettings["mailfrom"]; string mailServer = ConfigurationManager.AppSettings["mailServer"]; string username = ConfigurationManager.AppSettings["UserName"]; string Password = ConfigurationManager.AppSettings["Password"]; string Port = ConfigurationManager.AppSettings["Port"]; string MailURL = ConfigurationManager.AppSettings["MailURL"]; string MailSSL = ConfigurationManager.AppSettings["MailSSL"]; string DisplayName = ConfigurationManager.AppSettings["DisplayName"]; string MailTo = Convert.ToString(ViewState["TotalMailId"]); string Mailbody = ""; NetworkCredential cre = new NetworkCredential(username, Password); SmtpClient clientip = new SmtpClient(mailServer); clientip.Port = Convert.ToInt32(Port); clientip.UseDefaultCredentials = true; if (MailSSL != "0") { clientip.EnableSsl = true; } clientip.Credentials = cre; try { MailMessage Rmm2 = new MailMessage(); Rmm2.IsBodyHtml = true; Rmm2.From = new System.Net.Mail.MailAddress(mailfrom); Rmm2.Body = Mailbody.ToString(); System.Net.Mail.AlternateView htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(""); DataTable dtMailId = new DataTable(); objDOgroup.strUniqueKey = ViewState["ukey"].ToString(); dtMailId = objDAgroup.GetDataTable(objDOgroup, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetMailId); if (dtMailId.Rows.Count > 0) { for (int i = 0; i < dtMailId.Rows.Count; i++) { string name = Convert.ToString(dtMailId.Rows[i]["Name"]); string MailId = Convert.ToString(dtMailId.Rows[i]["vchrUserName"]); if (MailId != null) { //MailTo += "," + MailId; MailTo = MailId; htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString("<b>Skorkel group joining invitation</b>" + "<br><br>" + "Dear " + name + " " + "<br><br>" + ViewState["LoginName"] + " request you to allow joining " + ViewState["strGroupName"] + " group. <br><br>" + "Thanks," + "<br>" + "The Skorkel Team<br><br>" + "****This is a system generated Email. Kindly do not reply****", null, "text/html"); Rmm2.To.Clear(); Rmm2.To.Add(MailTo); Rmm2.Subject = "Skorkel Group Joining Request."; Rmm2.AlternateViews.Add(htmlView); Rmm2.IsBodyHtml = true; clientip.Send(Rmm2); Rmm2.To.Clear(); // ViewState["TotalMailId"] = TotalMailId; } } } } catch (FormatException ex) { ex.Message.ToString(); return; } catch (SmtpException ex) { ex.Message.ToString(); return; } finally { conn.Close(); } } catch (Exception ex) { ex.Message.ToString(); } }
private void SendMailGroup() //int RecieverID, int SenderID { try { string body = null; DataTable dtRecord = new DataTable(); SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); string mailfrom = ConfigurationManager.AppSettings["mailfrom"]; string mailServer = ConfigurationManager.AppSettings["mailServer"]; string username = ConfigurationManager.AppSettings["UserName"]; string Password = ConfigurationManager.AppSettings["Password"]; string Port = ConfigurationManager.AppSettings["Port"]; string MailURL = ConfigurationManager.AppSettings["MailURL"]; string MailSSL = ConfigurationManager.AppSettings["MailSSL"]; string DisplayName = ConfigurationManager.AppSettings["DisplayName"]; string MailTo = Convert.ToString(ViewState["TotalMailId"]); string Mailbody = ""; objdonetwork.RegistrationId = Convert.ToInt32(ViewState["UserID"]); dtRecord = objdanetwork.GetUserConnections(objdonetwork, DA_Networks.NetworkDetails.GetgroupShareInvitee); //NetworkCredential cre = new NetworkCredential(username, Password); //SmtpClient clientip = new SmtpClient(mailServer); //clientip.Port = Convert.ToInt32(Port); //clientip.UseDefaultCredentials = true; //if (MailSSL != "0") // clientip.EnableSsl = true; //clientip.Credentials = cre; SmtpClient clientip = new SmtpClient(mailServer); clientip.Port = Convert.ToInt32(Port); clientip.UseDefaultCredentials = false; if (MailSSL != "0") { clientip.EnableSsl = true; } clientip.Credentials = new System.Net.NetworkCredential(username, Password); try { MailMessage Rmm2 = new MailMessage(); Rmm2.IsBodyHtml = true; Rmm2.From = new System.Net.Mail.MailAddress(mailfrom, DisplayName); Rmm2.Body = Mailbody.ToString(); System.Net.Mail.AlternateView htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(""); DataTable dtMailId = new DataTable(); objDOgroup.strUniqueKey = ViewState["ukey"].ToString(); dtMailId = objDAgroup.GetDataTable(objDOgroup, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetMailId); if (dtMailId.Rows.Count > 0) { for (int i = 0; i < dtMailId.Rows.Count; i++) { string name = Convert.ToString(dtMailId.Rows[i]["Name"]); string MailId = Convert.ToString(dtMailId.Rows[i]["vchrUserName"]); if (MailId != null) { //MailTo += "," + MailId; MailTo = MailId; //htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString("<b>Skorkel group joining invitation</b>" // + "<br><br>" + "Dear " + name + " " // + "<br><br>" + ViewState["LoginName"] // + " request you to allow joining " + ViewState["strGroupName"] + " group. <br><br>" // + "Thanks," + "<br>" // + "The Skorkel Team<br><br>" // + "****This is a system generated Email. Kindly do not reply****", null, "text/html"); using (StreamReader reader = new StreamReader(Server.MapPath("~/EmailTemplate.htm"))) { body = reader.ReadToEnd(); } if (ViewState["join"].ToString() == "A") { string MailUrlFinal = MailURL + "/Group-Profile.aspx?GrpId=" + Convert.ToInt32(ViewState["GroupOutId"]); body = body.Replace("{UserName}", name); body = body.Replace("{Content}", "<b>" + dtRecord.Rows[0]["Name"] + "</b>" + " added you to the " + ViewState["strGroupName"] + " group. <br>" + "Please click below to view group details: " + "<br><a href = '" + MailUrlFinal + "' style='background:#01B7BD;padding:5px 10px;border-radius:15px;color:#fff;text-decoration: none;'>View Details</a>"); body = body.Replace("{RedirectURL}", MailURL); htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(body, null, MediaTypeNames.Text.Html); Rmm2.To.Clear(); Rmm2.To.Add(MailTo); //Rmm2.Subject = "Skorkel Group Joining Request."; Rmm2.Subject = ViewState["strGroupName"] + " Skorkel Group included you, By " + dtRecord.Rows[0]["Name"]; } else if (ViewState["join"].ToString() == "R") { string MailUrlFinal = MailURL + "/Group-Profile.aspx?GrpId=" + Convert.ToInt32(ViewState["GroupOutId"]); body = body.Replace("{UserName}", name); body = body.Replace("{Content}", "<b>" + dtRecord.Rows[0]["Name"] + "</b>" + " added you to the " + ViewState["strGroupName"] + " group. <br>" + "Please click below to view group details: " + "<br><a href = '" + MailUrlFinal + "' style='background:#01B7BD;padding:5px 10px;border-radius:15px;color:#fff;text-decoration: none;'>View Details</a>"); body = body.Replace("{RedirectURL}", MailURL); htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(body, null, MediaTypeNames.Text.Html); Rmm2.To.Clear(); Rmm2.To.Add(MailTo); //Rmm2.Subject = "Skorkel Group Joining Request."; Rmm2.Subject = ViewState["strGroupName"] + " Skorkel Group included you, By " + dtRecord.Rows[0]["Name"]; } Rmm2.AlternateViews.Add(htmlView); Rmm2.IsBodyHtml = true; clientip.Send(Rmm2); Rmm2.To.Clear(); // ViewState["TotalMailId"] = TotalMailId; } } } } catch (FormatException ex) { ex.Message.ToString(); return; } catch (SmtpException ex) { ex.Message.ToString(); return; } finally { conn.Close(); } } catch (Exception ex) { ex.Message.ToString(); } }