예제 #1
0
        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;
        }
예제 #2
0
        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);
        }
예제 #3
0
        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();
            }
        }
예제 #4
0
        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;
            }
        }
예제 #5
0
        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);
        }
예제 #6
0
 public void remove(KnygosDataSet1 dataSet, int n)
 {
     dataSet.Table[n].Zmogus = 0;
     dataSet.Table[n][4]     = DBNull.Value;
 }
예제 #7
0
 public void delete(KnygosDataSet1 dataSet, int n)
 {
     dataSet.Table.Rows.Remove(dataSet.Table[n]);
 }