static void Main(string[] args)
{
Console.WriteLine("Введите свою дату рождения");
Console.Write("Год = ");
int year = Convert.ToInt32(Console.ReadLine());
Console.Write("Месяц = ");
int month = Convert.ToInt32(Console.ReadLine());
Console.Write("День = ");
int day = Convert.ToInt32(Console.ReadLine());
Console.WriteLine($"Вот ваш знак задиака - {Proverka.Zodiac(year, month, day)}");
Console.WriteLine($"Родились в год - {Proverka.Сalendar(year, month, day)}");
Console.ReadKey();
}
public void dbEnter(string login, string password)
{
command.CommandText = "SELECT [ID_Sotrudnika] FROM [INGPROMTORG].[dbo].[Sotrudniki] WHERE [Sotrudnika_Login] = '" + login + "' and [Sotrudnika_Password] = '" + password + "'";
try
{
connection.Open();
IDUser = Convert.ToInt32(command.ExecuteScalar().ToString());
command.CommandText = "SELECT [Dolgnost_ID] FROM [INGPROMTORG].[dbo].[Sotrudniki] WHERE [ID_Sotrudnika] like '%" + IDUser.ToString() + "%'";
Proverka = Convert.ToInt32(command.ExecuteScalar().ToString());
command.CommandText = "SELECT [Dostup_Dolgnost] FROM [INGPROMTORG].[dbo].[Dolgnost] WHERE [ID_Dolgnost] like '%" + Proverka.ToString() + "%'";
Dostup = command.ExecuteScalar().ToString();
sot = Dostup[0].ToString();
dol = Dostup[1].ToString();
pokup = Dostup[2].ToString();
usl = Dostup[3].ToString();
tovar = Dostup[4].ToString();
tovn = Dostup[5].ToString();
trann = Dostup[6].ToString();
dog = Dostup[7].ToString();
}
catch
{
IDUser = 0;
}
finally
{
connection.Close();
}
}
