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; } }