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