protected void Update_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Data.FilesUpload obj = new Data.FilesUpload();
obj.Id = Id;
obj.ProductId = ddlProduct.SelectedValue;
obj.OriginalFileName = ddlProduct.SelectedItem.Text;
obj.ThumbnailLink = txtImage.Text;
obj.Active = chkActive.Checked ? "1" : "0";
if (Insert == true)
{
obj.Name = "";
obj.IconLink = "";
obj.WebContentLink = "";
FilesUploadService.FilesUpload_Insert(obj);
}
else
{
dt = FilesUploadService.FilesUpload_GetByTop("1", "Id='" + Id + "'", "");
obj.Name = dt.Rows[0]["Name"].ToString();
obj.IconLink = dt.Rows[0]["IconLink"].ToString();
obj.WebContentLink = dt.Rows[0]["WebContentLink"].ToString();
FilesUploadService.FilesUpload_Update(obj);
}
BindGrid();
pnView.Visible = true;
pnUpdate.Visible = false;
Insert = false;
}
}
private void BindGrid()
{
grdUploadFiles.DataSource = FilesUploadService.FilesUpload_GetByTop("", "", "Name");
grdUploadFiles.DataBind();
if (grdUploadFiles.PageCount <= 1)
{
grdUploadFiles.PagerStyle.Visible = false;
}
else
{
grdUploadFiles.PagerStyle.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
DataTable dt = FilesUploadService.FilesUpload_GetByTop("", "Active = 1", "Name");
rptProducts.DataSource = dt;
rptProducts.DataBind();
}
}
catch (Exception ex)
{
MailSender.SendMail("", "", "Error System", ex.Message + "\n" + ex.StackTrace);
}
}
protected void grdUploadFiles_ItemCommand(object source, DataGridCommandEventArgs e)
{
string strCA = e.CommandArgument.ToString();
switch (e.CommandName)
{
case "Edit":
Insert = false;
Id = strCA;
dt = FilesUploadService.FilesUpload_GetByTop("1", "Id='" + Id + "'", "");
LoadDropDownBoxProduct();
if (!string.Empty.Equals(dt.Rows[0]["ProductId"].ToString()))
{
ddlProduct.SelectedValue = dt.Rows[0]["ProductId"].ToString();
}
txtImage.Text = dt.Rows[0]["ThumbnailLink"].ToString();
imgImage.ImageUrl = dt.Rows[0]["ThumbnailLink"].ToString().Length > 0 ? dt.Rows[0]["ThumbnailLink"].ToString() : "";
chkActive.Checked = dt.Rows[0]["Active"].ToString() == "1" || dt.Rows[0]["Active"].ToString() == "True";
pnView.Visible = false;
pnUpdate.Visible = true;
break;
case "Active":
string strA = "";
string str = e.Item.Cells[2].Text;
strA = str == "1" ? "0" : "1";
SqlDataProvider sql = new SqlDataProvider();
sql.ExecuteNonQuery("Update [FilesUpload] set Active=" + strA + " Where Id='" + strCA + "'");
BindGrid();
break;
case "Delete":
FilesUploadService.FilesUpload_Delete(strCA);
BindGrid();
break;
}
}
protected void btnAddCart_Click(object sender, EventArgs e)
{
try
{
if (isLogin)
{
if (isValidDownload)
{
DataTable file = FilesUploadService.FilesUpload_GetByTop("1", "ProductId='" + id + "'", "");
if (file.Rows.Count == 0)
{
WebMsgBox.Show("File này không còn tồn tại trong hệ thống!");
return;
}
DownloadHistory history = new DownloadHistory();
history.UserId = cus.Id;
history.FileId = file.Rows[0]["Id"].ToString();
history.DownloadedDate = DateTime.Now.ToString("MM/dd/yyyy");
DownloadHistoryService.DownloadHistory_Insert(history);
Response.Redirect(file.Rows[0]["WebContentLink"].ToString(), false);
}
else
{
WebMsgBox.Show("Bạn chỉ có thể tải miễn phí 2 lần/ngày");
}
}
else
{
Response.Redirect("/thanh-vien/dang-nhap", false);
}
}
catch (Exception ex)
{
MailSender.SendMail("", "", "Error System", ex.Message + "\n" + ex.StackTrace);
}
}
protected void lbtSynch_Click(object sender, EventArgs e)
{
try
{
DriveService service = CreateDriveService();
string pageToken = null;
List <Google.Apis.Drive.v3.Data.File> lstFiles = new List <Google.Apis.Drive.v3.Data.File>();
do
{
lstFiles.AddRange(ListFiles(service, ref pageToken));
} while (pageToken != null);
lstFiles = lstFiles.Distinct().ToList();
List <Google.Apis.Drive.v3.Data.File> lstNewFiles = new List <Google.Apis.Drive.v3.Data.File>();
DataTable dtFiles = FilesUploadService.FilesUpload_GetByTop("", "", "");
for (int i = 0; i < lstFiles.Count; i++)
{
DataRow[] rows = dtFiles.Select("Id='" + lstFiles[i].Id + "'");
if (rows == null || rows.Length == 0)
{
lstNewFiles.Add(lstFiles[i]);
}
}
if (lstNewFiles.Count == 0)
{
WebMsgBox.Show("Không có file mới để đồng bộ!");
return;
}
string json = Newtonsoft.Json.JsonConvert.SerializeObject(lstNewFiles);
DataTable pDt = JsonConvert.DeserializeObject <DataTable>(json);
foreach (var column in pDt.Columns.Cast <DataColumn>().ToArray())
{
if (pDt.AsEnumerable().All(dr => dr.IsNull(column)))
{
pDt.Columns.Remove(column);
}
}
pDt.Columns.Add("OriginalFileName", typeof(string));
if (pDt.Columns["thumbnailLink"] == null)
{
pDt.Columns.Add("thumbnailLink", typeof(string));
}
pDt.Columns.Add("Active", typeof(int));
pDt.Columns.Add("ProductId", typeof(int));
pDt.Columns["Id"].SetOrdinal(0);
pDt.Columns["Name"].SetOrdinal(1);
pDt.Columns["thumbnailLink"].SetOrdinal(2);
pDt.Columns["IconLink"].SetOrdinal(3);
pDt.Columns["WebContentLink"].SetOrdinal(4);
for (int i = 0; i < pDt.Rows.Count; i++)
{
pDt.Rows[i]["Active"] = 1;
}
pDt.AcceptChanges();
BulkInsert(pDt);
BindGrid();
WebMsgBox.Show("Đồng bộ dữ liệu thành công!");
}
catch (Exception)
{
throw;
}
}
