public static ProductYad2Collection GetAllProductByAppUserId(Int64 AppUserId)
{
Query qry = new Query(ProductYad2.TableSchema);
qry.Where(ProductYad2.Columns.AppUserId, AppUserId);
qry.OrderBy(ProductYad2.Columns.UpdateDate, SortDirection.DESC);
ProductYad2Collection pcol = ProductYad2Collection.FetchByQuery(qry);
return(pcol);
}
public static List <ProductYad2UI> GetAllProduct()
{
Query qry = new Query(ProductYad2.TableSchema);
qry.Where(ProductYad2.Columns.Status, StatusType.Approved);
qry.AddWhere(ProductYad2.TableSchema.SchemaName, ProductYad2.Columns.UpdateDate, WhereComparision.GreaterThanOrEqual, DateTime.UtcNow.AddDays(-(Convert.ToDouble(Settings.GetSetting(Settings.Keys.YAD_2_EXPIRY_DAY)))));
qry.OrderBy(ProductYad2.Columns.UpdateDate, SortDirection.DESC);
ProductYad2Collection pcol = ProductYad2Collection.FetchByQuery(qry);
List <ProductYad2UI> LstProductYad2UI = new List <ProductYad2UI>();
foreach (ProductYad2 item in pcol)
{
LstProductYad2UI.Add(new ProductYad2UI(item, GetAllCatagoriesOfProduct(item._ProductId)));
}
return(LstProductYad2UI);
}
public override void Get(HttpRequest Request, HttpResponse Response, params string[] PathParams)
{
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetMaxAge(TimeSpan.Zero);
try
{
Int64 AppUserId;
if (IsAuthorizedRequest(Request, Response, true, out AppUserId))
{
Response.ContentType = @"application/json";
using (StreamWriter streamWriter = new StreamWriter(Response.OutputStream))
{
using (JsonTextWriter jsonWriter = new JsonTextWriter(streamWriter))
{
ProductYad2Collection productYad2Col = ProductYad2Controller.GetAllProductByAppUserId(AppUserId);
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName(@"products");
jsonWriter.WriteStartArray();
foreach (ProductYad2 productYad2 in productYad2Col)
{
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName(@"product_id");
jsonWriter.WriteValue(productYad2.ProductId);
jsonWriter.WritePropertyName(@"product_name");
jsonWriter.WriteValue(productYad2.ProductName ?? "");
jsonWriter.WritePropertyName(@"product_date");
jsonWriter.WriteValue(productYad2.UpdateDate.ToShortDateString());
jsonWriter.WritePropertyName(@"status");
jsonWriter.WriteValue(Enum.GetName(typeof(StatusType), productYad2.Status).ToLower());
jsonWriter.WriteEndObject();
}
jsonWriter.WriteEndArray();
jsonWriter.WriteEndObject();
}
}
}
}
catch (Exception) { }
}
