public List <GrnBatchDetail> Search()
{
try
{
List <GrnBatchDetail> GRNBatchDetailList = new List <GrnBatchDetail>();
System.Data.DataTable dTable = new DataTable();
string errorMessage = string.Empty;
dTable = GetSelectedRecords(Common.ToXml(this), SP_GRNBATCHDETAIL_SEARCH, ref errorMessage);
if (dTable != null)
{
foreach (System.Data.DataRow drow in dTable.Rows)
{
GrnBatchDetail _Grn = new GrnBatchDetail();
_Grn = CreateBatchObject(drow);
GRNBatchDetailList.Add(_Grn);
}
}
return(GRNBatchDetailList);
}
catch (Exception ex)
{
throw ex;
}
}
private List <GrnBatchDetail> GetBatchDetail()
{
try
{
GrnBatchDetail batch = new GrnBatchDetail();
batch.GRNNo = GRNNo;
batch.ItemId = ItemId;
List <GrnBatchDetail> ListBatch = batch.Search();
return(ListBatch);
}
catch (Exception ex)
{
throw ex;
}
}
private GrnBatchDetail CreateBatchObject(DataRow dr)
{
try
{
GrnBatchDetail batch = new GrnBatchDetail();
batch.BatchNumber = Convert.ToString(dr[CON_FIELD_BATCHNUMBER]);
batch.ExpiryDate = Convert.ToString(dr[CON_FIELD_EXPIRYDATE]);
batch.GRNNo = Convert.ToString(dr[CON_FIELD_GRNNO]);
batch.ItemId = Convert.ToInt32(dr[CON_FIELD_ITEMID]);
batch.ManufacturerBatchNumber = Convert.ToString(dr[CON_FIELD_MANUFACTURERBATCHNO]);
batch.ManufacturingDate = Convert.ToString(dr[CON_FIELD_MANUFACTURINGDATE]);
batch.MRP = Convert.ToDouble(dr[CON_FIELD_MRP]);
batch.ReceivedQty = Convert.ToDouble(dr[CON_FIELD_RECEIVEDQTY]);
batch.SerialNo = Convert.ToInt32(dr[CON_FIELD_SERIALNO]);
batch.RowNo = Convert.ToInt32(dr["RowNo"]);
return(batch);
}
catch (Exception ex)
{
throw ex;
}
}
