private void BindEditSubjectList()
{
DataTable dtSub = new DataTable();
objgrp.inGroupId = Convert.ToInt32(ViewState["intGroupId"]);
dtSub = objgrpDB.GetDataTable(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetContextByGroupID);
ViewState["SaveSubCatname"] = dtSub;
List <string> catValues = new List <string>();
if (dtSub.Rows.Count > 0)
{
for (int i = 0; i < dtSub.Rows.Count; i++)
{
catValues.Add(dtSub.Rows[i]["intCategoryId"].ToString());
//if (subval == "")
//{
// subval = dtSub.Rows[i]["intCategoryId"].ToString();
//}
//else
//{
// subval += "," + dtSub.Rows[i]["intCategoryId"].ToString();
//}
}
// hdnSubject.Value = subval;
}
LstSubjCategory.SetValues(catValues.ToArray());
}
private void BindTopSubjectList()
{
DataTable dtTopSub = new DataTable();
objgrp.inGroupId = Convert.ToInt32(ViewState["intGroupId"]);
dtTopSub = objgrpDB.GetDataTable(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetAllSelectedContextID);
if (dtTopSub.Rows.Count > 0)
{
LstSubjCategory.DataSource = dtTopSub;
LstSubjCategory.DataBind();
}
else
{
LstSubjCategory.DataSource = null;
LstSubjCategory.DataBind();
}
ViewState["DocId"] = null;
ViewState["SubjectCategoryId"] = null;
}
/// <summary>
/// Bind Subject Category From the table Scrl_Category_SubjectTbl
/// </summary>
private void BindSubjectList()
{
DataTable dtSub = new DataTable();
DataSet ds = new DataSet();
objgrp.inGroupId = Convert.ToInt32(ViewState["intGroupId"]);
dtSub = objgrpDB.GetDataTable(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetContextByGroupID);
if (dtSub.Rows.Count > 0)
{
LstSubjCategory.DataSource = dtSub;
LstSubjCategory.DataBind();
LstProfSubjCategory.DataSource = dtSub;
LstProfSubjCategory.DataBind();
}
else
{
LstSubjCategory.DataSource = null;
LstSubjCategory.DataBind();
LstProfSubjCategory.DataSource = null;
LstProfSubjCategory.DataBind();
}
}
protected void btnSaveGroup_Click(object sender, EventArgs e)
{
ViewState["join"] = hdnAutoreqJoin.Value == "1" ? "A" : "R";
try
{
lblSuccMessage.Text = "";
String GroupeAccess = String.Empty;
string ip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (ip == null)
{
ip = Request.ServerVariables["REMOTE_ADDR"];
}
objgrp.intRegistrationId = Convert.ToInt32(ViewState["UserID"]);
objgrp.strGroupName = txtTitle.Text.Trim();
if (txtPurpose.InnerText != "Description")
{
//Defect # 9 HTML Validations
txtPurpose.InnerText = Validations.validateHtmlInput(txtPurpose.InnerText);
objgrp.strSummary = txtPurpose.InnerText.Trim();
}
else
{
objgrp.strSummary = "";
}
objgrp.inGroupId = Convert.ToInt32(ViewState["intGroupId"]);
string PhotoPath = "";
if (hdnFileData.Value != "")
{
string name = hdnPhotoName.Value;
string ext = System.IO.Path.GetExtension(name).ToLower();
if (ext.Trim() != ".jpg" && ext.Trim() != ".jpeg" && ext.Trim() != ".png" && ext.Trim() != ".gif" && ext.Trim() != ".org")
{
lblSuccMess.Text = "File format not supported.Image should be '.jpg or .jpeg or .png or .gif'";
lblSuccMess.CssClass = "RedErrormsg";
return;
}
// int FileLength = FileUpload1.PostedFile.ContentLength;
// if (FileLength <= 3145728)
// {
PhotoPath = DateTime.Now.ToString().Replace("/", "").Replace(".", "").Replace(":", "").Replace(" ", "") + System.IO.Path.GetExtension(hdnPhotoName.Value).ToString();
// FileUpload1.SaveAs(Server.MapPath("~\\CroppedPhoto\\" + PhotoPath));
File.WriteAllBytes(Server.MapPath("~\\CroppedPhoto\\" + PhotoPath), Convert.FromBase64String(hdnFileData.Value.Split(',')[1]));
ViewState["ImagePath"] = PhotoPath;
Session["ImagePath"] = PhotoPath;
ViewState["ImagePath"] = PhotoPath;
imgUser.Src = "CroppedPhoto/" + Convert.ToString(Session["ImagePath"]);
lblSuccMess.Text = "";
//}
// else
// PhotoPath = ViewState["ImagePath"].ToString();
}
//if (FileUpload1.HasFile)
//{
// string name = FileUpload1.FileName;
// string ext = System.IO.Path.GetExtension(name);
// if (ext.Trim() != ".jpg" && ext.Trim() != ".jpeg" && ext.Trim() != ".png" && ext.Trim() != ".gif" && ext.Trim() != ".org")
// {
// lblSuccMessage.Text = "File format not supported.Image should be '.jpg or .jpeg or .png or .gif'";
// lblSuccMessage.CssClass = "RedErrormsg";
// return;
// }
// int FileLength = FileUpload1.PostedFile.ContentLength;
// if (FileLength <= 3145728)
// {
// PhotoPath = DateTime.Now.ToString().Replace("/", "").Replace(".", "").Replace(":", "").Replace(" ", "") + System.IO.Path.GetExtension(FileUpload1.FileName).ToString();
// FileUpload1.SaveAs(Server.MapPath("~\\CroppedPhoto\\" + PhotoPath));
// ViewState["ImagePath"] = PhotoPath;
// Session["ImagePath"] = PhotoPath;
// imgUser.Src = "CroppedPhoto/" + Convert.ToString(Session["ImagePath"]);
// ImgRemovePic.Visible = true;
// lblSuccMessage.Text = "";
// }
// else
// PhotoPath = Convert.ToString(ViewState["ImagePath"]);
//}
if (Session["ImagePath"] != null)
{
objgrp.strLogoPath = Session["ImagePath"].ToString();
}
else
{
objgrp.strLogoPath = "";
}
if (Convert.ToString(ViewState["join"]) == "A")
{
objgrp.strAccess = Convert.ToString(ViewState["join"]);
}
else
{
objgrp.strAccess = Convert.ToString(ViewState["join"]);
}
objgrp.strIpAddress = ip;
objgrp.intAddedBy = Convert.ToInt32(ViewState["UserID"]);
objgrpDB.AddEditDel_Scrl_UserGroupDetailTbl(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.Update);
//Added By Dilip
WallMessageDO.intAddedBy = Convert.ToInt32(Convert.ToString(Session["ExternalUserId"]));
WallMessageDO.intGroupId = Convert.ToInt32(ViewState["intGroupId"]);
List <KeyValuePair <string, string> > members = txtInviteMember.GetSelectedValues();
// string[] members = totalMembers.Split(',');
for (int i = 0; i < members.Count; i++)
{
if (members[i].Value != "")
{
int IDs = Convert.ToInt32(members[i].Value);
objDOgroup.intAddedBy = Convert.ToInt32(ViewState["UserID"]);
objDOgroup.strUniqueKey = Convert.ToString(ViewState["strUniqueKey"]);
objDOgroup.inGroupId = Convert.ToInt32(ViewState["intGroupId"]);
objDOgroup.inviteMembers = Convert.ToString(IDs);
objDAgroup.AddEditDel_Scrl_UserGroupDetailTbl(objDOgroup, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.UpGrpRoleRequestPermission);
objDAgroup.AddEditDel_Scrl_UserGroupDetailTbl(objDOgroup, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.InsertGroupInvitationEdit);
int ID = Convert.ToInt32(members[i].Value);
WallMessageDO.intInvitedUserId = Convert.ToInt32(ID);
WallMessageDO.striInvitedUserId = Convert.ToString(ID);
WallMessageDO.intAddedBy = Convert.ToInt32(Convert.ToString(Session["ExternalUserId"]));
WallMessageDO.intGroupId = Convert.ToInt32(ViewState["intGroupId"]);
WallMessageDA.Scrl_AddEditDelWallMessage(WallMessageDO, DA_WallMessage.WallMessage.SelectMessageDetails);
if (hdnTitle.Value != objgrp.strGroupName)
{
WallMessageDO.intAddedBy = Convert.ToInt32(Convert.ToString(Session["ExternalUserId"]));
WallMessageDO.intGroupId = Convert.ToInt32(ViewState["intGroupId"]);
WallMessageDO.StrRecommendation = "Group owner updated the group name as \"" + objgrp.strGroupName + "\"";
WallMessageDO.strSubject = "Group Name Changed";
WallMessageDO.strIpAddress = ip;
WallMessageDO.intAddedBy = Convert.ToInt32(ViewState["UserID"]);
WallMessageDO.intInvitedUserId = Convert.ToInt32(ID);
WallMessageDO.striInvitedUserId = Convert.ToString(ID);
WallMessageDO.strTotalGrpMemberID = hdnTitle.Value;
WallMessageDA.Scrl_AddEditDelWallMessage(WallMessageDO, DA_WallMessage.WallMessage.Add);
}
dt = WallMessageDA.GetDataTable(WallMessageDO, DA_WallMessage.WallMessage.CheckMessagesend);
if (dt.Rows.Count == 0)
{
WallMessageDO.intAddedBy = Convert.ToInt32(Convert.ToString(Session["ExternalUserId"]));
WallMessageDO.intGroupId = Convert.ToInt32(ViewState["intGroupId"]);
if (objgrp.strAccess == "A")
{
WallMessageDO.StrRecommendation = "Group Owner added You to Group.";
WallMessageDO.strSubject = "Group Invitation";
}
else
{
WallMessageDO.StrRecommendation = "Group Owner Invite You to Join Group.";
WallMessageDO.strSubject = "Group Invitation";
}
WallMessageDO.strIpAddress = ip;
WallMessageDO.intAddedBy = Convert.ToInt32(Convert.ToString(Session["ExternalUserId"]));
WallMessageDO.intInvitedUserId = Convert.ToInt32(ID);
WallMessageDO.striInvitedUserId = Convert.ToString(ID);
WallMessageDA.Scrl_AddEditDelWallMessage(WallMessageDO, DA_WallMessage.WallMessage.Add);
}
if (objgrp.strAccess == "A")
{
objGrpJoinDO.inGroupId = Convert.ToInt32(ViewState["intGroupId"]);
objGrpJoinDO.intInvitedUserId = Convert.ToInt32(ViewState["UserID"]);
ip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (ip == null)
{
ip = Request.ServerVariables["REMOTE_ADDR"];
}
objGrpJoinDO.strIpAddress = ip;
objGrpJoinDO.intAddedBy = Convert.ToInt32(ID);
objGrpJoinDO.intRegistrationId = Convert.ToInt32(ID);
objGrpJoinDO.isAccepted = 1;
objGrpJoinDA.AddEditDel_Scrl_UserGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.Insert);
}
}
}
objDO.intAddedBy = Convert.ToInt32(ViewState["UserID"]);
if (ip == null)
{
ip = Request.ServerVariables["REMOTE_ADDR"];
}
objDO.strIpAddress = ip;
objDO.inGroupId = Convert.ToInt32(ViewState["intGroupId"]);
objDO.strUniqueKey = objDA.GetUniqueKeyPermissionDataTable(objDO, Convert.ToInt32(ViewState["intGroupId"]));
objDO.grpInvMemberId = Convert.ToInt32(ViewState["GroupMemberId"]);
////commented by akash on 29/04/2015
//DataTable dttt = objDA.GetDataTable(objDO, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.deleteMemeberRole);
//for (int i = 0; i < members.Length; i++)
//{
// if (members.GetValue(i) != "")
// {
// lblinviteMemeber.Visible = false;
// int ID = Convert.ToInt32(members.GetValue(i));
// objDO.strMemberName = ID.ToString();
// objDO.inviteMembers = Convert.ToString(ID);
// DataTable dt = objDA.GetRolePermissionDataTable(objDO, DA_Scrl_UserGroupDetailTbl.Scrl_GroupModulePermissionTbl.GetinviteMember);
// if (dt.Rows.Count > 0)
// {
// objDO.intModifiedBy = Convert.ToInt32(ViewState["UserID"]);
// objDO.intGrpInvitationMemberId = Convert.ToInt32(dt.Rows[0]["intGrpInvitationMemberId"].ToString());
// objDA.AddEditDel_Scrl_UserGroupDetailTbl(objDO, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.UpdateGroupInvitation);
// }
// else
// {
// objDA.AddEditDel_Scrl_UserGroupDetailTbl(objDO, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.InsertGroupInvitation);
// }
// }
// else
// {
// lblinviteMemeber.Visible = true;
// }
//}
////-----------------------------------
ViewState["GroupOutId"] = Convert.ToInt32(ViewState["intGroupId"]);
DataTable dtsub = new DataTable();
//dtsub = (DataTable)ViewState["SubjectCategory"];
//if (dtsub.Rows.Count > 0)
//{
objgrpDB.AddEditDel_Scrl_UserGroupDetailTbl(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.DeleteContextGroupDocument);
//}
//else
//{
// objgrpDB.AddEditDel_Scrl_UserGroupDetailTbl(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.DeleteContextGroupDocument);
//}
List <KeyValuePair <string, string> > contexts = LstSubjCategory.GetSelectedValues();
foreach (KeyValuePair <string, string> dr in contexts)
{
objgrp.inGroupId = Convert.ToInt32(ViewState["GroupOutId"]);
objgrp.intSubjectCategoryId = Convert.ToInt32(dr.Value);
objgrp.intAddedBy = Convert.ToInt32(ViewState["UserID"]);
objgrpDB.AddEditDel_Scrl_UserGroupDetailTbl(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.UpdateCotextGroupDocument);
}
clearGroup();
divGroupSucces.Style.Add("display", "block");
Response.Redirect("Group-Profile.aspx?GrpId=" + ViewState["intGroupId"]);
}
catch { }
}
