public ActionResult UpdateCustomerPass(string CurrentPass, string Pass)
{
if (HttpContext.Request.Cookies[StaticLicense.LicName + "Active"] != null)
{
string SSSession = "";
HttpCookie cookie = HttpContext.Request.Cookies.Get(StaticLicense.LicName + "Active");
if (cookie != null)
{
Encryption ENC = new Encryption();
SSSession = ENC.DecryptText(cookie.Value, "OMD_Token");
ActivationModel act = JsonConvert.DeserializeObject <ActivationModel>(SSSession);
PDBC db = new PDBC("PandaMarketCMS", true);
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters()
{
_KEY = "@CurrentPass",
_VALUE = ENC.MD5Hash(CurrentPass)
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@Pass",
_VALUE = ENC.MD5Hash(Pass)
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@CustomerId",
_VALUE = act.CustomerId
};
parss.Add(par);
db.Connect();
if (Convert.ToInt32(db.Select("SELECT COUNT(*) FROM [tbl_Customer_Main] WHERE id_Customer= @CustomerId AND C_Password = @CurrentPass", parss).Rows[0][0]) != 0)
{
db.Script("UPDATE [tbl_Customer_Main] SET[C_Password] =@Pass WHERE id_Customer= @CustomerId", parss);
db.DC();
return(Content("Success"));
}
else
{
db.DC();
return(Content("WrongPass"));
}
}
else
{
return(Content("Error"));
}
}
else
{
return(Content("Login"));
}
}
public List <PostModel> UserPostModels(string Cat, int Page, int Id, string search, string DateType = "Date")
{
var res = new List <PostModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select(QueryMaker_BlogPost(Cat, Page, Id, search));
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new PostModel()
{
Id = Convert.ToInt32(dt.Rows[i]["Id"]),
by = dt.Rows[i]["adminName"].ToString(),
Category = dt.Rows[i]["Category"].ToString(),
InGroup = dt.Rows[i]["GroupName"].ToString(),
GPIDforPostPAge = dt.Rows[i]["GroupId"].ToString(),
ImagePath = AppendServername(dt.Rows[i]["Pic"].ToString()),
IsDeleted = Convert.ToInt32(dt.Rows[i]["Is_Deleted"]),
IsDisabled = Convert.ToInt32(dt.Rows[i]["Is_Disabled"]),
text = dt.Rows[i]["Text"].ToString(),
title = dt.Rows[i]["Title"].ToString(),
text_min = dt.Rows[i]["Text_min"].ToString(),
date = DateReturner(dt.Rows[i]["Date"].ToString(), DateType),
AdminPic = AppendServername(dt.Rows[i]["AdminPic"].ToString()),
PostType = dt.Rows[i]["TypeId"].ToString()
};
res.Add(model);
}
return(res);
}
public void AddNewTemplate(string TempName, string Html)
{
PDBC db = new PDBC("DBConnectionString", true);
db.Connect();
db.Script("INSERT INTO [dbo].[EmailTemplate_tbl]VALUES('" + TempName + "','" + Html + "')");
}
public List <Key_ValueModel> SubCat_Value(string SCOKID)
{
List <Key_ValueModel> result = new List <Key_ValueModel>();
PDBC db = new PDBC();
ExcParameters par = new ExcParameters()
{
_KEY = "@SCOKID",
_VALUE = SCOKID
};
List <ExcParameters> pAs = new List <ExcParameters>();
pAs.Add(par);
db.Connect();
using (DataTable dt = db.Select("SELECT [id_SCOV] as id,[SCOVValueName] as [name] FROM [tbl_Product_SubCategoryOptionValue] WHERE[id_SCOK] = @SCOKID", pAs))
{
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var maodel = new Key_ValueModel()
{
Id = Convert.ToInt32(dt.Rows[i]["id"]),
Value = dt.Rows[i]["name"].ToString()
};
result.Add(maodel);
}
}
return(result);
}
public List <CategoryModel> Blog_TagTable()
{
var res = new List <CategoryModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT A.[Id],A.[Name],A.[CtegoryId],A.[Is_Disabled],A.[Is_Deleted],B.[Name] as CatName FROM [tbl_BLOG_Tags] as A inner join [tbl_BLOG_Categories] as B on A.CtegoryId=B.Id");
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new CategoryModel()
{
Num = i + 1,
Id = Convert.ToInt32(dt.Rows[i]["Id"]),
Name = dt.Rows[i]["Name"].ToString(),
Deleted = Convert.ToInt32(dt.Rows[i]["Is_Deleted"]),
Disabled = Convert.ToInt32(dt.Rows[i]["Is_Disabled"]),
CatId = Convert.ToInt32(dt.Rows[i]["CtegoryId"]),
Category = dt.Rows[i]["CatName"].ToString()
};
res.Add(model);
}
return(res);
}
public List <ProGroupModel> SubCatTbl()
{
var res = new List <ProGroupModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT C.id_SC,B.PTname,A.MCName,C.ISDelete,C.ISDESABLED,C.SCName FROM [tbl_Product_MainCategory] as A inner join [tbl_Product_Type] as B on A.id_PT=B.id_PT inner join [tbl_Product_SubCategory] as C on A.id_MC=C.id_MC");
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new ProGroupModel()
{
Num = i + 1,
Id = Convert.ToInt32(dt.Rows[i]["id_SC"]),
IsDeleted = Convert.ToInt32(dt.Rows[i]["ISDelete"]),
IsDisables = Convert.ToInt32(dt.Rows[i]["ISDESABLED"]),
Type = dt.Rows[i]["PTname"].ToString(),
Main = dt.Rows[i]["MCName"].ToString(),
Sub = dt.Rows[i]["SCName"].ToString()
};
res.Add(model);
}
return(res);
}
public List <ProGroupModel> TagsTbl()
{
var res = new List <ProGroupModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT D.id_TE,B.PTname,A.MCName,C.SCName,D.TE_name FROM [tbl_Product_MainCategory] as A inner join [tbl_Product_Type] as B on A.id_PT=B.id_PT inner join [tbl_Product_SubCategory] as C on A.id_MC=C.id_MC inner join [tbl_Product_TagEnums] as D on C.id_SC=D.SubCatId");
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new ProGroupModel()
{
Num = i + 1,
Id = Convert.ToInt32(dt.Rows[i]["id_TE"]),
Type = dt.Rows[i]["PTname"].ToString(),
Main = dt.Rows[i]["MCName"].ToString(),
Sub = dt.Rows[i]["SCName"].ToString(),
SubK = dt.Rows[i]["TE_name"].ToString(),
};
res.Add(model);
}
return(res);
}
public ActionResult GetUser(CustomerStruct viewModel)
{
//INSERT INTO [tblUsers]([id],[un],[password]) VALUES (1111,@un,@password)
if (ModelState.IsValid)
{
PDBC db = new PDBC("MVCCNS", true);
List <ExcParameters> paramss = new List <ExcParameters>();
ExcParameters parameters = new ExcParameters()
{
_KEY = "@password",
_VALUE = viewModel.password
};
paramss.Add(parameters);
parameters = new ExcParameters()
{
_KEY = "@un",
_VALUE = viewModel.name
};
paramss.Add(parameters);
db.Connect();
string res = db.Script("INSERT INTO [tblUsers]([id],[un],[password]) VALUES (1111,@un,@password)", paramss);
return(Content(res));
}
else
{
ModelState.Values.ToString();
return(Content("0"));
}
}
public string Add_Update_AdType_(string ActToDo, string Ad_Name, string Routes, int id = 0)
{
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
if (ActToDo == "insert")
{
string Ad_id_ = db.Script("INSERT INTO [tbl_ADMIN_types] output inserted.ad_typeID VALUES(N'" + Ad_Name + "')");
var ids = Routes.Split(',');
for (int i = 0; i < ids.Length; i++)
{
db.Script("INSERT INTO [tbl_ADMIN_types_ruleRoute_Connection] VALUES(" + Ad_id_ + "," + ids[i] + ",1)");
}
}
else if (ActToDo == "update")
{
db.Script("UPDATE[tbl_ADMIN_types] SET [ad_type_name] =N'" + Ad_Name + "' WHERE ad_typeID=" + id);
db.Script("DELETE FROM [tbl_ADMIN_types_ruleRoute_Connection] WHERE ad_typeID=" + id);
var ids = Routes.Split(',');
for (int i = 0; i < ids.Length; i++)
{
db.Script("INSERT INTO [tbl_ADMIN_types_ruleRoute_Connection] VALUES(" + id + "," + ids[i] + ",1)");
}
}
return("success");
}
public ActionResult SmsRegister(string MobileNum, string Pass)
{
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
if (Convert.ToInt32(db.Select("SELECT COUNT(*) FROM [tbl_Customer_Main] WHERE C_Mobile LIKE N'" + MobileNum + "'").Rows[0][0]) == 0)
{
Encryption ENC = new Encryption();
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters()
{
_KEY = "@Mobile",
_VALUE = MobileNum
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@PassWord",
_VALUE = ENC.MD5Hash(Pass)
};
parss.Add(par);
int UserId = Convert.ToInt32(db.Script("INSERT INTO [tbl_Customer_Main] OUTPUT inserted.id_Customer VALUES(GETDATE(),@Mobile,N'',N'',N'',0,0,NULL,@PassWord)", parss));
Random generator = new Random();
string GeneratedCode = generator.Next(100000, 999999).ToString("D6");
parss = new List <ExcParameters>();
par = new ExcParameters()
{
_KEY = "@id_Customer",
_VALUE = UserId
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@sms_irKeyType",
_VALUE = 2
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@sms_irSentKey",
_VALUE = GeneratedCode
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@sms_irIsKeyAlive",
_VALUE = 1
};
parss.Add(par);
string result = db.Script("INSERT INTO [dbo].[tbl_sms_ir_CustomerKeys]([id_Customer],[sms_irKeyType],[sms_irSentKey],[sms_irKeyGeneratedDate],[sms_irIsKeyAlive]) VALUES(@id_Customer ,@sms_irKeyType ,@sms_irSentKey ,GETDATE(),@sms_irIsKeyAlive)", parss);
SMS_ir sms = new SMS_ir();
db.DC();
return(Json(sms.SendVerificationCodeWithTemplate(UserId, "VelvetRegister", 2)));
}
else
{
db.DC();
return(Content("Reapited Num"));
}
}
public ActionResult Show_Profile()
{
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
var id_Admin = Session["id_Admin"];
using (DataTable dt = db.Select($"SELECT [id_Admin],[ad_type_name],[ad_password],[ad_firstname],[ad_lastname],[ad_avatarprofile],[ad_email],[ad_phone],[ad_mobile],[ad_NickName]FROM [dbo].[tbl_ADMIN_main] inner join [dbo].[tbl_ADMIN_types] on [dbo].[tbl_ADMIN_main].ad_typeID = [dbo].[tbl_ADMIN_types].ad_typeID where [id_Admin] ={id_Admin.ToString()}"))
{
db.DC();
Session["pass"] = dt.Rows[0]["ad_password"].ToString();
profile data_pro = new profile()
{
ad_avatarprofile = dt.Rows[0]["ad_avatarprofile"].ToString(),
ad_type_name = dt.Rows[0]["ad_type_name"].ToString(),
ad_firstname = dt.Rows[0]["ad_firstname"].ToString(),
ad_lastname = dt.Rows[0]["ad_lastname"].ToString(),
ad_NickName = dt.Rows[0]["ad_NickName"].ToString(),
ad_phone = dt.Rows[0]["ad_phone"].ToString(),
ad_mobile = dt.Rows[0]["ad_mobile"].ToString(),
ad_email = dt.Rows[0]["ad_email"].ToString()
};
ViewBag.Show_Pro = data_pro;
};
return(View());
}
public ActionResult AddToFavorite(int Id, int CustomerId)
{
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
Encryption ENC = new Encryption();
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters()
{
_KEY = "@UId",
_VALUE = CustomerId
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@ProId",
_VALUE = Id
};
parss.Add(par);
if (db.Select("SELECT [CustomerId],[ProductId] FROM [tbl_Customer_Favorites] where [CustomerId]=@UId AND ProductId=@ProId", parss).Rows.Count == 0)
{
db.Script("INSERT INTO [tbl_Customer_Favorites]([CustomerId],[ProductId])VALUES(@UId,@ProId)", parss);
db.DC();
return(Content("1"));
}
else
{
db.Script("DELETE FROM [tbl_Customer_Favorites]WHERE CustomerId=@UId AND ProductId=@ProId", parss);
db.DC();
return(Content("0"));
}
}
public ActionResult CheckCode(int UId, string Code)
{
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT [C_ActivationToken] FROM [tbl_Customer_Main] where id_Customer = " + UId);
if (dt.Rows.Count != 0)
{
string token = dt.Rows[0][0].ToString();
if (token == Code)
{
db.DC();
return(Content("Success"));
}
else
{
db.DC();
return(Content("Wrong Code"));
}
}
else
{
db.DC();
return(Content("User Not Found"));
}
}
public ActionResult GetCustomerAddress()
{
if (HttpContext.Request.Cookies[StaticLicense.LicName + "Active"] != null)
{
string SSSession = "";
HttpCookie cookie = HttpContext.Request.Cookies.Get(StaticLicense.LicName + "Active");
if (cookie != null)
{
Encryption ENC = new Encryption();
SSSession = ENC.DecryptText(cookie.Value, "OMD_Token");
ActivationModel act = JsonConvert.DeserializeObject <ActivationModel>(SSSession);
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
List <ExcParameters> parss = new List <ExcParameters>();
D_APIModelFiller DMF = new D_APIModelFiller();
return(Json(DMF.CustomerAddresses(Convert.ToInt32(act.CustomerId))));
}
else
{
return(Content("Error"));
}
}
else
{
return(Content("Login"));
}
}
public string Add_Update_ProType(string Action, string Name, int id = 0)
{
PDBC db = new PDBC("PandaMarketCMS", true);
List <ExcParameters> paramss = new List <ExcParameters>();
ExcParameters parameters;
parameters = new ExcParameters()
{
_KEY = "@PTname",
_VALUE = Name
};
paramss.Add(parameters);
parameters = new ExcParameters()
{
_KEY = "@id_P",
_VALUE = id
};
paramss.Add(parameters);
db.Connect();
if (Action == "insert")
{
db.Script("INSERT INTO [tbl_Product_Type]([PTname],[ISDESABLED],[ISDelete])VALUES(@PTname,0,0)", paramss);
}
else if (Action == "Update")
{
db.Script("UPDATE [tbl_Product_Type] SET [PTname] = @PTname WHERE id_PT =@id_P", paramss);
}
db.DC();
return("Success");
}
public List <TableModel> SCVModel(int id)
{
var result = new List <TableModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt;
if (id == 0)
{
dt = db.Select("SELECT A.id_SCOV, A.SCOVValueName , B.SCOKName FROM [tbl_Product_SubCategoryOptionValue]as A inner join [tbl_Product_SubCategoryOptionKey] as B On A.id_SCOK=B.id_SCOK Where B.ISDelete=0 AND B.ISDESABLED=0");
}
else
{
dt = db.Select("SELECT A.id_SCOV, A.SCOVValueName , B.SCOKName FROM [tbl_Product_SubCategoryOptionValue]as A inner join [tbl_Product_SubCategoryOptionKey] as B On A.id_SCOK=B.id_SCOK Where B.ISDelete=0 AND B.ISDESABLED=0 AND A.id_SCOK=" + id);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new TableModel()
{
Num = i + 1,
Id = Convert.ToInt32(dt.Rows[i]["id_SCOV"]),
Group1 = dt.Rows[i]["SCOVValueName"].ToString(),
Group2 = dt.Rows[i]["SCOKName"].ToString()
};
result.Add(model);
}
return(result);
}
public List <ProGroupModel> TypeTbl()
{
var res = new List <ProGroupModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT [id_PT],[PTname],[ISDESABLED],[ISDelete]FROM [tbl_Product_Type]");
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new ProGroupModel()
{
Num = i + 1,
Id = Convert.ToInt32(dt.Rows[i]["id_PT"]),
IsDeleted = Convert.ToInt32(dt.Rows[i]["ISDelete"]),
IsDisables = Convert.ToInt32(dt.Rows[i]["ISDESABLED"]),
Type = dt.Rows[i]["PTname"].ToString()
};
res.Add(model);
}
return(res);
}
public List <TableModel> Tags(int SubId)
{
var result = new List <TableModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt;
if (SubId == 0)
{
dt = db.Select("SELECT [id_TE],[TE_name],B.SCName FROM [tbl_Product_TagEnums] as A inner join [tbl_Product_SubCategory] as B On A.SubCatId=B.id_SC WHERE B.ISDelete=0 AND B.ISDESABLED=0 ");
}
else
{
dt = db.Select("SELECT [id_TE],[TE_name],B.SCName FROM [tbl_Product_TagEnums] as A inner join [tbl_Product_SubCategory] as B On A.SubCatId=B.id_SC WHERE B.ISDelete=0 AND B.ISDESABLED=0 AND A.SubCatId=" + SubId);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new TableModel()
{
Num = i + 1,
Id = Convert.ToInt32(dt.Rows[i]["id_TE"]),
Group1 = dt.Rows[i]["TE_name"].ToString(),
Group2 = dt.Rows[i]["SCName"].ToString()
};
result.Add(model);
}
return(result);
}
public List <ProGroupModel> SubCatvValueTbl()
{
var res = new List <ProGroupModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT E.id_SCOV,B.PTname,A.MCName,C.SCName,D.SCOKName,E.SCOVValueName FROM [tbl_Product_MainCategory] as A inner join [tbl_Product_Type] as B on A.id_PT=B.id_PT inner join [tbl_Product_SubCategory] as C on A.id_MC=C.id_MC inner join [tbl_Product_SubCategoryOptionKey] as D on C.id_SC=D.id_SC inner join [tbl_Product_SubCategoryOptionValue] as E on D.id_SCOK=E.id_SCOK");
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new ProGroupModel()
{
Num = i + 1,
Id = Convert.ToInt32(dt.Rows[i]["id_SCOV"]),
Type = dt.Rows[i]["PTname"].ToString(),
Main = dt.Rows[i]["MCName"].ToString(),
Sub = dt.Rows[i]["SCName"].ToString(),
SubK = dt.Rows[i]["SCOKName"].ToString(),
SubVal = dt.Rows[i]["SCOVValueName"].ToString()
};
res.Add(model);
}
return(res);
}
public UpdateProModel UpdateProFiller(int id)
{
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT [id_MProduct],[Description],[Title],[Seo_Description],[Seo_KeyWords],[IS_AD],[Search_Gravity] FROM [tbl_Product] where id_MProduct=" + id);
var res = new UpdateProModel()
{
Id = Convert.ToInt32(dt.Rows[0]["id_MProduct"]),
Title = dt.Rows[0]["Title"].ToString(),
Description = dt.Rows[0]["Description"].ToString(),
SEO_keyword = dt.Rows[0]["Seo_KeyWords"].ToString(),
SEO_Description = dt.Rows[0]["Seo_Description"].ToString(),
SearchGravity = Convert.ToInt32(dt.Rows[0]["Search_Gravity"]),
IsAd = dt.Rows[0]["IS_AD"].ToString()
};
DataTable dt2 = db.Select("SELECT [PicID] FROM [tbl_Product_PicConnector] where id_MProduct=" + id);
string s = "";
for (int i = 0; i < dt2.Rows.Count; i++)
{
s += dt2.Rows[i]["PicID"] + ",";
}
res.Pics = s;
return(res);
}
public List <TableModel> MainTagsTbl()
{
var res = new List <TableModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT [id_MainStarTag],[MST_Description],[MST_Name] FROM [tbl_Product_MainStarTags]");
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new TableModel()
{
Num = i + 1,
Id = Convert.ToInt32(dt.Rows[i]["id_MainStarTag"]),
Group1 = dt.Rows[i]["MST_Name"].ToString(),
Group2 = dt.Rows[i]["MST_Description"].ToString()
};
res.Add(model);
}
return(res);
}
public List <AdminTypeTbl_Model> AdminTypeTbl()
{
var res = new List <AdminTypeTbl_Model>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt1 = db.Select("SELECT [ad_typeID],[ad_type_name] FROM [tbl_ADMIN_types]");
for (int i = 0; i < dt1.Rows.Count; i++)
{
DataTable dt2 = db.Select("SELECT [rulerouteID]FROM [tbl_ADMIN_types_ruleRoute_Connection] where HasAccess=1 and [ad_typeID]=" + dt1.Rows[i]["ad_typeID"]);
StringBuilder s = new StringBuilder();
for (int j = 0; j < dt2.Rows.Count; j++)
{
s.Append(dt2.Rows[j]["rulerouteID"]);
s.Append(",");
}
var model = new AdminTypeTbl_Model()
{
TypeId = Convert.ToInt32(dt1.Rows[i]["ad_typeID"]),
AT_Name = dt1.Rows[i]["ad_type_name"].ToString(),
EditString = s.ToString(),
Num = i + 1
};
res.Add(model);
}
return(res);
}
public List <CategoryModel> Blog_GroupTable()
{
var res = new List <CategoryModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT [G_Id],[name],[Is_Disabled],[Is_Deleted],[GpToken] FROM [tbl_BLOG_Groups]");
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new CategoryModel()
{
Num = i + 1,
Id = Convert.ToInt32(dt.Rows[i]["G_Id"]),
Name = dt.Rows[i]["name"].ToString(),
Deleted = Convert.ToInt32(dt.Rows[i]["Is_Deleted"]),
Disabled = Convert.ToInt32(dt.Rows[i]["Is_Disabled"]),
Category = dt.Rows[i]["GpToken"].ToString()
};
res.Add(model);
}
return(res);
}
// GET: AdministratorUploader
public ActionResult Gallery()
{
ImageGalleryModelView model = new ImageGalleryModelView();
model.imgs = new List <ImageGalleryModel>();
PDBC db = new PDBC();
db.Connect();
using (DataTable dt = db.Select("SELECT [thumUploadAddress],[CreatedDate],[Descriptions],[uploadPicName],[alt],[ISDELETE],[PicCategoryType],[PicID],[orgPicID],[orgUploadAddress] FROM [imageView] WHERE ISDELETE != 1 ORDER BY [savedCode] DESC"))
{
for (int i = 0; i < dt.Rows.Count; i++)
{
model.imgs.Add(new ImageGalleryModel()
{
alt = dt.Rows[i]["alt"].ToString(),
CreatedDate = dt.Rows[i]["CreatedDate"].ToString(),
Descriptions = dt.Rows[i]["Descriptions"].ToString(),
ISDELETE = dt.Rows[i]["ISDELETE"].ToString(),
orgPicID = dt.Rows[i]["orgPicID"].ToString(),
orgUploadAddress = dt.Rows[i]["orgUploadAddress"].ToString(),
PicCategoryType = dt.Rows[i]["PicCategoryType"].ToString(),
PicID = dt.Rows[i]["PicID"].ToString(),
thumUploadAddress = dt.Rows[i]["thumUploadAddress"].ToString(),
uploadPicName = dt.Rows[i]["uploadPicName"].ToString()
});
}
}
return(View(model));
}
public List <PostModel> Posttable()
{
var res = new List <PostModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT [Id],[Title],[GroupId],[Text_min],[Text],(SELECT [ad_firstname]+ ' '+ [ad_lastname] as name FROM [tbl_ADMIN_main]where id_Admin=[WrittenBy_AdminId])as adminName ,[Date],[IsImportant],[Is_Deleted],[Is_Disabled],(SELECT [name]FROM [tbl_BLOG_Categories] where Id=[Cat_Id]) as Category,(SELECT [name]FROM [tbl_BLOG_Groups] where G_Id=[GroupId]) as GroupName,(SELECT top 1 B.PicAddress FROM [tbl_BLOG_Pic_Connector] as A inner join [tbl_ADMIN_UploadStructure_ImageAddress] as B on A.[PicId]=B.PicID where A.PostId=Id)as Pic FROM [tbl_BLOG_Post] order by(date)desc");
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
DateTime date = Convert.ToDateTime(dt.Rows[i]["Date"]);
PersianDateTime persianDateTime = new PersianDateTime(date);
var model = new PostModel()
{
Id = Convert.ToInt32(dt.Rows[i]["Id"]),
by = dt.Rows[i]["adminName"].ToString(),
Category = dt.Rows[i]["Category"].ToString(),
InGroup = dt.Rows[i]["GroupName"].ToString(),
ImagePath = AppendServername(dt.Rows[i]["Pic"].ToString()),
IsDeleted = Convert.ToInt32(dt.Rows[i]["Is_Deleted"]),
IsDisabled = Convert.ToInt32(dt.Rows[i]["Is_Disabled"]),
text = dt.Rows[i]["Text"].ToString(),
title = dt.Rows[i]["Title"].ToString(),
text_min = dt.Rows[i]["Text_min"].ToString(),
date = persianDateTime.ToLongDateString(),
GPIDforPostPAge = dt.Rows[i]["GroupId"].ToString()
};
res.Add(model);
}
return(res);
}
private List <tbl_BLOG> list_comm(string id)
{
PDBC db = new PDBC("PandaMarketCMS", true);
List <tbl_BLOG> List_BLG = new List <tbl_BLOG>();
string query = "SELECT [Id],[message],[Name],[PostId],[ImagePath],[Date]";
query += "FROM [tbl_BLOG_Comment] where[PostId] = " + id + "order by Id desc";
db.Connect();
DataTable dt = db.Select(query);
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
tbl_BLOG BLG = new tbl_BLOG();
BLG.Id = Convert.ToInt32(dt.Rows[0]["Id"]);
BLG.message = dt.Rows[i]["message"].ToString();
BLG.name = dt.Rows[i]["Name"].ToString();
BLG.Date = dt.Rows[i]["Date"].ToString();
BLG.ImagePath = dt.Rows[i]["ImagePath"].ToString();
List_BLG.Add(BLG);
}
return(List_BLG);
}
public ActionResult MyAccount()
{
HttpCookie reqCookies = Request.Cookies["Cookies"];
string C_Mobile, C_Password;
if (reqCookies != null)
{
C_Mobile = reqCookies["C_Mobile"].ToString();
C_Password = reqCookies["C_Password"].ToString();
PDBC dbo = new PDBC("PandaMarketCMS", true);
string query;
query = "SELECT [id_Customer],[C_Mobile],[C_Password]FROM[PandaMarketCMS].[dbo].[tbl_Customer_Main]";
query += $" where[C_Mobile] = N'{C_Mobile}' AND [C_Password] = N'{C_Password}'";
dbo.Connect();
using (DataTable dt = dbo.Select(query))
{
if (dt.Rows.Count > 0)
{
tbl_Customer_Main data = new tbl_Customer_Main()
{
id_Customer = dt.Rows[0]["id_Customer"].ToString()
};
Session["d1"] = data;
return(Redirect("???????"));
}
}
}
return(View());
}
public List <tbl_BLOG> Pic_BLOG(string id)
{
List <tbl_BLOG> List_BLG = new List <tbl_BLOG>();
PDBC db = new PDBC("PandaMarketCMS", true);
string query = "SELECT distinct [PostId],[PicSizeType],[PicAddress],[PicThumbnailAddress]";
query += "FROM [tbl_ADMIN_UploadStructure_ImageAddress]inner join [tbl_BLOG_Pic_Connector]";
query += " on [tbl_BLOG_Pic_Connector].PicId =[tbl_ADMIN_UploadStructure_ImageAddress].PicID ";
query += $" where PostId ={id}";
db.Connect();
using (DataTable dt = db.Select(query))
{
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
tbl_BLOG BLG = new tbl_BLOG();
BLG.PicId = id;
BLG.PicSizeType = dt.Rows[i]["PicSizeType"].ToString();
BLG.PicAddress = dt.Rows[i]["PicAddress"].ToString();
BLG.PicThumbnailAddress = dt.Rows[i]["PicThumbnailAddress"].ToString();
List_BLG.Add(BLG);
}
}
return(List_BLG);
}
public ActionResult AddCustomerAddress(string CityId, string FullAddress, string CodePosti)
{
tbl_Customer_Main tcm = new tbl_Customer_Main();
var coockie = HttpContext.Request.Cookies.Get(ProjectProperies.AuthCustomerCode());
if (coockie != null)
{
tcm = CoockieController.SayWhoIsHE(coockie.Value);
var Id = tcm.id_Customer;
PDBC db = new PDBC();
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters()
{
_KEY = "@Id",
_VALUE = Id
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@CityId",
_VALUE = CityId
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@FullAddress",
_VALUE = FullAddress
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@CodePosti",
_VALUE = CodePosti
};
parss.Add(par);
db.Connect();
string result = db.Script("INSERT INTO [tbl_Customer_Address]([id_Customer],[ID_Shahr],[C_AddressHint],[C_FullAddress])VALUES(@Id,@CityId,@CodePosti,@FullAddress)", parss);
db.DC();
if (result == "1")
{
return(Content("Success"));
}
else
{
return(Content("Error"));
}
}
else
{
return(Content("Error"));
}
}
public List <List <AddPor_page4_Model> > ListMaker(string json)
{
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
var result = new List <List <AddPor_page4_Model> >();
var JsonList = JsonConvert.DeserializeObject <List <OptionsJsonModel> >(json);
foreach (var item in JsonList)
{
var m = new List <AddPor_page4_Model>();
foreach (var Ids_itm in item.Ids.Split(','))
{
var m2 = new AddPor_page4_Model()
{
OptionKey_Id = item.MainId,
ValId = Convert.ToInt32(Ids_itm),
OptionValue = db.Select("SELECT [SCOVValueName] FROM [tbl_Product_SubCategoryOptionValue]where id_SCOV=" + Ids_itm).Rows[0][0].ToString()
};
m.Add(m2);
}
result.Add(m);
}
db.DC();
return(result);
}
