public HttpResponseMessage GetBatchByProduct(int productId, int companyId, int branchId) { var purchase = _batchService.GetBatchByProduct(@"SELECT pd.BatchID,b.BatchName FROM PurchaseDetails pd INNER JOIN Batch b ON pd.BatchId = b.BatchId Where pd.ProductId={0} AND b.CompanyId={1} AND b.BranchId ={2} AND b.status=1 ", productId, companyId, branchId).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, purchase)); }