public void CheckValidUser(string sJsonInput)
{
string sResult = string.Empty;
result objResult = new result();
int iValid = 0;
try
{
string sUserName = string.Empty;
string sPassword = string.Empty;
sFuncName = "CheckValidUser";
oLog.WriteToDebugLogFile("Validate Login Function", sFuncName);
sJsonInput = "[" + sJsonInput + "]";
oLog.WriteToDebugLogFile("Getting the Json Input 1 from web '" + sJsonInput + "'", sFuncName);
DataTable dtInput = JsonStringToDataTable(sJsonInput);
if (dtInput != null && dtInput.Rows.Count > 0)
{
sUserName = dtInput.Rows[0]["sUserName"].ToString();
sPassword = dtInput.Rows[0]["sPassword"].ToString();
}
sSQL = string.Format("call \"AE_SP002_VALIDUSER\"('" + sUserName + "','" + sPassword + "')");
oLog.WriteToDebugLogFile("Execute SQL" + sSQL, sFuncName);
OdbcParameter[] Param = new OdbcParameter[0];
iValid = oCommon.ExecuteNonQuery_DR(sSQL, Param);
if (iValid == 1)
{
objResult.Result = "SUCCESS";
objResult.DisplayMessage = "Login successfully";
}
else if (iValid == 2)
{
objResult.Result = "FAILURE";
objResult.DisplayMessage = "Incorrect UserName";
}
else if (iValid == 3)
{
objResult.Result = "FAILURE";
objResult.DisplayMessage = "Incorrect Password";
}
else
{
objResult.Result = "FAILURE";
objResult.DisplayMessage = "Incorrect UserName/Password";
}
oLog.WriteToDebugLogFile("Ending Function", sFuncName);
oLog.WriteToDebugLogFile("Completed With SUCCESS ", sFuncName);
lstResult.Add(objResult);
Context.Response.Output.Write(js.Serialize(lstResult));
}
catch (Exception ex)
{
sErrDesc = ex.Message.ToString();
oLog.WriteToErrorLogFile(sErrDesc, sFuncName);
oLog.WriteToDebugLogFile("Completed With ERROR ", sFuncName);
objResult.Result = "Error";
objResult.DisplayMessage = sErrDesc;
lstResult.Add(objResult);
Context.Response.Output.Write(js.Serialize(lstResult));
}
}
