public SearchItemResponse Search(string tag)
{
SearchItemResponse searchItem = null;
apiBaseAddress
.Append(@"search/{0}")
.FormatWith(tag)
.DownloadString(this.ClientVerificationToken, response => searchItem = response.DeserializeTo <SearchItemResponse>());
return(searchItem);
}
public static SearchItemResponse Unmarshall(UnmarshallerContext context)
{
SearchItemResponse searchItemResponse = new SearchItemResponse();
searchItemResponse.HttpResponse = context.HttpResponse;
searchItemResponse.RequestId = context.StringValue("SearchItem.RequestId");
searchItemResponse.Success = context.BooleanValue("SearchItem.Success");
searchItemResponse.Message = context.StringValue("SearchItem.Message");
searchItemResponse.Code = context.IntegerValue("SearchItem.Code");
SearchItemResponse.SearchItem_Head head = new SearchItemResponse.SearchItem_Head();
head.SearchTime = context.IntegerValue("SearchItem.Head.SearchTime");
head.DocsFound = context.IntegerValue("SearchItem.Head.DocsFound");
head.DocsReturn = context.IntegerValue("SearchItem.Head.DocsReturn");
searchItemResponse.Head = head;
SearchItemResponse.SearchItem_PicInfo picInfo = new SearchItemResponse.SearchItem_PicInfo();
picInfo.Category = context.StringValue("SearchItem.PicInfo.Category");
picInfo.Region = context.StringValue("SearchItem.PicInfo.Region");
List <SearchItemResponse.SearchItem_PicInfo.SearchItem_Category> picInfo_allCategory = new List <SearchItemResponse.SearchItem_PicInfo.SearchItem_Category>();
for (int i = 0; i < context.Length("SearchItem.PicInfo.AllCategory.Length"); i++)
{
SearchItemResponse.SearchItem_PicInfo.SearchItem_Category category = new SearchItemResponse.SearchItem_PicInfo.SearchItem_Category();
category.Name = context.StringValue("SearchItem.PicInfo.AllCategory[" + i + "].Name");
category.Id = context.StringValue("SearchItem.PicInfo.AllCategory[" + i + "].Id");
picInfo_allCategory.Add(category);
}
picInfo.AllCategory = picInfo_allCategory;
searchItemResponse.PicInfo = picInfo;
List <SearchItemResponse.SearchItem_Auction> searchItemResponse_auctions = new List <SearchItemResponse.SearchItem_Auction>();
for (int i = 0; i < context.Length("SearchItem.Auctions.Length"); i++)
{
SearchItemResponse.SearchItem_Auction auction = new SearchItemResponse.SearchItem_Auction();
auction.CustContent = context.StringValue("SearchItem.Auctions[" + i + "].CustContent");
auction.ItemId = context.StringValue("SearchItem.Auctions[" + i + "].ItemId");
auction.SortExprValues = context.StringValue("SearchItem.Auctions[" + i + "].SortExprValues");
auction.CatId = context.StringValue("SearchItem.Auctions[" + i + "].CatId");
auction.PicName = context.StringValue("SearchItem.Auctions[" + i + "].PicName");
searchItemResponse_auctions.Add(auction);
}
searchItemResponse.Auctions = searchItemResponse_auctions;
return(searchItemResponse);
}
/// <summary>
/// create dummy SearchItemResponse object
/// </summary>
/// <param name="i"></param>
/// <returns></returns>
private SearchItemResponse CreateDummyExpenditureResponse(int i)
{
var data = new SearchItemResponse()
{
CategoryCd = "CategoryCode" + i.ToString(),
SubCategoryCd = "subCategorCd" + i.ToString(),
ExpendId = 1 + i,
ExpendSeqNum = 1,
JobseekerId = 10000000 + i,
ClaimId = 10000 + i,
StatusCd = "StatusCode" + i.ToString(),
};
return(data);
}
public SearchItemResponse SearchItemProcess(SearchItemRequest SIR)
{
SearchItemResponse SM = new SearchItemResponse();
try
{
if (SIR.UserId == "" || SIR.UserId == null)
{
SM.Status = "Failure";
SM.Message = "Invalid UserId";
return(SM);
}
if (SIR.WorkOrderNo == "" || SIR.WorkOrderNo == null)
{
SM.Status = "Failure";
SM.Message = "Invalid WorkOrderNo";
return(SM);
}
if (SIR.ItemName == "" || SIR.ItemName == null)
{
SM.Status = "Failure";
SM.Message = "Invalid ItemName";
return(SM);
}
query = "Sp_WorkOrderWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "SearchItemProcess");
dbcommand.Parameters.AddWithValue("@WorkOrderNo", SIR.WorkOrderNo);
dbcommand.Parameters.AddWithValue("@UserId", SIR.UserId);
dbcommand.Parameters.AddWithValue("@ItemName", SIR.ItemName);
dbcommand.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
SM.ItemName = dt.Rows[0]["ItemName"].ToString();
SM.WorkOrderNo = dt.Rows[0]["WorkOrderNo"].ToString();
SM.ItemId = dt.Rows[0]["ItemId"].ToString();
SM.Status = "Success";
SM.Message = "Record Found";
}
else
{
SM.Status = "Failure";
SM.Message = "Invalid Item Name";
}
}
catch (Exception Ex)
{
SM.Status = "Failure";
SM.Message = Ex.Message;
}
//finally
//{
// //dbcommand.Connection.Close();
//}
return(SM);
}
