public static DataTable GetVersion()
{
try
{
wlSQL objWLSql = new wlSQL();
objWLSql.AddParameter("@paramType", DbType.Int32, ParameterDirection.Input, 0, 1);
return(objWLSql.ExecuteDataSet("emi_version").Tables[0]);
}
catch (Exception ex)
{
throw wlLogging.HandleEx(ex);
}
}
public static List <Status> GetUserStatusList()
{
try
{
DataTable dt;
wlSQL objWLSql = new wlSQL();
dt = objWLSql.ExecuteDataSet("p_LookupStatuses_sel").Tables[0];
return(Util.ConvertDataTable <Status>(dt));
}
catch (Exception ex)
{
throw wlLogging.HandleEx(ex);
}
}
public static DataSet GetProductDetails(int productTypeId)
{
try
{
DataSet ds;
wlSQL objWLSql = new wlSQL();
objWLSql.AddParameter("@ProductTypes", DbType.Int32, ParameterDirection.Input, 0, productTypeId);
ds = objWLSql.ExecuteDataSet("emi_ProductsDetails_ProductTypes");
return(ds);
}
catch (Exception ex)
{
throw wlLogging.HandleEx(ex);
}
}
public static List <UserRoles> GetUserRolePermissions(int _userID = 0)
{
try
{
DataTable dt;
wlSQL objWLSql = new wlSQL();
objWLSql.AddParameter("@UserID", DbType.Int64, ParameterDirection.Input, 0, _userID);
dt = objWLSql.ExecuteDataSet("p_UserRoles_sel_byID").Tables[0];
return(Util.ConvertDataTable <UserRoles>(dt));
}
catch (Exception ex)
{
throw wlLogging.HandleEx(ex);
}
}
public static List <UsersDto> GetUserList()
{
try
{
DataTable dt;
wlSQL objWLSql = new wlSQL();
objWLSql.AddParameter("@paramType", DbType.Int32, ParameterDirection.Input, 0, 6);
dt = objWLSql.ExecuteDataSet("emi_carproduct").Tables[0];
return(Util.ConvertDataTable <UsersDto>(dt));
}
catch (Exception ex)
{
throw wlLogging.HandleEx(ex);
}
}
public static List <Users> GetLoginDetails(string emailAddress)
{
try
{
DataTable dt;
wlSQL objWLSql = new wlSQL();
objWLSql.AddParameter("@EmailAddress", DbType.String, ParameterDirection.Input, 0, emailAddress);
dt = objWLSql.ExecuteDataSet("p_Users_sel_LoginDetails").Tables[0];
return(Util.ConvertDataTable <Users>(dt));
}
catch (Exception ex)
{
throw wlLogging.HandleEx(ex);
}
}
public static List <CarsDetailsDto> GetProductTypes(ProductTypesDto productID)
{
try
{
DataTable dt;
wlSQL objWLSql = new wlSQL();
objWLSql.AddParameter("@paramType", DbType.Int32, ParameterDirection.Input, 0, 7);
objWLSql.AddParameter("@ProductTypeId", DbType.String, ParameterDirection.Input, 0, productID.ProductTypeId);
dt = objWLSql.ExecuteDataSet("emi_carproduct").Tables[0];
return(Util.ConvertDataTable <CarsDetailsDto>(dt));
}
catch (Exception ex)
{
throw wlLogging.HandleEx(ex);
}
}
public static List <AppVersions> GetAllVersion()
{
try
{
//wlSQL objWLSql = new wlSQL();
//objWLSql.AddParameter("@paramType", DbType.Int32, ParameterDirection.Input, 0, 2);
//return objWLSql.ExecuteDataSet("emi_version").Tables[0];
DataTable dt;
wlSQL objWLSql = new wlSQL();
objWLSql.AddParameter("@paramType", DbType.Int32, ParameterDirection.Input, 0, 2);
dt = objWLSql.ExecuteDataSet("emi_version").Tables[0];
return(Util.ConvertDataTable <AppVersions>(dt));
}
catch (Exception ex)
{
throw wlLogging.HandleEx(ex);
}
}