public string DeleteMember(int M_Id)
{
string s = "";
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters
{
_KEY = "@T_Id",
_VALUE = M_Id
};
parss.Add(par);
base.Connect();
s += base.Script("UPDATE [tbl_TeamMembers] SET [Deleted] = 1 WHERE T_Id= @T_Id ", parss);
base.DC();
if (s == "1")
{
return("Success");
}
else
{
return("fail");
}
}
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 DeletePortfolio(int P_Id)
{
string s = "";
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters
{
_KEY = "@P_Id",
_VALUE = P_Id
};
parss.Add(par);
base.Connect();
s += base.Script("UPDATE [tbl_Portfolio] SET [Deleted] = 1 WHERE P_Id= @P_Id ", parss);
base.DC();
if (s == "1")
{
return("Success");
}
else
{
return("fail");
}
}
public ActionResult SCKPage(string action, string value, string id, string data_SCK)
{
string query_new, query_edit;
string res = " ";
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
List <ExcParameters> paramss = new List <ExcParameters>();
ExcParameters parameters = new ExcParameters();
if (action == "new")
{
query_new = "INSERT INTO [tbl_Product_SubCategoryOptionKey]([id_SC],[SCOKName],[ISDESABLED],[ISDelete])VALUES(@data_SCK,@value,0,0)";
parameters = new ExcParameters()
{
_KEY = "@value",
_VALUE = value
};
paramss.Add(parameters);
parameters = new ExcParameters()
{
_KEY = "@data_SCK",
_VALUE = data_SCK
};
paramss.Add(parameters);
res = db.Script(query_new, paramss);
}
else if (action == "edit")
{
query_edit = "UPDATE [tbl_Product_SubCategoryOptionKey] SET [SCOKName] = @value WHERE id_SCOK =@id";
parameters = new ExcParameters()
{
_KEY = "@id",
_VALUE = id
};
paramss.Add(parameters);
parameters = new ExcParameters()
{
_KEY = "@value",
_VALUE = value
};
paramss.Add(parameters);
res = db.Script(query_edit, paramss);
}
return(Content(res));
}
public bool saveIMG(string name, string lable, string desc, string webAddress, string absolutepath)
{
List <ExcParameters> parms = new List <ExcParameters>();
ExcParameters par = new ExcParameters()
{
_KEY = "@PicAddress",
_VALUE = webAddress
};
parms.Add(par);
par = new ExcParameters()
{
_KEY = "@PicName",
_VALUE = name
};
parms.Add(par);
par = new ExcParameters()
{
_KEY = "@PicLable",
_VALUE = lable
};
parms.Add(par);
par = new ExcParameters()
{
_KEY = "@PicDescription",
_VALUE = desc
};
parms.Add(par);
par = new ExcParameters()
{
_KEY = "@PicabsolutePath",
_VALUE = absolutepath
};
parms.Add(par);
par = new ExcParameters()
{
_KEY = "@PicThumbnailabsolutePath",
_VALUE = absolutepath
};
parms.Add(par);
par = new ExcParameters()
{
_KEY = "@PicThumbnailAddress",
_VALUE = webAddress
};
parms.Add(par);
base.Connect();
string res = base.Script("INSERT INTO [tbl_PicUploader] ([PicAddress] ,[PicThumbnailAddress] ,[PicName] ,[PicLable] ,[PicDescription] ,[CanDelete] ,[PicabsolutePath] ,[PicThumbnailabsolutePath]) VALUES (@PicAddress ,@PicThumbnailAddress ,@PicName ,@PicLable ,@PicDescription ,1 ,@PicabsolutePath ,@PicThumbnailabsolutePath )", parms);
base.DC();
if (res == "1")
{
return(true);
}
else
{
return(false);
}
}
public string DeActiveMail(int MailId)
{
string s = "";
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters
{
_KEY = "@M_Id",
_VALUE = MailId
};
parss.Add(par);
base.Connect();
DataTable dt = base.Select("SELECT [EmailAddress] FROM [tbl_Newsletter] WHERE Mail_Id= @M_Id", parss);
if (dt.Rows.Count != 0)
{
s += base.Script("UPDATE [tbl_Newsletter] SET [IsActive] = 0 WHERE Mail_Id=@M_Id", parss);
}
base.DC();
if (s == "1")
{
return("Success");
}
else
{
return("fail");
}
}
public string DeActiveService(int S_Id)
{
string s = "";
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters
{
_KEY = "@S_Id",
_VALUE = S_Id
};
parss.Add(par);
base.Connect();
s += base.Script("UPDATE [tbl_Services] SET [Active] = 0 WHERE S_Id= @S_Id ", parss);
base.DC();
if (s == "1")
{
return("Success");
}
else
{
return("fail");
}
}
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 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 string DeletePic_Clients(int PicId)
{
string s = "";
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters
{
_KEY = "@P_Id",
_VALUE = PicId
};
parss.Add(par);
base.Connect();
DataTable dt = base.Select("SELECT [PicId] ,[PicUseAs] FROM [tbl_PicUse] where PicId=@P_Id AND PicUseAs LIKE N'OurClients'", parss);
if (dt.Rows.Count != 0)
{
s += base.Script("DELETE FROM [tbl_PicUse] WHERE PicId=@P_Id AND PicUseAs LIKE N'OurClients'", parss);
}
base.DC();
if (s == "1")
{
return("Success");
}
else
{
return("fail");
}
}
public string AddPic_Clients(List <int> PicId)
{
string s = "";
List <ExcParameters> parss;
ExcParameters par;
base.Connect();
DataTable dt;
for (int i = 0; i < PicId.Count; i++)
{
parss = new List <ExcParameters>();
par = new ExcParameters
{
_KEY = "@P_Id",
_VALUE = PicId[i]
};
parss.Add(par);
dt = base.Select("SELECT [PicId] ,[PicUseAs] FROM [tbl_PicUse] where PicId=@P_Id AND PicUseAs LIKE N'OurClients'", parss);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_PicUse] ([PicId],[PicUseAs]) VALUES(@P_Id,N'OurClients')", parss);
}
}
base.DC();
return("Success");
}
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 <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 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 string AddNewsLetter(string Email)
{
string s = "";
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters
{
_KEY = "@Email",
_VALUE = Email
};
parss.Add(par);
base.Connect();
if (base.Select("SELECT [Mail_Id] FROM [tbl_Newsletter] where [EmailAddress]=@Email", parss).Rows.Count != 0)
{
s = base.Script("INSERT INTO [tbl_Newsletter]([EmailAddress],[Date],[IsActive])VALUES(@Email,GETDATE(),1)", parss);
base.DC();
if (s == "1")
{
return("Success");
}
else
{
return("Fail");
}
}
else
{
return("repeated");
}
}
public string SeenMessage(int MessageId)
{
string s = "";
base.Connect();
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters
{
_KEY = "@M_Id",
_VALUE = MessageId
};
parss.Add(par);
DataTable dt = base.Select("SELECT [Name] FROM [tbl_Message] WHERE M_Id= @M_Id");
if (dt.Rows.Count != 0)
{
s += base.Script("UPDATE [tbl_Message] SET [Seen] =1 WHERE M_Id=@M_Id", parss);
}
if (s == "1")
{
return("Success");
}
else
{
return("fail");
}
}
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 ActionResult ContactUsMessage(string Name, string Email, string Subject, string Message)
{
// PDBC db = new PDBC("PandaMarketCMS", true);
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters()
{
_KEY = "@Name",
_VALUE = Name
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@Email",
_VALUE = Email
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@Subject",
_VALUE = Subject
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@Message",
_VALUE = Message
};
parss.Add(par);
return(Content("Success"));
}
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 customerProfileComments()
{
int CustomerId = 1009;
string Query;
Query = "SELECT [C_FirstName]+' '+[C_LastNAme] as name,[id_Customer],[CommentId],[Message],[date],[Title],[C_regDate],[id_MProduct],[VerifyType] FROM [v_CommentsList] WHERE id_Customer=@CustomerId ORDER BY([date])DESC";
var Comments = new List <CommentModel>();
PDBC db = new PDBC();
ExcParameters par = new ExcParameters()
{
_KEY = "@CustomerId",
_VALUE = CustomerId
};
List <ExcParameters> pars = new List <ExcParameters>();
pars.Add(par);
db.Connect();
using (DataTable dt = db.Select(Query, pars))
{
for (int i = 0; i < dt.Rows.Count; i++)
{
CommentModel Comment = new CommentModel()
{
ProId = Convert.ToInt32(dt.Rows[i]["id_MProduct"]),
CusromerId = Convert.ToInt32(dt.Rows[i]["id_Customer"]),
ProTitle = dt.Rows[i]["Title"].ToString(),
CustomerName = dt.Rows[i]["name"].ToString(),
ProductCode = "",
C_RegisterDate = DateConvert.DateReturner(dt.Rows[i]["C_regDate"].ToString(), "ShortDate"),
CommentDate = DateConvert.DateReturner(dt.Rows[i]["date"].ToString(), "ShortDate"),
Message = dt.Rows[i]["Message"].ToString(),
CommentId = Convert.ToInt32(dt.Rows[i]["CommentId"]),
VerifyType = dt.Rows[i]["VerifyType"].ToString(),
};
Comment.Reply = new List <ReplyModel>();
using (DataTable dtJ = db.Select("SELECT [AdminId],[ad_avatarprofile],[ad_firstname]+' '+[ad_lastname] as AdName,[CommentId],[Message],[RepId],[date] FROM [v_ReplyList] WHERE [CommentId]=" + Comment.CommentId + " order by([date])DESC"))
{
for (int j = 0; j < dtJ.Rows.Count; j++)
{
Comment.Reply.Add(new ReplyModel()
{
//= dtJ.Rows[j][""].ToString(),
AdminId = Convert.ToInt32(dtJ.Rows[j]["AdminId"]),
Message = dtJ.Rows[j]["Message"].ToString(),
RepDate = DateConvert.DateReturner(dtJ.Rows[j]["date"].ToString(), "DateTime"),
AdminName = dtJ.Rows[j]["AdName"].ToString(),
AdminPic = dtJ.Rows[j]["ad_avatarprofile"].ToString(),
RepId = Convert.ToInt32(dtJ.Rows[j]["RepId"]),
});
}
}
}
db.DC();
return(View(Comments));
}
}
public ActionResult AddCustomerAddress(int cityId, string Address, string CodePosti)
{
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>();
ExcParameters par = new ExcParameters()
{
_KEY = "@cityId",
_VALUE = cityId
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@Address",
_VALUE = Address
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@CodePosti",
_VALUE = CodePosti
};
parss.Add(par);
par = new ExcParameters()
{
_KEY = "@CustomerId",
_VALUE = act.CustomerId
};
parss.Add(par);
string AddresId = db.Script("INSERT INTO [tbl_Customer_Address] output inserted.id_CAddress VALUES( @CustomerId ,@cityId ,@CodePosti,@Address)", parss);
db.DC();
return(Content("Success"));
}
else
{
return(Content("Error"));
}
}
else
{
return(Content("Login"));
}
}
public ActionResult TypePage(string action, string value, string id)
{
string query_new, query_edit;
string res = " ";
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
List <ExcParameters> paramss = new List <ExcParameters>();
ExcParameters parameters = new ExcParameters();
if (action == "new")
{
query_new = "INSERT INTO [dbo].[tbl_Product_Type]([PTname],[ISDESABLED],[ISDelete])VALUES(@PTname,0,0)";
parameters = new ExcParameters()
{
_KEY = "@PTname",
_VALUE = value
};
paramss.Add(parameters);
res = db.Script(query_new, paramss);
}
else if (action == "edit")
{
query_edit = "UPDATE [dbo].[tbl_Product_Type] SET [PTname] = @PTname WHERE id_PT =@id_PT";
parameters = new ExcParameters()
{
_KEY = "@id_PT",
_VALUE = id
};
paramss.Add(parameters);
parameters = new ExcParameters()
{
_KEY = "@PTname",
_VALUE = value
};
paramss.Add(parameters);
res = db.Script(query_edit, paramss);
}
return(Content(res));
}
public JsonResult User_deActivate(string idTodeActive)
{
PDBC db = new PDBC();
uint id = 0;
if (UInt32.TryParse(idTodeActive, out id))
{
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters()
{
_KEY = "@id_PT",
_VALUE = idTodeActive
};
parss.Add(par);
db.Connect();
string result = db.Script("UPDATE [tbl_Customer_Main] SET [C_ISActivate] = 0 WHERE id_Customer= @id_PT", parss);
db.DC();
if (result == "1")
{
var ModelSender = new ErrorReporterModel
{
ErrorID = "SX106",
Errormessage = $"این مشتری با موفقیت غیر فعال شد!",
Errortype = "Success"
};
return(Json(ModelSender));
}
else
{
PPBugReporter rep = new PPBugReporter(BugTypeFrom.SQL, result);
var ModelSender = new ErrorReporterModel
{
ErrorID = "EX115",
Errormessage = $"عدم توانایی در ثبت اطلاعات!",
Errortype = "Error"
};
return(Json(ModelSender));
}
}
else
{
PPBugReporter rep = new PPBugReporter(BugTypeFrom.SQL, "sher o ver e L326");
var ModelSender = new ErrorReporterModel
{
ErrorID = "EX115",
Errormessage = $"عدم توانایی در ثبت اطلاعات!",
Errortype = "Error"
};
return(Json(ModelSender));
}
}
public ActionResult get_Opinion(string id, string value)
{
string res = " ", query_edit;
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
List <ExcParameters> paramss = new List <ExcParameters>();
ExcParameters parameters = new ExcParameters();
parameters = new ExcParameters()
{
_KEY = "@id",
_VALUE = id
};
paramss.Add(parameters);
if (value == "delete")
{
query_edit = "UPDATE [dbo].[tbl_Product_Opinion] SET [ISDELETE] = @value WHERE [id_Opinion] = @id";
parameters = new ExcParameters()
{
_KEY = "@value",
_VALUE = "1"
};
paramss.Add(parameters);
res = db.Script(query_edit, paramss);
}
else if (value == "on")
{
query_edit = "UPDATE [dbo].[tbl_Product_Opinion] SET [Is_Accepted] = @value ,[DateAccepted] = GETDATE() WHERE [id_Opinion] = @id";
parameters = new ExcParameters()
{
_KEY = "@value",
_VALUE = "1"
};
paramss.Add(parameters);
res = db.Script(query_edit, paramss);
}
return(RedirectToAction("Opinion"));
}
public ActionResult UploadEditorResultActions(string IDToEdit, string picname, string picdesc, string picWords)
{
string SSSession = ""; CheckAccess check = new CheckAccess(SSSession);
if (check.HasAccess)
{
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
List <ExcParameters> EXpars = new List <ExcParameters>();
ExcParameters par = new ExcParameters()
{
_KEY = "@PicID",
_VALUE = IDToEdit
};
EXpars.Add(par);
par = new ExcParameters()
{
_KEY = "@alt",
_VALUE = picdesc
};
EXpars.Add(par);
par = new ExcParameters()
{
_KEY = "@uploadPicName",
_VALUE = picname
};
EXpars.Add(par);
par = new ExcParameters()
{
_KEY = "@Descriptions",
_VALUE = picWords
};
EXpars.Add(par);
string updateRes =
db.Script(
"UPDATE [tbl_ADMIN_UploaderStructure] SET [alt] = @alt ,[uploadPicName] = @uploadPicName ,[Descriptions] = @Descriptions WHERE [PicID] = @PicID", EXpars);
if (updateRes == "1")
{
//{"name":"1","id":"1"}
return(Content("{\"Res\":\"1\"}"));
}
else
{
return(Content("{\"Res\":\"-2\"}"));
}
}
else
{
return(Content("{\"Res\":\"-1\"}"));
}
}
public string GetSeenCookie(string Ip)
{
PersianDateTime persianDateTime = new PersianDateTime(DateTime.Now);
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters
{
_KEY = "@Ip",
_VALUE = Ip
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@day",
_VALUE = persianDateTime.GetDayOfYear
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@month",
_VALUE = persianDateTime.GetMonthEnum(persianDateTime.GetLongMonthName)
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@year",
_VALUE = persianDateTime.GetShortYear
};
parss.Add(par);
base.Connect();
string s = base.Script("INSERT INTO [tbl_SiteSeen] ([IpAddress],[Day],[Month],[Year]) VALUES(@Ip,@day,@month,@year)", parss);
base.DC();
if (s == "1")
{
var security = new Security();
return(security.HMACMD5Generator("{ Today Seen }"));
}
else
{
return("");
}
}
public string UpdateMember(OurTeamModel model)
{
string s = "";
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters
{
_KEY = "@T_Id",
_VALUE = model.T_Id
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@PicId",
_VALUE = model.PicId
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@Name",
_VALUE = model.Name
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@Job",
_VALUE = model.Job
};
parss.Add(par);
base.Connect();
s += base.Script("UPDATE [tbl_TeamMembers] SET [Name] = @Name ,[Subject] = @Job ,[PicId] = @PicId WHERE T_Id= @T_Id ", parss);
base.DC();
if (s == "1")
{
return("Success");
}
else
{
return("fail");
}
}
public PortfolioModel GetPortfolio(int Id)
{
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters
{
_KEY = "@P_Id",
_VALUE = Id
};
parss.Add(par);
base.Connect();
DataTable dt = base.Select("SELECT [P_Id],[Subject],[BackGroundPicId],(SELECT [PicThumbnailAddress] FROM [tbl_PicUploader] where PicId=[BackGroundPicId]) as BackGroundPic,[LogoPicId],(SELECT [PicThumbnailAddress] FROM [tbl_PicUploader] where PicId=[LogoPicId]) as LogoPic ,[Discription],[SEO_KeyWord],[SEO_Discription],[Show_MainPage] FROM [tbl_Portfolio] where P_Id=@P_Id", parss);
base.DC();
PortfolioModel model = new PortfolioModel();
if (dt.Rows.Count != 0)
{
model.Background_Id = Convert.ToInt32(dt.Rows[0]["BackGroundPicId"]);
model.Background_Path = dt.Rows[0]["BackGroundPic"].ToString();
model.Discription = dt.Rows[0]["Discription"].ToString();
model.Logo_Path = dt.Rows[0]["LogoPic"].ToString();
model.Log_Id = Convert.ToInt32(dt.Rows[0]["LogoPicId"]);
model.PortfolioId = Convert.ToInt32(dt.Rows[0]["P_Id"]);
model.SEO_discription = dt.Rows[0]["SEO_Discription"].ToString();
model.SEO_Keyword = dt.Rows[0]["SEO_KeyWord"].ToString();
model.Subject = dt.Rows[0]["Subject"].ToString();
model.Show = Convert.ToInt32(dt.Rows[0]["Show_MainPage"]);
}
else
{
model.Background_Id = 0;
model.Background_Path = "";
model.Discription = "";
model.Logo_Path = "";
model.Log_Id = 0;
model.PortfolioId = 0;
model.SEO_discription = "";
model.SEO_Keyword = "";
model.Subject = "";
model.Show = 0;
}
return(model);
}
public string SendMessage(MessageModel model)
{
string s = "";
List <ExcParameters> parss = new List <ExcParameters>();
ExcParameters par = new ExcParameters
{
_KEY = "@Message",
_VALUE = model.Message
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@Name",
_VALUE = model.Name
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@Email",
_VALUE = model.Email
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@Subject",
_VALUE = model.Subject
};
parss.Add(par);
base.Connect();
s += base.Script("INSERT INTO [tbl_Message]([Name],[Subject],[EmailAddress],[Date],[Message],[Answered],[Seen],[AnswerMessage])VALUES(@Name,@Subject,@Email,GETDATE(),@Message,0,0,N'')", parss);
base.DC();
if (s == "1")
{
return("Success");
}
else
{
return("fail");
}
}
public ActionResult comment_post(tbl_BLOG tbl)
{
string query_new;
string res = " ";
PDBC db = new PDBC("PandaMarketCMS", true);
List <ExcParameters> paramss = new List <ExcParameters>();
ExcParameters parameters = new ExcParameters();
query_new = "INSERT INTO [dbo].[tbl_BLOG_Comment]([Email],[message],[Name],[PostId])VALUES(@Email ,@message ,@Name ,@PostId)";
parameters = new ExcParameters()
{
_KEY = "@Email",
_VALUE = tbl.Email
};
paramss.Add(parameters);
parameters = new ExcParameters()
{
_KEY = "@message",
_VALUE = tbl.message
};
paramss.Add(parameters);
parameters = new ExcParameters()
{
_KEY = "@Name",
_VALUE = tbl.name
};
paramss.Add(parameters);
parameters = new ExcParameters()
{
_KEY = "@PostId",
_VALUE = tbl.Id
};
paramss.Add(parameters);
db.Connect();
res = db.Script(query_new, paramss);
db.DC();
return(Redirect("blog_post?IdPage=" + tbl.Id));
}
