protected void Page_Load(object sender, EventArgs e)
{
clsCookies.CookieCheckSession();
var user = new clsUser();
clsCookies.CookieGetSession(user);
lbAdminName.Text = user.UserName;
}
public static void CookieCreateSession(clsUser AdminUser)
{
string strValue = HttpContext.Current.Session.SessionID.ToString() + "#" + AdminUser.UserId.ToString() +
"#" + AdminUser.TypeId.ToString() + "#" + AdminUser.UserName.ToString();
HttpCookie LoginCookies = new HttpCookie("LoginCookies");
LoginCookies.Value = strValue;
LoginCookies.Expires = DateTime.Now.AddHours(2);
HttpContext.Current.Response.Cookies.Add(LoginCookies);
}
protected void lkbSubmit_OnClick(object sender, EventArgs e)
{
try
{
var objUser = new clsUser();
if (!string.IsNullOrEmpty(Convert.ToString(Request.QueryString["Id"])))
objUser.UserId = TypeConversionUtility.ToInteger(Request.QueryString["Id"]);
else
objUser.UserId = 0;
objUser.UserName = TypeConversionUtility.ToStringWithNull(txtName.Text.Trim());
objUser.EmailId = TypeConversionUtility.ToStringWithNull(txtEmailId.Text.Trim());
objUser.LoginId = TypeConversionUtility.ToStringWithNull(txtLoginId.Text.Trim());
objUser.LoginPwd = TypeConversionUtility.ToStringWithNull(txtPwd.Text.Trim());
objUser.Status = TypeConversionUtility.ToInteger(ddlStatus.SelectedValue);
objUser.TypeId = Convert.ToInt32(ddUserLevel.SelectedValue);
if (UserRepository.CheckUserExits(objUser.UserId, objUser.LoginId))
{
lblMsg.Text = "Login Id already exist. Try using different login id.";
pnlMsg.Visible = true;
}
else if (UserRepository.UserAddUpdate(objUser)) // Add/Update Login Details
{
if (objUser.UserId == 0)
{
pnlMsg.Visible = true;
lblMsg.Text = "Record has been successfully inserted.";
lblMsg.CssClass = "success";
txtName.Text = "";
txtEmailId.Text = "";
txtPwd.Text = "";
txtLoginId.Text = "";
ddlStatus.SelectedValue = "0";
}
else
Response.Redirect("userList.aspx?msg=Record has been successfully updated.");
}
}
catch (Exception ex)
{
lblMsg.Text = string.Format("<p class=\"error\">{0}</p>", ex);
pnlMsg.Visible = true;
}
}
public static void CookieGetSession(clsUser AdminUser)
{
if (HttpContext.Current.Request.Cookies["LoginCookies"] != null)
{
string strValue = HttpContext.Current.Request.Cookies["LoginCookies"].Value;
string[] sValue = strValue.Split('#');
if (sValue.Length > 3)
{
AdminUser.UserId = Convert.ToInt32(sValue[1]);
AdminUser.TypeId = Convert.ToInt32(sValue[2]);
AdminUser.UserName = sValue[3].ToString();
}
else
HttpContext.Current.Response.Redirect("logout.aspx");
}
else
HttpContext.Current.Response.Redirect("logout.aspx");
}
/// <summary>
/// Add/Update User Details
/// </summary>
/// <param name="objUser"></param>
/// <returns></returns>
public bool UserAddUpdate(clsUser objUser)
{
bool flag = false;
SqlParameter[] sqlParameters =
{
new SqlParameter("@QueryType", 4),
new SqlParameter("@UserId", objUser.UserId),
new SqlParameter("@UserName", objUser.UserName),
new SqlParameter("@EmailId", objUser.EmailId),
new SqlParameter("@LoginId", objUser.LoginId),
new SqlParameter("@LoginPwd", objUser.LoginPwd),
new SqlParameter("@Status", objUser.Status),
new SqlParameter("@TypeId", objUser.TypeId)
};
int iRow = objSql.ExecuteSP_NonQuery(spName, sqlParameters);
if (iRow > 0)
flag = true;
return flag;
}
/// <summary>
/// Get and Set Login Validate
/// </summary>
/// <returns></returns>
public clsUser UserLoginValidate(string loginId, string loginPwd)
{
var objuser = new clsUser();
SqlParameter[] sqlParameters =
{
new SqlParameter("@LoginId", loginId),
new SqlParameter("@LoginPwd", loginPwd),
new SqlParameter("@QueryType", 1)
};
using (SqlDataReader dr = objSql.SP_GetDataReader(spName, sqlParameters))
{
if (dr.HasRows)
{
if (dr.Read())
{
objuser.UserId = Convert.ToInt32(dr["UserId"]);
objuser.UserName = Convert.ToString(dr["UserName"]);
objuser.EmailId = Convert.ToString(dr["EmailId"]);
objuser.LoginId = Convert.ToString(dr["LoginId"]);
objuser.Status = Convert.ToInt32(dr["Status"]);
objuser.TypeId = Convert.ToInt32(dr["TypeId"]);
}
}
dr.Close();
}
objSql.CloseConnection();
objSql.DisposeConnection();
return objuser;
}
/// <summary>
/// Get User List With Paged
/// </summary>
/// <returns></returns>
public List<clsUser> UserListPaged(bool? status, int startPage, int pageLength, out int noOfPages,
out int totalRecords)
{
var lstUser = new List<clsUser>();
SqlParameter[] sqlParameters =
{
new SqlParameter("@Status", status),
new SqlParameter("@StartPage", startPage),
new SqlParameter("@PageLength", pageLength),
new SqlParameter("@noOfPages", noOfPages = 0) {Direction = ParameterDirection.Output},
new SqlParameter("@TotalRecords", totalRecords = 0) {Direction = ParameterDirection.Output},
};
using (SqlDataReader dr = objSql.SP_GetDataReader("usp_GetUsersPaged", sqlParameters))
{
if (dr.HasRows)
{
while (dr.Read())
{
var objUser = new clsUser();
objUser.UserId = Convert.ToInt32(dr["UserId"]);
objUser.UserName = Convert.ToString(dr["UserName"]);
objUser.EmailId = Convert.ToString(dr["EmailId"]);
objUser.LoginId = Convert.ToString(dr["LoginId"]);
objUser.LoginPwd = Convert.ToString(dr["LoginPwd"]);
objUser.Status = Convert.ToInt32(dr["Status"]);
objUser.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]);
objUser.TypeId = Convert.ToInt32(dr["TypeId"]);
lstUser.Add(objUser);
}
}
dr.Close();
}
objSql.CloseConnection();
objSql.DisposeConnection();
noOfPages = Convert.ToInt32(sqlParameters[3].Value);
totalRecords = Convert.ToInt32(sqlParameters[4].Value);
return lstUser;
}
/// <summary>
/// Get User List
/// </summary>
/// <returns></returns>
public List<clsUser> UserList()
{
var lstUser = new List<clsUser>();
SqlParameter[] sqlParameters =
{
new SqlParameter("@QueryType", 6)
};
using (SqlDataReader dr = objSql.SP_GetDataReader(spName, sqlParameters))
{
if (dr.HasRows)
{
while (dr.Read())
{
var objUser = new clsUser();
objUser.UserId = Convert.ToInt32(dr["UserId"]);
objUser.UserName = Convert.ToString(dr["UserName"]);
objUser.EmailId = Convert.ToString(dr["EmailId"]);
objUser.LoginId = Convert.ToString(dr["LoginId"]);
objUser.LoginPwd = Convert.ToString(dr["LoginPwd"]);
objUser.Status = Convert.ToInt32(dr["Status"]);
objUser.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]);
objUser.TypeId = Convert.ToInt32(dr["TypeId"]);
lstUser.Add(objUser);
}
}
dr.Close();
}
objSql.CloseConnection();
objSql.DisposeConnection();
return lstUser;
}
/// <summary>
/// Get User Details By User Id
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public clsUser UserDetails(int userId)
{
var objUser = new clsUser();
SqlParameter[] selectParam =
{
new SqlParameter("@UserId", userId),
new SqlParameter("@QueryType", 3)
};
using (SqlDataReader dr = objSql.SP_GetDataReader(spName, selectParam))
{
if (dr.HasRows)
{
if (dr.Read())
{
objUser.UserId = Convert.ToInt32(dr["UserId"]);
objUser.UserName = Convert.ToString(dr["UserName"]);
objUser.EmailId = Convert.ToString(dr["EmailId"]);
objUser.LoginId = Convert.ToString(dr["LoginId"]);
objUser.LoginPwd = Convert.ToString(dr["LoginPwd"]);
objUser.Status = Convert.ToInt32(dr["Status"]);
objUser.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]);
objUser.TypeId = Convert.ToInt32(dr["TypeId"]);
}
}
dr.Close();
}
objSql.CloseConnection();
objSql.DisposeConnection();
return objUser;
}
public static bool UserAddUpdate(clsUser userInfo)
{
var objUser = new sqlUser();
return objUser.UserAddUpdate(userInfo);
}
