internal static void InactiveJalanByID(int RoadID) { using (PPJDBDataContext PPJdb = new PPJDBDataContext()) { JalanInfo jalanInfo = PPJdb.JalanInfos.SingleOrDefault(rec => rec.NoRujukanJalan == RoadID); if (jalanInfo != null) { jalanInfo.Aktif = false; PPJdb.SubmitChanges(); } } }
internal static void InsertNewJalan(JalanInfomation JalanInfo) { using (PPJDBDataContext PPJdb = new PPJDBDataContext()) { JalanInfo jalanInfo = new JalanInfo(); jalanInfo.Aktif = true; jalanInfo.HargaKosSeunit = JalanInfo.HargaKosSeunit; jalanInfo.JumlahTiang = JalanInfo.JumlahTiang; jalanInfo.HargaSeunit = JalanInfo.HargaSeunit; jalanInfo.NamaJalan = JalanInfo.NamaJalan; jalanInfo.JumlahArm = JalanInfo.JumlahArm; jalanInfo.Rosak = JalanInfo.Rosak; jalanInfo.Tersedia = JalanInfo.Tersedia; jalanInfo.SaizGegantung = JalanInfo.SaizGegantung; PPJdb.JalanInfos.InsertOnSubmit(jalanInfo); PPJdb.SubmitChanges(); } }
internal static void UpdateJalan(JalanInfomation JalanInfo, int RoadID) { using (PPJDBDataContext PPJdb = new PPJDBDataContext()) { JalanInfo jalanInfo = PPJdb.JalanInfos.SingleOrDefault(rec => rec.NoRujukanJalan == RoadID); if (jalanInfo != null) { jalanInfo.HargaKosSeunit = JalanInfo.HargaKosSeunit; jalanInfo.JumlahTiang = JalanInfo.JumlahTiang; jalanInfo.HargaSeunit = JalanInfo.HargaSeunit; jalanInfo.NamaJalan = JalanInfo.NamaJalan; jalanInfo.JumlahArm = JalanInfo.JumlahArm; jalanInfo.Rosak = JalanInfo.Rosak; jalanInfo.Tersedia = JalanInfo.Tersedia; jalanInfo.SaizGegantung = JalanInfo.SaizGegantung; PPJdb.SubmitChanges(); } } }
internal static DataTable getRoadByID(int RoadID) { DataTable output = getTableStructture(); //output.Columns.Add("NoRujukanJalan", typeof(int)); //output.Columns.Add("NamaJalan", typeof(string)); PPJDBDataContext PPJdb = new PPJDBDataContext(); JalanInfo jalanInfo = PPJdb.JalanInfos.SingleOrDefault(rec => rec.NoRujukanJalan == RoadID); DataRow dr = output.NewRow(); dr["No"] = 1; dr["NoRujukanJalan"] = jalanInfo.NoRujukanJalan; dr["NamaJalan"] = jalanInfo.NamaJalan; dr["JumlahTiang"] = jalanInfo.JumlahTiang; dr["Rosak"] = jalanInfo.Rosak; dr["Tersedia"] = jalanInfo.Tersedia; dr["JumlahArm"] = jalanInfo.JumlahArm; dr["SaizGegantung"] = jalanInfo.SaizGegantung; dr["HargaKosSeunit"] = jalanInfo.HargaKosSeunit; dr["HargaSeunit"] = jalanInfo.HargaSeunit; output.Rows.Add(dr); //output = null; return(output); }