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); } } }
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); } } }