public void take(KnygosDataSet1 dataSet, int n, int ID) { DateTime Data = DateTime.Today; Data = Data.AddMonths(1); dataSet.Table[n].Zmogus = ID; dataSet.Table[n][4] = Data; }
public void add(KnygosDataSet1 dataSet, String autorius, String pavadinimas) { int id = generateId(dataSet); DataRow anyRow = dataSet.Table.NewRow(); anyRow[0] = id; anyRow[1] = autorius; anyRow[2] = pavadinimas; anyRow[3] = 0; dataSet.Table.Rows.Add(anyRow); }
public void delete(KnygosDataSet1 dataSet, int n) { //dataSet.Table.Rows.Remove(dataSet.Table[n]); using (LibraryDataEntities2 dataEntities = new LibraryDataEntities2()) { Knygo knygo = (from c in dataEntities.Knygos where c.Id == n select c).FirstOrDefault(); dataEntities.Knygos.Remove(knygo); dataEntities.SaveChanges(); } }
public void extend(KnygosDataSet1 dataSet, int n) { DateTime grazinimoData = (DateTime)dataSet.Table[n][4]; if (dataSet.Table[n][4] == DBNull.Value) { throw new Exception("Knyga niekam nepriklauso"); } else if (baudosDydis(grazinimoData) > 0) { throw new Exception("Negalima pratesti grazinimo datos. Bauda jau pradeta skaiciuoti."); } else { grazinimoData = grazinimoData.AddMonths(1); dataSet.Table[n][4] = grazinimoData; } }
private int generateId(KnygosDataSet1 knygosDataSet1) { int i; int id = 1000; for (i = 0; i < knygosDataSet1.Table.Count; i++) { if ((int)knygosDataSet1.Table[i][0] == id) { id++; } else { return(id); } } return(id); }
public void remove(KnygosDataSet1 dataSet, int n) { dataSet.Table[n].Zmogus = 0; dataSet.Table[n][4] = DBNull.Value; }
public void delete(KnygosDataSet1 dataSet, int n) { dataSet.Table.Rows.Remove(dataSet.Table[n]); }