public bool FormsVerification(string LoginName, string CompanyCode, string ApplicationCode, ref DataTable dt)
{
try
{
List <FormVerification> lst = new List <FormVerification>();
//var Serializer = new JavaScriptSerializer();
SqlParameter[] sqlParam =
{
new SqlParameter("@LoginName", LoginName),
new SqlParameter("@CompCode", CompanyCode),
new SqlParameter("@ApplicationCode", ApplicationCode)
};
dt = DataAccess.getDataTable("SP_FormsVerification", sqlParam, CConnection.GetSecurityConnectionString());
if (dt != null && dt.Rows.Count > 0)
{
lst = EnumerableExtension.ToList <FormVerification>(dt);
if (lst.Count > 0)
{
HttpContext.Current.Session["UserRights"] = lst;
SecurityDT = dt;
}
// FormsActionVerification(LoginName, CompanyCode, ApplicationCode);
return(true);
}
}
catch (Exception ex)
{
return(false);
}
return(false);
}
public bool LoginVerification(string username, string password, ref DataTable dt)
{
try
{
//var Serializer = new JavaScriptSerializer();
SqlParameter[] sqlParam =
{
new SqlParameter("@LoginName", username),
new SqlParameter("@Password", password)
};
dt = DataAccess.getDataTable("SP_LoginVerification", sqlParam, CConnection.GetSecurityConnectionString());
if (dt != null && dt.Rows.Count > 0)
{
return(true);
}
}
catch (Exception ex)
{
return(false);
}
return(false);
}
public bool FormsActionVerification(string LoginName, string CompanyCode, string ApplicationCode)
{
try
{
//var Serializer = new JavaScriptSerializer();
SqlParameter[] sqlParam =
{
new SqlParameter("@LoginName", LoginName),
new SqlParameter("@CompCode", CompanyCode),
new SqlParameter("@ApplicationCode", ApplicationCode)
};
dt = DataAccess.getDataTable("SP_FormsActionVerification", sqlParam, CConnection.GetSecurityConnectionString());
SqlParameter[] sqlParam1 =
{
new SqlParameter("@LoginName", LoginName),
new SqlParameter("@CompCode", CompanyCode),
new SqlParameter("@ApplicationCode", ApplicationCode)
};
SecurityDT_Add = DataAccess.getDataTable("SP_FormsActionVerification_Add", sqlParam1, CConnection.GetSecurityConnectionString());
SqlParameter[] sqlParam2 =
{
new SqlParameter("@LoginName", LoginName),
new SqlParameter("@CompCode", CompanyCode),
new SqlParameter("@ApplicationCode", ApplicationCode)
};
SecurityDT_Edit = DataAccess.getDataTable("SP_FormsActionVerification_Edit", sqlParam2, CConnection.GetSecurityConnectionString());
SqlParameter[] sqlParam3 =
{
new SqlParameter("@LoginName", LoginName),
new SqlParameter("@CompCode", CompanyCode),
new SqlParameter("@ApplicationCode", ApplicationCode)
};
SecurityDT_Delete = DataAccess.getDataTable("SP_FormsActionVerification_Delete", sqlParam3, CConnection.GetSecurityConnectionString());
SqlParameter[] sqlParam4 =
{
new SqlParameter("@LoginName", LoginName),
new SqlParameter("@CompCode", CompanyCode),
new SqlParameter("@ApplicationCode", ApplicationCode)
};
SecurityDT_Post = DataAccess.getDataTable("SP_FormsActionVerification_Post", sqlParam4, CConnection.GetSecurityConnectionString());
SqlParameter[] sqlParam5 =
{
new SqlParameter("@LoginName", LoginName),
new SqlParameter("@CompCode", CompanyCode),
new SqlParameter("@ApplicationCode", ApplicationCode)
};
SecurityDT_Print = DataAccess.getDataTable("SP_FormsActionVerification_Print", sqlParam5, CConnection.GetSecurityConnectionString());
if (dt != null && dt.Rows.Count > 0)
{
//SecurityDT_Add = dt;
return(true);
}
}
catch (Exception ex)
{
return(false);
}
return(false);
}
