private IList <BO.ProductPackSize> GetProductPackSizeList(Int32?PackSizeID) { try { SqlConnection con = CreateCon(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(); da.SelectCommand.CommandText = "[POS_SP_GET_GETProductPackSize]"; da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Connection = con; // da.SelectCommand.Parameters.Add("@PackSizeID", System.Data.SqlDbType.Int).Value = PackSizeID; 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.ProductPackSize> objDoctorList = new List <POS.BO.ProductPackSize>(); POS.BO.ProductPackSize obj = null; int index = 1; foreach (DataRow row in dt.Rows) { obj = new BO.ProductPackSize(); obj.Sln = index++; obj.PackSizeID = Convert.ToInt32(row["PackSizeID"]); obj.Strip = Convert.ToInt32(row["Strip"]); obj.PcsPerStrip = Convert.ToInt32(row["PcsPerStrip"]); obj.PackSize = row["PackSizeName"].ToString(); obj.PackSizeDescription = row["Description"].ToString(); objDoctorList.Add(obj); } return(objDoctorList); } catch (Exception) { throw; } }
public BO.ProductPackSize GETStripAndPcsPerStripByProductID(long productID) { try { SqlConnection con = CreateCon(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(); da.SelectCommand.CommandText = "POS_SET_SP_GET_StripAndPcsPerStripByProductID"; da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Connection = con; da.SelectCommand.Parameters.Add("@ProductID", System.Data.SqlDbType.BigInt).Value = productID; 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.ProductPackSize> objProductPackSize = new List <POS.BO.ProductPackSize>(); POS.BO.ProductPackSize obj = null; int index = 1; foreach (DataRow row in dt.Rows) { obj = new BO.ProductPackSize(); obj.Sln = index++; obj.ProductId = Convert.ToInt32(row["ProductID"]); obj.PackSizeID = Convert.ToInt32(row["PackSizeID"]); obj.Strip = Convert.ToInt32(row["Strip"]); obj.PcsPerStrip = Convert.ToInt32(row["PcsPerStrip"]); obj.PackSize = row["PackSizeName"].ToString(); } return(obj); } catch (Exception) { throw; } }
public int Update(BO.ProductPackSize objProductPackSize) { try { int returnStatus = 0; SqlConnection con = CreateCon(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(); da.SelectCommand.CommandText = "[POS_SP_Update_SET_ProductPackSize]"; da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Connection = con; da.SelectCommand.Parameters.Add("@PackSizeID", System.Data.SqlDbType.Int).Value = objProductPackSize.PackSizeID; da.SelectCommand.Parameters.Add("@PackSizeName", SqlDbType.VarChar, 100).Value = objProductPackSize.PackSize; da.SelectCommand.Parameters.Add("@Strip", SqlDbType.Int).Value = objProductPackSize.Strip; da.SelectCommand.Parameters.Add("@PcsPerStrip", System.Data.SqlDbType.Int).Value = objProductPackSize.PcsPerStrip; da.SelectCommand.Parameters.Add("@PackSizeDescription", System.Data.SqlDbType.VarChar, 500).Value = objProductPackSize.PackSizeDescription; if (con.State == ConnectionState.Closed) { con.Open(); } if (da.SelectCommand.ExecuteNonQuery() == 1) { returnStatus = 1; } else { returnStatus = 0; } if (con.State == ConnectionState.Open) { con.Close(); } return(returnStatus); } catch (Exception ex) { throw ex; } }
public int Update(BO.ProductPackSize objProduct) { return(_iProductPackSize.Update(objProduct)); }
public int Insert(BO.ProductPackSize objProduct) { return(_iProductPackSize.Insert(objProduct)); }