public string UserBlock(users_Prop userprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_Users_Block", new object[] { userprop.UserName }).Tables[0].Rows[0][0].ToString());
}
catch (Exception e)
{
throw e;
}
}
public string UserUpdatePassword(users_Prop userprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_Users_UpdatePassword", new object[] { userprop.UserName, userprop.Password }).Tables[0].Rows[0][0].ToString());
}
catch (Exception e)
{
throw e;
}
}
public DataTable UserSelect(users_Prop userprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_Users_Select", new object[] { userprop.UserName }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public string Logout(users_Prop userprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_GetLoginLogout", new object[] { userprop.UserName, "OUT" }).Tables[0].Rows[0][0].ToString());
}
catch (Exception e)
{
throw e;
}
}
public string UserUpdatePassword(users_Prop userprop)
{
try
{
userdal = new users_dal();
string strMsg = userdal.UserUpdatePassword(userprop);
return(strMsg);
}
catch (Exception e)
{
ErrMessage = e.Message;
return("");
}
}
public DataTable UserSelect(users_Prop userprop)
{
try
{
userdal = new users_dal();
DataTable dt = userdal.UserSelect(userprop);
return(dt);
}
catch (Exception e)
{
ErrMessage = e.Message;
return(null);
}
}
public string UserCheckLogin(users_Prop userprop)
{
try
{
userdal = new users_dal();
string strMsg = userdal.UsersCheckLogin(userprop);
return(strMsg);
}
catch (Exception e)
{
ErrMessage = e.Message;
return("");
}
}
public string LogOut(users_Prop userprop)
{
try
{
userdal = new users_dal();
string strMsg = userdal.Logout(userprop);
return(strMsg);
}
catch (Exception e)
{
ErrMessage = e.Message;
return("");
}
}
public string UsersUpdate(users_Prop userprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_Users_update", new object[] {
userprop.UserName
, userprop.FirstName
, userprop.LastName
, userprop.CounterID
, userprop.GroupID
}).Tables[0].Rows[0][0].ToString());
}
catch (Exception e)
{
throw e;
}
}
public string UsersCheckLogin(users_Prop userprop)
{
try
{
DataSet ds = SqlHelper.ExecuteDataset(com.con, "usp_Users_checklogin", new object[] { userprop.UserName, userprop.Password, userprop.IPAddress });
if (ds.Tables.Count > 1)
{
return(ds.Tables[1].Rows[0][0].ToString());
}
else
{
return(ds.Tables[0].Rows[0][0].ToString());
}
}
catch (Exception e)
{
throw e;
}
}
public string UsersInsert(users_Prop userprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_Users_Insert", new object[] {
userprop.UserName
, userprop.Password
, userprop.FirstName
, userprop.LastName
, userprop.CounterID
, userprop.GroupID
, userprop.SubdivisionCode
, userprop.AccountNo
, userprop.PhoneNo
, userprop.EmailID
, userprop.IPAddress
}).Tables[0].Rows[0][0].ToString());
}
catch (Exception e)
{
throw e;
}
}