public bool SearchCollections(ref List <Web_Collections_Model> lstResult, string Ma, string Name)
{
bool result = false;
try
{
string condition = string.Empty;
if (Ma != string.Empty)
{
condition += "(`id` like '%" + Ma.Replace("\'", "\\\'") + "' ";
condition += " or `id` like '" + Ma.Replace("\'", "\\\'") + "%' ";
condition += " or `id` like '%" + Ma.Replace("\'", "\\\'") + "%') ";
}
if (Name != string.Empty)
{
if (condition != string.Empty)
{
condition += "and (`name` like '%" + Name.Replace("\'", "\\\'") + "' ";
condition += " or `name` like '" + Name.Replace("\'", "\\\'") + "%' ";
condition += " or `name` like '%" + Name.Replace("\'", "\\\'") + "%') ";
}
else
{
condition += "(`name` like '%" + Name.Replace("\'", "\\\'") + "' ";
condition += " or `name` like '" + Name.Replace("\'", "\\\'") + "%' ";
condition += " or `name` like '%" + Name.Replace("\'", "\\\'") + "%') ";
}
}
DataTable dt;
if ((dt = DBHandler.selectDataBase(ref conn,
"`web_collections`",
"*",
condition)) != null)
{
lstResult = new List <Web_Collections_Model>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Web_Collections_Model item = new Web_Collections_Model()
{
id = (long)dt.Rows[i]["id"],
name = (string)dt.Rows[i]["name"],
featureimage = (string)dt.Rows[i]["featureimage"],
title = (string)dt.Rows[i]["title"],
description = (string)dt.Rows[i]["description"],
content = (string)dt.Rows[i]["content"],
relatedmenu = (int)dt.Rows[i]["relatedmenu"],
createdDate = (DateTime)dt.Rows[i]["createdDate"],
isdraft = (bool)dt.Rows[i]["isdraft"],
};
lstResult.Add(item);
}
result = true;
}
}
catch (Exception ex)
{
LogFile.writeLog(LogFile.DIR, "Exception" + LogFile.getTimeStringNow() + ".txt", LogFile.Filemode.GHIDE, ex.Message);
}
return(result);
}
public bool Update(Web_Collections_Model Obj)
{
bool result = false;
try
{
if (DBHandler.updateDataBase(ref conn, "`web_collections`",
"`name` = '" + Obj.name +
"', `title` = '" + Obj.title.Replace("'", "\'") +
"', `featureimage` = '" + Obj.featureimage.Replace("'", "\'") +
"', `description` = '" + Obj.description.Replace("'", "\'").Replace("\n", "<br/>") +
"', `relatedmenu` = '" + Obj.relatedmenu +
"', `content` = '" + Obj.content.Replace("'", "\'").Replace("\n", "<br/>") +
"', `isdraft` = " + ((Obj.isdraft) ? 1: 0), "`id` = '" + Obj.id + "'"))
{
result = true;
}
}
catch (Exception ex)
{
LogFile.writeLog(LogFile.DIR, "Exception" + LogFile.getTimeStringNow() + ".txt", LogFile.Filemode.GHIDE, ex.Message);
}
return(result);
}
public bool Save(Web_Collections_Model Obj, ref long id)
{
bool result = false;
try
{
// if Obj.id == -1. It doest't add. Add and save.
if (Obj.id == -1)
{
Add(Obj);
id = -1;
Web_Collections_Model rs = null;
if (GetCollectionbyName(ref rs, Obj.name))
{
id = rs.id;
}
}
else
{
Update(Obj);
id = Obj.id;
}
result = true;
}
catch (Exception ex)
{
LogFile.writeLog(LogFile.DIR, "Exception" + LogFile.getTimeStringNow() + ".txt", LogFile.Filemode.GHIDE, ex.Message);
}
return(result);
}
private void Dv_SelectionChanged(object sender, EventArgs e)
{
if (dv.SelectedRows.Count == 1)
{
long id = (long)dv.SelectedRows[0].Cells["MC"].Value;
selectedItem = result.Where(s => s.id == id).FirstOrDefault();
}
}
public void DeleteFileCollection(Web_Collections_Model Obj)
{
List <string> lstImage = FTPAction.getListFiles(AppConfig.FTPHost, AppConfig.FTPUser, AppConfig.FTPPassword, FTPAction.localSourceWeb + "/" + Common.AppConfig.PathImageCollections + "/" + Obj.id, string.Empty);
foreach (var item in lstImage)
{
FTPAction.deleteFile(AppConfig.FTPHost, AppConfig.FTPUser, AppConfig.FTPPassword, FTPAction.localSourceWeb + "/" + Common.AppConfig.PathImageCollections + "/" + Obj.id, item);
}
FTPAction.deleteDirectory(AppConfig.FTPHost, AppConfig.FTPUser, AppConfig.FTPPassword, FTPAction.localSourceWeb + "/" + Common.AppConfig.PathImageCollections + "/" + Obj.id);
}
private void Dv_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex >= 0)
{
try
{
long id = (long)dv.Rows[e.RowIndex].Cells["MC"].Value;
selectedItem = result.Where(s => s.id == id).FirstOrDefault();
}
catch { }
}
}
private void ItemAdd_Click(object sender, EventArgs e)
{
using (CollectionsActionView view = new CollectionsActionView(Resources.EnumClass.CollectionsAction.Add,
ref controller,
null))
{
if (view.ShowDialog() == DialogResult.OK)
{
Btn_Search_Click(null, null);
selectedItem = null;
}
}
}
private void ItemDelete_Click(object sender, EventArgs e)
{
if (selectedItem != null)
{
if (controller.Delete(selectedItem))
{
Common.Functions.ShowMessgeInfo("Delete Success");
Btn_Search_Click(null, null);
selectedItem = null;
}
else
{
Common.Functions.ShowMessgeInfo("Delete Fail");
}
}
}
private void Btn_Search_Click(object sender, EventArgs e)
{
result = null;
if (controller.SearchCollections(ref result, tb_MaSP.Text, tb_TenSP.Text))
{
dv.Rows.Clear();
dp.setObjCount(result.Count, 10);
if (result.Count == 0)
{
Functions.ShowMessgeInfo("Không có dữ liệu nào phù hợp");
}
Functions.ShowMaiQuynhAnh();
}
else
{
Functions.ShowMessgeInfo("Search thất bại");
}
selectedItem = null;
}
private bool SendImage(ref Web_Collections_Model obj, ref List <ImageAttachModel> lstImage, ref List <ImageAttachModel> DeleteImageList)
{
bool result = true;
if (FeatureImage.IsLocal)
{
if (!FTPAction.sendFile(AppConfig.FTPHost, AppConfig.FTPUser, AppConfig.FTPPassword,
FTPAction.localSourceWeb + "/" + Common.AppConfig.PathImageCollections + "/" + obj.id, obj.name + Common.Functions.GetExtension(FeatureImage.Link),
Common.Functions.GetPathFileName(FeatureImage.Link), Common.Functions.GetSafeFileName(FeatureImage.Link)))
{
return(false);
}
FeatureImage.IsLocal = false;
FeatureImage.Link = AppConfig.WebUrl + "/" + Common.AppConfig.PathImageCollections + "/" + obj.id + "/" + obj.name + Common.Functions.GetExtension(FeatureImage.Link);
}
obj.featureimage = obj.name + Common.Functions.GetExtension(FeatureImage.Link);
foreach (var item in lstImage)
{
if (item.IsLocal)
{
if (!FTPAction.sendFile(AppConfig.FTPHost, AppConfig.FTPUser, AppConfig.FTPPassword,
FTPAction.localSourceWeb + "/" + Common.AppConfig.PathImageCollections + "/" + obj.id, Common.Functions.GetSafeFileName(item.Link),
Common.Functions.GetPathFileName(item.Link), Common.Functions.GetSafeFileName(item.Link)))
{
return(false);
}
item.IsLocal = false;
item.Link = AppConfig.WebUrl + "/" + Common.AppConfig.PathImageCollections + "/" + obj.id + "/" + Common.Functions.GetSafeFileName(item.Link);
}
obj.content = obj.content.Replace("[~" + item.id.ToString() + "]", item.Link);
}
foreach (var item in DeleteImageList)
{
if (!item.IsLocal)
{
FTPAction.deleteFile(AppConfig.FTPHost, AppConfig.FTPUser, AppConfig.FTPPassword,
FTPAction.localSourceWeb + "/" + Common.AppConfig.PathImageCollections + "/" + obj.id, Common.Functions.GetSafeFileName(item.Link));
}
}
return(result);
}
public bool Delete(Web_Collections_Model Obj)
{
bool result = false;
try
{
if (DBHandler.deleteDataBase(ref conn,
"`web_collections`",
"`id` = " + Obj.id))
{
result = true;
DeleteFileCollection(Obj);
}
}
catch (Exception ex)
{
LogFile.writeLog(LogFile.DIR, "Exception" + LogFile.getTimeStringNow() + ".txt", LogFile.Filemode.GHIDE, ex.Message);
}
return(result);
}
public CollectionsActionView(CollectionsAction Action, ref CollectionsController Controller, Web_Collections_Model obj)
{
InitializeComponent();
action = Action;
controller = Controller;
if (obj != null)
{
Obj = new Web_Collections_Model()
{
id = obj.id,
content = obj.content,
createdDate = obj.createdDate,
description = obj.description,
featureimage = obj.featureimage,
name = obj.name,
relatedmenu = obj.relatedmenu,
title = obj.title,
isdraft = obj.isdraft
};
}
this.Load += CollectionsActionView_Load;
}
public bool GetCollectionbyName(ref Web_Collections_Model collection, string name)
{
bool result = false;
try
{
DataTable dt;
if ((dt = DBHandler.selectDataBase(ref conn,
"`web_collections`",
"*",
"`name` = '" + name + "'",
"LIMIT 1")) != null)
{
if (dt.Rows.Count == 1)
{
collection = new Web_Collections_Model()
{
id = (long)dt.Rows[0]["id"],
name = (string)dt.Rows[0]["name"],
featureimage = (string)dt.Rows[0]["featureimage"],
title = (string)dt.Rows[0]["title"],
description = (string)dt.Rows[0]["description"],
content = (string)dt.Rows[0]["content"],
relatedmenu = (int)dt.Rows[0]["relatedmenu"],
createdDate = (DateTime)dt.Rows[0]["createdDate"],
isdraft = (bool)dt.Rows[0]["isdraft"],
};
result = true;
}
}
}
catch (Exception ex)
{
LogFile.writeLog(LogFile.DIR, "Exception" + LogFile.getTimeStringNow() + ".txt", LogFile.Filemode.GHIDE, ex.Message);
}
return(result);
}
private void btn_action_Click(object sender, EventArgs e)
{
if (tb_name.Equals(string.Empty))
{
Common.Functions.ShowMessgeError("Chưa nhập thông tin \"name\"");
return;
}
if (tb_title.Equals(string.Empty))
{
Common.Functions.ShowMessgeError("Chưa nhập thông tin \"title\"");
return;
}
if (rtb_description.Equals(string.Empty))
{
Common.Functions.ShowMessgeError("Chưa nhập thông tin \"description\"");
return;
}
if (rtb_content.Equals(string.Empty))
{
Common.Functions.ShowMessgeError("Chưa nhập thông tin \"content\"");
return;
}
if (FeatureImage.Equals(null))
{
Common.Functions.ShowMessgeError("Chưa nhập thông tin \"Feature Image\"");
return;
}
if (chlb_catogary.CheckedItems.Count == 0)
{
Common.Functions.ShowMessgeError("Chưa nhập thông tin \"catogary\"");
return;
}
string CollectionLink = string.Empty;
if (Obj == null)
{
CollectionLink = CheckExistCollectionLink(Common.Functions.getWebNameValid(tb_name.Text));
if (CollectionLink.Equals(string.Empty))
{
Common.Functions.ShowMessgeError("Không có kết nối đến máy chủ");
return;
}
}
else
{
CollectionLink = Obj.name;
}
var lstImage = pn_imageattach.GetImageAttachList();
var DeletedImageAttachList = pn_imageattach.DeletedImageAttachList;
Web_Collections_Model obj = new Web_Collections_Model()
{
id = (Obj == null) ? -1 : Obj.id,
name = CollectionLink,
title = tb_title.Text,
content = rtb_content.Text,
featureimage = FeatureImage.Link,
description = rtb_description.Text,
relatedmenu = (int)(chlb_catogary.CheckedItems[0] as Web_Menu_Model).id,
isdraft = false
};
long id = -1;
if (controller.Save(obj, ref id))
{
obj.id = id;
if (SendImage(ref obj, ref lstImage, ref DeletedImageAttachList))
{
controller.Update(obj);
pn_imageattach.ClearDeletedImageAttachList();
//pn_imageattach.StoreImageAttachList(lstImage);
Obj = obj;
Common.Functions.ShowMessgeInfo("Success");
}
else
{
controller.Delete(obj);
Common.Functions.ShowMessgeInfo("Fail");
}
}
else
{
Common.Functions.ShowMessgeInfo("Fail");
}
}
