Ejemplo n.º 1
0
    private void InsertRecord()
    {
        logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
        dbo_ProductClass clsdbo_Product = new dbo_ProductClass();

        SetData(clsdbo_Product);


        bool   success = false;
        string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;

        success = dbo_ProductDataClass.Add(clsdbo_Product, User_ID);

        dbo_ProductListClass clsdbo_ProductList = new dbo_ProductListClass();


        List <dbo_PriceGroupClass> price_group    = dbo_PriceGroupDataClass.Search(string.Empty, "0");
        dbo_PriceGroupClass        price_group_id = price_group.FirstOrDefault(f => f.StandardPrice == true);

        clsdbo_ProductList.Price_Group_ID  = price_group_id.Price_Group_ID;
        clsdbo_ProductList.Product_List_ID = GenerateID.Product_List_ID();
        var date = new DateTime(9456, 12, 31);

        clsdbo_ProductList.Agent_Price            = clsdbo_Product.Agent_Price;
        clsdbo_ProductList.Product_Effective_Date = DateTime.Now;
        clsdbo_ProductList.Start_Effective_Date   = DateTime.Now;
        clsdbo_ProductList.End_Effective_Date     = date;
        clsdbo_ProductList.Product_ID             = clsdbo_Product.Product_ID;
        clsdbo_ProductList.Product_Name           = clsdbo_Product.Product_Name;
        clsdbo_ProductList.Point = clsdbo_Product.Point;
        clsdbo_ProductList.Vat   = clsdbo_Product.Vat;
        //clsdbo_ProductList.CP_Meiji_Price = clsdbo_Product.CP_Meiji_Price;

        dbo_ProductListDataClass.Add(clsdbo_ProductList, User_ID);

        price_group    = dbo_PriceGroupDataClass.Search(string.Empty, "1");
        price_group_id = price_group.FirstOrDefault(f => f.StandardPrice == true);


        if (price_group_id != null)
        {
            clsdbo_ProductList.Price_Group_ID  = price_group_id.Price_Group_ID;
            clsdbo_ProductList.SP_Price        = clsdbo_Product.SP_Price;
            clsdbo_ProductList.CP_Meiji_Price  = clsdbo_Product.CP_Meiji_Price;
            clsdbo_ProductList.Agent_Price     = null;
            clsdbo_ProductList.Product_List_ID = GenerateID.Product_List_ID();

            dbo_ProductListDataClass.Add(clsdbo_ProductList, User_ID);
        }

        if (success)
        {
            Show("บันทึกสำเร็จ");
        }
        else
        {
            Show("error");
        }
    }