protected void AddNatureofBussiness(int nid)
{
try
{
LIBtblOrgNatureofBussiness objLIBtblOrgNatureofBussiness = new LIBtblOrgNatureofBussiness();
DALtblOrgNatureofBussiness objDALtblOrgNatureofBussiness = new DALtblOrgNatureofBussiness();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
objLIBtblOrgNatureofBussiness.id = -1;
objLIBtblOrgNatureofBussiness.orgid = Convert.ToInt32(Session["orgid"].ToString());
objLIBtblOrgNatureofBussiness.natureid = nid;
objLIBtblOrgNatureofBussiness.createdBy = User.Identity.Name;
objLIBtblOrgNatureofBussiness.dt = DateTime.Now.ToShortDateString();
tp.MessagePacket = objLIBtblOrgNatureofBussiness;
tp = objDALtblOrgNatureofBussiness.InserttblOrgNatureofBussiness(tp);
if (tp.MessageId > -1)
{
string[] strOutParamValues = (string[])tp.MessageResultset;
}
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
}
protected void insertRecord(decimal bm1_1, decimal bm1_2, decimal bm2_1, decimal bm2_2, decimal bm3_1, decimal bm3_2, string curr, int industryid)
{
try
{
LIBtblmstBenchmark objLIBtblmstBenchmark = new LIBtblmstBenchmark();
DALtblmstBenchmark objDALtblmstBenchmark = new DALtblmstBenchmark();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
objLIBtblmstBenchmark.id = -1;
objLIBtblmstBenchmark.industryid = industryid;
objLIBtblmstBenchmark.bm1_1 = bm1_1;
objLIBtblmstBenchmark.bm1_2 = bm1_2;
objLIBtblmstBenchmark.bm2_1 = bm2_1;
objLIBtblmstBenchmark.bm2_2 = bm2_2;
objLIBtblmstBenchmark.bm3_1 = bm3_1;
objLIBtblmstBenchmark.bm3_2 = bm3_2;
objLIBtblmstBenchmark.currency = curr;
objLIBtblmstBenchmark.metric = ddlRType.SelectedItem.Text;
tp.MessagePacket = objLIBtblmstBenchmark;
tp = objDALtblmstBenchmark.InserttblmstBenchmark(tp);
if (tp.MessageId > -1)
{
string[] strOutParamValues = (string[])tp.MessageResultset;
//MessageBox.Show(strOutParamValues[0].ToString());
}
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
}
protected void SendButton_Click(object sender, EventArgs e)
{
string intrest = "";
try
{
LIBtblmstContact objLIBtblmstContact = new LIBtblmstContact();
DALtblmstContact objDALtblmstContact = new DALtblmstContact();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
objLIBtblmstContact.id = -1;
objLIBtblmstContact.Name = txtname.Text;
objLIBtblmstContact.Email = txtEmail.Text;
objLIBtblmstContact.phone = txtPHONE.Text;
objLIBtblmstContact.designation = txtDESIGNATION.Text;
objLIBtblmstContact.OrgName = txtORGANIZATION.Text;
objLIBtblmstContact.dt = DateTime.Now.ToShortDateString();
if (rdoBasic.Checked == true)
{
objLIBtblmstContact.INTREST = rdoBasic.Text;
}
if (rdoPro.Checked == true)
{
objLIBtblmstContact.INTREST = rdoPro.Text;
}
tp.MessagePacket = objLIBtblmstContact;
tp = objDALtblmstContact.InserttblmstContact(tp);
intrest = objLIBtblmstContact.INTREST;
if (tp.MessageId > -1)
{
string[] strOutParamValues = (string[])tp.MessageResultset;
}
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
try
{
DALCommon cmn1 = new DALCommon();
string strBody1 = cmn1.prcFindInFile(Server.MapPath("sendmailadmin.html").ToString(), "#name#", txtname.Text);
strBody1 = cmn1.prcFindInString(strBody1, "#Designation#", txtDESIGNATION.Text);
strBody1 = cmn1.prcFindInString(strBody1, "#Email#", txtEmail.Text);
strBody1 = cmn1.prcFindInString(strBody1, "#Phone#", txtPHONE.Text);
strBody1 = cmn1.prcFindInString(strBody1, "#Organisation#", txtORGANIZATION.Text);
strBody1 = cmn1.prcFindInString(strBody1, "#Intrested#", intrest);
// strBody = "Hi " + txtname.Text + ", You or someone with your id signed up at this site, Your new account is almost ready, but before you can login you need to confirm your email id by visitng the link below: http://localhost:56941/EmailConfirmation.aspx?ID=" + userInfo.ProviderUserKey.ToString() + " Once you have visited the verification URL, your account will be activated. If you have any problems or questions, please reply to this email. Thanks!";
cmn1.SendHtmlFormattedEmail("*****@*****.**", "inQsights Op Contact Form submission", strBody1);
sendmailuser();
}
catch (HttpException ex)
{
}
}
protected void UpdateUserButton_Click(object sender, EventArgs e)
{
try
{
// Create new user.
clsESPSql.ExecNonQuery("update aspnet_Users set mobilealias='" + Mobile.Text + "' where username='******'");
try
{
LIBtblmstOrgUsers objLIBtblmstOrgUsers = new LIBtblmstOrgUsers();
DALtblmstOrgUsers objDALtblmstOrgUsers = new DALtblmstOrgUsers();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
objLIBtblmstOrgUsers.id = -1;
objLIBtblmstOrgUsers.Name = Name.Text;
objLIBtblmstOrgUsers.Email = Email.Text;
objLIBtblmstOrgUsers.Phone = Mobile.Text;
objLIBtblmstOrgUsers.orgid = Convert.ToInt32(Session["orgid"].ToString());
tp.MessagePacket = objLIBtblmstOrgUsers;
tp = objDALtblmstOrgUsers.InserttblmstOrgUsers(tp);
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
// Response.Redirect("user.aspx", false);
UserName.Text = "";
Email.Text = "";
Mobile.Text = "";
UserType.SelectedIndex = 0;
lblErrorMessage.Text = "user details updated successfully";
lblErrorMessage.ForeColor = System.Drawing.Color.Green;
UserType.Enabled = true;
CreateUserButton.Visible = true;
UpdateUser.Visible = false;
DataTable dt = clsESPSql.ExecQuery("SP_GetUserByRole 'DataEntry' ");
rptuserlist.DataSource = dt;
rptuserlist.DataBind();
ViewState["dt"] = dt;
}
catch (MembershipCreateUserException ex)
{
//lblErrorMessage.Text = GetErrorMessage(ex.StatusCode);
}
}
protected void SendButton_Click(object sender, EventArgs e)
{
try
{
LIBtblmstContact objLIBtblmstContact = new LIBtblmstContact();
DALtblmstContact objDALtblmstContact = new DALtblmstContact();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
objLIBtblmstContact.id = -1;
objLIBtblmstContact.Name = txtname.Text;
objLIBtblmstContact.Email = txtEmail.Text;
objLIBtblmstContact.phone = txtPHONE.Text;
objLIBtblmstContact.designation = txtDESIGNATION.Text;
objLIBtblmstContact.OrgName = txtORGANIZATION.Text;
objLIBtblmstContact.dt = DateTime.Now.ToShortDateString();
if (rdoBasic.Checked == true)
{
objLIBtblmstContact.INTREST = rdoBasic.Text;
}
if (rdoPro.Checked == true)
{
objLIBtblmstContact.INTREST = rdoPro.Text;
}
tp.MessagePacket = objLIBtblmstContact;
tp = objDALtblmstContact.InserttblmstContact(tp);
if (tp.MessageId > -1)
{
string[] strOutParamValues = (string[])tp.MessageResultset;
}
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
try
{
DALCommon cmn = new DALCommon();
string strBody = cmn.prcFindInFile(Server.MapPath("sendmail.html").ToString(), "#name#", txtname.Text);
//strBody = cmn.prcFindInString(strBody, "#VerificationUrl#", "http://localhost:56941/EmailConfirmation.aspx?ID=" + userInfo.ProviderUserKey.ToString());
// strBody = "Hi " + txtname.Text + ", You or someone with your id signed up at this site, Your new account is almost ready, but before you can login you need to confirm your email id by visitng the link below: http://localhost:56941/EmailConfirmation.aspx?ID=" + userInfo.ProviderUserKey.ToString() + " Once you have visited the verification URL, your account will be activated. If you have any problems or questions, please reply to this email. Thanks!";
cmn.SendHtmlFormattedEmail(txtEmail.Text, "Contact inQsights", strBody);
ClientScript.RegisterStartupScript(GetType(), "Save", "<SCRIPT LANGUAGE='javascript'>javascript:alert('Thank you for showing your intrest!');</script>");
}
catch (HttpException ex)
{
}
}
protected int AddOrgInfo(string fyear, decimal turnover, decimal headcount, decimal profit, decimal wagebill, decimal attrtion, string industry)
{
int ret = 0;
try
{
LIBtblmstOrgInfo objLIBtblmstOrgInfo = new LIBtblmstOrgInfo();
DALtblmstOrgInfo objDALtblmstOrgInfo = new DALtblmstOrgInfo();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
objLIBtblmstOrgInfo.id = -1;
objLIBtblmstOrgInfo.orgid = Convert.ToInt32(Session["orgid"].ToString());
objLIBtblmstOrgInfo.year = fyear;
objLIBtblmstOrgInfo.turnover = turnover;
objLIBtblmstOrgInfo.HeadCount = headcount;
objLIBtblmstOrgInfo.Profit = profit;
objLIBtblmstOrgInfo.WageBill = wagebill;
objLIBtblmstOrgInfo.Attrtion = attrtion;
objLIBtblmstOrgInfo.createdBy = User.Identity.Name;
objLIBtblmstOrgInfo.dt = DateTime.Now.ToShortDateString();
objLIBtblmstOrgInfo.Currency = ddlCurrency.SelectedItem.Text;
objLIBtblmstOrgInfo.Industry = industry;
tp.MessagePacket = objLIBtblmstOrgInfo;
tp = objDALtblmstOrgInfo.InserttblmstOrgInfo(tp);
Session["cur"] = ddlCurrency.SelectedItem.Text;
if (tp.MessageId > -1)
{
string[] strOutParamValues = (string[])tp.MessageResultset;
ret = 1;
}
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
return(ret);
}
protected void CreateUserButton_Click(object sender, EventArgs e)
{
try
{
// Create new user.
MembershipCreateStatus status;
MembershipUser newUser = Membership.CreateUser(Email.Text, Password.Text, Email.Text, null, null, false, out status);
try
{
//if (!Roles.IsUserInRole("Manager"))
//{
if (!Roles.RoleExists("Manager"))
{
Roles.CreateRole("Manager");
Roles.AddUserToRole(Email.Text, "Manager");
}
else
{
Roles.AddUserToRole(Email.Text, "Manager");
}
//}
// FormsAuthentication.SetAuthCookie(RegisterUser.UserName, false /* createPersistentCookie */);
clsESPSql.ExecNonQuery("update aspnet_Users set mobilealias='" + Mobile.Text + "' where username='******'");
try
{
LIBtblOrgBasicInfo objLIBtblOrgBasicInfo = new LIBtblOrgBasicInfo();
DALtblOrgBasicInfo objDALtblOrgBasicInfo = new DALtblOrgBasicInfo();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
objLIBtblOrgBasicInfo.id = -1;
objLIBtblOrgBasicInfo.username = Email.Text;
objLIBtblOrgBasicInfo.Name = Name.Text;
objLIBtblOrgBasicInfo.Email = Email.Text;
objLIBtblOrgBasicInfo.phone = Mobile.Text;
objLIBtblOrgBasicInfo.designation = Designation.Text;
objLIBtblOrgBasicInfo.OrgName = Orgnaisation.Text;
objLIBtblOrgBasicInfo.industry = Industry.Text;
objLIBtblOrgBasicInfo.dt = DateTime.Now.ToShortDateString();
tp.MessagePacket = objLIBtblOrgBasicInfo;
tp = objDALtblOrgBasicInfo.InserttblOrgBasicInfo(tp);
//if (tp.MessageId > -1)
//{
// string[] strOutParamValues = (string[])tp.MessageResultset;
// Response.Redirect("~/Manager/Default.aspx", false);
//}
MembershipUser userInfo = Membership.GetUser(Email.Text);
//Construct the verification URL
// string verifyUrl = Request.Url.GetLeftPart(UriPartial.Authority) + Page.ResolveUrl("~/Verify.aspx?ID=" + userInfo.ProviderUserKey.ToString());
DALCommon cmn = new DALCommon();
string strBody = cmn.prcFindInFile(Server.MapPath("mail.html").ToString(), "#UserName#", Name.Text);
strBody = cmn.prcFindInString(strBody, "#VerificationUrl#", "http://localhost:56941/EmailConfirmation.aspx?ID=" + userInfo.ProviderUserKey.ToString());
// strBody = "Hello " + Name.Text + "!. You or someone with your id signed up at this site, Your new account is almost ready, but before you can login you need to confirm your email id by visitng the link below: http://localhost:56941/EmailConfirmation.aspx?ID=" + userInfo.ProviderUserKey.ToString() + " Once you have visited the verification URL, your account will be activated. If you have any problems or questions, please reply to this email. Thanks!";
cmn.SendHtmlFormattedEmail(Email.Text, "Verification Code", strBody);
Response.Redirect("Verification.aspx", false);
//RegisterUser.LoginCreatedUser = false;
// lblmsg.Text = " An email has been sent to your account. Please view the email and confirm your account to complete the registration process.";
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
}
catch (Exception ex)
{
}
// If user created successfully, set password question and answer (if applicable) and
// redirect to login page. Otherwise return an error message.
//if (Membership.RequiresQuestionAndAnswer)
//{
// newUser.ChangePasswordQuestionAndAnswer(Password.Text,
// PasswordQuestionTextbox.Text,
// PasswordAnswerTextbox.Text);
//}
}
catch (MembershipCreateUserException ex)
{
lblErrorMessage.Text = GetErrorMessage(ex.StatusCode);
}
catch (HttpException ex)
{
lblErrorMessage.Text = ex.Message;
}
}
protected void lnkSaveGrade_Click(object sender, EventArgs e)
{
try
{
lblmsg1.Text = "";
lblsuccessmsg1.Text = "";
//txtSubType.Text = "";
string no = "";
int add = 0;
int upd = 0;
for (int i = 0; i < rptGrade.Items.Count; i++)
{
TextBox txtGrade = (TextBox)rptGrade.Items[i].FindControl("txt1");
Label lblno = (Label)rptGrade.Items[i].FindControl("lblno");
HiddenField hdnid = (HiddenField)rptGrade.Items[i].FindControl("hdnid");
if (txtGrade.Text != "")
{
LIBtblmstgrade objLIBtblmstgrade = new LIBtblmstgrade();
DALtblmstgrade objDALtblmstgrade = new DALtblmstgrade();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
if (hdnid.Value == "")
{
objLIBtblmstgrade.id = -1;
}
else
{
objLIBtblmstgrade.id = Convert.ToInt32(hdnid.Value);
}
objLIBtblmstgrade.Grade = txtGrade.Text.Trim().Length > 0 ? txtGrade.Text.Replace("'", "''") : "";
objLIBtblmstgrade.GLevel = Convert.ToInt32(lblno.Text.Trim());
objLIBtblmstgrade.orgid = Convert.ToInt32(Session["orgid"]);
tp.MessagePacket = objLIBtblmstgrade;
tp = objDALtblmstgrade.Inserttblmstgrade(tp);
string[] strOutParamValues = (string[])tp.MessageResultset;
if (strOutParamValues.Length > 0)
{
if (strOutParamValues[0].ToString() == "-3")
{
no = no + "," + lblno.Text.Trim();
lblmsg1.ForeColor = System.Drawing.Color.Red;
}
else if (strOutParamValues[0].ToString() == "-2")
{
lblmsg1.Text = lblmsg1.Text + "--" + txtGrade.Text.Trim() + ": Grade Already Exist.";
lblmsg1.ForeColor = System.Drawing.Color.Red;
}
else
{
if (hdnid.Value != "")
{
upd = upd + 1;
}
else
{
add = add + 1;
}
}
}
}
}
if (add > 0 || upd > 0)
{
lblsuccessmsg1.Text = " Grade mapping saved successfully";
}
//if (upd > 0)
//{
// lblsuccessmsg1.Text = lblsuccessmsg1.Text + "/" + upd.ToString() + " Grade Modified Successfully";
//}
bindGridGradedata();
//Response.Redirect(Request.Url.ToString(), false);
if (no != "")
{
lblmsg1.Text = no + " : Grade Position should be in sequence ";
}
string msg = lblsuccessmsg1.Text + lblmsg1.Text;
ClientScript.RegisterStartupScript(GetType(), "Save", "<SCRIPT LANGUAGE='javascript'>javascript:alert('" + msg + "');</script>");
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
}
protected void RegisterUser_CreatedUser(object sender, EventArgs e)
{
try
{
if (!Roles.IsUserInRole(RegisterUser.UserName, "Manager"))
{
if (!Roles.RoleExists("Manager"))
{
Roles.CreateRole("Manager");
Roles.AddUserToRole(RegisterUser.UserName, "Manager");
}
else
{
Roles.AddUserToRole(RegisterUser.UserName, "Manager");
}
}
FormsAuthentication.SetAuthCookie(RegisterUser.UserName, false /* createPersistentCookie */);
Label lblmsg = (Label)RegisterUserWizardStep.ContentTemplateContainer.FindControl("lblErrorMessage");
string Name = ((TextBox)RegisterUserWizardStep.ContentTemplateContainer.FindControl("Name")).Text;
string Designation = ((TextBox)RegisterUserWizardStep.ContentTemplateContainer.FindControl("Designation")).Text;
string Mobile = ((TextBox)RegisterUserWizardStep.ContentTemplateContainer.FindControl("Mobile")).Text;
string Industry = ((DropDownList)RegisterUserWizardStep.ContentTemplateContainer.FindControl("Industry")).Text;
string Orgnaisation = ((TextBox)RegisterUserWizardStep.ContentTemplateContainer.FindControl("Orgnaisation")).Text;
string pwd = ((TextBox)RegisterUserWizardStep.ContentTemplateContainer.FindControl("Password")).Text;
clsESPSql.ExecNonQuery("update aspnet_Users set pwd='" + pwd + "', mobilealias='" + Mobile + "' where username='******'");
try
{
LIBtblOrgBasicInfo objLIBtblOrgBasicInfo = new LIBtblOrgBasicInfo();
DALtblOrgBasicInfo objDALtblOrgBasicInfo = new DALtblOrgBasicInfo();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
objLIBtblOrgBasicInfo.id = -1;
objLIBtblOrgBasicInfo.username = RegisterUser.UserName;
objLIBtblOrgBasicInfo.Name = Name;
objLIBtblOrgBasicInfo.Email = RegisterUser.UserName;
objLIBtblOrgBasicInfo.phone = Mobile;
objLIBtblOrgBasicInfo.designation = Designation;
objLIBtblOrgBasicInfo.OrgName = Orgnaisation;
objLIBtblOrgBasicInfo.industry = Industry;
objLIBtblOrgBasicInfo.dt = DateTime.Now.ToShortDateString();
tp.MessagePacket = objLIBtblOrgBasicInfo;
tp = objDALtblOrgBasicInfo.InserttblOrgBasicInfo(tp);
//if (tp.MessageId > -1)
//{
// string[] strOutParamValues = (string[])tp.MessageResultset;
Response.Redirect("Verification.aspx", false);
//}
// Page.ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>javascript: document.getElementById('ahrfcreate').click();</script>");
RegisterUser.LoginCreatedUser = true;
// lblmsg.Text = " An email has been sent to your account. Please view the email and confirm your account to complete the registration process.";
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
}
catch (Exception ex)
{
}
}
protected void CreateUserButton_Click(object sender, EventArgs e)
{
try
{
// Create new user.
MembershipCreateStatus status;
string Password = GeneratePWD();
MembershipUser newUser = Membership.CreateUser(Email.Text, Password, Email.Text, null, null, true, out status);
//if (!Roles.IsUserInRole("Manager"))
//{
string role = "Manager";
if (!Roles.RoleExists(role))
{
Roles.CreateRole(role);
Roles.AddUserToRole(Email.Text, role);
}
else
{
//Roles.RemoveUserFromRole(Email.Text, role);
Roles.AddUserToRole(Email.Text, role);
}
clsESPSql.ExecNonQuery("update aspnet_Users set pwd='" + Password + "', mobilealias='" + Mobile.Text + "' where username='******'");
try
{
LIBtblOrgBasicInfo objLIBtblOrgBasicInfo = new LIBtblOrgBasicInfo();
DALtblOrgBasicInfo objDALtblOrgBasicInfo = new DALtblOrgBasicInfo();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
objLIBtblOrgBasicInfo.id = -1;
objLIBtblOrgBasicInfo.username = Email.Text;
objLIBtblOrgBasicInfo.Name = Name.Text;
objLIBtblOrgBasicInfo.Email = Email.Text;
objLIBtblOrgBasicInfo.phone = Mobile.Text;
objLIBtblOrgBasicInfo.designation = Designation.Text;
objLIBtblOrgBasicInfo.OrgName = Orgnaisation.Text;
objLIBtblOrgBasicInfo.industry = Industry.SelectedItem.Text;
objLIBtblOrgBasicInfo.Orglevel = ddlLevel.SelectedValue;
objLIBtblOrgBasicInfo.dt = DateTime.Now.ToShortDateString();
tp.MessagePacket = objLIBtblOrgBasicInfo;
tp = objDALtblOrgBasicInfo.InserttblOrgBasicInfo(tp);
DataTable dt = clsESPSql.ExecQuery("SP_GetManager ");
rptuserlist.DataSource = dt;
rptuserlist.DataBind();
ViewState["dt"] = dt;
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
DALCommon cmn = new DALCommon();
string strBody = cmn.prcFindInFile(Server.MapPath("mail.html").ToString(), "#UserName#", Email.Text);
strBody = cmn.prcFindInString(strBody, "#Password#", Password);
cmn.SendHtmlFormattedEmail(Email.Text, "User Created", strBody);
// Response.Redirect("user.aspx", false);
UserName.Text = "";
Email.Text = "";
Mobile.Text = "";
Designation.Text = "";
Orgnaisation.Text = "";
Industry.SelectedIndex = 0;
ddlLevel.SelectedIndex = 0;
lblErrorMessage.Text = "User Created successfully";
lblErrorMessage.ForeColor = System.Drawing.Color.Green;
}
catch (MembershipCreateUserException ex)
{
lblErrorMessage.Text = GetErrorMessage(ex.StatusCode);
}
}
protected void UpdateUserButton_Click(object sender, EventArgs e)
{
try
{
// Create new user.
clsESPSql.ExecNonQuery("update aspnet_Users set mobilealias='" + Mobile.Text + "' where username='******'");
try
{
LIBtblOrgBasicInfo objLIBtblOrgBasicInfo = new LIBtblOrgBasicInfo();
DALtblOrgBasicInfo objDALtblOrgBasicInfo = new DALtblOrgBasicInfo();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
objLIBtblOrgBasicInfo.id = -1;
objLIBtblOrgBasicInfo.username = Email.Text;
objLIBtblOrgBasicInfo.Name = Name.Text;
objLIBtblOrgBasicInfo.Email = Email.Text;
objLIBtblOrgBasicInfo.phone = Mobile.Text;
objLIBtblOrgBasicInfo.designation = Designation.Text;
objLIBtblOrgBasicInfo.OrgName = Orgnaisation.Text;
objLIBtblOrgBasicInfo.industry = Industry.SelectedItem.Text;
objLIBtblOrgBasicInfo.dt = DateTime.Now.ToShortDateString();
objLIBtblOrgBasicInfo.Orglevel = ddlLevel.SelectedValue;
tp.MessagePacket = objLIBtblOrgBasicInfo;
tp = objDALtblOrgBasicInfo.InserttblOrgBasicInfo(tp);
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
// Response.Redirect("user.aspx", false);
UserName.Text = "";
Email.Text = "";
Mobile.Text = "";
Designation.Text = "";
Orgnaisation.Text = "";
Industry.SelectedIndex = 0;
lblErrorMessage.Text = "user details updated successfully";
lblErrorMessage.ForeColor = System.Drawing.Color.Green;
CreateUserButton.Visible = true;
UpdateUser.Visible = false;
DataTable dt = clsESPSql.ExecQuery("SP_GetManager ");
rptuserlist.DataSource = dt;
rptuserlist.DataBind();
ViewState["dt"] = dt;
}
catch (MembershipCreateUserException ex)
{
//lblErrorMessage.Text = GetErrorMessage(ex.StatusCode);
}
}
protected void CreateUserButton_Click(object sender, EventArgs e)
{
try
{
// Create new user.
MembershipCreateStatus status;
Password.Text = GeneratePWD();
MembershipUser newUser = Membership.CreateUser(Email.Text, Password.Text, Email.Text, null, null, true, out status);
//if (!Roles.IsUserInRole("Manager"))
//{
string role = UserType.SelectedValue;
if (!Roles.RoleExists(role))
{
Roles.CreateRole(role);
Roles.AddUserToRole(Email.Text, role);
}
else
{
//Roles.RemoveUserFromRole(Email.Text, role);
Roles.AddUserToRole(Email.Text, role);
}
clsESPSql.ExecNonQuery("update aspnet_Users set pwd='" + Password.Text + "', mobilealias='" + Mobile.Text + "' where username='******'");
try
{
LIBtblmstOrgUsers objLIBtblmstOrgUsers = new LIBtblmstOrgUsers();
DALtblmstOrgUsers objDALtblmstOrgUsers = new DALtblmstOrgUsers();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
objLIBtblmstOrgUsers.id = -1;
objLIBtblmstOrgUsers.Name = Name.Text;
objLIBtblmstOrgUsers.Email = Email.Text;
objLIBtblmstOrgUsers.Phone = Mobile.Text;
objLIBtblmstOrgUsers.orgid = Convert.ToInt32(Session["orgid"].ToString());
tp.MessagePacket = objLIBtblmstOrgUsers;
tp = objDALtblmstOrgUsers.InserttblmstOrgUsers(tp);
DataTable dt = clsESPSql.ExecQuery("SP_GetUserByRole 'DataEntry', " + Session["orgid"].ToString());
rptuserlist.DataSource = dt;
rptuserlist.DataBind();
ViewState["dt"] = dt;
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
DALCommon cmn = new DALCommon();
string strBody = cmn.prcFindInFile(Server.MapPath("mail.html").ToString(), "#UserName#", Email.Text);
strBody = cmn.prcFindInString(strBody, "#Password#", Password.Text);
cmn.SendHtmlFormattedEmail(Email.Text, "Account Created", strBody);
// Response.Redirect("user.aspx", false);
UserName.Text = "";
Email.Text = "";
Mobile.Text = "";
UserType.SelectedIndex = 0;
lblErrorMessage.Text = "User Created successfully";
lblErrorMessage.ForeColor = System.Drawing.Color.Green;
}
catch (MembershipCreateUserException ex)
{
lblErrorMessage.Text = GetErrorMessage(ex.StatusCode);
}
}
