public bool isLoginInfoCorrct(string usrname, string pswd) { string sqlStr = "SELECT user_id FROM sec.sec_users WHERE ((lower(user_name) = '" + usrname.Replace("'", "''").ToLower() + "') AND (usr_password = md5('" + cmnCde.encrypt(pswd, CommonCodes.AppKey).Replace("'", "''") + "')) AND (now() between to_timestamp(valid_start_date|| ' 00:00:00','YYYY-MM-DD HH24:MI:SS') " + "AND to_timestamp(valid_end_date || ' 23:59:59','YYYY-MM-DD HH24:MI:SS')))"; DataSet dtSt = new DataSet(); dtSt = cmnCde.selectDataNoParams1(sqlStr); if (dtSt.Tables[0].Rows.Count > 0) { return(true); } else { return(false); } }