public void DeleteOldPicDictionary(string PicUrl)
{
try
{
if (PicUrl == "")
{
return;
}
else
{
File.Delete(Server.MapPath(@"..\" + PicUrl));
ViewModel.tblDictionary updatePicUrl = new ViewModel.tblDictionary();
updatePicUrl.PicUrl = "";
updatePicUrl.IDDictionary = hfIDDictionary.Value.StringToGuid();
int ret = BisDictionary.UpdatePicUrl(updatePicUrl);
if (ret <= 0)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "ErrorDB", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اشکال درخذف عکس!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true);
}
}
}
catch
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "ErrorDB", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اشکال در برقراری ارتباط با دیتابیس!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true);
}
}
public JArray GetOneRecordRandom(ViewModel.tblDictionary Dictionary)
{
return(sqlHelper.ReturnJsonData("sp_tblDictionary_GetDataOneRecordRandom", Dictionary));
}
public bool ToggleActivation(ViewModel.tblDictionary Dictionary)
{
return(sqlHelper.RunProcedure("sp_tblDictionary_ToggleActivation", Dictionary) > 0);
}
public int UpdatePicUrl(ViewModel.tblDictionary Dictionary)
{
return(sqlHelper.RunProcedure("sp_tblDictionary_UpdatePicUrl", Dictionary));
}
public bool DeleteDictionary(ViewModel.tblDictionary Dictionary)
{
return(sqlHelper.RunProcedure("sp_tblDictionary_DeleteRow", Dictionary) > 0);
}
public bool UpdateDictionary(ViewModel.tblDictionary Dictionary)
{
return(sqlHelper.RunProcedure("sp_tblDictionary_Update", Dictionary) > 0);
}
public bool AddDictionary(ViewModel.tblDictionary Dictionary)
{
return(sqlHelper.RunProcedure("sp_tblDictionary_Insert", Dictionary) > 0);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (txtValue.Text != "" && txtTitle.Text != "" && txtSourceText.Text != "" && txtMetaTag.Text != "" && txtMetaDescription.Text != "" && txtKeyWord.Text != "" && txtAbstract.Text != "")
{
ViewModel.tblDictionary newDictionary = new ViewModel.tblDictionary();
newDictionary.Title = txtTitle.Text.FixFarsi();
newDictionary.Value = txtValue.Text.FixFarsi();
newDictionary.Abstract = txtAbstract.Text.FixFarsi();
newDictionary.KeyWord = txtKeyWord.Text.FixFarsi();
newDictionary.SourceText = txtSourceText.Text.FixFarsi();
newDictionary.MetaDescription = txtMetaDescription.Text.FixFarsi();
newDictionary.MetaTag = txtMetaTag.Text.FixFarsi();
newDictionary.Status = 1;
switch (hfMode.Value)
{
case "New":
try
{
DataSet dsCheckDictionaryName = (DataSet)Session["dsDictionary"];
int ChekDictionaryCount = dsCheckDictionaryName.Tables[0].Select("Title = '" + txtTitle.Text + "'").Count();
if (ChekDictionaryCount == 0)
{
newDictionary.PicUrl = fulDictionary.MoveFile(@"..\Picture\Dictionary");
newDictionary.IDDictionary = Guid.NewGuid();
bool ret = BisDictionary.AddDictionary(newDictionary);
if (ret)
{
newFields();
hfMode.Value = "New";
fillGrdDictionary();
hfIDDictionary.Value = newDictionary.IDDictionary.ToString();
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "Succsess", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اطلاعات ثبت شد!</p>\",title: \"<p style='text-align:right;direction:rtl'>ثبت اطلاعات</p>\"});", true);
}
else
{
try { File.Delete(@"\" + newDictionary.PicUrl); }
catch { }
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "ErrorSave", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اشکال در ثبت اطلاعات!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "ErrorRepeat", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> عبارت وارد شده تکراری است!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true);
}
}
catch
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "ErrorDB", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اشکال در برقراری ارتباط با دیتابیس!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true);
}
break;
case "Edit":
try
{
string Url = fulDictionary.MoveFile(@"..\Picture\Dictionary");
if (Url != "")
{
DeleteOldPicDictionary(hfDictionaryPicUrl.Value);
newDictionary.PicUrl = Url;
}
else
{
ViewModel.Search SearchUrl = new ViewModel.Search();
SearchUrl.Filter = " And tblDictionary.IDDictionary = '" + hfIDDictionary.Value + "'";
DataSet dsUrl = BisDictionary.GetDictionaryData(SearchUrl);
newDictionary.PicUrl = dsUrl.ReturnDataSetField("PicUrl");
}
newDictionary.IDDictionary = hfIDDictionary.Value.StringToGuid();
bool result = BisDictionary.UpdateDictionary(newDictionary);
if (result)
{
hfMode.Value = "New";
newFields();
fillGrdDictionary();
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "Succsess", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اطلاعات ویرایش شد!</p>\",title: \"<p style='text-align:right;direction:rtl'>ویرایش اطلاعات</p>\"});", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "ErrorSave", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اشکال در ویرایش اطلاعات!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true);
}
}
catch
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "ErrorDB", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اشکال در برقراری ارتباط با دیتابیس!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true);
}
break;
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "ErrortxtValue", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> لطفا همه فیلدها را کامل نمایید!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true);
}
}
}
protected void grdDictionary_RowCommand(object sender, GridViewCommandEventArgs e)
{
Guid IDDictionary = e.CommandArgument.ToString().StringToGuid();
switch (e.CommandName)
{
case "Edit":
try
{
hfIDDictionary.Value = IDDictionary.ToString();
ViewModel.Search getDictionary = new ViewModel.Search();
getDictionary.Filter = " and tblDictionary.IDDictionary ='" + IDDictionary + "'";
DataSet ds = BisDictionary.GetDictionaryData(getDictionary);
if (!ds.Null_Ds())
{
txtTitle.Text = ds.ReturnDataSetField("Title");
txtValue.Text = ds.ReturnDataSetField("Value");
txtAbstract.Text = ds.ReturnDataSetField("Abstract");
txtKeyWord.Text = ds.ReturnDataSetField("KeyWord");
txtSourceText.Text = ds.ReturnDataSetField("SourceText");
txtMetaTag.Text = ds.ReturnDataSetField("MetaTag");
txtMetaDescription.Text = ds.ReturnDataSetField("MetaDescription");
hfDictionaryPicUrl.Value = ds.ReturnDataSetField("PicUrl");
hfMode.Value = "Edit";
}
else
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "ErrorDB", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اشکال در برقراری ارتباط با دیتابیس!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true);
}
}
catch
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "ErrorDB", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اشکال در برقراری ارتباط با دیتابیس!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true);
}
break;
case "Delete":
try
{
ViewModel.Search getDictionary = new ViewModel.Search();
getDictionary.Filter = " and tblDictionary.IDDictionary ='" + IDDictionary + "'";
DataSet ds = BisDictionary.GetDictionaryData(getDictionary);
ViewModel.tblDictionary DelDictionary = new ViewModel.tblDictionary();
DelDictionary.IDDictionary = IDDictionary;
bool retDel = BisDictionary.DeleteDictionary(DelDictionary);
if (retDel)
{
try { File.Delete(Server.MapPath(@"\" + ds.ReturnDataSetField("PicUrl"))); }
catch { }
fillGrdDictionary();
hfMode.Value = "New";
}
else
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "ErrorDB", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اشکال در حذف اطلاعات!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true);
}
}
catch
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "ErrorDB", " bootbox.alert({message: \"<p dir='rtl' style='color:#004179;font-size:17px;'> اشکال در برقراری ارتباط با دیتابیس!</p>\",title: \"<p style='text-align:right;direction:rtl'>خطا</p>\"});", true);
}
break;
}
}
