public DataTable DL_InsertLoginHistory(ML_User_Access objML_Default)
{
SqlParameter[] par = { new SqlParameter("@UserId", objML_Default.UserName),
new SqlParameter("@Ip", objML_Default.IP),
new SqlParameter("@loginTime", objML_Default.LoginDate),
new SqlParameter("@Name", objML_Default.UserName) };
return(SqlHelper.ExecuteDataset(con, "OSP_LoginHistory_Insert", par).Tables[0]);
}
public int DL_ChangePassword(ML_User_Access objML_Default)
{
SqlParameter[] par = { new SqlParameter("@UserName", objML_Default.UserName),
new SqlParameter("@OldPassowrd", objML_Default.OldPassword),
new SqlParameter("@password", objML_Default.Passsword),
new SqlParameter("@ConformPwd", objML_Default.ConformPasword),
new SqlParameter("@ModifyBy", objML_Default.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "SPCN_Change_Password", par));
}
public int DL_InsUpdUserDetail(ML_User_Access objML_Default)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Default.ID),
new SqlParameter("@UserName", objML_Default.UserName),
new SqlParameter("@LastName", objML_Default.LastName),
new SqlParameter("@EmailID", objML_Default.EmailID),
new SqlParameter("@MobileNo", objML_Default.MobileNo),
new SqlParameter("@Address", objML_Default.Address),
new SqlParameter("@Activation", objML_Default.Activation),
new SqlParameter("@country", objML_Default.country),
new SqlParameter("@State", objML_Default.State),
new SqlParameter("@City", objML_Default.City),
new SqlParameter("@password", objML_Default.Passsword),
new SqlParameter("@ConformPwd", objML_Default.ConformPasword),
new SqlParameter("@CreatedBy", objML_Default.CreatedBy),
new SqlParameter("@ModifyBy", objML_Default.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "OSP_InsUpdUserDetail", par));
}
private bool GetScreenAccess(string strPage)
{
bool blAccess = false;
BL_User_Access objBL_UserAccess = new BL_User_Access();
ML_User_Access objML_UserAccess = new ML_User_Access();
objML_UserAccess.ID = Convert.ToString(HttpContext.Current.Session["UserName"]);
objML_UserAccess.ModulesName = strPage;
DataTable dt = objBL_UserAccess.BL_ModulePermision(objML_UserAccess);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
blAccess = true;
}
else
{
blAccess = false;
}
}
return(blAccess);
}
public DataTable BL_ModulePermision(ML_User_Access objML_Default)
{
return(objDL_UserAccess.DL_ModulePermisson(objML_Default));
}
public int BL_ChangePassword(ML_User_Access objML_Default)
{
return(objDL_UserAccess.DL_ChangePassword(objML_Default));
}
public DataTable BL_UserDetailNameWise(ML_User_Access objML_Default)
{
return(objDL_UserAccess.DL_UserDetailNamewise(objML_Default));
}
public DataTable BL_InsertLoginHistory(ML_User_Access objML_Default)
{
return(objDL_UserAccess.DL_InsertLoginHistory(objML_Default));
}
public DataTable BL_LoginUser(ML_User_Access objML_Default)
{
return(objDL_UserAccess.DL_LoginUser(objML_Default));
}
public DataTable DL_LoginUser(ML_User_Access objML_Default)
{
SqlParameter[] par = { new SqlParameter("@UserName", objML_Default.UserName),
new SqlParameter("@Password", objML_Default.Passsword) };
return(SqlHelper.ExecuteDataset(con, "OSP_CheckLogin_Detail", par).Tables[0]);
}
public DataTable BL_EditUserDetail(ML_User_Access objML_Default)
{
return(objDL_UserAccess.DL_EditUserDetail(objML_Default));
}
public int DL_DeleteUserDetail(ML_User_Access objML_Default)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Default.ID), };
return(SqlHelper.ExecuteNonQuery(con, "SPCN_User_MasterAccess_Delete", par));
}
public DataTable DL_BindUser(ML_User_Access objML_UserAccess)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_UserAccess.ID) };
return(SqlHelper.ExecuteDataset(con, "SPCN_User_MasterAccess_Bind", par).Tables[0]);
}
public DataTable DL_ModulePermisson(ML_User_Access objML_Default)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Default.ID),
new SqlParameter("@ModulesName", objML_Default.ModulesName), };
return(SqlHelper.ExecuteDataset(con, "SPCN_Modules_Permissions_Select", par).Tables[0]);
}
public DataTable DL_UserDetailNamewise(ML_User_Access objML_Default)
{
SqlParameter[] par = { new SqlParameter("@UserName", objML_Default.UserName) };
return(SqlHelper.ExecuteDataset(con, "OSP_UserDetailNameWise", par).Tables[0]);
}
public DataTable BL_BindUser(ML_User_Access objML_UserAccess)
{
return(objDL_UserAccess.DL_BindUser(objML_UserAccess));
}
public int BL_DeleteUserDetail(ML_User_Access objML_Default)
{
return(objDL_UserAccess.DL_DeleteUserDetail(objML_Default));
}
public DataTable DL_EditUserDetail(ML_User_Access objML_Default)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Default.ID) };
return(SqlHelper.ExecuteDataset(con, "SPCN_User_MasterAccess_Select", par).Tables[0]);
}
public DataTable BL_FindLoginDetail(ML_User_Access objML_Default)
{
return(objDL_UserAccess.DL_FindLoginDetail(objML_Default));
}
public DataTable DL_FindLoginDetail(ML_User_Access objML_Default)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Default.UserName), };
return(SqlHelper.ExecuteDataset(con, "SPCN_User_Login_Forget", par).Tables[0]);
}
