public IRestResponse ChungChiY_SaveFullProcess(HoSoSaveFull hoSoFullSave) { var request = new RestRequest("HS/ChungChiY_SaveFullProcess", Method.POST) { RequestFormat = DataFormat.Json, JsonSerializer = new JsonSerializer() }; request.AddBody(new { hoSoFullSave.HoSoTiepNhan , hoSoFullSave.ChungChiHanhNgheY }); return(Execute(request)); }
public KetQuaTraVe ChungChiY_SaveFullProcess(HoSoSaveFull hoSoFullSave) { long hosoid = 0; long chungchihanhngheYID = 0; var flagupd = true; //1: insert - 0: update if (hoSoFullSave == null) { return(null); } try { using (var myScope = new TransactionScope()) { using (var connectionMotCua = new SqlConnection(MotCuaConn)) { connectionMotCua.Open(); if (hoSoFullSave.HoSoTiepNhan.hosotiepnhan.HoSoID != 0) { flagupd = false; hosoid = hoSoFullSave.HoSoTiepNhan.hosotiepnhan.HoSoID; } if (flagupd) { hosoid = _hoSoTiepNhanRepository.MotCua_HoSoTiepNhan_Ins( hoSoFullSave.HoSoTiepNhan.hosotiepnhan, connectionMotCua, trans); if (hosoid == -1) { myScope.Dispose(); return(null); } hoSoFullSave.HoSoTiepNhan.quatrinhxuly.HoSoID = hosoid; var kqQuaTrinhXuLyIns = _quaTrinhXuLyRepository.MotCua_QuaTrinhXuLy_Ins( hoSoFullSave.HoSoTiepNhan.quatrinhxuly, connectionMotCua, trans); _hoSoTiepNhanRepository.MotCua_HoSoTiepNhan_UpdQuaTrinhXuLyHienTaiByHoSoID(hosoid, kqQuaTrinhXuLyIns, connectionMotCua, trans); _workListRepository.MotCua_WorkList_InsUpdByUserIDandTrangThaiHoSoID( hoSoFullSave.HoSoTiepNhan.UserId, hoSoFullSave.HoSoTiepNhan.TrangThaiHoSoId, hoSoFullSave.HoSoTiepNhan.TrangThaiCapNhat, connectionMotCua, trans); } else { _hoSoTiepNhanRepository.MotCua_HoSoTiepNhan_UpdByHoSoID( hoSoFullSave.HoSoTiepNhan.hosotiepnhan, connectionMotCua, trans); } using (var connectionNganhY = new SqlConnection(NganhYConn)) { flagupd = true; connectionNganhY.Open(); hoSoFullSave.ChungChiHanhNgheY.chungChiHanhNgheY.HoSoID = hosoid; if (hoSoFullSave.ChungChiHanhNgheY.chungChiHanhNgheY.ChungChiHanhNgheYID != 0) { flagupd = false; chungchihanhngheYID = hoSoFullSave.ChungChiHanhNgheY.chungChiHanhNgheY.ChungChiHanhNgheYID; } if (flagupd) { chungchihanhngheYID = _chungChiHanhNgheYRepository.NganhY_ChungChiHanhNgheY_Ins( hoSoFullSave.ChungChiHanhNgheY.chungChiHanhNgheY, connectionNganhY, trans); if (chungchihanhngheYID == -1) { myScope.Dispose(); return(null); } if (hoSoFullSave.ChungChiHanhNgheY.lstChungChiHanhNgheY_TDCM?.Any() == true) { foreach (var tdcm in hoSoFullSave.ChungChiHanhNgheY.lstChungChiHanhNgheY_TDCM) { tdcm.ChungChiHanhNgheYID = chungchihanhngheYID; } var instdcm = _chungChiHanhNgheY_TDCMRepository.NganhY_ChungChiHanhNgheY_TDCM_Ins( hoSoFullSave.ChungChiHanhNgheY.lstChungChiHanhNgheY_TDCM, connectionNganhY, trans); if (!instdcm) { myScope.Dispose(); return(null); } } if (hoSoFullSave.ChungChiHanhNgheY.lstChungChiHanhNgheY_QTTH?.Any() == true) { foreach (var qtth in hoSoFullSave.ChungChiHanhNgheY.lstChungChiHanhNgheY_QTTH) { qtth.ChungChiHanhNgheYID = chungchihanhngheYID; } var insqtth = _chungChiHanhNgheY_QTTHRepository.NganhY_ChungChiHanhNgheY_QTTH_Ins( hoSoFullSave.ChungChiHanhNgheY.lstChungChiHanhNgheY_QTTH, connectionNganhY, trans); if (!insqtth) { myScope.Dispose(); return(null); } } } else { var updcchn = _chungChiHanhNgheYRepository.NganhY_ChungChiHanhNgheY_UpdByCCHNYID( hoSoFullSave.ChungChiHanhNgheY.chungChiHanhNgheY, connectionNganhY, trans); if (!updcchn) { myScope.Dispose(); return(null); } var deltdcm = _chungChiHanhNgheY_TDCMRepository.NganhY_ChungChiHanhNgheY_TDCM_DelByCCHNYID( chungchihanhngheYID, connectionNganhY, trans); if (!deltdcm) { myScope.Dispose(); return(null); } var delqtth = _chungChiHanhNgheY_QTTHRepository.NganhY_ChungChiHanhNgheY_QTTH_DelByCCHNYID( chungchihanhngheYID, connectionNganhY, trans); if (!delqtth) { myScope.Dispose(); return(null); } var instdcm = _chungChiHanhNgheY_TDCMRepository.NganhY_ChungChiHanhNgheY_TDCM_Ins( hoSoFullSave.ChungChiHanhNgheY.lstChungChiHanhNgheY_TDCM, connectionNganhY, trans); if (!instdcm) { myScope.Dispose(); return(null); } var insqtth = _chungChiHanhNgheY_QTTHRepository.NganhY_ChungChiHanhNgheY_QTTH_Ins( hoSoFullSave.ChungChiHanhNgheY.lstChungChiHanhNgheY_QTTH, connectionNganhY, trans); if (!insqtth) { myScope.Dispose(); return(null); } } } } myScope.Complete(); return(new KetQuaTraVe { ChungChiId = chungchihanhngheYID, HoSoId = hosoid }); } } catch (TransactionAbortedException ex) { Console.WriteLine("TransactionAbortedException Message: {0}", ex.Message); return(null); } catch (ApplicationException ex) { Console.WriteLine("ApplicationException Message: {0}", ex.Message); return(null); } }