public int InsertAndUpdateGoldPrice(SuperAdminOpsVo productGoldPriceVO)
{
try
{
return(ProductGoldPriceDao.InsertAndUpdateGoldPrice(productGoldPriceVO));
}
catch
{
throw;
}
}
public DataSet GetDataBetweenDatesForGoldPrice(SuperAdminOpsVo productGoldPriceVO, int productGoldPriceId, int CurrentPage, out int Count)
//public DataSet GetDataBetweenDatesForGoldPrice(SuperAdminOpsVo productGoldPriceVO)
{
DataSet ds = new DataSet();
try
{
ds = ProductGoldPriceDao.GetDataBetweenDatesForGoldPrice(productGoldPriceVO, productGoldPriceId, CurrentPage, out Count);
}
catch
{
throw;
}
return(ds);
}
public int InsertAndUpdateGoldPrice(SuperAdminOpsVo productGoldPriceVO)
{
Database db;
DbCommand createUserCmd;
db = DatabaseFactory.CreateDatabase("wealtherp");
createUserCmd = db.GetStoredProcCommand("PG_goldPriceInsert");
try
{
db.AddInParameter(createUserCmd, "@pg_Date", DbType.DateTime, productGoldPriceVO.PG_Date);
db.AddInParameter(createUserCmd, "@pg_Price", DbType.String, productGoldPriceVO.PG_Price);
return(db.ExecuteNonQuery(createUserCmd));
}
catch
{
throw;
}
}
public DataSet GetDataBetweenDatesForGoldPrice(SuperAdminOpsVo productGoldPriceVO, int productGoldPriceId, int CurrentPage, out int Count)
//public DataSet GetDataBetweenDatesForGoldPrice(SuperAdminOpsVo productGoldPriceVO)
{
DataSet ds;
Database db;
DbCommand getPGPDetails;
db = DatabaseFactory.CreateDatabase("wealtherp");
getPGPDetails = db.GetStoredProcCommand("SP_ProductGoldPriceBteweenDates");
try
{
db.AddInParameter(getPGPDetails, "@currentPage", DbType.Int32, CurrentPage);
db.AddInParameter(getPGPDetails, "@pg_id", DbType.String, productGoldPriceVO.Pg_id);
if (productGoldPriceVO.Pg_fromDate != DateTime.MinValue)
{
db.AddInParameter(getPGPDetails, "@PG_Date_From", DbType.DateTime, productGoldPriceVO.Pg_fromDate);
}
else
{
db.AddInParameter(getPGPDetails, "@PG_Date_From", DbType.DateTime, DBNull.Value);
}
if (productGoldPriceVO.Pg_toDate != DateTime.MinValue)
{
db.AddInParameter(getPGPDetails, "@PG_Date_To", DbType.DateTime, productGoldPriceVO.Pg_toDate);
}
else
{
db.AddInParameter(getPGPDetails, "@PG_Date_To", DbType.DateTime, DBNull.Value);
}
db.AddOutParameter(getPGPDetails, "@Count", DbType.Int32, 0);
ds = db.ExecuteDataSet(getPGPDetails);
Count = (int)db.GetParameterValue(getPGPDetails, "@Count");
return(ds);
}
catch
{
throw;
}
}
