private void btnSave_Click(object sender, EventArgs e)
{
try
{
// luu xong thi tra ve default. nho check grid count
if (_flag == 1 && dtGrid.Rows.Count > 0)
{
var _iCenter_ticket_store = new Center_ticket_store();
center_ticket_store _center_ticket_store;
int _sNum, _eNum;
foreach (DataGridViewRow row in dtGrid.Rows)
{
_sNum = Int32.Parse(row.Cells[3].Value.ToString());
_eNum = Int32.Parse(row.Cells[4].Value.ToString());
_center_ticket_store = new center_ticket_store()
{
ticket_serie = row.Cells[2].Value.ToString(),
ticket_name = row.Cells[1].Value.ToString(),
//ticket_type = GetTicketId(row.Cells[2].Value.ToString().Trim()).id,
ticket_type = row.Cells[8].Value.ToString(),
start_number_serie = _sNum,
end_number_serie = _eNum,
date_store = DateTime.Now,
date_out = DateTime.Now,
outForSale = false,
quantity = _eNum - _sNum + 1,
book_number = (_eNum - _sNum + 1) / 100
};
if (_iCenter_ticket_store.Add(_center_ticket_store))
{
lblMsg.Text = SystemMessage.WarningSaveSuccess;
_lstTicketStore.Add(_center_ticket_store);
}
else
{
break;
}
}
_flag = 0;
btnNew.Text = "Thêm mới";
}
}
catch (Exception)
{
}
}
public bool Add(center_ticket_store ticket_store)
{
bool rs = false;
try
{
db.center_ticket_store.Add(ticket_store);
db.SaveChanges();
rs = true;
}
catch (Exception)
{
rs = false;
}
return(rs);
}
private void AddDataRow(center_ticket_store item)
{
#region "format_grid"
int wdtg = dtGrid.Width;
dtGrid.Columns[0].Width = (wdtg * 10) / 100;
dtGrid.Columns[1].Width = (wdtg * 30) / 100;
dtGrid.Columns[2].Width = (wdtg * 10) / 100;
dtGrid.Columns[3].Width = (wdtg * 10) / 100;
dtGrid.Columns[4].Width = (wdtg * 10) / 100;
dtGrid.Columns[5].Width = (wdtg * 10) / 100;
dtGrid.Columns[6].Width = (wdtg * 10) / 100;
dtGrid.Columns[7].Width = wdtg - (
dtGrid.Columns[0].Width +
dtGrid.Columns[1].Width +
dtGrid.Columns[2].Width +
dtGrid.Columns[3].Width +
dtGrid.Columns[4].Width +
dtGrid.Columns[5].Width +
dtGrid.Columns[6].Width
);
#endregion
#region "add_newRow"
int pos = dtGrid.RowCount + 1;
DataGridViewRow row = (DataGridViewRow)dtGrid.RowTemplate.Clone();
row.CreateCells(dtGrid,
pos,
item.ticket_name,
item.ticket_serie,
item.start_number_serie,
item.end_number_serie,
item.quantity,
item.book_number,
item.date_store,
item.ticket_type);
dtGrid.Rows.Add(row);
#endregion
}
private bool CheckSerieInDataRow(center_ticket_store item)
{
bool isCheck = false;
int _sNum, _eNum;
try
{
foreach (DataGridViewRow row in dtGrid.Rows)
{
if (item.ticket_serie == row.Cells[2].Value.ToString())
{
_sNum = Int32.Parse(row.Cells[3].Value.ToString());
_eNum = Int32.Parse(row.Cells[4].Value.ToString());
if ((item.start_number_serie >= _sNum) && (item.end_number_serie <= _eNum))
{
isCheck = true;
break;
}
if (_sNum >= item.start_number_serie && _sNum <= item.end_number_serie)
{
isCheck = true;
break;
}
if (_eNum >= item.start_number_serie && _eNum <= item.end_number_serie)
{
isCheck = true;
break;
}
}
}
}
catch (Exception)
{
}
return(isCheck);
}
private bool CheckSerieInTable(center_ticket_store item)
{
bool isCheck = false;
try
{
var temp = (from a in _lstTicketStore
where (a.ticket_serie == item.ticket_serie)
orderby a.start_number_serie descending
select a).ToList();
foreach (var j in temp)
{
if (item.start_number_serie <= j.end_number_serie)
{
isCheck = true;
break;
}
}
}
catch (Exception)
{
}
return(isCheck);
}
private void txtSerieEnd_KeyUp(object sender, KeyEventArgs e)
{
try
{
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));
#region "check_input"
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 "create_dataRow"
// neu nhat nut them thi flag = 1 va neu chua co trong grid thi dua du lieu vao grid
// neu flag dang la 0 thi la tim kiem
if (_flag == 0)
{
_flag = 2;
} // dung co la dang tim ve
if (_flag == 1)
{
// neu nhap cua them moi
#region "get_infoticket"
center_ticket_type item = GetTicketId(_ticketSerie);
if (item == null)
{
lblMsg.Text = SystemMessage.WarningTableTicketTypeNull; return;
}
#endregion
#region "check_ticket_input"
var _tk = new center_ticket_store()
{
ticket_serie = _ticketSerie,
ticket_name = item.ticket_name,
ticket_type = item.id,
start_number_serie = _sNum,
end_number_serie = _eNum,
date_store = DateTime.Now,
date_out = DateTime.Now,
outForSale = false,
quantity = _eNum - _sNum + 1,
book_number = (_eNum - _sNum + 1) / 100,
};
// ktra da nhap vao grid chua
if (CheckSerieInDataRow(_tk))
{
lblMsg.Text = SystemMessage.WarningExitInputTicket;
return;
}
// ktra da nhap vao table chua
if (CheckSerieInTable(_tk))
{
lblMsg.Text = SystemMessage.WarningSaveTicket;
return;
}
#endregion
AddDataRow(_tk);
txtSerieStart.Text = "";
txtSerieEnd.Text = "";
txtSerieStart.Focus();
}
else if (_flag == 2)
{
// neu nhap la tim kiem
if (_pageTotal > 0)
{
var lst = FindTicketBySerie(_lstTicketStore, _ticketSerie, _sNum, _eNum);
int p = 0;
if (lst.Count > 0)
{
p = 1;
}
FillData(lst, p, 0, p);
_flag = 0;
}
}
#endregion
}
catch (Exception)
{
}
}
