public DataTable Trach_Lot(int typeSearch, string Input)
{
string Condition = string.Empty;
if (typeSearch == 1)
{
Condition = " ti.InvoiceId LIKE '" + Input + "'";
}
else if (typeSearch == 2)
{
Condition = " ct.Lotnumber LIKE '%" + Input + "%'";
}
else if (typeSearch == 3)
{
Condition = " ct.BatchID LIKE '" + Input + "'";
}
else if (typeSearch == 4)
{
Condition = " od.OrderID LIKE '" + Input + "'";
}
else if (typeSearch == 5)
{
Condition = " od.PurchaseOrderID LIKE '" + Input + "'";
}
else
{
Condition = " ti.InvoiceId LIKE '" + Input + "'";
}
return(Reports_DL.Trach_Lot(Condition));
}
public DataTable GetInvoiceList_Farmer(string FarmerID, string ProductID)
{
return(Reports_DL.GetInvoiceList_Farmer(FarmerID, ProductID));
}
public DataTable GetReports()
{
return(Reports_DL.GetReports());
}
public DataTable GeDispatchDetails(string ProductID)
{
return(Reports_DL.GeDispatchDetails(ProductID));
}
public DataTable GetFreezeDetails()
{
return(Reports_DL.GetFreezeDetails());
}
public DataTable GetAFLReportData(string ICSCode, string Year)
{
return(Reports_DL.GetAFLReportData(ICSCode, Year));
}
public DataTable GetAFLTotalProduction(string ICSCode, string Year, int ProductID)
{
return(Reports_DL.GetAFLTotalProduction(ICSCode, Year, ProductID));
}
public DataTable GetProduction(string ProductID, DateTime Date, string Year)
{
return(Reports_DL.GetProduction(ProductID, Date, Year));
}
public DataTable GetNewallcollectionList(string code)
{
return(Reports_DL.GetNewallcollectionList(code));
}
public DataTable GetSelectedBlendnDate(string Date, int productID)
{
return(Reports_DL.GetSelectedBlendnDate(Date, productID));
}
public DataTable GetSelectedBlendQty(string Code, int productID)
{
return(Reports_DL.GetSelectedBlendQty(Code, productID));
}
public DataTable GetSelectedCollectionDate(string Date, int productID, string Code)
{
return(Reports_DL.GetSelectedCollectionDate(Date, productID, Code));
}
public DataTable GetAllProducDetails()
{
return(Reports_DL.GetAllProducDetails());
}
public DataTable GetCollectionDates(int productID, string code)
{
return(Reports_DL.GetCollectionDates(productID, code));
}
public bool OrderReportsPathInsertandUpdate(int OrderID, int BranchOrderID, string Path, string CreatedBy, string ModifiedBy, int TypeOfOperation)
{
return(Reports_DL.OrderReportsPathInsertandUpdate(OrderID, BranchOrderID, Path, CreatedBy, ModifiedBy, TypeOfOperation));
}
public DataTable GetBlendDetails(string ProductID)
{
return(Reports_DL.GetBlendDetails(ProductID));
}
public DataTable OrderReportsPathGetDetails(int OrderID)
{
return(Reports_DL.OrderReportsPathGetDetails(OrderID));
}
public DataTable GePackingDetails(string ProductID)
{
return(Reports_DL.GePackingDetails(ProductID));
}
public DataTable GetAFLReportProduction(string ICSCode)
{
return(Reports_DL.GetAFLReportProduction(ICSCode));
}
public DataTable GetAFLReportProductionEstimation(string ICSCode, string Year)
{
return(Reports_DL.GetAFLReportProductionEstimation(ICSCode, Year));
}
