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