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