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