private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
DataRowView prevdrv = null;
if (bsLikmes.Count > 0)
{
prevdrv = bsLikmes[bsLikmes.Count - 1] as DataRowView;
}
var prevdr = prevdrv.Row as KlonsADataSet.RATESRow;
if (prevdr == null)
{
return;
}
var newdr = DataSetHelper.CopyRow(prevdr, null, -1) as KlonsADataSet.RATESRow;
if (newdr == null)
{
return;
}
newdr.BeginEdit();
newdr.ONDATE = DateTime.Today;
//newdr.ID = (int)MyData.KlonsQueriesTableAdapter.SP_RATES_ID();
newdr.ID = MyData.DataSetKlons.RATES.Max(d => d.ID) + 1;
newdr.EndEdit();
prevdr.Table.Rows.Add(newdr);
bsLikmes.Position = bsLikmes.Count - 1;
SaveData();
CheckSave();
}
private void AddPersonsRRow()
{
var drv_cur_p = bsPersons.Current as DataRowView;
if (drv_cur_p == null)
{
return;
}
var row_cur_p = drv_cur_p.Row as KlonsADataSet.PERSONSRow;
if (row_cur_p == null)
{
return;
}
if (bsPersonsR.Count == 0)
{
return;
}
var drv_last_pr = bsPersonsR[0] as DataRowView;
var row_last_pr = drv_last_pr.Row as KlonsADataSet.PERSONS_RRow;
var lastdt = row_last_pr.EDIT_DATE;
if (lastdt == DateTime.Today)
{
MyMainForm.ShowWarning("Jaunu labojumu nevar izveidot, jo\n" +
"labojums ar šodienas dautunu jau ir izveidots.");
return;
}
var table_pr = MyData.DataSetKlons.PERSONS_R;
var row_new_pr = DataSetHelper.CopyRow(row_last_pr, null, -1) as KlonsADataSet.PERSONS_RRow;
row_new_pr.EDIT_DATE = DateTime.Today;
if (!string.IsNullOrEmpty(row_cur_p.FNAME))
{
row_new_pr.FNAME = row_cur_p.FNAME;
}
if (!string.IsNullOrEmpty(row_cur_p.LNAME))
{
row_new_pr.LNAME = row_cur_p.LNAME;
}
if (!string.IsNullOrEmpty(row_cur_p.PK))
{
row_new_pr.PERSON_CODE = row_cur_p.PK;
}
table_pr.AddPERSONS_RRow(row_new_pr);
bsPersonsR.Position = 0;
}
private void AddAmatiRRow()
{
var drv_cur_am = bsAmati.Current as DataRowView;
if (drv_cur_am == null)
{
return;
}
var row_cur_am = drv_cur_am.Row as KlonsADataSet.POSITIONSRow;
if (row_cur_am == null)
{
return;
}
if (bsAmatiR.Count == 0)
{
return;
}
var drv_last_amr = bsAmatiR[0] as DataRowView;
var row_last_amr = drv_last_amr.Row as KlonsADataSet.POSITIONS_RRow;
var lastdt = row_last_amr.EDIT_DATE;
if (lastdt == DateTime.Today)
{
MyMainForm.ShowWarning("Jaunu labojumu nevar izveidot, jo\n" +
"labojums ar šodienas dautunu jau ir izveidots.");
return;
}
var table_amr = MyData.DataSetKlons.POSITIONS_R;
var row_new_amr = DataSetHelper.CopyRow(row_last_amr, null, -1) as KlonsADataSet.POSITIONS_RRow;
row_new_amr.EDIT_DATE = DateTime.Today;
if (!string.IsNullOrEmpty(row_cur_am.TITLE))
{
row_new_amr.TITLE = row_cur_am.TITLE;
}
if (!string.IsNullOrEmpty(row_cur_am.IDDEP))
{
row_new_amr.IDDEP = row_cur_am.IDDEP;
}
table_amr.AddPOSITIONS_RRow(row_new_amr);
bsAmatiR.Position = 0;
}
