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; } }