public ThietBiVatTu GetById(string tbvt_ma) { try { ThietBiVatTu output; ThietBiVatTu_Dto modeldb = ChiTietThietBiVatTuService.CTTBVT_ById(tbvt_ma); output = new ThietBiVatTu { TBVT_ID = modeldb.TBVT_ID, TBVT_MA_TBVT = modeldb.TBVT_MA_TBVT, TBVT_TEN = modeldb.TBVT_TEN, TBVT_SERIAL = modeldb.TBVT_SERIAL, TBVT_LOAI = modeldb.TBVT_LOAI, TBVT_NGAY_MUA = modeldb.TBVT_NGAY_MUA, TBVT_DVT = modeldb.TBVT_DVT, TBVT_NHAP_THEO_LO = modeldb.TBVT_NHAP_THEO_LO, TBVT_SL_THEO_LO = modeldb.TBVT_SL_THEO_LO, TBVT_HANG_SX = modeldb.TBVT_HANG_SX, TBVT_NAM_SX = modeldb.TBVT_NAM_SX, TBVT_NGAY_TINH_BAO_HANH = modeldb.TBVT_NGAY_TINH_BAO_HANH, TBVT_NGAY_KET_THUC_BAO_HANH = modeldb.TBVT_NGAY_KET_THUC_BAO_HANH, TBVT_NHA_CUNG_CAP = modeldb.TBVT_NHA_CUNG_CAP, TBVT_TINH_TRANG_THIET_BI = modeldb.TBVT_TINH_TRANG_THIET_BI, TBVT_GHI_CHU_TINH_TRANG = modeldb.TBVT_GHI_CHU_TINH_TRANG, TBVT_CAN_BAO_DUONG = modeldb.TBVT_CAN_BAO_DUONG, TBVT_CHU_KY_BAO_DUONG = modeldb.TBVT_CHU_KY_BAO_DUONG, TBVT_NOI_DUNG_BAO_DUONG = modeldb.TBVT_NOI_DUNG_BAO_DUONG, TBVT_TI_LE_HAO_MON = modeldb.TBVT_TI_LE_HAO_MON, TBVT_TINH_TRANG_TBTBVT = modeldb.TBVT_TINH_TRANG_TBTBVT, TBVT_PhuKien = PhuKienService.PhuKien_GetBy_TBVT_ID(modeldb.TBVT_ID) }; if (modeldb == null) { return(null); } //output = new ThietBiVatTu //{ // Console.WriteLine(ex.Message); // Console.WriteLine(ex.StackTrace); // return null; //}; return(output); } catch { return(null); } }
public List <dynamic> Insert([FromBody] ThietBiVatTu input) { try { ThietBiVatTu_Dto modeldb = new ThietBiVatTu_Dto { TBVT_MA_TBVT = input.TBVT_MA_TBVT, TBVT_TEN = input.TBVT_TEN, TBVT_SERIAL = input.TBVT_SERIAL, TBVT_LOAI = input.TBVT_LOAI, TBVT_NGAY_MUA = input.TBVT_NGAY_MUA, TBVT_DVT = input.TBVT_DVT, TBVT_NHAP_THEO_LO = input.TBVT_NHAP_THEO_LO, TBVT_SL_THEO_LO = input.TBVT_SL_THEO_LO, TBVT_HANG_SX = input.TBVT_HANG_SX, TBVT_NAM_SX = input.TBVT_NAM_SX, TBVT_NGAY_TINH_BAO_HANH = input.TBVT_NGAY_TINH_BAO_HANH, TBVT_NGAY_KET_THUC_BAO_HANH = input.TBVT_NGAY_KET_THUC_BAO_HANH, TBVT_NHA_CUNG_CAP = input.TBVT_NHA_CUNG_CAP, TBVT_TINH_TRANG_THIET_BI = input.TBVT_TINH_TRANG_THIET_BI, TBVT_GHI_CHU_TINH_TRANG = input.TBVT_GHI_CHU_TINH_TRANG, TBVT_CAN_BAO_DUONG = input.TBVT_CAN_BAO_DUONG, TBVT_CHU_KY_BAO_DUONG = input.TBVT_CHU_KY_BAO_DUONG, TBVT_NOI_DUNG_BAO_DUONG = input.TBVT_NOI_DUNG_BAO_DUONG, TBVT_TI_LE_HAO_MON = input.TBVT_TI_LE_HAO_MON, TBVT_TINH_TRANG_TBTBVT = input.TBVT_TINH_TRANG_TBTBVT, RECORD_STATUS = "1" }; var result = ChiTietThietBiVatTuService.CTTBVT_Insert(modeldb); Console.WriteLine("ThietBiVatTu {0} inserted with result: ", input.TBVT_MA_TBVT); Console.WriteLine(result[0]); if (input.TBVT_PhuKien == null) { Console.WriteLine("No PhuKien to insert"); return(result); } int TBVT_ID = result.FirstOrDefault().TBVTID; foreach (var phukien in input.TBVT_PhuKien) { Console.WriteLine("PhuKien {0} processing!", phukien.PHU_KIEN_MA_PK); PhuKien_DTO vt_phukien = phukien; vt_phukien.PHU_KIEN_TBVT_ID = TBVT_ID; var phukienResult = PhuKienService.PhuKien_Insert(vt_phukien).FirstOrDefault(); Console.WriteLine("PhuKien {0} inserted!", phukien.PHU_KIEN_MA_PK); Console.WriteLine(phukienResult); if (phukienResult.Result < 0) { result.Add(phukienResult); } } return(result); } catch (Exception ex) { Console.WriteLine(ex.Message); Console.WriteLine(ex.StackTrace); return(new List <dynamic> { new { Result = -1, ErrorDesc = "Có lỗi phía hệ thông, vui lòng báo lên quản trị viên" } }); } }
public List <dynamic> Update([FromBody] ThietBiVatTu input) { try { ThietBiVatTu_Dto modeldb = new ThietBiVatTu_Dto { TBVT_ID = input.TBVT_ID.Value, TBVT_MA_TBVT = input.TBVT_MA_TBVT, TBVT_TEN = input.TBVT_TEN, TBVT_SERIAL = input.TBVT_SERIAL, TBVT_LOAI = input.TBVT_LOAI, TBVT_NGAY_MUA = input.TBVT_NGAY_MUA, TBVT_DVT = input.TBVT_DVT, TBVT_NHAP_THEO_LO = input.TBVT_NHAP_THEO_LO, TBVT_SL_THEO_LO = input.TBVT_SL_THEO_LO, TBVT_HANG_SX = input.TBVT_HANG_SX, TBVT_NAM_SX = input.TBVT_NAM_SX, TBVT_NGAY_TINH_BAO_HANH = input.TBVT_NGAY_TINH_BAO_HANH, TBVT_NGAY_KET_THUC_BAO_HANH = input.TBVT_NGAY_KET_THUC_BAO_HANH, TBVT_NHA_CUNG_CAP = input.TBVT_NHA_CUNG_CAP, TBVT_TINH_TRANG_THIET_BI = input.TBVT_TINH_TRANG_THIET_BI, TBVT_GHI_CHU_TINH_TRANG = input.TBVT_GHI_CHU_TINH_TRANG, TBVT_CAN_BAO_DUONG = input.TBVT_CAN_BAO_DUONG, TBVT_CHU_KY_BAO_DUONG = input.TBVT_CHU_KY_BAO_DUONG, TBVT_NOI_DUNG_BAO_DUONG = input.TBVT_NOI_DUNG_BAO_DUONG, TBVT_TI_LE_HAO_MON = input.TBVT_TI_LE_HAO_MON, TBVT_TINH_TRANG_TBTBVT = input.TBVT_TINH_TRANG_TBTBVT }; Console.WriteLine("update {0} processing", input.TBVT_MA_TBVT); var result = ChiTietThietBiVatTuService.CTTBVT_Update(modeldb); var updateResult = result.FirstOrDefault(); if (updateResult.Result < 0) { Console.WriteLine("update error: {0}", updateResult.ErrorDesc); } if (input.TBVT_PhuKien == null) { Console.WriteLine("no PhuKien updated", input.TBVT_MA_TBVT); return(result); } foreach (var phukien in input.TBVT_PhuKien) { PhuKien_DTO phukienDto = PhuKienService.PhuKien_ById(phukien.PHU_KIEN_MA_PK); if (phukien != null) { Console.WriteLine("updating phukien {0} ", phukien.PHU_KIEN_ID); phukienDto.PHU_KIEN_DVT = phukien.PHU_KIEN_DVT; phukienDto.PHU_KIEN_GHI_CHU = phukien.PHU_KIEN_GHI_CHU; phukienDto.PHU_KIEN_SO_LUONG = phukien.PHU_KIEN_SO_LUONG; phukienDto.PHU_KIEN_TEN = phukien.PHU_KIEN_TEN; var phukienResult = PhuKienService.PhuKien_Update(phukienDto).FirstOrDefault(); if (phukienResult.Result < 0) { Console.WriteLine("update failed phukien {0} ", phukien.PHU_KIEN_ID); Console.WriteLine(phukienResult.ErrorDesc); } else { Console.WriteLine("updated phukien {0} ", phukien.PHU_KIEN_ID); } } else { PhuKien_DTO vt_phukien = phukien; vt_phukien.PHU_KIEN_TBVT_ID = updateResult.TBVTID; var phukienResult = PhuKienService.PhuKien_Insert(vt_phukien).FirstOrDefault(); if (phukienResult.Result < 0) { Console.WriteLine("insert failed phukien {0} ", phukien.PHU_KIEN_ID); Console.WriteLine(phukienResult.ErrorDesc); } else { Console.WriteLine("inserted phukien {0} ", phukien.PHU_KIEN_ID); } } } return(result); } catch (Exception ex) { Console.WriteLine(ex.Message); Console.WriteLine(ex.StackTrace); return(new List <dynamic> { new { Result = -1, ErrorDesc = "Có lỗi phía hệ thông, vui lòng báo lên trị viên" } }); } }