protected void ButtonUpload_Click(object sender, EventArgs e)
{
if (FileUploadBahanBaku.HasFile)
{
Server.ScriptTimeout = 1000000;
PenggunaLogin penggunaLogin = (PenggunaLogin)Session["PenggunaLogin"];
string lokasiFile = Server.MapPath("/file_excel/Jenis Biaya Proyeksi/Import/") + "Import JenisBiayaProyeksi" + DateTime.Now.ToString("d MMMM yyyy hh.mm.ss") + ".xls";
FileUploadBahanBaku.SaveAs(lokasiFile);
if (File.Exists(lokasiFile))
{
ImportExcel_Class _ImportExcel_Class = new ImportExcel_Class(penggunaLogin, lokasiFile);
_ImportExcel_Class.ImportJenisBiayaProyeksi();
//Terjadi Error
if (_ImportExcel_Class.Message != null)
{
LiteralWarning.Text = Alert_Class.Pesan(TipeAlert.Danger, _ImportExcel_Class.Message);
}
else
{
LiteralWarning.Text = Alert_Class.Pesan(TipeAlert.Success, "Import Jenis Biaya Proyeksi selesai");
}
}
}
}
protected void ButtonUpload_Click(object sender, EventArgs e)
{
try
{
string SessionCode = DateTime.Now.ToString("ddMMyyHHmmss");
#region Silahkan pilih file
if (!FileUploadExcel.HasFile)
{
LiteralWarning.Text = Alert_Class.Pesan(TipeAlert.Danger, "Silahkan pilih file");
return;
}
#endregion
#region Format file harus .xls
if (Path.GetExtension(FileUploadExcel.FileName) != ".xls")
{
LiteralWarning.Text = Alert_Class.Pesan(TipeAlert.Danger, "Format file harus .xls");
return;
}
#endregion
string Folder = Server.MapPath("/file_excel/Kurir/Import/");
//MEMBUAT FOLDER JIKA FOLDER TIDAK DITEMUKAN
if (!Directory.Exists(Folder))
{
Directory.CreateDirectory(Folder);
}
PenggunaLogin Pengguna = (PenggunaLogin)Session["PenggunaLogin"];
string LokasiFile = Folder + Pengguna.Store + " Import Kurir " + DateTime.Now.ToString("d MMMM yyyy hh.mm.ss") + ".xls";
FileUploadExcel.SaveAs(LokasiFile);
#region Silahkan ulangi proses upload
if (!File.Exists(LokasiFile))
{
LiteralWarning.Text = Alert_Class.Pesan(TipeAlert.Danger, "Silahkan ulangi proses upload");
return;
}
#endregion
ImportExcel_Class ImportExcel_Class = new ImportExcel_Class(Pengguna, LokasiFile);
ImportExcel_Class.ImportKurir();
if (!string.IsNullOrWhiteSpace(ImportExcel_Class.Message))
{
LiteralWarning.Text = Alert_Class.Pesan(TipeAlert.Danger, ImportExcel_Class.Message);
}
//else
// Response.Redirect("/WITReport/PerpindahanStok/ProdukDetail.aspx?keterangan=Import Excel " + SessionCode + "&returnUrl=/WITAdministrator/Produk/Default.aspx", false);
}
catch (Exception ex)
{
LiteralWarning.Text = Alert_Class.Pesan(TipeAlert.Danger, ex.Message);
LogError_Class LogError = new LogError_Class(ex, Request.Url.PathAndQuery);
}
}
protected void ButtonImport_Click(object sender, EventArgs e)
{
if (!FileUploadExcel.HasFile)
{
LiteralWarning.Text = Alert_Class.Pesan(TipeAlert.Danger, "File tidak ditemukan");
return;
}
if (Path.GetExtension(FileUploadExcel.FileName) != ".xls")
{
LiteralWarning.Text = Alert_Class.Pesan(TipeAlert.Danger, "Format file harus .xls");
return;
}
PenggunaLogin penggunaLogin = (PenggunaLogin)Session["PenggunaLogin"];
string lokasiFolder = Server.MapPath("/file_excel/Survei/Import/");
if (!Directory.Exists(lokasiFolder))
{
Directory.CreateDirectory(lokasiFolder);
}
string lokasiFile = lokasiFolder + "Import Survei " + DateTime.Now.ToString("d MMMM yyyy hh.mm.ss") + ".xls";
FileUploadExcel.SaveAs(lokasiFile);
if (File.Exists(lokasiFile))
{
ImportExcel_Class ImportExcel_Class = new ImportExcel_Class(penggunaLogin, lokasiFile);
int Result = ImportExcel_Class.ImportSurvei();
//Terjadi Error
if (ImportExcel_Class.Message != null || Result == 0)
{
LiteralWarning.Text = Alert_Class.Pesan(TipeAlert.Danger, ImportExcel_Class.Message);
}
else
{
Response.Redirect("Pengaturan.aspx?id=" + Result);
}
}
}
protected void ButtonUpload_Click(object sender, EventArgs e)
{
if (FileUploadExcel.HasFile)
{
Server.ScriptTimeout = 1000000;
PenggunaLogin penggunaLogin = (PenggunaLogin)Session["PenggunaLogin"];
string Folder = string.Empty;
Folder = Server.MapPath("/file_excel/Akuntansi/Import/");
string lokasiFile = Folder + "Import Akuntansi " + DateTime.Now.ToString("d MMMM yyyy hh.mm.ss") + ".xls";
if (!Directory.Exists(Folder))
{
Directory.CreateDirectory(Folder);
}
FileUploadExcel.SaveAs(lokasiFile);
if (File.Exists(lokasiFile))
{
ImportExcel_Class _ImportExcel_Class = new ImportExcel_Class(penggunaLogin, lokasiFile);
var _result = _ImportExcel_Class.ImportPemasukanAkuntansi();
//Terjadi Error
if (_ImportExcel_Class.Message != null)
{
LiteralWarning.Text = Alert_Class.Pesan(TipeAlert.Danger, _ImportExcel_Class.Message);
}
else
{
LiteralWarning.Text = Alert_Class.Pesan(TipeAlert.Success, "Import Excel selesai");
RepeaterJurnal.DataSource = _result["DataImport"];
RepeaterJurnal.DataBind();
}
}
}
}
protected void ButtonUploadChecker_Click(object sender, EventArgs e)
{
try
{
string SessionCode = DateTime.Now.ToString("ddMMyyHHmmss");
#region Silahkan pilih file
if (!FileUploadChecker.HasFile)
{
LiteralChecker.Text = Alert_Class.Pesan(TipeAlert.Danger, "Silahkan pilih file");
return;
}
#endregion
#region Format file harus .xls
if (Path.GetExtension(FileUploadChecker.FileName) != ".xls")
{
LiteralChecker.Text = Alert_Class.Pesan(TipeAlert.Danger, "Format file harus .xls");
return;
}
#endregion
string Folder = Server.MapPath("/file_excel/Produk/Import/");
//MEMBUAT FOLDER JIKA FOLDER TIDAK DITEMUKAN
if (!Directory.Exists(Folder))
{
Directory.CreateDirectory(Folder);
}
PenggunaLogin Pengguna = (PenggunaLogin)Session["PenggunaLogin"];
string LokasiFile = Folder + Pengguna.Store + " Checker Produk " + DateTime.Now.ToString("d MMMM yyyy hh.mm.ss") + ".xls";
FileUploadChecker.SaveAs(LokasiFile);
#region Silahkan ulangi proses upload
if (!File.Exists(LokasiFile))
{
LiteralChecker.Text = Alert_Class.Pesan(TipeAlert.Danger, "Silahkan ulangi proses upload");
return;
}
#endregion
ImportExcel_Class ImportExcel_Class = new ImportExcel_Class(Pengguna, LokasiFile);
List <string> DataDuplicate = ImportExcel_Class.ImportProdukChecker(SessionCode);
if (DataDuplicate.Count > 0)
{
peringatan.Visible = true;
LiteralChecker.Text = "<b>BERIKUT DATA DUPLIKAT</b> <br /><br />";
foreach (var item in DataDuplicate)
{
LiteralChecker.Text += item;
LiteralChecker.Text += "<br />";
}
}
else
{
peringatan.Visible = true;
LiteralChecker.Text = "TIDAK ADA DATA DUPLIKAT";
}
}
catch (Exception ex)
{
LiteralChecker.Text = Alert_Class.Pesan(TipeAlert.Danger, ex.Message);
LogError_Class LogError = new LogError_Class(ex, Request.Url.PathAndQuery);
}
}
