private void btnSave_Click(object sender, EventArgs e) { if (_flag == -1) { return; } try { if (_flag == 1 && dtGrid.Rows.Count > 0) { var _iCenter_ticket_store = new Center_ticket_delivery(); center_ticket_delivery _center_ticket_delivery; int _sNum, _eNum; foreach (DataGridViewRow row in dtGrid.Rows) { _sNum = Int32.Parse(row.Cells[4].Value.ToString()); _eNum = Int32.Parse(row.Cells[5].Value.ToString()); _center_ticket_delivery = new center_ticket_delivery() { ticket_name = row.Cells[2].Value.ToString(), ticketSerie = row.Cells[3].Value.ToString(), startSerie = _sNum, endSerie = _eNum, quantity = _eNum - _sNum + 1, deliveryer_name = row.Cells[7].Value.ToString(), delivery_date = DateTime.Now, ticket_type = row.Cells[9].Value.ToString(), deliveryer = Int32.Parse(row.Cells[10].Value.ToString()), receiver_name = row.Cells[11].Value.ToString(), receiver = Int32.Parse(row.Cells[12].Value.ToString()) }; if (_iCenter_ticket_store.Add(_center_ticket_delivery)) { lblMsg.Text = SystemMessage.WarningSaveSuccess; _lstTicketDelivery.Add(_center_ticket_delivery); } else { lblMsg.Text = "Lỗi khi đang lưu dữ liệu"; break; } } // khi luu xong _flag = 0; btnNew.Text = "Thêm mới"; } } catch (Exception) { } }
public bool Add(center_ticket_delivery ticket_delivery) { try { db.center_ticket_delivery.Add(ticket_delivery); db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
private center_ticket_delivery FindInListTable(center_ticket_delivery item, List <center_ticket_delivery> lst) { center_ticket_delivery rs = null; try { rs = (from a in lst where a.ticket_type == item.ticket_type && item.startSerie >= a.startSerie && item.endSerie <= a.endSerie select a).SingleOrDefault(); return(rs); } catch (Exception) { return(null); } }
private bool CheckTicketInGrid(center_ticket_delivery item) { bool isCheck = false; int _sNum, _eNum; string _ticketType = ""; try { foreach (DataGridViewRow row in dtGrid.Rows) { _ticketType = row.Cells[9].Value.ToString(); if (_ticketType == item.ticket_type) { _sNum = Int32.Parse(row.Cells[4].Value.ToString()); _eNum = Int32.Parse(row.Cells[5].Value.ToString()); if ((item.startSerie >= _sNum) && (item.endSerie <= _eNum)) { isCheck = true; break; } if (_sNum >= item.startSerie && _sNum <= item.endSerie) { isCheck = true; break; } if (_eNum >= item.startSerie && _eNum <= item.endSerie) { isCheck = true; break; } } } } catch (Exception) { isCheck = false; } return(isCheck); }
private void AddRowToGrid(center_ticket_delivery item) { int pos = dtGrid.RowCount + 1; DataGridViewRow row = (DataGridViewRow)dtGrid.RowTemplate.Clone(); row.CreateCells(dtGrid, pos, false, item.ticket_name, item.ticketSerie, item.startSerie, item.endSerie, item.quantity, item.deliveryer_name, item.delivery_date, item.ticket_type, item.deliveryer, item.receiver_name, item.receiver ); dtGrid.Rows.Add(row); }
private void txtSerieEnd_KeyUp(object sender, KeyEventArgs e) { if (_flag == -1) { return; } try { #region "input" lblMsg.Text = ""; string _serieStart = txtSerieStart.Text.Trim().ToUpper(); string _serieEnd = txtSerieEnd.Text.Trim().ToUpper(); if (_serieStart == "" || _serieEnd == "") { return; } string _ticketSerie = _serieStart.Substring(0, 10); string _ticketType = _serieStart.Substring(8, 1); int _sNum = Int32.Parse(_serieStart.Substring(10)); int _eNum = Int32.Parse(_serieEnd.Substring(10)); #endregion #region "check_inputSerie" int rs = SystemHelp.CheckInputSerie(_serieStart, _serieEnd, _ticketSerie, _ticketType, _sNum, _eNum); if (rs == 1) { lblMsg.Text = SystemMessage.WarningStartNumberErr; return; } else if (rs == 2) { lblMsg.Text = SystemMessage.WarningTicketTypeErr; return; } else if (rs == 3) { lblMsg.Text = SystemMessage.WarningMinMaxErr; return; } else if (rs == 4) { lblMsg.Text = SystemMessage.WarningTicketTypeErr; return; } #endregion #region "check_select_employee" if (cboEmployee.SelectedIndex == 0 && _flag == 1) { lblMsg.Text = SystemMessage.WarningEmployeeNull; txtSerieEnd.Text = ""; txtSerieStart.Text = ""; cboEmployee.Focus(); return; } #endregion if (_flag == 0) { _flag = 2; } // get ticket_type var itemTicketType = SystemHelp.GetTicketTypeFromList(_ticketSerie, _lstTicketType); // create obj ticket_delivery center_ticket_delivery itemTicket_delivery = new center_ticket_delivery() { delivery_date = DateTime.Now, deliveryer_name = ObjLogin.displayname, deliveryer = ObjLogin.id, receiver_name = cboEmployee.Text, receiver = Int32.Parse(cboEmployee.SelectedValue.ToString()), ticket_name = itemTicketType.ticket_name, ticket_type = itemTicketType.id, quantity = _eNum - _sNum + 1, startSerie = _sNum, endSerie = _eNum, ticketSerie = _ticketSerie, session_id = 0 }; // nhap cua them moi if (_flag == 1) { // check ticket_delivery in grid if (CheckTicketInGrid(itemTicket_delivery)) { lblMsg.Text = SystemMessage.WarningExitInputTicket; return; } // check ticket_delivery in table if (FindInListTable(itemTicket_delivery, _lstTicketDelivery) != null) { lblMsg.Text = SystemMessage.WarningSaveTicketDelivery; return; } // add ticket to grid AddRowToGrid(itemTicket_delivery); cboEmployee.Enabled = false; txtSerieStart.Text = ""; txtSerieEnd.Text = ""; txtSerieStart.Focus(); } else if (_flag == 2) { // nhap cua tim serie ve _flag = 0; if (_pageTotal > 0) { dtGrid.Rows.Clear(); var item = FindInListTable(itemTicket_delivery, _lstTicketDelivery); if (item == null) { lblMsg.Text = "Không tim thấy vé."; cboEmployee.SelectedIndex = 0; lblPageInfo.Text = ""; return; } DataGridViewRow row = (DataGridViewRow)dtGrid.RowTemplate.Clone(); row.CreateCells(dtGrid, 1, false, item.ticket_name, item.ticketSerie, item.startSerie, item.endSerie, item.quantity, item.deliveryer_name, item.delivery_date, item.ticket_type); dtGrid.Rows.Add(row); cboEmployee.Text = item.receiver_name; lblPageInfo.Text = "1/1"; btnPre.Enabled = false; btnNext.Enabled = false; } } } catch (Exception) { } }