public BO.ProductBatch GetProductBatchByID(long BatchID) { try { querry = @"Select ProductBatch.BatchID,ProductBatch.BatchNo,ProductCode, ProductBatch.ProductID ,Product.ProductName from ProductBatch inner join dbo.Product on dbo.Product.ProductId = dbo.ProductBatch.ProductID where ProductBatch.IsActive = 1 and BatchID= " + BatchID + " "; DataTable dt = ExecuteQuerry(querry).Tables[0]; List <POS.BO.ProductBatch> objList = new List <POS.BO.ProductBatch>(); POS.BO.ProductBatch obj = null; foreach (DataRow row in dt.Rows) { obj = new BO.ProductBatch(); obj.BatchID = Convert.ToInt32(row["BatchID"]); obj.BatchNo = row["BatchNo"].ToString(); obj.ProductName = row["ProductName"].ToString(); obj.ProductCode = row["ProductCode"].ToString(); obj.ProductID = Convert.ToInt64(row["ProductID"].ToString()); } return(obj); } catch (Exception ex) { throw ex; } }
/// <summary> /// used get product wise batchID /// </summary> /// <param name="productID"></param> /// <returns></returns> public IList <BO.ProductBatch> GetProductIDWiseProductBactchList(int productID) { try { querry = @"Select ProductBatch.BatchID,ProductBatch.BatchNo from ProductBatch where dbo.ProductBatch.ProductID = " + productID + " and ProductBatch.IsActive = 1 "; DataTable dt = ExecuteQuerry(querry).Tables[0]; List <POS.BO.ProductBatch> objList = new List <POS.BO.ProductBatch>(); POS.BO.ProductBatch obj = null; foreach (DataRow row in dt.Rows) { obj = new BO.ProductBatch(); obj.BatchID = Convert.ToInt32(row["BatchID"]); obj.BatchNo = row["BatchNo"].ToString(); objList.Add(obj); } return(objList); } catch (Exception ex) { throw ex; } }
public IList <POS.BO.ProductBatch> GetProductBatchList() { try { SqlConnection con = CreateCon(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(); da.SelectCommand.CommandText = "[POS_SP_GET_GETProductBatch]"; da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Connection = con; if (con.State == ConnectionState.Closed) { con.Open(); } DataSet ds = new DataSet(); da.Fill(ds); if (con.State == ConnectionState.Open) { con.Close(); } DataTable dt = ds.Tables[0]; List <POS.BO.ProductBatch> objDoctorList = new List <POS.BO.ProductBatch>(); POS.BO.ProductBatch obj = null; int index = 1; foreach (DataRow row in dt.Rows) { obj = new BO.ProductBatch(); obj.Sln = index++; obj.BatchID = Convert.ToInt32(row["BatchID"]); obj.BatchName = row["BatchName"].ToString(); obj.BatchNo = row["BatchCode"].ToString(); obj.BatchDescription = row["Description"].ToString(); // obj.ProductName = row["ProductName"].ToString(); // obj.ProductID = Convert.ToInt64(row["ProductID"].ToString()); objDoctorList.Add(obj); } return(objDoctorList); } catch (Exception ex) { throw ex; } }