public ActionResult DeleteConfirmed(long id) { hasil hasil = db.hasils.Find(id); db.hasils.Remove(hasil); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "IDHasil,id_perusahaan,id_tahun,ROE,ROI,cash_ratio,current_ratio,CP,PP,TATO,TMS_TA,target,target_2,tingkat_kesehatan,grade")] hasil hasil) { if (ModelState.IsValid) { db.Entry(hasil).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.id_perusahaan = new SelectList(db.perusahaans, "IDPerusahaan", "nama_perusahaan", hasil.id_perusahaan); ViewBag.IDHasil = new SelectList(db.sumbers, "IDSumber", "IDSumber", hasil.IDHasil); ViewBag.id_tahun = new SelectList(db.tahuns, "IDTahun", "IDTahun", hasil.id_tahun); return(View(hasil)); }
// GET: hasils/Delete/5 public ActionResult Delete(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } hasil hasil = db.hasils.Find(id); if (hasil == null) { return(HttpNotFound()); } return(View(hasil)); }
// GET: hasils/Edit/5 public ActionResult Edit(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } hasil hasil = db.hasils.Find(id); if (hasil == null) { return(HttpNotFound()); } ViewBag.id_perusahaan = new SelectList(db.perusahaans, "IDPerusahaan", "nama_perusahaan", hasil.id_perusahaan); ViewBag.IDHasil = new SelectList(db.sumbers, "IDSumber", "IDSumber", hasil.IDHasil); ViewBag.id_tahun = new SelectList(db.tahuns, "IDTahun", "IDTahun", hasil.id_tahun); return(View(hasil)); }
// GET: hasils/Details/5 public ActionResult Details(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } hasil hasil = db.hasils.Find(id); TempData["id_perusahaan"] = db.hasils.Find(id).id_perusahaan; if (hasil == null) { return(HttpNotFound()); } //string nama_perusahaan = db.perusahaans.Find(id).nama_perusahaan; var IDPerusahaan = db.hasils.Find(id).id_perusahaan; var selectedHasil = (from hasil_ in db.hasils join perusahaan in db.perusahaans on hasil_.id_perusahaan equals perusahaan.IDPerusahaan join tahun in db.tahuns on hasil_.id_tahun equals tahun.IDTahun where hasil_.id_perusahaan == IDPerusahaan select new { hasil_.IDHasil, perusahaan.nama_perusahaan, tahun.tahun1, hasil_.target_2, tahun.IDTahun }) .OrderByDescending(x => x.IDTahun).Take(5); string nama_perusahaan = "PT Nama Perusahaan"; string[] KodeTahun = new string[5]; double[] NilaiTarget = new double[5]; int i = 4; foreach (var temp in selectedHasil) { nama_perusahaan = temp.nama_perusahaan; KodeTahun[i] = temp.tahun1.ToString(); NilaiTarget[i] = Math.Round((double)temp.target_2 * 100, 0); i--; } List <string> KodeTahunValues = KodeTahun.ToList(); List <double> TargetValues = NilaiTarget.ToList(); List <double> BatasKurangSehat = new List <double> { 70, 70, 70, 70, 70 }; List <double> BatasTidakSehat = new List <double> { 40, 40, 40, 40, 40 }; List <SplineSeriesData> TargetData = new List <SplineSeriesData>(); List <SplineSeriesData> DataKurangSehat = new List <SplineSeriesData>(); List <SplineSeriesData> DataTidakSehat = new List <SplineSeriesData>(); foreach (double value in TargetValues) { SplineSeriesData data = new SplineSeriesData(); data.Y = value; //if (value == 86) //{ // data.Marker.Symbol = "url(http://www.highcharts.com/demo/gfx/sun.png)"; // //kasi warna //} TargetData.Add(data); } foreach (double value in BatasKurangSehat) { SplineSeriesData data = new SplineSeriesData(); data.Y = value; DataKurangSehat.Add(data); } foreach (double value in BatasTidakSehat) { SplineSeriesData data = new SplineSeriesData(); data.Y = value; DataTidakSehat.Add(data); } ViewData["Tahun"] = KodeTahunValues; ViewData["TargetData"] = TargetData; ViewData["DataKurangSehat"] = DataKurangSehat; ViewData["DataTidakSehat"] = DataTidakSehat; ViewData["NamaPerusahaan"] = nama_perusahaan;//db.hasils.Find(IDPerusahaan).nama_perusahaan; return(View(hasil)); }
public static void Main(string[] args) { //BEGIN MASUKAN DATA TRAIN & DATA TEST KE ARRAY StreamReader reader = new StreamReader(File.OpenRead(@"D:\Backup Collyeah\Tugas\AI\Data Tugas 3 AI\DataTrain_Tugas3_AI.csv")); traintmp[] dataTmp = new traintmp[801]; train[] dataTrain = new train[801]; int i = 0; while (!reader.EndOfStream) { var line = reader.ReadLine(); var values = line.Split(','); dataTmp[i].index = values[0]; dataTmp[i].x1 = values[1]; dataTmp[i].x2 = values[2]; dataTmp[i].x3 = values[3]; dataTmp[i].x4 = values[4]; dataTmp[i].x5 = values[5]; dataTmp[i].y = values[6]; i++; } //convert string for (int j = 1; j < 801; j++) { string stringVal = dataTmp[j].index; string stringVal1 = dataTmp[j].x1; string stringVal2 = dataTmp[j].x2; string stringVal3 = dataTmp[j].x3; string stringVal4 = dataTmp[j].x4; string stringVal5 = dataTmp[j].x5; string stringVal6 = dataTmp[j].y; if (stringVal1.Contains(".")) { stringVal1 = stringVal1.Replace(".", ","); } if (stringVal2.Contains(".")) { stringVal2 = stringVal2.Replace(".", ","); } if (stringVal3.Contains(".")) { stringVal3 = stringVal3.Replace(".", ","); } if (stringVal4.Contains(".")) { stringVal4 = stringVal4.Replace(".", ","); } if (stringVal5.Contains(".")) { stringVal5 = stringVal5.Replace(".", ","); } int idx = System.Convert.ToInt32(stringVal); double x1 = System.Convert.ToDouble(stringVal1); double x2 = System.Convert.ToDouble(stringVal2); double x3 = System.Convert.ToDouble(stringVal3); double x4 = System.Convert.ToDouble(stringVal4); double x5 = System.Convert.ToDouble(stringVal5); int y = System.Convert.ToInt32(stringVal6); dataTrain[j].index = idx; dataTrain[j].x1 = x1; dataTrain[j].x2 = x2; dataTrain[j].x3 = x3; dataTrain[j].x4 = x4; dataTrain[j].x5 = x5; dataTrain[j].y = y; } StreamReader reader2 = new StreamReader(File.OpenRead(@"D:\Backup Collyeah\Tugas\AI\Data Tugas 3 AI\DataTest_Tugas3_AI.csv")); traintmp[] dataTmp2 = new traintmp[201]; train[] dataTest = new train[201]; int c = 0; while (!reader2.EndOfStream) { var line2 = reader2.ReadLine(); var values2 = line2.Split(','); dataTmp2[c].index = values2[0]; dataTmp2[c].x1 = values2[1]; dataTmp2[c].x2 = values2[2]; dataTmp2[c].x3 = values2[3]; dataTmp2[c].x4 = values2[4]; dataTmp2[c].x5 = values2[5]; dataTmp2[c].y = values2[6]; c++; } for (int j = 1; j < 201; j++) { string stringVal = dataTmp2[j].index; string stringVal1 = dataTmp2[j].x1; string stringVal2 = dataTmp2[j].x2; string stringVal3 = dataTmp2[j].x3; string stringVal4 = dataTmp2[j].x4; string stringVal5 = dataTmp2[j].x5; string stringVal6 = dataTmp2[j].y; if (stringVal1.Contains(".")) { stringVal1 = stringVal1.Replace(".", ","); } if (stringVal2.Contains(".")) { stringVal2 = stringVal2.Replace(".", ","); } if (stringVal3.Contains(".")) { stringVal3 = stringVal3.Replace(".", ","); } if (stringVal4.Contains(".")) { stringVal4 = stringVal4.Replace(".", ","); } if (stringVal5.Contains(".")) { stringVal5 = stringVal5.Replace(".", ","); } int idx = System.Convert.ToInt32(stringVal); double x1 = System.Convert.ToDouble(stringVal1); double x2 = System.Convert.ToDouble(stringVal2); double x3 = System.Convert.ToDouble(stringVal3); double x4 = System.Convert.ToDouble(stringVal4); double x5 = System.Convert.ToDouble(stringVal5); dataTest[j].index = idx; dataTest[j].x1 = x1; dataTest[j].x2 = x2; dataTest[j].x3 = x3; dataTest[j].x4 = x4; dataTest[j].x5 = x5; dataTest[j].y = 4; } //END MEMASUKAN ARRAY List <int> hasilKategori = new List <int>(); //MENGHITUNG JARAK SETIAP DATA TEST KE DATA TRAI for (int j = 1; j < 201; j++) { hasil[] tmpHasil = new hasil[801]; for (int l = 1; l < 801; l++) { //MENGITUNG JARAK EUCLEDIAN double eucledian = Math.Sqrt(Math.Pow((dataTrain[l].x1 - dataTest[j].x1), 2) + Math.Pow((dataTrain[l].x2 - dataTest[j].x2), 2) + Math.Pow((dataTrain[l].x3 - dataTest[j].x3), 2) + Math.Pow((dataTrain[l].x4 - dataTest[j].x4), 2) + Math.Pow((dataTrain[l].x5 - dataTest[j].x5), 2)); //MEMASUKKAN DATA JARAK & KELAS KE DALAM ARRAY tmpHasil[l].jarak = eucledian; tmpHasil[l].kategori = dataTrain[l].y; } //tmpHasil.OrderBy(x=>x.jarak); Array.Sort(tmpHasil, (x, y) => x.jarak.CompareTo(y.kategori)); hitungKategori[] hitung = new hitungKategori[4]; hitung[0].kategori = 0; hitung[1].kategori = 1; hitung[2].kategori = 2; hitung[3].kategori = 3; //MENGHITUNG MAYORITAS KELAS KATEGORI BERDASARKAN K=11 for (int k = 1; k < 12; k++) { if (tmpHasil[k].kategori == 0) { hitung[0].count += 1; } else if (tmpHasil[k].kategori == 1) { hitung[1].count += 1; } else if (tmpHasil[k].kategori == 2) { hitung[2].count += 1; } else if (tmpHasil[k].kategori == 3) { hitung[3].count += 1; } } //hitung.OrderBy(x=>x.count); Array.Sort(hitung, (x, y) => y.count.CompareTo(x.count)); //Console.WriteLine(hitung[0].kategori + " " + hitung[0].count); //Console.WriteLine(hitung[1].kategori + " " + hitung[1].count); //Console.WriteLine(hitung[2].kategori + " " + hitung[2].count); //Console.WriteLine(hitung[3].kategori + " " + hitung[3].count); //Console.ReadKey(); dataTest[j].y = hitung[0].kategori; hasilKategori.Add(dataTest[j].y); } for (int j = 1; j < 201; j++) { Console.Write(dataTest[j].index + " " + dataTest[j].y); Console.WriteLine(); } using (var file = File.CreateText(@"C:\Users\SyekhTampan\Desktop\Tugas2AI\DataTebakanTugas3.csv")) { file.WriteLine("Kategori"); foreach (var arr in hasilKategori) { int count = 0; if (count <= 200) { file.WriteLine(string.Join(",", arr)); } count++; } } Console.ReadKey(); }