public JsonResult GetSubCateGoryForSelect2FromMainCateGoryID(string MainCategoryId) { int idPT = 0; List <Id_ValueModel> model = new List <Id_ValueModel>(); if (Int32.TryParse(MainCategoryId, out idPT)) { PDBC db = new PDBC(); ExcParameters par = new ExcParameters() { _KEY = "@MainCategoryId", _VALUE = MainCategoryId }; List <ExcParameters> parass = new List <ExcParameters>(); parass.Add(par); db.Connect(); using (DataTable dt = db.Select("SELECT [id_SC] as id,[SCName] as [name] FROM [tbl_Product_SubCategory]WHERE ISDelete=0 AND ISDESABLED =0 AND id_MC=@MainCategoryId", parass)) { db.DC(); int dtrowcount = dt.Rows.Count; if (dtrowcount > 0) { var res = new Id_ValueModel() { Id = 0, Value = "لطفا یک مورد را انتخاب نماید" }; model.Add(res); for (int i = 0; i < dt.Rows.Count; i++) { res = new Id_ValueModel() { Id = Convert.ToInt32(dt.Rows[i]["id"]), Value = dt.Rows[i]["name"].ToString() }; model.Add(res); } } else { model.Add(new Id_ValueModel() { Id = 0, Value = "هیچ موردی برای نمایش وجود ندارد!" }); } } } else { model.Add(new Id_ValueModel() { Id = 0, Value = "هیچ موردی برای نمایش وجود ندارد!" }); } return(Json(model)); }
public ActionResult ProductDetails(int Id_Pro, int Sub) { string SSSession = ""; CheckAccess check = new CheckAccess(SSSession); if (check.HasAccess) { var model = new Id_ValueModel() { Id = Id_Pro, Value = Sub.ToString() }; return(View(model)); } else { return(RedirectToAction("NotAccess", "MS")); } }
public ActionResult Add_Product(string Act = "insert", int id = 0) { string SSSession = ""; CheckAccess check = new CheckAccess(SSSession); if (check.HasAccess) { var model = new Id_ValueModel() { Id = id, Value = Act }; return(View(model)); } else { return(RedirectToAction("NotAccess", "MS")); } }
public List <Id_ValueModel> Post_Tags(int PostId) { PDBC db = new PDBC("PandaMarketCMS", true); var res = new List <Id_ValueModel>(); db.Connect(); DataTable dt = db.Select("SELECT [Id],[Name] FROM [tbl_BLOG_Tags] as A inner join [tbl_BLOG_TagConnector] as B on A.Id=B.Tag_Id Where [Is_Disabled]=0 AND [Is_Deleted]=0 AND B.Post_Id=" + PostId); db.DC(); for (int i = 0; i < dt.Rows.Count; i++) { var model = new Id_ValueModel() { Id = Convert.ToInt32(dt.Rows[i]["Id"]), Value = dt.Rows[i]["Name"].ToString() }; res.Add(model); } return(res); }
public List <Id_ValueModel> B_Tags_Filler(int CatId) { PDBC db = new PDBC("PandaMarketCMS", true); var res = new List <Id_ValueModel>(); db.Connect(); DataTable dt = db.Select("SELECT [Id],[name] FROM [tbl_BLOG_Tags] WHERE [Is_Disabled]=0 AND [Is_Deleted]=0 AND [CtegoryId]=" + CatId); db.DC(); for (int i = 0; i < dt.Rows.Count; i++) { var model = new Id_ValueModel() { Id = Convert.ToInt32(dt.Rows[i]["Id"]), Value = dt.Rows[i]["name"].ToString() }; res.Add(model); } return(res); }
public List <Id_ValueModel> B_Types_Filler() { PDBC db = new PDBC("PandaMarketCMS", true); var res = new List <Id_ValueModel>(); db.Connect(); DataTable dt = db.Select("SELECT [B_TypeId],[B_TypeToken] FROM [tbl_BLOG_PostType]"); db.DC(); for (int i = 0; i < dt.Rows.Count; i++) { var model = new Id_ValueModel() { Id = Convert.ToInt32(dt.Rows[i]["B_TypeId"]), Value = dt.Rows[i]["B_TypeToken"].ToString() }; res.Add(model); } return(res); }
public List <Id_ValueModel> Groups_Filler() { PDBC db = new PDBC(); var res = new List <Id_ValueModel>(); db.Connect(); DataTable dt = db.Select("SELECT [G_Id],[name] FROM [tbl_BLOG_Groups] WHERE Is_Disabled=0 AND Is_Deleted=0"); db.DC(); for (int i = 0; i < dt.Rows.Count; i++) { var model = new Id_ValueModel() { Id = Convert.ToInt32(dt.Rows[i]["G_Id"]), Value = dt.Rows[i]["name"].ToString() }; res.Add(model); } return(res); }
public List <Id_ValueModel> PriceShowModel_Filler() { var result = new List <Id_ValueModel>(); PDBC db = new PDBC("PandaMarketCMS", true); db.Connect(); DataTable dt = db.Select("SELECT [PriceShowId],[PriceShowformat] FROM [tbl_Product_PriceShow]"); for (int i = 0; i < dt.Rows.Count; i++) { var model = new Id_ValueModel() { Id = Convert.ToInt32(dt.Rows[i]["PriceShowId"]), Value = dt.Rows[i]["PriceShowformat"].ToString() }; result.Add(model); } return(result); }
public List <Id_ValueModel> PQTModel_Filler() { var result = new List <Id_ValueModel>(); PDBC db = new PDBC("PandaMarketCMS", true); db.Connect(); DataTable dt = db.Select("SELECT[id_PQT],[PQT_Demansion] FROM[tbl_Product_ProductQuantityType] order by([PQT_Demansion])"); for (int i = 0; i < dt.Rows.Count; i++) { var model = new Id_ValueModel() { Id = Convert.ToInt32(dt.Rows[i]["id_PQT"]), Value = dt.Rows[i]["PQT_Demansion"].ToString() }; result.Add(model); } return(result); }
public List <Id_ValueModel> OffTypeModel_Filler() { var result = new List <Id_ValueModel>(); PDBC db = new PDBC("PandaMarketCMS", true); db.Connect(); DataTable dt = db.Select("SELECT [OffType],[OffType_Symbol]FROM .[tbl_Product_OffType]"); for (int i = 0; i < dt.Rows.Count; i++) { var model = new Id_ValueModel() { Id = Convert.ToInt32(dt.Rows[i]["OffType"]), Value = dt.Rows[i]["OffType_Symbol"].ToString() }; result.Add(model); } return(result); }
public List <Id_ValueModel> MainTagsModel_Filler() { var result = new List <Id_ValueModel>(); PDBC db = new PDBC("PandaMarketCMS", true); db.Connect(); DataTable dt = db.Select("SELECT [id_MainStarTag],[MST_Name] FROM [tbl_Product_MainStarTags]"); for (int i = 0; i < dt.Rows.Count; i++) { var model = new Id_ValueModel() { Id = Convert.ToInt32(dt.Rows[i]["id_MainStarTag"]), Value = dt.Rows[i]["MST_Name"].ToString() }; result.Add(model); } return(result); }
public List <Id_ValueModel> TagsModel_Filler(int id) { var result = new List <Id_ValueModel>(); PDBC db = new PDBC("PandaMarketCMS", true); db.Connect(); DataTable dt = db.Select("SELECT [id_TE],[TE_name]FROM [tbl_Product_TagEnums] WHERE SubCatId=" + id); for (int i = 0; i < dt.Rows.Count; i++) { var model = new Id_ValueModel() { Id = Convert.ToInt32(dt.Rows[i]["id_TE"]), Value = dt.Rows[i]["TE_name"].ToString() }; result.Add(model); } return(result); }
public List <Id_ValueModel> DropFiller(string drop, int id = 0) { string query = ""; if (drop == "Type") { query = "SELECT [id_PT] as id ,[PTname] as [name] FROM [tbl_Product_Type] WHERE ISDelete=0 AND ISDESABLED=0"; } else if (drop == "MainCat") { if (id != 0) { query = "SELECT [id_MC] as id,[MCName] as [name] FROM[tbl_Product_MainCategory] WHERE ISDelete=0 AND ISDESABLED=0 AND id_PT=" + id; } } else if (drop == "SubCat") { if (id != 0) { query = "SELECT [id_SC] as id,[SCName] as [name] FROM [tbl_Product_SubCategory]WHERE ISDelete=0 AND ISDESABLED =0 AND id_MC=" + id; } } else if (drop == "SubCat_Key") { if (id != 0) { query = "SELECT [id_SCOK] as id,[SCOKName] as [name] FROM[tbl_Product_SubCategoryOptionKey]WHERE ISDelete=0 AND [ISDESABLED]=0 AND [id_SC]=" + id; } } else if (drop == "SubCat_Value") { if (id != 0) { query = "SELECT [id_SCOV] as id,[SCOVValueName] as [name] FROM[tbl_Product_SubCategoryOptionValue]WHERE[id_SCOK] = " + id; } } List <Id_ValueModel> result = new List <Id_ValueModel>(); if (!query.Equals("")) { PDBC db = new PDBC("PandaMarketCMS", true); db.Connect(); DataTable dt = db.Select(query); for (int i = 0; i < dt.Rows.Count; i++) { var maodel = new Id_ValueModel() { Id = Convert.ToInt32(dt.Rows[i]["id"]), Value = dt.Rows[i]["name"].ToString() }; result.Add(maodel); } } else { result.Add(new Id_ValueModel { Id = 0, Value = "انتخاب کنید" }); } return(result); }
public ActionResult test() { //PDBC db = new PDBC("PandaMarketCMS", true); //db.Connect(); //db.Script("DELETE FROM [tbl_Product_SubCategoryOptionKey]"); //DataTable dt = db.Select("SELECT [id_SC] FROM [tbl_Product_SubCategory]"); //for (int i = 0; i < dt.Rows.Count; i++) //{ // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionKey] VALUES(" + dt.Rows[i]["id_SC"] + ",N'تولید کننده',0,0,null,null)"); // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionKey] VALUES(" + dt.Rows[i]["id_SC"] + ",N'جنسیت',0,0,null,null)"); // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionKey] VALUES(" + dt.Rows[i]["id_SC"] + ",N'سایز',0,0,null,null)"); // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionKey] VALUES(" + dt.Rows[i]["id_SC"] + ",N'رنگ',0,0,null,null)"); // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionKey] VALUES(" + dt.Rows[i]["id_SC"] + ",N'نوع',0,0,null,null)"); // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionKey] VALUES(" + dt.Rows[i]["id_SC"] + ",N'جنس رویه',0,0,null,null)"); // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionKey] VALUES(" + dt.Rows[i]["id_SC"] + ",N'لایه داخلی',0,0,null,null)"); // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionKey] VALUES(" + dt.Rows[i]["id_SC"] + ",N'جنس زیره',0,0,null,null)"); // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionKey] VALUES(" + dt.Rows[i]["id_SC"] + ",N'حداقل میزان خرید',0,0,null,null)"); // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionKey] VALUES(" + dt.Rows[i]["id_SC"] + ",N'تعداد در کارتن',0,0,null,null)"); //} //string[] s1 = { "آبی ", " بژ ", " پسته ای ", " پلنگی ", " تکاوری ", " خاکی ", " زرشکی ", " زیتونی ", " سبز ", " سرخابی ", " سرمه ای ", " سفید ", " طلایی ", " فیروزه ای ", " فیلی ", " قرمز ", " قهوه ای- عسلی ", " کالباسی ", " کرم ", " کرم- سفید ", " کرم- قهوه ای ", " کویری ", " گردویی ", " گلبهی ", " لیمویی ", " مشکی- کلار ", " مشکی- آبی ", " مشکی- سبز ", " مشکی- طوسی ", " مشکی- طوسی- قرمز ", " مشکی- قرمز ", " نارنجی ", " نباتی ", " نسکافه ای ", " نوک مدادی ", " یاسی ", " الوان ", " طوسی ", " عسلی ", " قهوه ای ", " کاراملی ", " مشکی" }; //DataTable dt2 = db.Select("SELECT id_SCOK FROM [tbl_Product_SubCategoryOptionKey] where SCOKName LIKE N'رنگ'"); //for (int i = 0; i < dt2.Rows.Count; i++) //{ // for (int j = 0; j < s1.Length; j++) // { // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionValue] VALUES (" + dt2.Rows[i]["id_SCOK"] + ",N'" + s1[j] + "')"); // } //} //string[] s2 = { "مردانه ", " زنانه ", " پسرانه ", " دخترانه ", " اسپورت" }; //dt2 = db.Select("SELECT id_SCOK FROM [tbl_Product_SubCategoryOptionKey] where SCOKName LIKE N'جنسیت'"); //for (int i = 0; i < dt2.Rows.Count; i++) //{ // for (int j = 0; j < s2.Length; j++) // { // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionValue] VALUES (" + dt2.Rows[i]["id_SCOK"] + ",N'" + s2[j] + "')"); // } //} //string[] s3 = { "26 تا 31", "32 تا 36", "36 تا 40", "36 تا 41", "37 تا 40", "37 تا 41", "37 تا 42", "38", "38 تا 48", "39", "40", "40 تا 42", "40 تا 44", "40 تا 45", "40 تا 46", "41", "41 تا 45", "42", "42 تا 45", "43", "44", "45", "45 تا 47", "48 تا 48", "46", "47", "48" }; //dt2 = db.Select("SELECT id_SCOK FROM [tbl_Product_SubCategoryOptionKey] where SCOKName LIKE N'سایز'"); //for (int i = 0; i < dt2.Rows.Count; i++) //{ // for (int j = 0; j < s3.Length; j++) // { // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionValue] VALUES (" + dt2.Rows[i]["id_SCOK"] + ",N'" + s3[j] + "')"); // } //} //string[] s4 = { "بدون بند ", " بندی ", " بدون پد سیلیکونی ", " با پد سیلیکونی" }; //dt2 = db.Select("SELECT id_SCOK FROM [tbl_Product_SubCategoryOptionKey] where SCOKName LIKE N'نوع'"); //for (int i = 0; i < dt2.Rows.Count; i++) //{ // for (int j = 0; j < s4.Length; j++) // { // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionValue] VALUES (" + dt2.Rows[i]["id_SCOK"] + ",N'" + s4[j] + "')"); // } //} //string[] s5 = { "پارچه ای ", " چرم صنعتی ", " چرم طبیعی گاوی ", " فوم ", " کنف ", " نبوک طبیعی ", " فوم طرح چرم" }; //dt2 = db.Select("SELECT id_SCOK FROM [tbl_Product_SubCategoryOptionKey] where SCOKName LIKE N'جنس رویه'"); //for (int i = 0; i < dt2.Rows.Count; i++) //{ // for (int j = 0; j < s5.Length; j++) // { // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionValue] VALUES (" + dt2.Rows[i]["id_SCOK"] + ",N'" + s5[j] + "')"); // } //} //string[] s6 = { "فوم ", "چرم طبیعی بزی" }; //dt2 = db.Select("SELECT id_SCOK FROM [tbl_Product_SubCategoryOptionKey] where SCOKName LIKE N'لایه داخلی'"); //for (int i = 0; i < dt2.Rows.Count; i++) //{ // for (int j = 0; j < s6.Length; j++) // { // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionValue] VALUES (" + dt2.Rows[i]["id_SCOK"] + ",N'" + s6[j] + "')"); // } //} //string[] s7 = { "شهپر ", " شیما ", " پازین" }; //dt2 = db.Select("SELECT id_SCOK FROM [tbl_Product_SubCategoryOptionKey] where SCOKName LIKE N'تولید کننده'"); //for (int i = 0; i < dt2.Rows.Count; i++) //{ // for (int j = 0; j < s7.Length; j++) // { // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionValue] VALUES (" + dt2.Rows[i]["id_SCOK"] + ",N'" + s7[j] + "')"); // } //} //dt2 = db.Select("SELECT id_SCOK FROM [tbl_Product_SubCategoryOptionKey] where SCOKName LIKE N'جنس زیره'"); //string[] s8 = { "PU", "PU دو دانسیته", "TPU" }; //for (int i = 0; i < dt2.Rows.Count; i++) //{ // for (int j = 0; j < s8.Length; j++) // { // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionValue] VALUES (" + dt2.Rows[i]["id_SCOK"] + ",N'" + s8[j] + "')"); // } //} //dt2 = db.Select("SELECT id_SCOK FROM [tbl_Product_SubCategoryOptionKey] where SCOKName LIKE N'حداقل میزان خرید'"); //for (int i = 0; i < dt2.Rows.Count; i++) //{ // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionValue] VALUES (" + dt2.Rows[i]["id_SCOK"] + ",N'یک کارتن')"); //} //dt2 = db.Select("SELECT id_SCOK FROM [tbl_Product_SubCategoryOptionKey] where SCOKName LIKE N'تعداد در کارتن'"); //string[] s9 = { " 8 ", " 9 ", " 10 ", " 12 ", " 16 ", " 18 ", " 24 " }; //for (int i = 0; i < dt2.Rows.Count; i++) //{ // for (int j = 0; j < s9.Length; j++) // { // db.Script("INSERT INTO [tbl_Product_SubCategoryOptionValue] VALUES (" + dt2.Rows[i]["id_SCOK"] + ",N'" + s9[j] + "')"); // } //} var model = new Id_ValueModel() { Id = 1, Value = "hello" }; return(Json(model)); }