private void SaveInfo(string strLink = "")
        {
            try
            {
                string Area_Code = txtCode.Value;
                string Area_Name = txtName.Value;
                string Area_Desc = txtDesc.Value;


                int Area_Parent_Id = Utils.CIntDef(ddlCategory.SelectedValue, 0);
                int Area_Active = Utils.CIntDef(rblActive.SelectedValue);
                int Area_Order = Utils.CIntDef(txtOrder.Value);
                decimal Area_ShippingFee = Utils.CDecDef(txtShippingFee.Value);
                decimal Area_HomeFee = Utils.CDecDef(txtHomeFee.Value);
                string Area_Parent_Path = "0";
                int Area_Rank = 1;

                //english language
                //string Cat_Code_En = txtCodeEn.Value;
                //string Cat_Name_En = txtNameEn.Value;
                //string Cat_Desc_En = txtDescEn.Value;
                //string Cat_Seo_Url_En = txtSeoUrlEn.Value;
                //string Cat_Seo_Tittle_En = txtSeoTitleEn.Value;
                //string Cat_Seo_Keyword_En = txtSeoKeywordEn.Value;
                //string Cat_Seo_Description_En = txtSeoDescriptionEn.Value;


                if (Area_Parent_Id > 0)
                {
                    var CatParent = DB.GetTable<ESHOP_PROPERTy>().Where(c => c.PROP_ID == Area_Parent_Id);

                    Area_Parent_Path = CatParent.Single().PROP_PARENT_PATH + "," + Utils.CStrDef(Area_Parent_Id);
                    Area_Rank = Utils.CIntDef(CatParent.Single().PROP_RANK) + 1;
                }
              
                if (m_cat_id == 0)
                {
                    //insert

                    ESHOP_PROPERTy area_insert = new ESHOP_PROPERTy();

                    area_insert.PROP_CODE = Area_Code;
                    area_insert.PROP_NAME = Area_Name;
                    area_insert.PROP_DESC = Area_Desc;


                    area_insert.PROP_PARENT_ID = Area_Parent_Id;
                    area_insert.PROP_ACTIVE = Area_Active;
                    area_insert.PROP_PRIORITY = Area_Order;

                    area_insert.PROP_PARENT_PATH = Area_Parent_Path;
                    area_insert.PROP_RANK = Area_Rank;
                    area_insert.PROP_SHIPPING_FEE = Area_ShippingFee;

                    DB.ESHOP_PROPERTies.InsertOnSubmit(area_insert);
                    DB.SubmitChanges();

                    var _cat = DB.GetTable<ESHOP_PROPERTy>().OrderByDescending(g => g.PROP_ID).Take(1);

                    m_cat_id = Utils.CIntDef(_cat.Single().PROP_ID);

                    strLink = string.IsNullOrEmpty(strLink) ? "area_list.aspx?area_id=" + m_cat_id : strLink;
                }
                else
                {
                    //update
                    var c_update = DB.GetTable<ESHOP_PROPERTy>().Where(g => g.PROP_ID == m_cat_id);

                    if (c_update.ToList().Count > 0)
                    {
                        c_update.First().PROP_CODE = Area_Code;
                        c_update.First().PROP_NAME = Area_Name;
                        c_update.First().PROP_DESC = Area_Desc;


                        c_update.First().PROP_PARENT_ID = Area_Parent_Id;
                        c_update.First().PROP_ACTIVE = Area_Active;
                        c_update.First().PROP_PRIORITY = Area_Order;

                        c_update.First().PROP_PARENT_PATH = Area_Parent_Path;
                        c_update.First().PROP_RANK = Area_Rank;
                        c_update.First().PROP_SHIPPING_FEE = Area_ShippingFee;

                        DB.SubmitChanges();

                        strLink = string.IsNullOrEmpty(strLink) ? "area_list.aspx" : strLink;
                    }
                }
            }
            catch (Exception ex)
            {
                clsVproErrorHandler.HandlerError(ex);
            }
            finally
            {
                if (!string.IsNullOrEmpty(strLink))
                { Response.Redirect(strLink); }
            }
        }
        private void SaveInfo(string strLink = "")
        {
            try
            {
                string Prop_Name = txtName.Value;
                string Prop_Desc = txtDesc.Value;

                int Prop_Parent_Id = Utils.CIntDef(ddlCategory.SelectedValue, 0);
                int Prop_Status = Utils.CIntDef(rblStatus.SelectedValue);
                int Prop_Rank = 1;

                if (Prop_Parent_Id > 0)
                {
                    var CatParent = DB.GetTable<ESHOP_PROPERTy>().Where(c => c.PROP_ID == Prop_Parent_Id);

                    Prop_Rank = Utils.CIntDef(CatParent.Single().PROP_RANK) + 1;
                }

                if (m_prop_id == 0)
                {
                    //insert

                    ESHOP_PROPERTy cat_insert = new ESHOP_PROPERTy();

                    cat_insert.PROP_NAME = Prop_Name;
                    cat_insert.PROP_DESC = Prop_Desc;

                    cat_insert.PROP_PARENT_ID = Prop_Parent_Id;
                    cat_insert.PROP_ACTIVE = Prop_Status;
                    cat_insert.PROP_RANK = Prop_Rank;

                    DB.ESHOP_PROPERTies.InsertOnSubmit(cat_insert);
                    DB.SubmitChanges();

                    var _cat = DB.GetTable<ESHOP_CATEGORy>().OrderByDescending(g => g.CAT_ID).Take(1);

                    m_prop_id = _cat.Single().CAT_ID;

                    strLink = string.IsNullOrEmpty(strLink) ? "properties_list.aspx" : strLink;
                }
                else
                {
                    //update
                    var c_update = DB.GetTable<ESHOP_CATEGORy>().Where(g => g.CAT_ID == m_prop_id);

                    if (c_update.ToList().Count > 0)
                    {
                        c_update.Single().CAT_NAME = Prop_Name;
                        c_update.Single().CAT_DESC = Prop_Desc;

                        c_update.Single().CAT_PARENT_ID = Prop_Parent_Id;
                        c_update.Single().CAT_STATUS = Prop_Status;

                        c_update.Single().CAT_RANK = Prop_Rank;

                        DB.SubmitChanges();

                        strLink = string.IsNullOrEmpty(strLink) ? "properties_list.aspx" : strLink;
                    }
                }

            }
            catch (Exception ex)
            {
                clsVproErrorHandler.HandlerError(ex);
            }
            finally
            {
                if (!string.IsNullOrEmpty(strLink))
                { Response.Redirect(strLink); }
            }
        }
        private void SaveInfo(string strLink = "")
        {
            try
            {
                string Prop_Name = txtName.Value;
                string Prop_Desc = txtDesc.Value;

                int Prop_Parent_Id = Utils.CIntDef(ddlCategory.SelectedValue, 0);
                int Prop_Status    = Utils.CIntDef(rblStatus.SelectedValue);
                int Prop_Rank      = 1;

                if (Prop_Parent_Id > 0)
                {
                    var CatParent = DB.GetTable <ESHOP_PROPERTy>().Where(c => c.PROP_ID == Prop_Parent_Id);

                    Prop_Rank = Utils.CIntDef(CatParent.Single().PROP_RANK) + 1;
                }

                if (m_prop_id == 0)
                {
                    //insert

                    ESHOP_PROPERTy cat_insert = new ESHOP_PROPERTy();

                    cat_insert.PROP_NAME = Prop_Name;
                    cat_insert.PROP_DESC = Prop_Desc;

                    cat_insert.PROP_PARENT_ID = Prop_Parent_Id;
                    cat_insert.PROP_ACTIVE    = Prop_Status;
                    cat_insert.PROP_RANK      = Prop_Rank;

                    DB.ESHOP_PROPERTies.InsertOnSubmit(cat_insert);
                    DB.SubmitChanges();

                    var _cat = DB.GetTable <ESHOP_CATEGORy>().OrderByDescending(g => g.CAT_ID).Take(1);

                    m_prop_id = _cat.Single().CAT_ID;

                    strLink = string.IsNullOrEmpty(strLink) ? "properties_list.aspx" : strLink;
                }
                else
                {
                    //update
                    var c_update = DB.GetTable <ESHOP_CATEGORy>().Where(g => g.CAT_ID == m_prop_id);

                    if (c_update.ToList().Count > 0)
                    {
                        c_update.Single().CAT_NAME = Prop_Name;
                        c_update.Single().CAT_DESC = Prop_Desc;

                        c_update.Single().CAT_PARENT_ID = Prop_Parent_Id;
                        c_update.Single().CAT_STATUS    = Prop_Status;

                        c_update.Single().CAT_RANK = Prop_Rank;

                        DB.SubmitChanges();

                        strLink = string.IsNullOrEmpty(strLink) ? "properties_list.aspx" : strLink;
                    }
                }
            }
            catch (Exception ex)
            {
                clsVproErrorHandler.HandlerError(ex);
            }
            finally
            {
                if (!string.IsNullOrEmpty(strLink))
                {
                    Response.Redirect(strLink);
                }
            }
        }
示例#4
0
        private void SaveInfo(string strLink = "")
        {
            try
            {
                string Area_Code = txtCode.Value;
                string Area_Name = txtName.Value;
                string Area_Desc = txtDesc.Value;


                int     Area_Parent_Id   = Utils.CIntDef(ddlCategory.SelectedValue, 0);
                int     Area_Active      = Utils.CIntDef(rblActive.SelectedValue);
                int     Area_Order       = Utils.CIntDef(txtOrder.Value);
                decimal Area_ShippingFee = Utils.CDecDef(txtShippingFee.Value);
                string  Area_Parent_Path = "0";
                int     Area_Rank        = 1;

                //english language
                //string Cat_Code_En = txtCodeEn.Value;
                //string Cat_Name_En = txtNameEn.Value;
                //string Cat_Desc_En = txtDescEn.Value;
                //string Cat_Seo_Url_En = txtSeoUrlEn.Value;
                //string Cat_Seo_Tittle_En = txtSeoTitleEn.Value;
                //string Cat_Seo_Keyword_En = txtSeoKeywordEn.Value;
                //string Cat_Seo_Description_En = txtSeoDescriptionEn.Value;


                if (Area_Parent_Id > 0)
                {
                    var CatParent = DB.GetTable <ESHOP_PROPERTy>().Where(c => c.PROP_ID == Area_Parent_Id);

                    Area_Parent_Path = CatParent.Single().PROP_PARENT_PATH + "," + Utils.CStrDef(Area_Parent_Id);
                    Area_Rank        = Utils.CIntDef(CatParent.Single().PROP_RANK) + 1;
                }

                if (m_cat_id == 0)
                {
                    //insert

                    ESHOP_PROPERTy area_insert = new ESHOP_PROPERTy();

                    area_insert.PROP_CODE = Area_Code;
                    area_insert.PROP_NAME = Area_Name;
                    area_insert.PROP_DESC = Area_Desc;


                    area_insert.PROP_PARENT_ID = Area_Parent_Id;
                    area_insert.PROP_ACTIVE    = Area_Active;
                    area_insert.PROP_PRIORITY  = Area_Order;

                    area_insert.PROP_PARENT_PATH  = Area_Parent_Path;
                    area_insert.PROP_RANK         = Area_Rank;
                    area_insert.PROP_SHIPPING_FEE = Area_ShippingFee;
                    area_insert.PROP_SHIP_NOTE    = txtHomeFee.Value;
                    DB.ESHOP_PROPERTies.InsertOnSubmit(area_insert);
                    DB.SubmitChanges();

                    var _cat = DB.GetTable <ESHOP_PROPERTy>().OrderByDescending(g => g.PROP_ID).Take(1);

                    m_cat_id = Utils.CIntDef(_cat.Single().PROP_ID);

                    strLink = string.IsNullOrEmpty(strLink) ? "area_list.aspx?area_id=" + m_cat_id : strLink;
                }
                else
                {
                    //update
                    var c_update = DB.GetTable <ESHOP_PROPERTy>().Where(g => g.PROP_ID == m_cat_id);

                    if (c_update.ToList().Count > 0)
                    {
                        c_update.First().PROP_CODE = Area_Code;
                        c_update.First().PROP_NAME = Area_Name;
                        c_update.First().PROP_DESC = Area_Desc;


                        c_update.First().PROP_PARENT_ID = Area_Parent_Id;
                        c_update.First().PROP_ACTIVE    = Area_Active;
                        c_update.First().PROP_PRIORITY  = Area_Order;

                        c_update.First().PROP_PARENT_PATH  = Area_Parent_Path;
                        c_update.First().PROP_RANK         = Area_Rank;
                        c_update.First().PROP_SHIPPING_FEE = Area_ShippingFee;
                        c_update.First().PROP_SHIP_NOTE    = txtHomeFee.Value;
                        DB.SubmitChanges();

                        strLink = string.IsNullOrEmpty(strLink) ? "area_list.aspx" : strLink;
                    }
                }
            }
            catch (Exception ex)
            {
                clsVproErrorHandler.HandlerError(ex);
            }
            finally
            {
                if (!string.IsNullOrEmpty(strLink))
                {
                    Response.Redirect(strLink);
                }
            }
        }