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; }