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(); } } }