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