private bool Validasi(Tr_BSTKBefore BSTKBefore, ref string result) { if (!db.Ms_Customers.Any(x => x.Company_Name == BSTKBefore.Nama_Customer)) { result = "Company Name does't exist!"; return(false); } else if (!db.Ms_Vehicles.Any(x => x.license_no == BSTKBefore.Nomor_Plat_Kendaraan)) { result = "license no does't exist!"; return(false); } else if (!db.Cn_Users.Any(x => x.User_ID == BSTKBefore.CreatedBy)) { result = "User Name does't exist!"; return(false); } else if (BSTKBefore.IsEdited && (int)BSTKBefore.BSTKBefore_ID == 0) { result = "Must fill BSTKBefore_ID"; return(false); } else if (BSTKBefore.IsEdited && !db.Tr_BSTKBefores.Any(x => x.BSTKBefore_ID == BSTKBefore.BSTKBefore_ID)) { result = "BSTKBefore_ID not found"; return(false); } return(true); }
public IHttpActionResult PostTr_BSTKBefores(Tr_BSTKBefore BSTKBeforeRequest) { var results = new Result(); results.Status = "Error"; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } string messages = ""; if (!Validasi(BSTKBeforeRequest, ref messages)) { results.Message = messages; return(Json(results)); } using (var dbs = db.Database.BeginTransaction()) { try { if (BSTKBeforeRequest.IsEdited == false) { //save data var bstk = new Tr_BSTKBefores(); bstk.Customer_ID = db.Ms_Customers.Where(x => x.Company_Name == BSTKBeforeRequest.Nama_Customer).Select(x => x.Customer_ID).FirstOrDefault(); bstk.Vehicle_ID = db.Ms_Vehicles.Where(x => x.license_no == BSTKBeforeRequest.Nomor_Plat_Kendaraan).Select(x => x.Vehicle_id).FirstOrDefault(); bstk.Automatic_Light_Switch = BSTKBeforeRequest.Automatic_Light_Switch; bstk.Automatic_Light_Switch_Ket = BSTKBeforeRequest.Automatic_Light_Switch_Ket; bstk.Lampu_Kecil = BSTKBeforeRequest.Lampu_Kecil; bstk.Lampu_Kecil_Ket = BSTKBeforeRequest.Lampu_Kecil_Ket; bstk.Lampu_Dekat = BSTKBeforeRequest.Lampu_Dekat; bstk.Lampu_Dekat_Ket = BSTKBeforeRequest.Lampu_Dekat_Ket; bstk.Lampu_Jauh = BSTKBeforeRequest.Lampu_Jauh; bstk.Lampu_Jauh_Ket = BSTKBeforeRequest.Lampu_Jauh_Ket; bstk.Lampu_Kabut_Fog_Lamp = BSTKBeforeRequest.Lampu_Kabut_Fog_Lamp; bstk.Lampu_Kabut_Fog_Lamp_Ket = BSTKBeforeRequest.Lampu_Kabut_Fog_Lamp_Ket; bstk.Lampu_Sign_Depan = BSTKBeforeRequest.Lampu_Sign_Depan; bstk.Lampu_Sign_Depan_Ket = BSTKBeforeRequest.Lampu_Sign_Depan_Ket; bstk.Lampu_Sign_Belakang = BSTKBeforeRequest.Lampu_Sign_Belakang; bstk.Lampu_Sign_Belakang_Ket = BSTKBeforeRequest.Lampu_Sign_Belakang_Ket; bstk.Lampu_Belakang = BSTKBeforeRequest.Lampu_Belakang; bstk.Lampu_Belakang_Ket = BSTKBeforeRequest.Lampu_Belakang_Ket; bstk.Lampu_Rem = BSTKBeforeRequest.Lampu_Rem; bstk.Lampu_Rem_Ket = BSTKBeforeRequest.Lampu_Rem_Ket; bstk.Lampu_Mundur = BSTKBeforeRequest.Lampu_Mundur; bstk.Lampu_Mundur_Ket = BSTKBeforeRequest.Lampu_Mundur_Ket; bstk.Lampu_Dashboard = BSTKBeforeRequest.Lampu_Dashboard; bstk.Lampu_Dashboard_Ket = BSTKBeforeRequest.Lampu_Dashboard_Ket; bstk.Lampu_Plafond_Depan_dan_Belakang = BSTKBeforeRequest.Lampu_Plafond_Depan_dan_Belakang; bstk.Lampu_Plafond_Depan_dan_Belakang_Ket = BSTKBeforeRequest.Lampu_Plafond_Depan_dan_Belakang_Ket; bstk.Klakson = BSTKBeforeRequest.Klakson; bstk.Klakson_Ket = BSTKBeforeRequest.Klakson_Ket; bstk.Antena = BSTKBeforeRequest.Antena; bstk.Antena_Ket = BSTKBeforeRequest.Antena_Ket; bstk.Tape_Radio_CD_DVD_TV_Player = BSTKBeforeRequest.Tape_Radio_CD_DVD_TV_Player; bstk.Tape_Radio_CD_DVD_TV_Player_Ket = BSTKBeforeRequest.Tape_Radio_CD_DVD_TV_Player_Ket; bstk.Remote_Tape_Radio_CD_DVD_TV_Player = BSTKBeforeRequest.Remote_Tape_Radio_CD_DVD_TV_Player; bstk.Remote_Tape_Radio_CD_DVD_TV_Player_Ket = BSTKBeforeRequest.Remote_Tape_Radio_CD_DVD_TV_Player_Ket; bstk.Alarm_Remote_Key = BSTKBeforeRequest.Alarm_Remote_Key; bstk.Alarm_Remote_Key_Ket = BSTKBeforeRequest.Alarm_Remote_Key_Ket; bstk.Central_Lock = BSTKBeforeRequest.Central_Lock; bstk.Central_Lock_Ket = BSTKBeforeRequest.Central_Lock_Ket; bstk.Power_Window = BSTKBeforeRequest.Power_Window; bstk.Power_Window_Ket = BSTKBeforeRequest.Power_Window_Ket; bstk.Switch_Mirror = BSTKBeforeRequest.Switch_Mirror; bstk.Switch_Mirror_Ket = BSTKBeforeRequest.Switch_Mirror_Ket; bstk.Air_Conditioner = BSTKBeforeRequest.Air_Conditioner; bstk.Air_Conditioner_Ket = BSTKBeforeRequest.Air_Conditioner_Ket; bstk.Safety_Belt = BSTKBeforeRequest.Safety_Belt; bstk.Safety_Belt_Ket = BSTKBeforeRequest.Safety_Belt_Ket; bstk.Karpet = BSTKBeforeRequest.Karpet; bstk.Karpet_Ket = BSTKBeforeRequest.Karpet_Ket; bstk.Lighter = BSTKBeforeRequest.Lighter; bstk.Lighter_Ket = BSTKBeforeRequest.Lighter_Ket; bstk.Asbak = BSTKBeforeRequest.Asbak; bstk.Asbak_Ket = BSTKBeforeRequest.Asbak_Ket; bstk.Sarung_Jok = BSTKBeforeRequest.Sarung_Jok; bstk.Sarung_Jok_Ket = BSTKBeforeRequest.Sarung_Jok_Ket; bstk.Sandaran_Kepala = BSTKBeforeRequest.Sandaran_Kepala; bstk.Sandaran_Kepala_Ket = BSTKBeforeRequest.Sandaran_Kepala_Ket; bstk.Spion_Dalam = BSTKBeforeRequest.Spion_Dalam; bstk.Spion_Dalam_Ket = BSTKBeforeRequest.Spion_Dalam_Ket; bstk.Wiper_Blade = BSTKBeforeRequest.Wiper_Blade; bstk.Wiper_Blade_Ket = BSTKBeforeRequest.Wiper_Blade_Ket; bstk.Windshield_Washer = BSTKBeforeRequest.Windshield_Washer; bstk.Windshield_Washer_Ket = BSTKBeforeRequest.Windshield_Washer_Ket; bstk.Talang_Air = BSTKBeforeRequest.Talang_Air; bstk.Talang_Air_Ket = BSTKBeforeRequest.Talang_Air_Ket; bstk.Fender_Lumpur_Depan_dan_Belakang = BSTKBeforeRequest.Fender_Lumpur_Depan_dan_Belakang; bstk.Fender_Lumpur_Depan_dan_Belakang_Ket = BSTKBeforeRequest.Fender_Lumpur_Depan_dan_Belakang_Ket; bstk.Spion_Kiri_Kanan = BSTKBeforeRequest.Spion_Kiri_Kanan; bstk.Spion_Kiri_Kanan_Ket = BSTKBeforeRequest.Spion_Kiri_Kanan_Ket; bstk.Tutup_Bensin = BSTKBeforeRequest.Tutup_Bensin; bstk.Tutup_Bensin_Ket = BSTKBeforeRequest.Tutup_Bensin_Ket; bstk.Emblem_Logo = BSTKBeforeRequest.Emblem_Logo; bstk.Emblem_Logo_Ket = BSTKBeforeRequest.Emblem_Logo_Ket; bstk.Kaca_Mobil_dan_Kaca_Film = BSTKBeforeRequest.Kaca_Mobil_dan_Kaca_Film; bstk.Kaca_Mobil_dan_Kaca_Film_Ket = BSTKBeforeRequest.Kaca_Mobil_dan_Kaca_Film_Ket; bstk.STNK = BSTKBeforeRequest.STNK; bstk.STNK_Ket = BSTKBeforeRequest.STNK_Ket; bstk.Buku_KIR_Stiker_Peneng = BSTKBeforeRequest.Buku_KIR_Stiker_Peneng; bstk.Buku_KIR_Stiker_Peneng_Ket = BSTKBeforeRequest.Buku_KIR_Stiker_Peneng_Ket; bstk.Owners_Manual_Book = BSTKBeforeRequest.Owners_Manual_Book; bstk.Owners_Manual_Book_Ket = BSTKBeforeRequest.Owners_Manual_Book_Ket; bstk.Buku_Service = BSTKBeforeRequest.Buku_Service; bstk.Buku_Service_Ket = BSTKBeforeRequest.Buku_Service_Ket; bstk.Ban_Serep = BSTKBeforeRequest.Ban_Serep; bstk.Ban_Serep_Ket = BSTKBeforeRequest.Ban_Serep_Ket; bstk.Kunci_Roda_Busi_Pas_Tang = BSTKBeforeRequest.Kunci_Roda_Busi_Pas_Tang; bstk.Kunci_Roda_Busi_Pas_Tang_Ket = BSTKBeforeRequest.Kunci_Roda_Busi_Pas_Tang_Ket; bstk.Kunci_Stir = BSTKBeforeRequest.Kunci_Stir; bstk.Kunci_Stir_Ket = BSTKBeforeRequest.Kunci_Stir_Ket; bstk.Dongkrak = BSTKBeforeRequest.Dongkrak; bstk.Dongkrak_Ket = BSTKBeforeRequest.Dongkrak_Ket; bstk.P3K = BSTKBeforeRequest.P3K; bstk.P3K_Ket = BSTKBeforeRequest.P3K_Ket; bstk.Segitiga_Pengaman = BSTKBeforeRequest.Segitiga_Pengaman; bstk.Segitiga_Pengaman_Ket = BSTKBeforeRequest.Segitiga_Pengaman_Ket; bstk.Lap_Kanebo = BSTKBeforeRequest.Lap_Kanebo; bstk.Lap_Kanebo_Ket = BSTKBeforeRequest.Lap_Kanebo_Ket; bstk.Foto_Kendaraan_Tampak_Depan = BSTKBeforeRequest.Foto_Kendaraan_Tampak_Depan; bstk.Foto_Kendaraan_Tampak_Belakang = BSTKBeforeRequest.Foto_Kendaraan_Tampak_Belakang; bstk.Foto_Kendaraan_Tampak_Samping_Kanan = BSTKBeforeRequest.Foto_Kendaraan_Tampak_Samping_Kanan; bstk.Foto_Kendaraan_Tampak_Samping_Kiri = BSTKBeforeRequest.Foto_Kendaraan_Tampak_Samping_Kiri; bstk.apar = BSTKBeforeRequest.apar; bstk.fuel = BSTKBeforeRequest.fuel; bstk.isi_tangki = BSTKBeforeRequest.isi_tangki; bstk.isi_tangki_ket = BSTKBeforeRequest.isi_tangki_ket; bstk.km = BSTKBeforeRequest.km; bstk.velg_ban = BSTKBeforeRequest.velg_ban; bstk.tutup_dop = BSTKBeforeRequest.tutup_dop; bstk.signature = BSTKBeforeRequest.signature; bstk.signature_image = BSTKBeforeRequest.signature_image; bstk.CreatedDate = DateTime.Now; bstk.CreatedBy = BSTKBeforeRequest.CreatedBy; bstk.IsCompleted = false; bstk.IsDeleted = false; db.Tr_BSTKBefores.Add(bstk); db.SaveChanges(); if (BSTKBeforeRequest.Foto_Kendaraan_Tampak_Depan != "" && !SaveImage(BSTKBeforeRequest.Foto_Kendaraan_Tampak_Depan, bstk.BSTKBefore_ID.ToString(), "BSTKBefore\\Depan")) { results.Message = "Failed Save Image Tampak Depan"; return(Json(results)); } if (BSTKBeforeRequest.Foto_Kendaraan_Tampak_Belakang != "" && !SaveImage(BSTKBeforeRequest.Foto_Kendaraan_Tampak_Belakang, bstk.BSTKBefore_ID.ToString(), "BSTKBefore\\Belakang")) { results.Message = "Failed Save Image Tampak Belakang"; return(Json(results)); } if (BSTKBeforeRequest.Foto_Kendaraan_Tampak_Samping_Kanan != "" && !SaveImage(BSTKBeforeRequest.Foto_Kendaraan_Tampak_Samping_Kanan, bstk.BSTKBefore_ID.ToString(), "BSTKBefore\\Kanan")) { results.Message = "Failed Save Image Tampak Samping Kanan"; return(Json(results)); } if (BSTKBeforeRequest.Foto_Kendaraan_Tampak_Samping_Kiri != "" && !SaveImage(BSTKBeforeRequest.Foto_Kendaraan_Tampak_Samping_Kiri, bstk.BSTKBefore_ID.ToString(), "BSTKBefore\\Kiri")) { results.Message = "Failed Save Image Tampak Samping Kiri"; return(Json(results)); } if (BSTKBeforeRequest.signature_image != "" && !SaveImage(BSTKBeforeRequest.signature_image, bstk.BSTKBefore_ID.ToString(), "BSTKBefore\\Signature")) { results.Message = "Failed Save Image Tampak Signature"; return(Json(results)); } results.Status = "Success"; dbs.Commit(); return(Json(results)); } else { //edit data var bstk = db.Tr_BSTKBefores.Where(x => x.BSTKBefore_ID == BSTKBeforeRequest.BSTKBefore_ID).FirstOrDefault(); bstk.Automatic_Light_Switch = BSTKBeforeRequest.Automatic_Light_Switch; bstk.Automatic_Light_Switch_Ket = BSTKBeforeRequest.Automatic_Light_Switch_Ket; bstk.Lampu_Kecil = BSTKBeforeRequest.Lampu_Kecil; bstk.Lampu_Kecil_Ket = BSTKBeforeRequest.Lampu_Kecil_Ket; bstk.Lampu_Dekat = BSTKBeforeRequest.Lampu_Dekat; bstk.Lampu_Dekat_Ket = BSTKBeforeRequest.Lampu_Dekat_Ket; bstk.Lampu_Jauh = BSTKBeforeRequest.Lampu_Jauh; bstk.Lampu_Jauh_Ket = BSTKBeforeRequest.Lampu_Jauh_Ket; bstk.Lampu_Kabut_Fog_Lamp = BSTKBeforeRequest.Lampu_Kabut_Fog_Lamp; bstk.Lampu_Kabut_Fog_Lamp_Ket = BSTKBeforeRequest.Lampu_Kabut_Fog_Lamp_Ket; bstk.Lampu_Sign_Depan = BSTKBeforeRequest.Lampu_Sign_Depan; bstk.Lampu_Sign_Depan_Ket = BSTKBeforeRequest.Lampu_Sign_Depan_Ket; bstk.Lampu_Sign_Belakang = BSTKBeforeRequest.Lampu_Sign_Belakang; bstk.Lampu_Sign_Belakang_Ket = BSTKBeforeRequest.Lampu_Sign_Belakang_Ket; bstk.Lampu_Belakang = BSTKBeforeRequest.Lampu_Belakang; bstk.Lampu_Belakang_Ket = BSTKBeforeRequest.Lampu_Belakang_Ket; bstk.Lampu_Rem = BSTKBeforeRequest.Lampu_Rem; bstk.Lampu_Rem_Ket = BSTKBeforeRequest.Lampu_Rem_Ket; bstk.Lampu_Mundur = BSTKBeforeRequest.Lampu_Mundur; bstk.Lampu_Mundur_Ket = BSTKBeforeRequest.Lampu_Mundur_Ket; bstk.Lampu_Dashboard = BSTKBeforeRequest.Lampu_Dashboard; bstk.Lampu_Dashboard_Ket = BSTKBeforeRequest.Lampu_Dashboard_Ket; bstk.Lampu_Plafond_Depan_dan_Belakang = BSTKBeforeRequest.Lampu_Plafond_Depan_dan_Belakang; bstk.Lampu_Plafond_Depan_dan_Belakang_Ket = BSTKBeforeRequest.Lampu_Plafond_Depan_dan_Belakang_Ket; bstk.Klakson = BSTKBeforeRequest.Klakson; bstk.Klakson_Ket = BSTKBeforeRequest.Klakson_Ket; bstk.Antena = BSTKBeforeRequest.Antena; bstk.Antena_Ket = BSTKBeforeRequest.Antena_Ket; bstk.Tape_Radio_CD_DVD_TV_Player = BSTKBeforeRequest.Tape_Radio_CD_DVD_TV_Player; bstk.Tape_Radio_CD_DVD_TV_Player_Ket = BSTKBeforeRequest.Tape_Radio_CD_DVD_TV_Player_Ket; bstk.Remote_Tape_Radio_CD_DVD_TV_Player = BSTKBeforeRequest.Remote_Tape_Radio_CD_DVD_TV_Player; bstk.Remote_Tape_Radio_CD_DVD_TV_Player_Ket = BSTKBeforeRequest.Remote_Tape_Radio_CD_DVD_TV_Player_Ket; bstk.Alarm_Remote_Key = BSTKBeforeRequest.Alarm_Remote_Key; bstk.Alarm_Remote_Key_Ket = BSTKBeforeRequest.Alarm_Remote_Key_Ket; bstk.Central_Lock = BSTKBeforeRequest.Central_Lock; bstk.Central_Lock_Ket = BSTKBeforeRequest.Central_Lock_Ket; bstk.Power_Window = BSTKBeforeRequest.Power_Window; bstk.Power_Window_Ket = BSTKBeforeRequest.Power_Window_Ket; bstk.Switch_Mirror = BSTKBeforeRequest.Switch_Mirror; bstk.Switch_Mirror_Ket = BSTKBeforeRequest.Switch_Mirror_Ket; bstk.Air_Conditioner = BSTKBeforeRequest.Air_Conditioner; bstk.Air_Conditioner_Ket = BSTKBeforeRequest.Air_Conditioner_Ket; bstk.Safety_Belt = BSTKBeforeRequest.Safety_Belt; bstk.Safety_Belt_Ket = BSTKBeforeRequest.Safety_Belt_Ket; bstk.Karpet = BSTKBeforeRequest.Karpet; bstk.Karpet_Ket = BSTKBeforeRequest.Karpet_Ket; bstk.Lighter = BSTKBeforeRequest.Lighter; bstk.Lighter_Ket = BSTKBeforeRequest.Lighter_Ket; bstk.Asbak = BSTKBeforeRequest.Asbak; bstk.Asbak_Ket = BSTKBeforeRequest.Asbak_Ket; bstk.Sarung_Jok = BSTKBeforeRequest.Sarung_Jok; bstk.Sarung_Jok_Ket = BSTKBeforeRequest.Sarung_Jok_Ket; bstk.Sandaran_Kepala = BSTKBeforeRequest.Sandaran_Kepala; bstk.Sandaran_Kepala_Ket = BSTKBeforeRequest.Sandaran_Kepala_Ket; bstk.Spion_Dalam = BSTKBeforeRequest.Spion_Dalam; bstk.Spion_Dalam_Ket = BSTKBeforeRequest.Spion_Dalam_Ket; bstk.Wiper_Blade = BSTKBeforeRequest.Wiper_Blade; bstk.Wiper_Blade_Ket = BSTKBeforeRequest.Wiper_Blade_Ket; bstk.Windshield_Washer = BSTKBeforeRequest.Windshield_Washer; bstk.Windshield_Washer_Ket = BSTKBeforeRequest.Windshield_Washer_Ket; bstk.Talang_Air = BSTKBeforeRequest.Talang_Air; bstk.Talang_Air_Ket = BSTKBeforeRequest.Talang_Air_Ket; bstk.Fender_Lumpur_Depan_dan_Belakang = BSTKBeforeRequest.Fender_Lumpur_Depan_dan_Belakang; bstk.Fender_Lumpur_Depan_dan_Belakang_Ket = BSTKBeforeRequest.Fender_Lumpur_Depan_dan_Belakang_Ket; bstk.Spion_Kiri_Kanan = BSTKBeforeRequest.Spion_Kiri_Kanan; bstk.Spion_Kiri_Kanan_Ket = BSTKBeforeRequest.Spion_Kiri_Kanan_Ket; bstk.Tutup_Bensin = BSTKBeforeRequest.Tutup_Bensin; bstk.Tutup_Bensin_Ket = BSTKBeforeRequest.Tutup_Bensin_Ket; bstk.Emblem_Logo = BSTKBeforeRequest.Emblem_Logo; bstk.Emblem_Logo_Ket = BSTKBeforeRequest.Emblem_Logo_Ket; bstk.Kaca_Mobil_dan_Kaca_Film = BSTKBeforeRequest.Kaca_Mobil_dan_Kaca_Film; bstk.Kaca_Mobil_dan_Kaca_Film_Ket = BSTKBeforeRequest.Kaca_Mobil_dan_Kaca_Film_Ket; bstk.STNK = BSTKBeforeRequest.STNK; bstk.STNK_Ket = BSTKBeforeRequest.STNK_Ket; bstk.Buku_KIR_Stiker_Peneng = BSTKBeforeRequest.Buku_KIR_Stiker_Peneng; bstk.Buku_KIR_Stiker_Peneng_Ket = BSTKBeforeRequest.Buku_KIR_Stiker_Peneng_Ket; bstk.Owners_Manual_Book = BSTKBeforeRequest.Owners_Manual_Book; bstk.Owners_Manual_Book_Ket = BSTKBeforeRequest.Owners_Manual_Book_Ket; bstk.Buku_Service = BSTKBeforeRequest.Buku_Service; bstk.Buku_Service_Ket = BSTKBeforeRequest.Buku_Service_Ket; bstk.Ban_Serep = BSTKBeforeRequest.Ban_Serep; bstk.Ban_Serep_Ket = BSTKBeforeRequest.Ban_Serep_Ket; bstk.Kunci_Roda_Busi_Pas_Tang = BSTKBeforeRequest.Kunci_Roda_Busi_Pas_Tang; bstk.Kunci_Roda_Busi_Pas_Tang_Ket = BSTKBeforeRequest.Kunci_Roda_Busi_Pas_Tang_Ket; bstk.Kunci_Stir = BSTKBeforeRequest.Kunci_Stir; bstk.Kunci_Stir_Ket = BSTKBeforeRequest.Kunci_Stir_Ket; bstk.Dongkrak = BSTKBeforeRequest.Dongkrak; bstk.Dongkrak_Ket = BSTKBeforeRequest.Dongkrak_Ket; bstk.P3K = BSTKBeforeRequest.P3K; bstk.P3K_Ket = BSTKBeforeRequest.P3K_Ket; bstk.Segitiga_Pengaman = BSTKBeforeRequest.Segitiga_Pengaman; bstk.Segitiga_Pengaman_Ket = BSTKBeforeRequest.Segitiga_Pengaman_Ket; bstk.Lap_Kanebo = BSTKBeforeRequest.Lap_Kanebo; bstk.Lap_Kanebo_Ket = BSTKBeforeRequest.Lap_Kanebo_Ket; bstk.Foto_Kendaraan_Tampak_Depan = BSTKBeforeRequest.Foto_Kendaraan_Tampak_Depan; bstk.Foto_Kendaraan_Tampak_Belakang = BSTKBeforeRequest.Foto_Kendaraan_Tampak_Belakang; bstk.Foto_Kendaraan_Tampak_Samping_Kanan = BSTKBeforeRequest.Foto_Kendaraan_Tampak_Samping_Kanan; bstk.Foto_Kendaraan_Tampak_Samping_Kiri = BSTKBeforeRequest.Foto_Kendaraan_Tampak_Samping_Kiri; bstk.apar = BSTKBeforeRequest.apar; bstk.fuel = BSTKBeforeRequest.fuel; bstk.isi_tangki = BSTKBeforeRequest.isi_tangki; bstk.isi_tangki_ket = BSTKBeforeRequest.isi_tangki_ket; bstk.km = BSTKBeforeRequest.km; bstk.velg_ban = BSTKBeforeRequest.velg_ban; bstk.tutup_dop = BSTKBeforeRequest.tutup_dop; bstk.signature = BSTKBeforeRequest.signature; //bstk.signature_image = BSTKBeforeRequest.signature_image; bstk.ModifiedDate = DateTime.Now; bstk.ModifiedBy = BSTKBeforeRequest.CreatedBy; db.SaveChanges(); if (BSTKBeforeRequest.Foto_Kendaraan_Tampak_Depan != "" && !SaveImage(BSTKBeforeRequest.Foto_Kendaraan_Tampak_Depan, bstk.BSTKBefore_ID.ToString(), "BSTKBefore\\Depan")) { results.Message = "Failed Save Image Tampak Depan"; return(Json(results)); } if (BSTKBeforeRequest.Foto_Kendaraan_Tampak_Belakang != "" && !SaveImage(BSTKBeforeRequest.Foto_Kendaraan_Tampak_Belakang, bstk.BSTKBefore_ID.ToString(), "BSTKBefore\\Belakang")) { results.Message = "Failed Save Image Tampak Belakang"; return(Json(results)); } if (BSTKBeforeRequest.Foto_Kendaraan_Tampak_Samping_Kanan != "" && !SaveImage(BSTKBeforeRequest.Foto_Kendaraan_Tampak_Samping_Kanan, bstk.BSTKBefore_ID.ToString(), "BSTKBefore\\Kanan")) { results.Message = "Failed Save Image Tampak Samping Kanan"; return(Json(results)); } if (BSTKBeforeRequest.Foto_Kendaraan_Tampak_Samping_Kiri != "" && !SaveImage(BSTKBeforeRequest.Foto_Kendaraan_Tampak_Samping_Kiri, bstk.BSTKBefore_ID.ToString(), "BSTKBefore\\Kiri")) { results.Message = "Failed Save Image Tampak Samping Kiri"; return(Json(results)); } if (BSTKBeforeRequest.signature_image != "" && !SaveImage(BSTKBeforeRequest.signature_image, bstk.BSTKBefore_ID.ToString(), "BSTKBefore\\Signature")) { results.Message = "Failed Save Image Tampak Signature"; return(Json(results)); } results.Status = "Success"; dbs.Commit(); return(Json(results)); } } catch (Exception e) { results.Message = e.Message; dbs.Rollback(); return(Json(results)); } } }
public Tr_BSTKBefore GetMs_Vehicles(int id) { Tr_BSTKBefore bstk = db.Tr_BSTKBefores.Where(x => x.IsDeleted == false && x.BSTKBefore_ID == id).Select(x => new Tr_BSTKBefore { Nama_Customer = x.Ms_Customers.Company_Name, Nomor_Plat_Kendaraan = x.Ms_Vehicles.license_no, Automatic_Light_Switch = x.Automatic_Light_Switch, Automatic_Light_Switch_Ket = x.Automatic_Light_Switch_Ket, Lampu_Kecil = x.Lampu_Kecil, Lampu_Kecil_Ket = x.Lampu_Kecil_Ket, Lampu_Dekat = x.Lampu_Dekat, Lampu_Dekat_Ket = x.Lampu_Dekat_Ket, Lampu_Jauh = x.Lampu_Jauh, Lampu_Jauh_Ket = x.Lampu_Jauh_Ket, Lampu_Kabut_Fog_Lamp = x.Lampu_Kabut_Fog_Lamp, Lampu_Kabut_Fog_Lamp_Ket = x.Lampu_Kabut_Fog_Lamp_Ket, Lampu_Sign_Depan = x.Lampu_Sign_Depan, Lampu_Sign_Depan_Ket = x.Lampu_Sign_Depan_Ket, Lampu_Sign_Belakang = x.Lampu_Sign_Belakang, Lampu_Sign_Belakang_Ket = x.Lampu_Sign_Belakang_Ket, Lampu_Belakang = x.Lampu_Belakang, Lampu_Belakang_Ket = x.Lampu_Belakang_Ket, Lampu_Rem = x.Lampu_Rem, Lampu_Rem_Ket = x.Lampu_Rem_Ket, Lampu_Mundur = x.Lampu_Mundur, Lampu_Mundur_Ket = x.Lampu_Mundur_Ket, Lampu_Dashboard = x.Lampu_Dashboard, Lampu_Dashboard_Ket = x.Lampu_Dashboard_Ket, Lampu_Plafond_Depan_dan_Belakang = x.Lampu_Plafond_Depan_dan_Belakang, Lampu_Plafond_Depan_dan_Belakang_Ket = x.Lampu_Plafond_Depan_dan_Belakang_Ket, Klakson = x.Klakson, Klakson_Ket = x.Klakson_Ket, Antena = x.Antena, Antena_Ket = x.Antena_Ket, Tape_Radio_CD_DVD_TV_Player = x.Tape_Radio_CD_DVD_TV_Player, Tape_Radio_CD_DVD_TV_Player_Ket = x.Tape_Radio_CD_DVD_TV_Player_Ket, Remote_Tape_Radio_CD_DVD_TV_Player = x.Remote_Tape_Radio_CD_DVD_TV_Player, Remote_Tape_Radio_CD_DVD_TV_Player_Ket = x.Remote_Tape_Radio_CD_DVD_TV_Player_Ket, Alarm_Remote_Key = x.Alarm_Remote_Key, Alarm_Remote_Key_Ket = x.Alarm_Remote_Key_Ket, Central_Lock = x.Central_Lock, Central_Lock_Ket = x.Central_Lock_Ket, Power_Window = x.Power_Window, Power_Window_Ket = x.Power_Window_Ket, Switch_Mirror = x.Switch_Mirror, Switch_Mirror_Ket = x.Switch_Mirror_Ket, Air_Conditioner = x.Air_Conditioner, Air_Conditioner_Ket = x.Air_Conditioner_Ket, Safety_Belt = x.Safety_Belt, Safety_Belt_Ket = x.Safety_Belt_Ket, Karpet = x.Karpet, Karpet_Ket = x.Karpet_Ket, Lighter = x.Lighter, Lighter_Ket = x.Lighter_Ket, Asbak = x.Asbak, Asbak_Ket = x.Asbak_Ket, Sarung_Jok = x.Sarung_Jok, Sarung_Jok_Ket = x.Sarung_Jok_Ket, Sandaran_Kepala = x.Sandaran_Kepala, Sandaran_Kepala_Ket = x.Sandaran_Kepala_Ket, Spion_Dalam = x.Spion_Dalam, Spion_Dalam_Ket = x.Spion_Dalam_Ket, Wiper_Blade = x.Wiper_Blade, Wiper_Blade_Ket = x.Wiper_Blade_Ket, Windshield_Washer = x.Windshield_Washer, Windshield_Washer_Ket = x.Windshield_Washer_Ket, Talang_Air = x.Talang_Air, Talang_Air_Ket = x.Talang_Air_Ket, Fender_Lumpur_Depan_dan_Belakang = x.Fender_Lumpur_Depan_dan_Belakang, Fender_Lumpur_Depan_dan_Belakang_Ket = x.Fender_Lumpur_Depan_dan_Belakang_Ket, Spion_Kiri_Kanan = x.Spion_Kiri_Kanan, Spion_Kiri_Kanan_Ket = x.Spion_Kiri_Kanan_Ket, Tutup_Bensin = x.Tutup_Bensin, Tutup_Bensin_Ket = x.Tutup_Bensin_Ket, Emblem_Logo = x.Emblem_Logo, Emblem_Logo_Ket = x.Emblem_Logo_Ket, Kaca_Mobil_dan_Kaca_Film = x.Kaca_Mobil_dan_Kaca_Film, Kaca_Mobil_dan_Kaca_Film_Ket = x.Kaca_Mobil_dan_Kaca_Film_Ket, STNK = x.STNK, STNK_Ket = x.STNK_Ket, Buku_KIR_Stiker_Peneng = x.Buku_KIR_Stiker_Peneng, Buku_KIR_Stiker_Peneng_Ket = x.Buku_KIR_Stiker_Peneng_Ket, Owners_Manual_Book = x.Owners_Manual_Book, Owners_Manual_Book_Ket = x.Owners_Manual_Book_Ket, Buku_Service = x.Buku_Service, Buku_Service_Ket = x.Buku_Service_Ket, Ban_Serep = x.Ban_Serep, Ban_Serep_Ket = x.Ban_Serep_Ket, Kunci_Roda_Busi_Pas_Tang = x.Kunci_Roda_Busi_Pas_Tang, Kunci_Roda_Busi_Pas_Tang_Ket = x.Kunci_Roda_Busi_Pas_Tang_Ket, Kunci_Stir = x.Kunci_Stir, Kunci_Stir_Ket = x.Kunci_Stir_Ket, Dongkrak = x.Dongkrak, Dongkrak_Ket = x.Dongkrak_Ket, P3K = x.P3K, P3K_Ket = x.P3K_Ket, Segitiga_Pengaman = x.Segitiga_Pengaman, Segitiga_Pengaman_Ket = x.Segitiga_Pengaman_Ket, Lap_Kanebo = x.Lap_Kanebo, Lap_Kanebo_Ket = x.Lap_Kanebo_Ket, Foto_Kendaraan_Tampak_Depan = x.Foto_Kendaraan_Tampak_Depan, Foto_Kendaraan_Tampak_Belakang = x.Foto_Kendaraan_Tampak_Belakang, Foto_Kendaraan_Tampak_Samping_Kanan = x.Foto_Kendaraan_Tampak_Samping_Kanan, Foto_Kendaraan_Tampak_Samping_Kiri = x.Foto_Kendaraan_Tampak_Samping_Kiri, apar = x.apar, fuel = x.fuel, isi_tangki = x.isi_tangki, isi_tangki_ket = x.isi_tangki_ket, km = x.km, velg_ban = x.velg_ban, tutup_dop = x.tutup_dop, signature = x.signature, signature_image = x.signature_image, CreatedBy = x.CreatedBy }).FirstOrDefault(); if (bstk == null) { return(null); } return(bstk); }