public DataTable GetMenu(int ind)
{
PL_Login pl = new PL_Login();
pl.Ind = ind;
DataTable dt = new DataTable();
dt = objdllogin.GetMenu(pl);
return(dt);
}
public DataSet GetLockList(int Ind)
{
PL_Login pl = new PL_Login();
pl.Ind = Ind;
DataSet ds = new DataSet();
ds = objdllogin.GetLockList(pl);
return(ds);
}
public DataTable InsertUserLevel(int Ind, string ItemDesc)
{
PL_Login pl = new PL_Login();
pl.Ind = Ind;
pl.ItemDesc = ItemDesc;
DataTable dt = new DataTable();
dt = objdllogin.InsertUserLevel(pl);
return(dt);
}
public DataTable GetMenu(PL_Login objpllogin)
{
cmd = new SqlCommand("SPGetAllMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", objpllogin.Ind);
da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataSet GetLockList(PL_Login pl)
{
DataSet ds = new DataSet();
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", 9);
da = new SqlDataAdapter(cmd);
da.Fill(ds);
return(ds);
}
public DataTable DeleteProfileCreation(int ind, int UserTypeId)
{
PL_Login pl = new PL_Login();
pl.Ind = ind;
pl.UserTypeId = UserTypeId;
DataTable dt = new DataTable();
dt = objdllogin.DeleteProfileCreation(pl);
return(dt);
}
public DataTable UpdateUserLevel(int ind, string ItemDesc, int ItemID)
{
PL_Login pl = new PL_Login();
pl.Ind = ind;
pl.ItemDesc = ItemDesc;
pl.ItemID = ItemID;
DataTable dt = new DataTable();
dt = objdllogin.UpdateUserLevel(pl);
return(dt);
}
public DataTable InsertProfileCreation(int ind, int UserTypeId, int ItemID)
{
PL_Login pl = new PL_Login();
pl.Ind = ind;
pl.UserTypeId = UserTypeId;
pl.ItemID = ItemID;
DataTable dt = new DataTable();
dt = objdllogin.InsertProfileCreation(pl);
return(dt);
}
public DataTable GetusertypeID(int ind, int UserTypeId)
{
PL_Login pl = new PL_Login();
pl.Ind = ind;
pl.UserTypeId = UserTypeId;
DataTable dt = new DataTable();
dt = objdllogin.GetusertypeID(pl);
return(dt);
}
public DataTable GetLogoutPassword(PL_Login objpllogin)
{
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", 17);
cmd.Parameters.AddWithValue("@UserId", objpllogin.UserId);
da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable UpdateActiveStatus(PL_Login pl)
{
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@UserId", pl.UserId);
da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable UpdateLockUnlock(int Ind, int UserInd, int UserId, string Remark)
{
PL_Login pl = new PL_Login();
pl.Ind = Ind;
pl.UserInd = UserInd;
pl.UserId = UserId;
pl.Remark = Remark;
DataTable dt = new DataTable();
dt = objdllogin.UpdateLockUnlock(pl);
return(dt);
}
public DataSet GetUserLoginID(PL_Login pl)
{
DataSet ds = new DataSet();
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", 12);
cmd.Parameters.AddWithValue("@LoginId", pl.UserLoginId);
cmd.Parameters.AddWithValue("@MacAddress", pl.MacAddress);
da = new SqlDataAdapter(cmd);
da.Fill(ds);
return(ds);
}
public DataTable InsertUserLevel(PL_Login pl)
{
DataTable dt = new DataTable();
cmd = new SqlCommand("SPGetAllMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@ItemDesc", pl.ItemDesc);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return(dt);
}
public DataTable InsertProfileCreation(PL_Login objpllogin)
{
cmd = new SqlCommand("SPGetAllMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", objpllogin.Ind);
cmd.Parameters.AddWithValue("@ItemID", objpllogin.ItemID);
cmd.Parameters.AddWithValue("@UserTypeId", objpllogin.UserTypeId);
da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable FinalLogin(int Ind, string UserLoginId, string LoginPwd, string MacAddress)
{
PL_Login pl = new PL_Login();
pl.Ind = Ind;
pl.UserLoginId = UserLoginId;
pl.LoginPwd = LoginPwd;
pl.MacAddress = MacAddress;
DataTable dt = new DataTable();
dt = objdllogin.FinalLogin(pl);
return(dt);
}
public DataTable FinalLogin(PL_Login pl)
{
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@LoginId", pl.UserLoginId);
cmd.Parameters.AddWithValue("@LoginPwd", pl.LoginPwd);
cmd.Parameters.AddWithValue("@MacAddress", pl.MacAddress);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return(dt);
}
public DataTable UpdateLockUnlock(PL_Login pl)
{
DataTable dt = new DataTable();
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@UserInd", pl.UserInd);
cmd.Parameters.AddWithValue("@UserId", pl.UserId);
cmd.Parameters.AddWithValue("@Remark", pl.Remark);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return(dt);
}
public int CheckLockInd(PL_Login pl)
{
int i = 0;
try
{
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@LoginId", pl.UserLoginId);
con.Open();
i = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
}
catch (Exception ex) { msg = ex.Message; } return(i);
}
public DataTable GetLoginDetails(PL_Login pl)
{
try
{
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@LoginId", pl.UserLoginId);
cmd.Parameters.AddWithValue("@LoginPwd", pl.LoginPwd);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
}
catch (Exception ex)
{
msg = ex.Message;
}
return(dt);
}
public DataTable GetAllRegister(PL_Login pl, int Ind)
{
try
{
cmd = new SqlCommand("SPGetAllMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", Ind);
if (Ind == 6)
{
cmd.Parameters.AddWithValue("@ItmId", pl.ItemID);
}
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
}
catch (Exception ex)
{
msg = ex.Message;
}
return(dt);
}
