me (tab.Rows [i] [1]. ToString ()), DateTime.Today)> 0)=true;
} (! f)
{. Show («Книга не була повернута в бібліотеку»);;
}=true;
}=false;
}. DataSource=tab.DefaultView;=dataGridView1 [0, e.RowIndex]. Value.ToString ();;
} void dataGridView2_RowHeaderMouseClick (object sender, DataGridViewCellMouseEventArgs e)
{Comand=AR.OC.CreateCommand ();. CommandText=«SELECT B. * FROM " Book " B INNER JOIN " Copy " C ON B.ISBN=C. ISBN AND B.ISBN=(select to_char («» + isbn +" ") from dual) AND C. " cLost "=0 AND C. " woCode " IS NULL » +
«INNER JOIN " Issuance " I ON I. " cNumber " = C. " cNumber " AND I. " iFactReturn " IS NULL» +
«INNER JOIN " Reader " R ON R. " rNumber " = I. " rNumber " AND R. " rNumber " = (select to_number (« » ; + AR.rNumber +" ") from dual) »; tab=new DataTable ();. Load (Comand.ExecuteReader ()); (tab.Rows.Count!=0)
{. Show («Ви вже вибрали цю книгу»);;
} (! clc)
{= Convert.ToInt32 (dataGridView2 [0, e.RowIndex]. Value);. Visible=true;. Visible=true;. Enabled=true;
}
} void comboBox1_SelectedIndexChanged (object sender, EventArgs e)
{(flag)
{tab; Comand=AR.OC.CreateCommand ();. CommandText=«SELECT B. * FROM " Book " B, " saved " s WHERE B.ISBN=s . ISBN AND s. " sCode "=» +. SelectedValue.ToString ();=new DataTable ();. Load (Comand.ExecuteReader ());. DataSource=tab.DefaultView;
}=false;
} void comboBox1_MouseClick (object sender, MouseEventArgs e)
{= true;
} void button2_Click (object sender, EventArgs e)
{(DateTime.Compare (dateTimePicker1.Value, DateTime.Today) <= 0)
{. Show («Дата повернення повинна бути більше поточної дати»);;
} tab; Comand=AR.OC.CreateCommand ();. CommandText=«SELECT B. * FROM " Book " B INNER JOIN " Copy " C ON B.ISBN= C.ISBN AND C. " cLost "=0 AND C. " woCode " IS NULL » +
«INNER JOIN " Issuance " I ON I. " cNumber " = C. " cNumber " AND I. " iFactReturn " IS NULL» +
«INNER JOIN " Reader " R ON R. " rNumber " = I. " rNumber " AND R. " rNumber " = (select to_number (« » ; + AR.rNumber +" ") from dual) »;=new DataTable ();. Load (Comand.ExecuteReader ()); (tab.Rows.Count == 5)
{. Show («Ви взяли вже п'ять книг і не можете вибирати нові»);;
}. CommandText=«INSERT INTO " Issuance " (" iNumber " , " cNumber " , " rNumber " , " iIssuance " , " iExpReturn " , " iFactReturn " , ICHOICE)» +
«VALUES (0,» +
«(select to_number (« »+ cNumber +"" ) from dual),» +
«(select to_number (« »+ AR.rNumber +"" ) from dual),» +
«(select to_date (SYSDATE,« dd-mm-rr ») from dual),» +
«(select to_date (« »+ dateTimePicker1.Value.ToShortDateString () +"" ," dd-mm-rr ») from dual),» +
«null, 1)»;=new DataTable ();. Load (...
