private void UpLoadMulti_5Folder()
{
List <string> lStrBath1 = new List <string>();
List <string> lStrBath2 = new List <string>();
List <string> lStrBath3 = new List <string>();
List <string> lStrBath4 = new List <string>();
lStrBath1.AddRange(Directory.GetDirectories(txt_PathFolder.Text));
int k = 0;
int total = lStrBath1.Count;
string pathserver = @"\" + new DirectoryInfo(txt_PathFolder.Text).Name;
string pathexcel = @"X:";
string s = new DirectoryInfo(txt_PathFolder.Text).Name;
createFolder(s);
int n = 0;
DataTable dt = new DataTable();
dt.Columns.AddRange(new[] { new DataColumn("ImageID", typeof(string)) });
foreach (string item1 in lStrBath1)
{
string pathserver1 = pathserver + @"\" + new DirectoryInfo(item1).Name;
string litem1 = s + @"\" + new DirectoryInfo(item1).Name;
createFolder(litem1);
lStrBath2.Clear();
lStrBath2.AddRange(Directory.GetDirectories(item1));
if (lStrBath2.Count > 0)
{
foreach (string item2 in lStrBath2)
{
string litem2 = litem1 + @"\" + new DirectoryInfo(item2).Name;
createFolder(litem2);
lStrBath3.Clear();
lStrBath3.AddRange(Directory.GetDirectories(item2));
if (lStrBath3.Count > 0)
{
foreach (string item3 in lStrBath3)
{
string pathserver2 = pathserver1 + @"\" + new DirectoryInfo(item3).Name;
string litem3 = litem2 + @"\" + new DirectoryInfo(item3).Name;
createFolder(litem3);
lStrBath4.Clear();
lStrBath4.AddRange(Directory.GetDirectories(item3));
if (lStrBath4.Count > 0)
{
for (int i = 0; i < lStrBath4.Count; i++)
{
string FolderNameTemp = new DirectoryInfo(lStrBath4[i]).Name;
if (true /*FolderNameTemp.Substring(0, 7) == "2225000"*/)
{
string batchID = (new DirectoryInfo(lStrBath4[i]).Name + txt_DateCreate.Text).Replace("/", "").Replace(@"\", "").Replace(@":", "").Replace(@"-", "");
string pathserver3 = pathserver2 + @"\" + new DirectoryInfo(lStrBath4[i]).Name + @"\";
string litem4 = litem3 + @"\" + batchID;
dt.Clear();
int m = 0;
n += 1;
lb_SobatchHoanThanh.Text = n + @" :";
var filters = new String[] { "jpg", "jpeg", "tif" };
string[] pathImageLocation = GetFilesFrom(lStrBath4[i], filters, true);
var fBatch = new tbl_Batch
{
BatchID = batchID,
BatchName = new DirectoryInfo(lStrBath4[i]).Name,
UserCreate = txt_UserCreate.Text,
DateCreate = DateTime.Now,
PathServer = pathserver1 + @"\" + new DirectoryInfo(item2).Name + @"\" + new DirectoryInfo(item3).Name + @"\",
PathPicture = pathexcel + pathserver3,
Location = txt_PathFolder.Text,
NumberImage = pathImageLocation.Length + "",
ChiaUser = chk_ChiaUser.Checked ? true : false,
CongKhaiBatch = false,
};
Global.Db.tbl_Batches.InsertOnSubmit(fBatch);
Global.Db.SubmitChanges();
progressBar1.Step = 1;
progressBar1.Value = 1;
progressBar1.Maximum = pathImageLocation.Count();
progressBar1.Minimum = 0;
ModifyProgressBarColor.SetState(progressBar1, 1);
for (int j = 0; j < pathImageLocation.Count(); j++)
{
FileInfo fi = new FileInfo(pathImageLocation[j]);
dt.Rows.Add(fi.Name);
}
string ConnectionString = Global.Db.Connection.ConnectionString;
SqlConnection con = new SqlConnection(ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("Insert_Image", con);
cmd.CommandTimeout = 10 * 60;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BatchID", batchID);
cmd.Parameters.AddWithValue("@ListIdImage", dt);
cmd.Parameters.AddWithValue("@ChiaUser", chk_ChiaUser.Checked ? 1 : 0);
cmd.ExecuteNonQuery();
con.Close();
string temp = Global.StrPath + "\\" + litem4;
if (!Directory.Exists(temp))
{
Directory.CreateDirectory(temp);
}
else
{
MessageBox.Show("Bị trùng tên batch!");
return;
}
for (int j = 0; j < pathImageLocation.Count(); j++)
{
File.Copy(pathImageLocation[j], temp + @"\" + new FileInfo(pathImageLocation[j]).Name);
lb_SoImageDaHoanThanh.Text = (j + 1) + @"\" + pathImageLocation.Count();
m += 1;
progressBar1.PerformStep();
}
lb_SoImageDaHoanThanh.Text = m + @"/" + pathImageLocation.Length;
}
}
}
}
}
}
}
k++;
}
MessageBox.Show(@"Tạo batch mới thành công!");
txt_BatchName.Text = "";
txt_ImagePath.Text = "";
lb_SoLuongHinh.Text = "";
txt_PathFolder.Text = "";
txt_Path.Text = @"X:\N\13";
btn_Browser.Enabled = true;
txt_PathFolder.Enabled = true;
txt_Path.Enabled = true;
}
private void UpLoadSingle()
{
if (txt_Path.Text == @"X:\N\13")
{
MessageBox.Show("Bạn đang để đường dẫn path mặc định. Vui lòng kiểm tra lại.");
return;
}
progressBar1.Step = 1;
progressBar1.Value = 1;
progressBar1.Maximum = _lFileNames.Length;
progressBar1.Minimum = 0;
ModifyProgressBarColor.SetState(progressBar1, 1);
string sBatchID = (txt_BatchName.Text + txt_DateCreate.Text).Replace("/", "").Replace(@"\", "").Replace(@":", "").Replace(@"-", "");
var batch = (from w in Global.Db.tbl_Batches.Where(w => w.BatchID == sBatchID) select w.BatchID).FirstOrDefault();
if (!string.IsNullOrEmpty(txt_ImagePath.Text))
{
if (string.IsNullOrEmpty(batch))
{
var fBatch = new tbl_Batch
{
BatchID = sBatchID,
BatchName = txt_BatchName.Text,
UserCreate = txt_UserCreate.Text,
DateCreate = DateTime.Now,
PathServer = "",
PathPicture = txt_Path.Text,
Location = txt_ImagePath.Text,
NumberImage = soluonghinh.ToString(),
ChiaUser = chk_ChiaUser.Checked ? true : false,
CongKhaiBatch = false,
};
Global.Db.tbl_Batches.InsertOnSubmit(fBatch);
Global.Db.SubmitChanges();
}
else
{
MessageBox.Show("Batch đã tồn tại vui lòng điền tên batch khác!");
return;
}
}
else
{
MessageBox.Show("Bạn chưa chọn hình ảnh!");
return;
}
string temp = Global.StrPath + "\\" + sBatchID;
if (!Directory.Exists(temp))
{
Directory.CreateDirectory(temp);
}
else
{
MessageBox.Show("Bị trùng tên batch!");
return;
}
DataTable dt = new DataTable();
dt.Columns.AddRange(new[] { new DataColumn("ImageID", typeof(string)) });
for (int i = 0; i < _lFileNames.Count(); i++)
{
FileInfo fi = new FileInfo(_lFileNames[i]);
dt.Rows.Add(fi.Name);
}
string ConnectionString = Global.Db.Connection.ConnectionString;
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("Insert_Image", con);
cmd.CommandTimeout = 10 * 60;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BatchID", sBatchID);
cmd.Parameters.AddWithValue("@ListIdImage", dt);
cmd.Parameters.AddWithValue("@ChiaUser", chk_ChiaUser.Checked ? 1 : 0);
con.Open();
cmd.ExecuteNonQuery();
for (int i = 0; i < _lFileNames.Count(); i++)
{
File.Copy(_lFileNames[i], temp + @"\" + new FileInfo(_lFileNames[i]).Name);
progressBar1.PerformStep();
lb_SoImageDaHoanThanh.Text = (i + 1) + @"\" + _lFileNames.Count();
}
txt_DateCreate.Text = DateTime.Now.ToShortDateString() + "-" + DateTime.Now.ToShortTimeString();
MessageBox.Show("Tạo batch mới thành công!");
txt_BatchName.Text = "";
txt_ImagePath.Text = "";
txt_Path.Text = @"X:\N\13";
lb_SoLuongHinh.Text = "";
}
private void UpLoadMulti()
{
try
{
btn_Browser.Enabled = false;
txt_PathFolder.Enabled = false;
txt_Path.Enabled = false;
List <string> lStrBath = new List <string>();
lStrBath.AddRange(Directory.GetDirectories(txt_PathFolder.Text));
int countBatchExists = 0;
string listBatchExxists = "";
for (int i = 0; i < lStrBath.Count; i++)
{
sBatchID = (new DirectoryInfo(lStrBath[i]).Name + txt_DateCreate.Text).Replace("/", "").Replace(@"\", "").Replace(@":", "").Replace(@"-", "");
batch = (from w in Global.Db.tbl_Batches.Where(w => w.BatchID == sBatchID) select w.BatchID).FirstOrDefault();
if (!string.IsNullOrEmpty(batch))
{
countBatchExists += 1;
listBatchExxists += lStrBath[i] + "\r\n";
}
}
if (countBatchExists > 0)
{
MessageBox.Show("Batch đã tồn tại :\r\n" + listBatchExxists);
btn_Browser.Enabled = true;
txt_PathFolder.Enabled = true;
txt_Path.Enabled = true;
return;
}
int n = 0;
DataTable dt = new DataTable();
dt.Columns.AddRange(new[] { new DataColumn("ImageID", typeof(string)) });
foreach (string itemBatch in lStrBath)
{
dt.Clear();
string batchName = "";
int m = 0;
batchName = (new DirectoryInfo(itemBatch).Name + txt_DateCreate.Text).Replace("/", "").Replace(@"\", "").Replace(@":", "").Replace(@"-", "");
n += 1;
lb_SobatchHoanThanh.Text = n + @" :";
var filters = new String[] { "jpg", "jpeg", "tif" };
string[] pathImageLocation = GetFilesFrom(itemBatch, filters, true);
var fBatch = new tbl_Batch
{
BatchID = batchName,
BatchName = new DirectoryInfo(itemBatch).Name,
UserCreate = txt_UserCreate.Text,
DateCreate = DateTime.Now,
PathServer = "",
PathPicture = txt_Path.Text,
Location = txt_PathFolder.Text,
NumberImage = pathImageLocation.Length + "",
ChiaUser = chk_ChiaUser.Checked ? true : false,
CongKhaiBatch = false,
};
Global.Db.tbl_Batches.InsertOnSubmit(fBatch);
Global.Db.SubmitChanges();
progressBar1.Step = 1;
progressBar1.Value = 1;
progressBar1.Maximum = pathImageLocation.Count();
progressBar1.Minimum = 0;
ModifyProgressBarColor.SetState(progressBar1, 1);
for (int i = 0; i < pathImageLocation.Count(); i++)
{
FileInfo fi = new FileInfo(pathImageLocation[i]);
dt.Rows.Add(fi.Name);
}
string ConnectionString = Global.Db.Connection.ConnectionString;
SqlConnection con = new SqlConnection(ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("Insert_Image", con);
cmd.CommandTimeout = 10 * 60;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BatchID", batchName);
cmd.Parameters.AddWithValue("@ListIdImage", dt);
cmd.Parameters.AddWithValue("@ChiaUser", chk_ChiaUser.Checked ? 1 : 0);
cmd.ExecuteNonQuery();
con.Close();
string temp = Global.StrPath + "\\" + batchName;
if (!Directory.Exists(temp))
{
Directory.CreateDirectory(temp);
}
else
{
MessageBox.Show("Bị trùng tên batch!");
return;
}
for (int i = 0; i < pathImageLocation.Count(); i++)
{
File.Copy(pathImageLocation[i], temp + @"\" + new FileInfo(pathImageLocation[i]).Name);
lb_SoImageDaHoanThanh.Text = (i + 1) + @"\" + pathImageLocation.Count();
m += 1;
progressBar1.PerformStep();
}
lb_SoImageDaHoanThanh.Text = m + @"/" + pathImageLocation.Length;
}
MessageBox.Show(@"Tạo batch mới thành công!");
txt_BatchName.Text = "";
txt_ImagePath.Text = "";
lb_SoLuongHinh.Text = "";
txt_PathFolder.Text = "";
txt_Path.Text = @"X:\N\13";
//btn_CreateBatch.Enabled = true;
btn_Browser.Enabled = true;
txt_PathFolder.Enabled = true;
txt_Path.Enabled = true;
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
public void TableToExcel_Check(string strfilename)
{
try
{
lb_SoLuong.Text = "";
progressBar1.Step = 1;
progressBar1.Value = 0;
progressBar1.Maximum = dataGridView1.RowCount;
progressBar1.Minimum = 0;
progressBar1.Visible = true;
ModifyProgressBarColor.SetState(progressBar1, 1);
app = new Microsoft.Office.Interop.Excel.Application();
book = app.Workbooks.Open(strfilename, 0, true, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
wrksheet = (Microsoft.Office.Interop.Excel.Worksheet)book.Sheets["NATSU"];
int h = 1, n = 0;
wrksheet.Cells[2, 7] = "Thời gian:" + timeFisrt.Text + "/" + dtp_FirstDay.Value.Day + "/" + dtp_FirstDay.Value.Month + "/" + dtp_FirstDay.Value.Year + " đến " + timeEnd.Text + "/" + dtp_EndDay.Value.Day + "/" + dtp_EndDay.Value.Month + "/" + dtp_EndDay.Value.Year;
for (int i = 0; i < dataGridView1.RowCount; i++)
{
wrksheet.Cells[h + 2, 1] = h;
wrksheet.Cells[h + 2, 2] = dataGridView1.Rows[i].Cells[0].Value + ""; //username
wrksheet.Cells[h + 2, 3] = dataGridView1.Rows[i].Cells[1].Value + ""; //fullname
wrksheet.Cells[h + 2, 4] = dataGridView1.Rows[i].Cells[2].Value + ""; //tong
wrksheet.Cells[h + 2, 5] = dataGridView1.Rows[i].Cells[3].Value + ""; //thoigian
h++;
progressBar1.PerformStep();
lb_SoLuong.Text = ++n + @"\" + progressBar1.Maximum;
}
string savePath;
saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Title = @"Save Excel Files";
saveFileDialog1.Filter = @"Excel files (*.xlsx)|*.xlsx";
saveFileDialog1.FileName = "NangSuatCheckerNatSu_" + dtp_FirstDay.Value.Day + "-" + dtp_EndDay.Value.Day;
saveFileDialog1.RestoreDirectory = true;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
book.SaveCopyAs(saveFileDialog1.FileName);
book.Saved = true;
savePath = Path.GetDirectoryName(saveFileDialog1.FileName);
}
else
{
MessageBox.Show(@"Error exporting excel!");
return;
}
if (savePath != null)
{
Process.Start(savePath);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
finally
{
progressBar1.Visible = false;
lb_SoLuong.Text = "";
if (book != null)
{
book.Close(false);
}
if (app != null)
{
app.Quit();
}
if (File.Exists(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\Productivity_Check.xlsx"))
{
File.Delete(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\Productivity_Check.xlsx");
}
if (File.Exists(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\" + saveFileDialog1.FileName))
{
File.Delete(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\" + saveFileDialog1.FileName);
}
}
}
