public ActionResult ExcellTest(FormCollection formCollection)
{
if (Request != null)
{
HttpPostedFileBase file = Request.Files["UploadedFile"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
string[] Liste = new string[20];
for (int i = 2; i < 22; i++)
{
try
{
Liste[i - 2] = workSheet.Cells[rowIterator, i].Value.ToString();
}
catch
{
Liste[i - 2] = null;
}
}
UrunRepo.ExcelKaydet(Liste);
}
}
}
}
return(View());
}
public ActionResult DatabaseSystem(FormCollection formCollection)
{
if (Session["User"] != null && Session["Yetki"].ToString() == "Admin")
{
if (Request != null)
{
List <Urun> urunler = new List <Urun>();
HttpPostedFileBase file = Request.Files["UploadedFile"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
try
{
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
int noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
urunler.Add(new Urun
{
Marka = (workSheet.Cells[rowIterator, 2].Value ?? String.Empty).ToString(),
Model = (workSheet.Cells[rowIterator, 3].Value ?? String.Empty).ToString(),
SinifKodu = (workSheet.Cells[rowIterator, 4].Value ?? String.Empty).ToString(),
SinifTanimi = (workSheet.Cells[rowIterator, 5].Value ?? String.Empty).ToString(),
MalzemeKodu = (workSheet.Cells[rowIterator, 6].Value ?? String.Empty).ToString(),
Section1 = (workSheet.Cells[rowIterator, 7].Value ?? String.Empty).ToString(),
Section2 = (workSheet.Cells[rowIterator, 8].Value ?? String.Empty).ToString(),
Section3 = (workSheet.Cells[rowIterator, 9].Value ?? String.Empty).ToString(),
Section4 = (workSheet.Cells[rowIterator, 10].Value ?? String.Empty).ToString(),
Section5 = (workSheet.Cells[rowIterator, 11].Value ?? String.Empty).ToString(),
Section6 = (workSheet.Cells[rowIterator, 12].Value ?? String.Empty).ToString(),
Section7 = (workSheet.Cells[rowIterator, 13].Value ?? String.Empty).ToString(),
Section8 = (workSheet.Cells[rowIterator, 14].Value ?? String.Empty).ToString(),
Section9 = (workSheet.Cells[rowIterator, 15].Value ?? String.Empty).ToString(),
Section10 = (workSheet.Cells[rowIterator, 16].Value ?? String.Empty).ToString(),
Section11 = (workSheet.Cells[rowIterator, 17].Value ?? String.Empty).ToString(),
Section12 = (workSheet.Cells[rowIterator, 18].Value ?? String.Empty).ToString(),
Section13 = (workSheet.Cells[rowIterator, 19].Value ?? String.Empty).ToString(),
Section14 = (workSheet.Cells[rowIterator, 20].Value ?? String.Empty).ToString(),
Section15 = (workSheet.Cells[rowIterator, 21].Value ?? String.Empty).ToString()
});
}
}
bool sonuc = UrunRepo.ExcelKaydet(urunler);
if (sonuc == true)
{
TempData["UyariTipi"] = "panel panel-success";
TempData["Sonuc"] = "Database Başarıyla Güncelleştirildi!";
return(View());
}
else
{
TempData["UyariTipi"] = "panel panel-danger";
TempData["Sonuc"] = "Geçerli Bir Excel Dosyası Seçilmedi! Database Güncelleme Başarılı Olmadı!";
return(View());
}
}
catch
{
TempData["UyariTipi"] = "panel panel-danger";
TempData["Sonuc"] = "Geçerli Bir Excel Dosyası Seçilmedi! Database Güncelleme Başarılı Olmadı!";
return(View());
}
}
else
{
TempData["UyariTipi"] = "panel panel-warning";
TempData["Sonuc"] = "Geçerli Dosyada Veri Yok yada Veri İçeren Bir Dosya Tipi Değil!";
return(View());
}
}
else
{
TempData["UyariTipi"] = "panel panel-warning";
TempData["Sonuc"] = "Dosya Seçilmedi!";
return(View());
}
}
else
{
TempData["UyariTipi"] = "text-danger";
TempData["Sonuc"] = "Tarayıcıda Oturum Süreniz Dolmuş! Lütfen Tekrar Oturum Açın!";
return(RedirectToAction("Logon", "Login"));
}
}
