private void btnAddExpiryDate_Click(object sender, EventArgs e)
{
ProductExpiryDates PExp = new ProductExpiryDates();
PExp.PRODUCT_ID = P.PRODUCT_ID;
PExp.PRODUCT_EXPIRY_DATE = dtppExpiryDate.Value.Date;
ProductExpiryDatesOP.InsertProductExpiryDate(PExp);
this.pRODUCT_EXPIRY_DATESTableAdapter.Fill(this.dsProductExpiryDates.PRODUCT_EXPIRY_DATES, (int)P.PRODUCT_ID);
}
public static void InsertProductExpiryDate(ProductExpiryDates PExp)
{
SqlCeCommand com = DBCon.CeCon.CreateCommand();
com.CommandText = "INSERT INTO PRODUCT_EXPIRY_DATES (PRODUCT_ID, PRODUCT_EXPIRY_DATE) VALUES (@PRODUCT_ID, @PRODUCT_EXPIRY_DATE)";
com.Parameters.AddWithValue("PRODUCT_ID", PExp.PRODUCT_ID == null ? (object)DBNull.Value : PExp.PRODUCT_ID);
com.Parameters.AddWithValue("PRODUCT_EXPIRY_DATE", PExp.PRODUCT_EXPIRY_DATE == null ? (object)DBNull.Value : PExp.PRODUCT_EXPIRY_DATE);
com.ExecuteNonQuery();
com.Dispose();
}
public static void UpdateProductExpiryDate(ProductExpiryDates PExp)
{
SqlCeCommand com = DBCon.CeCon.CreateCommand();
com.CommandText = "UPDATE PRODUCT_EXPIRY_DATES SET PRODUCT_EXPIRY_DATE = @PRODUCT_EXPIRY_DATE WHERE PRODUCT_ID = @PRODUCT_ID";
com.Parameters.AddWithValue("PRODUCT_ID", PExp.PRODUCT_ID == null ? (object)DBNull.Value : PExp.PRODUCT_ID);
com.Parameters.AddWithValue("PRODUCT_EXPIRY_DATE", PExp.PRODUCT_EXPIRY_DATE == null ? (object)DBNull.Value : PExp.PRODUCT_EXPIRY_DATE);
com.ExecuteNonQuery();
com.Dispose();
}
public static ProductExpiryDates GetNearestProductExpiryDate(Nullable <int> ProductID)
{
ProductExpiryDates PExp = new ProductExpiryDates();
SqlCeCommand com = DBCon.CeCon.CreateCommand();
com.CommandText = "SELECT PRODUCT_ID, MIN(PRODUCT_EXPIRY_DATE) AS PRODUCT_EXPIRY_DATE FROM PRODUCT_EXPIRY_DATES WHERE PRODUCT_ID = @PRODUCT_ID GROUP BY PRODUCT_ID";
com.Parameters.AddWithValue("PRODUCT_ID", ProductID);
SqlCeDataReader rd = com.ExecuteReader();
if (rd.Read())
{
PExp.PRODUCT_ID = rd["PRODUCT_ID"] == DBNull.Value ? null : rd["PRODUCT_ID"].ToString().ToNullableInt();
PExp.PRODUCT_EXPIRY_DATE = rd["PRODUCT_EXPIRY_DATE"] == DBNull.Value ? null : rd["PRODUCT_EXPIRY_DATE"].ToString().ToNullableDateTime();
}
rd.Close();
com.Dispose();
return(PExp);
}