Exemple #1
0
        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);
        }
Exemple #2
0
        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();
        }
Exemple #3
0
        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();
        }
Exemple #4
0
        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);
        }