protected void btnRegister_Click(object sender, EventArgs e)
{
try
{
MembershipCreateStatus status;
Membership.CreateUser(txtUserName.Text.Trim(), txtPassWord.Text, txtEmail.Text, null, null, true, out status);
if (status.ToString() == "Success")
{
UserPermission userpr = new UserPermission();
userpr.Username = txtUserName.Text;
userpr.CompanyId = int.Parse(cboCompanyName.SelectedValue);
userpr.AppPermission = chkAppPermission.Checked;
if (cboPermission.SelectedValue == "")
{
userpr.WebPermission = null;
}
else
{
userpr.WebPermission = cboPermission.SelectedValue;
}
userpr.CreateAccount = this.User.Identity.Name;
userpr.Insert();
//Send email created user
string mailBodyTemplate = Server.MapPath("~/Template/" + Common.AppSettingKey(Constant.MAIL_REGISTER_BODY));
List <ParamMailContent> listParameter = new List <ParamMailContent>();
string urlPotal = Common.AppSettingKey(Constant.PORTAL_CONFIG);
listParameter.Add(new ParamMailContent("{ACCOUNT_ID}", userpr.Username));
listParameter.Add(new ParamMailContent("{ACCOUNT_EMAIL}", txtEmail.Text));
listParameter.Add(new ParamMailContent("{ACCOUNT_PASS}", txtPassWord.Text));
listParameter.Add(new ParamMailContent("{WORKNC_URL}", urlPotal.Replace("Portal", "")));
MailInfo.SendMail(txtEmail.Text, Common.AppSettingKey(Constant.MAIL_REGISTER_SUBJECT), mailBodyTemplate, listParameter);
//Reset data
txtUserName.Text = txtEmail.Text = string.Empty;
cboPermission.SelectedIndex = 0;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert(\"" + (GetResource("RegisterUserSuccess") + "\");"), true);
}
if (Membership.GetUser(txtUserName.Text).UserName != string.Empty)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert(\"" + GetJSMessage(GetResource("Title_Error"), GetResource("RegisterUserFail")) + "\");", true);
}
}
catch (Exception ex)
{
btnRegister.Enabled = true;
this.btnRegister.Attributes.Add("onclick", "javascript:if (Page_ClientValidate()){ this.disabled=true;}" + Page.ClientScript.GetPostBackEventReference(btnRegister, "").ToString());
logger.Error("Error Register", ex);
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert(\"" + GetJSMessage(GetResource("Title_Error"), ex.Message) + "\");", true);
}
}
public void btnAddUser_Click(object sender, EventArgs e)
{
string userNameNew = MyUtilities.clean(txtNewUser.Text); // clean user name in case try to crash DB !!!
userNameNew.Trim();
string message;
if (userNameNew == "")
{
ShowErrorMessage("No user name entered. Please try again.");
return;
}
string groupname = CurrentGroupName;
int groupID = groupManagement.find_group_id(groupname);
//logFiles.ErrorLog(" trying to add user to group " + groupname + " user " + userNameNew);
int successAdd = groupManagement.unique_user_name(groupname, userNameNew);
if (successAdd == 0)
{
message = "User in group already?";
logFiles.ErrorMessageLog(message);
ShowErrorMessage(message);
return;
}
bool leader1 = chkIsLeader.Checked;
string ld1 = Convert.ToString(leader1);
successAdd = groupManagement. add_user_to_group(groupname, userNameNew, leader1, username);
if (successAdd == 0)
{
message = "New user not added. User '" + userNameNew + "' not found? ";
logFiles.ErrorMessageLog(message);
ShowErrorMessage(message);
}
message = "User added to group " + groupname + " username " +userNameNew ;
MailInfo.SendMail(message, MailInfo.GROUP_USER_ADDED);
SetUserGridData();
txtNewUser.Text= "";
chkIsLeader.Checked = false;
}
// add user to group
/// //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public int add_user_to_group(string groupname, string username, bool leader, string adding_user)
{
/// //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// test for new name
if (unique_user_name(groupname, username) == 0)
{
return(0);
}
;
// test if nadding user has leader authority in group
if (has_group_leader(groupname, adding_user) == 0)
{
return(0);
}
// add test if user in is user list !!!!
if (UsernameExists(username) == false)
{
return(0);
}
string slead;
if (leader == false)
{
slead = "no";
}
else
{
slead = "yes";
}
/////////////////////////////////////////
if (!DbUse.RunMySqlParams("INSERT INTO webmpx.group_members (Username, Groupname, leader) VALUES ( @username, @groupname, @leader)",
new string[] { "@username", "@groupname", "@leader" }, new object[] { username, groupname, slead }))
{
return(0);
}
// mail to usr
try {
string mail = DbUse.GetEmailAddress(username); // GREG
MailInfo.SendMail("You were invited to Value Stream Modeling website group. Please visit group models page.", MailInfo.GROUP_USER_ADDED, mail);
} catch (Exception ex) { }
return(-1);
}
public void btnCreateGroup_Click(object sender, EventArgs e)
{
string message;
string groupName = MyUtilities.clean(AddGroupName.Text);
groupName = groupName.Trim();
if (groupName == "")
{
//ShowErrorMessage("No group name entered. Please try again.");
return;
}
int successCreate = groupManagement.add_new_group(groupName, username);
if (successCreate == 0)
{
message = "Group name is already in use. Please choose a new group name.";
logFiles.ErrorMessageLog(message);
ShowErrorMessage(message);
ModalPopupExtender3.Show();
return;
}
if (successCreate == -1)
{
message = "Couldn't find added Group name TIMING!!!.";
logFiles.ErrorMessageLog(message);
ShowErrorMessage(message);
return;
}
CurrentGroupName = groupName;
ModalPopupExtender3.Hide();
DropDownList2Bind();
ModalPopupExtender3.Hide();
//ShowErrorMessage("added group " + groupName);
message = "User group " + groupName + " created.";
MailInfo.SendMail(message, MailInfo.GROUP_CREATED);
SetUserGridData();
}
protected void btnDeleteGroup_Click(object sender, EventArgs e)
{
//confirmed to Delete
// string str1 = curgrpname.Text;
// logFiles.ErrorLog("into Do delete group " + str1 + CurrentGroupName);
string groupname = CurrentGroupName;
int groupid = groupManagement.find_group_id(groupname);
if (groupid == 0)
{
ShowErrorMessage("Group not deleted. Group name not found ?" + groupname);
logFiles.ErrorMessageLog("Do delete group " + "Group not deleted. Group name not found ?" + groupname);
}
int ret = groupManagement.delete_group(groupname, username);
if (ret == 0)
{
ShowErrorMessage("Group not deleted. Current client (i.e. you) may not have Leader status...");
logFiles.ErrorMessageLog("Do delete group " + "Group not deleted. Current client (i.e. you) may not have Leader status...");
}
CurrentGroupName = "None";
//Response.Redirect("groups.aspx");
//DropDownList2Bind();
//SetUserGridData();
ret = DropDownList2Bind();
if (ret != 0) SetUserGridData();
string message = "User group " + groupname + " deleted.";
MailInfo.SendMail(message, MailInfo.GROUP_DELETED);
}
protected void btnDeleteUser_Click(object sender, EventArgs e)
{
string del_name = hdnUserId.Value; // name of user to delete ... get name from hiddden field
//ShowErrorMessage("User name ? " + del_name);
// string groupname = curgrpname.Text;
string groupname = CurrentGroupName;
int groupid = groupManagement.find_group_id(groupname);
//logFiles.ErrorLog("into ask delete user" + del_name + groupname);
//ShowErrorMessage("Group ? " + groupname);
if (groupid == 0)
{
ShowErrorMessage("Group not found ? " + groupname );
return;
}
int ret = groupManagement.delete_user_from_group ( groupid, username, del_name); // groupid, username is name of user DOING - MUST HAVE LEADER STATUS - CHECKED IN CODE
if (ret == 0)
{
ShowErrorMessage("User not removed from group. Current client (i.e. you) may not have Leader status...");
}
else
{
string message = "User group " + groupname + " User " + del_name + " deleted by user " + username;
MailInfo.SendMail(message, MailInfo.GROUP_USER_DELETED);
}
SetUserGridData();
}
public bool ChangePassword(string link, string pswdNew)
{
bool updated = false;
int id = GetPasswordResetLinkId(link);
if (id != -1)
{
string hash = PasswordHash.PasswordHash.CreateHash(pswdNew);
updated = DbUse.RunMysql("UPDATE userlog SET usercode = '" + hash + "' WHERE id = " + id + ";");
if (updated)
{
try {
string logBody = "Password was changed for\n";
logBody += "Username: "******"username", "id", id, "userlist") + "\n";
logBody += "User IP: " + System.Web.HttpContext.Current.Request.UserHostAddress + "\n";
MailInfo.SendMail(logBody, MailInfo.PASSWORD_RESET_ACTION);
} catch (Exception ex) {
logFiles.ErrorLog(ex);
}
}
}
return(updated);
}
protected void lBtnResetPassword_Click(object sender, EventArgs e)
{
try
{
GridViewRow r = (GridViewRow)((LinkButton)sender).NamingContainer;
MembershipUser u = Membership.GetUser(r.Cells[0].Text);
string newPassword = string.Empty;
newPassword = u.ResetPassword();
string replacePass = Membership.GeneratePassword(8, 4);
bool changedPass = u.ChangePassword(newPassword, replacePass);
if (newPassword != string.Empty && changedPass == true)
{
string mailBodyTemplate = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath(System.Web.HttpContext.Current.Request.ApplicationPath), "Template/" + Common.AppSettingKey(Constant.MAIL_RESETPW_BODY));
logger.Debug("mail boyd template = " + mailBodyTemplate);
List <ParamMailContent> listParameter = ParamMailContent.GetListParamailContext(u.UserName, replacePass, u.Email);
listParameter.Add(new ParamMailContent("{ACCOUNT_ID}", u.UserName));
listParameter.Add(new ParamMailContent("{ACCOUNT_EMAIL}", u.Email));
listParameter.Add(new ParamMailContent("{ACCOUNT_PASS}", replacePass));
MailInfo.SendMail(Common.GetRowString(r.Cells[1].Text), Common.AppSettingKey(Constant.MAIL_RESETPW_SUBJECT), mailBodyTemplate, listParameter);
RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("msResetPasswordSuccess"), string.Format(GetResource("msResetPasswordDetail"), Common.GetRowString(r.Cells[0].Text), replacePass)) + "\");");
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert(\"" + GetJSMessage(GetResource("Title_Error"), GetResource("msResetPasswordFail")) + "\");", true);
}
}
catch (Exception ex)
{
logger.Error("Error lBtnResetPassword_Click", ex);
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert(\"" + GetJSMessage(GetResource("Title_Error"), ex.Message) + "\");", true);
}
}
// delete group
/// //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public int delete_group(string groupname, string username)
{
/// //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
int val;
val = -1;
int groupid = find_group_id(groupname);
// check check if leader !!!
// check if user has group leader authority
if (has_group_leader(groupname, username) == 0)
{
return(0);
}
try {
string message = String.Format("User {0} deleting group '{1}' .\n", username, System.Web.HttpContext.Current.Request.UserHostAddress, DbUse.DomainPath);
// mail to usr , all memebers of group and admin
// TODO add mail addresses
MailInfo.SendMail(message, MailInfo.GROUP_DELETED);
} catch (Exception exp) {
logFiles.ErrorLog(exp);
}
// delele membrs list
string deleteQuery;
if (!DbUse.RunMySqlParams("DELETE webmpx.group_members.* FROM webmpx.group_members WHERE (((Group_members.Groupname)= '" + groupname + "' ));",
new string[] { }, new object[] { }))
{
return(0);
}
// xxx delete members ?
// xx flipLeader
// delete username from group
//delete files
deleteQuery = "DELETE webmpx.group_files.* From Webmpx.group_files WHERE (((group_files.Groupname)= '" + groupname + "' ));";
DbUse.RunMySqlParams(deleteQuery, new string[] { }, new object[] { });
//delete group
deleteQuery = "DELETE webmpx.group_list.* FROM webmpx.group_list WHERE (((Group_list.Group_id)= @groupid ));";
DbUse.RunMySqlParams(deleteQuery, new string[] { "@groupid" }, new object[] { groupid });
try {
string message = String.Format("User {0} deleted group '{1}' successfully.\n", username, System.Web.HttpContext.Current.Request.UserHostAddress, DbUse.DomainPath);
MailInfo.SendMail(message, MailInfo.GROUP_DELETED);
} catch (Exception exp) {
logFiles.ErrorLog(exp);
}
return(val);
}
