private void insert_cuoc_goi_moi() { CallInfor v_call_info = new CallInfor(); v_call_info = HelpUtils.get_call_infor(m_us_cuoc_goi.strCALL_ID ); m_us_cuoc_goi.strERROR_CODE = v_call_info.error_code; m_us_cuoc_goi.strERROR_DESC = v_call_info.error_desc; m_us_cuoc_goi.strSTATUS = v_call_info.status; m_us_cuoc_goi.strVOICE_CALL_LINK = v_call_info.link_down_record; if (v_call_info.datetime_response != null) { m_us_cuoc_goi.datDATETIME_RESPOND = HelpUtils.string_2_datetime(v_call_info.datetime_response); } else { m_us_cuoc_goi.datDATETIME_RESPOND = CIPConvert.ToDatetime("01/01/1900", "dd/MM/yyyy"); } if (v_call_info.end_time != null) { m_us_cuoc_goi.datEND_TIME = HelpUtils.string_2_datetime(v_call_info.end_time); } else { m_us_cuoc_goi.datEND_TIME = CIPConvert.ToDatetime("01/01/1900", "dd/MM/yyyy"); } if (v_call_info.start_time != null) { m_us_cuoc_goi.datSTART_TIME = HelpUtils.string_2_datetime(v_call_info.start_time); } else { m_us_cuoc_goi.datSTART_TIME = CIPConvert.ToDatetime("01/01/1900", "dd/MM/yyyy"); } m_us_cuoc_goi.dcDURATION = CIPConvert.ToDecimal(v_call_info.duration); m_us_cuoc_goi.dcID_TRANG_THAI = m_dc_id_trang_thai_cuoc_goi; m_us_cuoc_goi.dcRINGTIME = CIPConvert.ToDecimal(v_call_info.ringtime); m_us_cuoc_goi.Update(); BaseMessages.MsgBox_Infor("Đã lưu thông tin cuộc gọi thành công"); }
//private void insert_cuoc_goi_moi() //{ // m_us_cuoc_goi = new US_GD_CUOC_GOI_YEU_CAU(); // m_us_cuoc_goi.dcCALL_ID = CIPConvert.ToDecimal(m_call_id); // m_us_cuoc_goi.strCUOC_GOI_VAO_YN = "Y"; // m_us_cuoc_goi.strHO_TEN_SINH_VIEN = m_txt_ho_ten.Text; // m_us_cuoc_goi.strLOP = m_txt_ma_lop.Text; // m_us_cuoc_goi.strMA_SINH_VIEN = m_txt_ma_hoc_vien.Text; // m_us_cuoc_goi.strNOI_SINH = m_txt_noi_sinh.Text; // m_us_cuoc_goi.strSO_DIEN_THOAI = m_txt_dien_thoai.Text; // m_us_cuoc_goi.strTRUONG = CIPConvert.ToStr(m_cbo_truong.SelectedValue); // m_us_cuoc_goi.dcID_NGUOI_DUNG = CAppContext_201.getCurrentUserID(); // m_us_cuoc_goi.dcSTATION_ID = CIPConvert.ToDecimal(f001_main_form.m_str_stationId); // m_us_cuoc_goi.Insert(); //} private void insert_cuoc_goi_moi() { // Trường hợp này xảy ra khi bấm nút Lưu câu hỏi lần đầu tiên // Nếu cuộc gọi chưa được insert thì phải insert trước if (m_us_cuoc_goi.dcID == -1) { m_us_cuoc_goi.strCALL_ID = m_call_id; m_us_cuoc_goi.strCUOC_GOI_VAO_YN = "Y"; m_us_cuoc_goi.strHO_TEN_SINH_VIEN = m_txt_ho_ten.Text; m_us_cuoc_goi.strLOP = m_txt_ma_lop.Text; m_us_cuoc_goi.strMA_SINH_VIEN = m_txt_ma_hoc_vien.Text; m_us_cuoc_goi.strNOI_SINH = m_txt_noi_sinh.Text; m_us_cuoc_goi.strSO_DIEN_THOAI = m_txt_dien_thoai.Text; m_us_cuoc_goi.strTRUONG = CIPConvert.ToStr(m_cbo_truong.SelectedValue); m_us_cuoc_goi.dcID_NGUOI_DUNG = CAppContext_201.getCurrentUserID(); m_us_cuoc_goi.dcSTATION_ID = CIPConvert.ToDecimal(f002_main_form.m_str_stationId); m_us_cuoc_goi.dcID_TRANG_THAI = -1; m_us_cuoc_goi.strHO_TEN_QLHT = m_txt_ho_ten_qlht.Text.Trim(); m_us_cuoc_goi.strDIEN_THOAI_QLHT = m_txt_dien_thoai_qlht.Text.Trim(); if (m_e_form_mode == e_form_mode.NHAP_TAY) { m_us_cuoc_goi.dcTHOI_DIEM_GOI = THOI_DIEM_GOI.GOI_BUOI_TOI; } else if (m_e_form_mode == e_form_mode.TU_DONG_OPEN) { m_us_cuoc_goi.dcTHOI_DIEM_GOI = THOI_DIEM_GOI.GOI_BAN_NGAY; } m_us_cuoc_goi.Insert(); } // Trường hợp này xảy ra khi bấm nút End Call // Nếu cuộc gọi đã được insert rồi thì chỉ việc update thông tin còn lại. else { CallInfor v_call_info = new CallInfor(); if (m_e_form_mode == e_form_mode.TU_DONG_OPEN) { v_call_info = HelpUtils.get_call_infor(m_call_id ); } else { v_call_info = HelpUtils.get_call_infor_overtime(m_call_id ); } m_us_cuoc_goi.strERROR_CODE = v_call_info.error_code; m_us_cuoc_goi.strERROR_DESC = v_call_info.error_desc; m_us_cuoc_goi.strSTATUS = v_call_info.status; m_us_cuoc_goi.strVOICE_CALL_LINK = v_call_info.link_down_record; if (v_call_info.datetime_response != null) { m_us_cuoc_goi.datDATETIME_RESPOND = HelpUtils.string_2_datetime(v_call_info.datetime_response); } else { m_us_cuoc_goi.datDATETIME_RESPOND = CIPConvert.ToDatetime("01/01/1900", "dd/MM/yyyy"); } if (v_call_info.end_time != null) { m_us_cuoc_goi.datEND_TIME = HelpUtils.string_2_datetime(v_call_info.end_time); } else { m_us_cuoc_goi.datEND_TIME = CIPConvert.ToDatetime("01/01/1900", "dd/MM/yyyy"); } if (v_call_info.start_time != null) { m_us_cuoc_goi.datSTART_TIME = HelpUtils.string_2_datetime(v_call_info.start_time); } else { m_us_cuoc_goi.datSTART_TIME = CIPConvert.ToDatetime("01/01/1900", "dd/MM/yyyy"); } m_us_cuoc_goi.dcDURATION = CIPConvert.ToDecimal(v_call_info.duration); m_us_cuoc_goi.dcID_TRANG_THAI = m_dc_id_trang_thai_cuoc_goi; m_us_cuoc_goi.dcRINGTIME = CIPConvert.ToDecimal(v_call_info.ringtime); m_us_cuoc_goi.strHO_TEN_SINH_VIEN = m_txt_ho_ten.Text.Trim(); m_us_cuoc_goi.dcID_NGUOI_DUNG = CAppContext_201.getCurrentUserID(); m_us_cuoc_goi.strSO_DIEN_THOAI = m_txt_dien_thoai.Text; m_us_cuoc_goi.strCUOC_GOI_VAO_YN = "Y"; m_us_cuoc_goi.strCALL_ID = m_call_id; if (m_e_form_mode == e_form_mode.NHAP_TAY) { m_us_cuoc_goi.dcTHOI_DIEM_GOI = THOI_DIEM_GOI.GOI_BUOI_TOI; } else if (m_e_form_mode == e_form_mode.TU_DONG_OPEN) { m_us_cuoc_goi.dcTHOI_DIEM_GOI = THOI_DIEM_GOI.GOI_BAN_NGAY; } m_us_cuoc_goi.Update(); BaseMessages.MsgBox_Infor("Đã lưu thông tin cuộc gọi thành công"); } }