protected void Page_Load(object sender, EventArgs e)
{
whitfielduser wUser = new whitfielduser();
DataSet dsUser = wUser.GetUserRecord("admin");
DataTable myControls;
myControls = dsUser.Tables[0];
if (myControls.Rows.Count > 0)
{
try
{
foreach (DataRow dRow in myControls.Rows)
{
Response.Write(dRow["FirstName"].ToString() + " " + dRow["LastName"].ToString());
Response.Write(dRow["LoginId"].ToString().Trim());
Response.Write(dRow["EmployeeNo"].ToString().Trim());
Response.Write( dRow["RoleId"].ToString().Trim());
}
}
catch (Exception ex)
{
HttpResponse objResponse = HttpContext.Current.Response;
objResponse.Write(ex.Message);
}
}
}
public void LoginUser()
{
//[FirstName] [varchar](50) NOT NULL,
//[LastName] [varchar](50) NOT NULL,
//[Address] [varchar](250) NOT NULL,
//[City] [varchar](50) NOT NULL,
//[State] [varchar](50) NOT NULL,
//[Zip] [varchar](50) NOT NULL,
//[ContactNo1] [varchar](50) NOT NULL,
//[ContactNo2] [varchar](50) NOT NULL,
//[LoginId] [varchar](50) NOT NULL,
//[Password] [varchar](50) NOT NULL,
//[CreatedBy] [int] NULL,
//[CreatedOn] [datetime] NULL,
//[ModifiedBy] [int] NULL,
//[ModifiedOn] [timestamp] NULL,
//[EmployeeNo] [varchar](50) NOT NULL,
//[IsActive] [bit] NOT NULL
whitfielduser wUser = new whitfielduser();
if (wUser.IsUserExists(tbUserID.Text.Trim(),tbpassword.Text.Trim()))
{
DataSet dsUser = wUser.GetUserRecord(tbUserID.Text.Trim());
DataTable myControls;
myControls = dsUser.Tables[0];
if (myControls.Rows.Count > 0)
{
try
{
foreach (DataRow dRow in myControls.Rows)
{
Response.Cookies["useridentifier"].Value = dRow["Userid"].ToString().Trim();
Response.Cookies["Name"].Value = dRow["FirstName"].ToString() +" " + dRow["LastName"].ToString();
Response.Cookies["UserId"].Value = dRow["LoginId"].ToString().Trim();
Response.Cookies["EmployeeNo"].Value = dRow["EmployeeNo"].ToString().Trim();
Response.Cookies["RoleId"].Value = dRow["RoleId"].ToString().Trim();
if (dRow["RoleId"].ToString().Trim() == "5")
Response.Redirect("installer_projects.aspx");
else
Response.Redirect("whitfieldmain.aspx");
}
}
catch (Exception ex)
{
HttpResponse objResponse = HttpContext.Current.Response;
objResponse.Write(ex.Message);
}
}
}
else{
lblMsg.Text = "Check your Userid and password";
}
}
protected void Page_Load(object sender, EventArgs e)
{
whitfielduser _wuser = new whitfielduser();
if (!Page.IsPostBack)
{
Bindroles();
Bindstates();
BindEmplyeeType();
if (Request.QueryString["hFlag"] == "E")
{
DataSet dsUser = _wuser.GetUserRecord(Request.QueryString["hUserid"]);
DataTable dtUsr = dsUser.Tables[0];
foreach (DataRow dRow in dtUsr.Rows)
{
txtfn.Text = dRow["FirstName"].ToString();
txtln.Text = dRow["LastName"].ToString();
txtem.Text = dRow["email_address"].ToString();
txtEmpNo.Text = dRow["EmployeeNo"].ToString();
txtaddress.Text = dRow["Address"].ToString();
txtphno.Text = dRow["ContactNo1"].ToString();
BindCitiesforState(dRow["state"].ToString());
ddlstate.SelectedIndex = ddlstate.Items.IndexOf(ddlstate.Items.FindByValue(dRow["state"].ToString()));
ddlcity.SelectedIndex = ddlcity.Items.IndexOf(ddlcity.Items.FindByValue(dRow["city"].ToString()));
txtzip.Text = dRow["zip"].ToString();
txtuserid.Text = dRow["Loginid"].ToString();
txtpasswd.Text = dRow["password"].ToString();
ddlrole.SelectedIndex = ddlrole.Items.IndexOf(ddlrole.Items.FindByValue(dRow["roleid"].ToString()));
ddlEmplyType.SelectedIndex = ddlEmplyType.Items.IndexOf(ddlEmplyType.Items.FindByValue(dRow["empl_type_id"].ToString()));
txtrate.Text = dRow["hourly_rate"].ToString();
}
}
else
{
txtuserid.ReadOnly = false;
}
}
}