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)
{
}
}
