public DataTable gcm() { LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer(); DataTable dt = new DataTable(); dt = DAL.selectdata("gcm", null); return(dt); }
public DataTable deleteu(string ID) { LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50); param[0].Value = ID; DataTable dt = new DataTable(); dt = DAL.selectdata("deleteu", param); return(dt); }
public DataTable searchu(string habd) { LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@habd", SqlDbType.NVarChar, 50); param[0].Value = habd; DataTable dt = new DataTable(); dt = DAL.selectdata("searchu", param); return(dt); }
public DataTable Searchp(string s) { LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@s", SqlDbType.NVarChar, 4000); param[0].Value = s; dt = DAL.selectdata("serachinallcolumns", param); return(dt); }
public DataTable Login(string uname, String PWD) { LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter(@"uname", SqlDbType.NVarChar, 50); param[0].Value = uname; param[1] = new SqlParameter(@"PWD", SqlDbType.NVarChar, 50); param[1].Value = PWD; DataTable dt = new DataTable(); dt = DAL.selectdata("confirmlog", param); return(dt); }