public List <Depertment> RetrivedataFromDatabase() { string query = @"SELECT * FROM DepertmentInfo"; List <Depertment> depertments = new List <Depertment>(); //*****Database Operation Starts******** connection.Open(); aCommand = new SqlCommand(query, connection); aReader = aCommand.ExecuteReader(); if (aReader.HasRows) { while (aReader.Read()) { Depertment aDepertment = new Depertment(); aDepertment.DepertmentID = (int)aReader[0]; aDepertment.DepertmentName = aReader[1].ToString(); aDepertment.DepertmentCode = aReader[2].ToString(); depertments.Add(aDepertment); } } connection.Close(); //*****Database Operation Ends******** return(depertments); }
private void saveButton_Click(object sender, EventArgs e) { Depertment aDepertment = new Depertment(); string name = studentNameTextBox.Text; string email = emailTextBox.Text; string address = addressTextBox.Text; string depertmentId; studentNameTextBox.Text = string.Empty; emailTextBox.Text = string.Empty; addressTextBox.Text = string.Empty; Student aStudent = new Student(); aStudent.StudentName = name; aStudent.Email = email; aStudent.Address = address; aDepertment = (Depertment)depertmentComboBox.SelectedItem; aStudent.DepertmentId = aDepertment.DepertmentID; aStudentBll = new StudentBLL(); string confirmationMessege = aStudentBll.Save(aStudent); MessageBox.Show(confirmationMessege); ShowInGridView(); }
private void saveButton_Click(object sender, EventArgs e) { Depertment aDepertment = new Depertment(nameTextBox.Text, codeTextBox.Text); aDepertmentBll = new DepertmentBLL(); string messege = aDepertmentBll.CheckAndSave(aDepertment); MessageBox.Show(messege); ShowInGridView(); }
static void Main(string[] args) { Console.Write("Enter department's name: "); string departName = Console.ReadLine(); Console.WriteLine("Enter worker data: "); Console.Write("Name: "); string name = Console.ReadLine(); Console.Write("Level (Junior/MidLevel/Senior): "); WorkerLvel level = Enum.Parse <WorkerLvel>(Console.ReadLine()); Console.Write("Base salary: "); double baseSalary = double.Parse(Console.ReadLine(), CultureInfo.InvariantCulture); Depertment depertment = new Depertment(departName); Worker worker = new Worker(name, level, baseSalary, depertment); Console.WriteLine(); Console.Write("How many contracts to this worker ? "); int n = int.Parse(Console.ReadLine()); Console.WriteLine(); for (int i = 1; i <= n; i++) { Console.WriteLine($"Enter #{i} contract data: "); Console.Write("Date (DD/MM/YYYY): "); DateTime date = DateTime.Parse(Console.ReadLine()); Console.Write("Valeu per hour: "); double valeuPerHour = double.Parse(Console.ReadLine(), CultureInfo.InvariantCulture); Console.Write("Duration (hours): "); int duration = int.Parse(Console.ReadLine()); Console.WriteLine(); HourContract contract = new HourContract(date, valeuPerHour, duration); worker.AddContract(contract); } Console.WriteLine(); Console.Write("Enter month and year to calculate income (MM/YYYY): "); string monthAndYear = Console.ReadLine(); int month = int.Parse(monthAndYear.Substring(0, 2)); int year = int.Parse(monthAndYear.Substring(3)); Console.WriteLine("Name: " + worker.Name); Console.WriteLine("Depertment: " + worker.Depertment.Name); Console.WriteLine("Income for " + monthAndYear + ": " + worker.Income(year, month).ToString("f2", CultureInfo.InvariantCulture)); }
public int SaveInDatabase(Depertment aDepertment) { string query = string.Format("INSERT INTO DepertmentInfo VALUES ('{0}','{1}')", aDepertment.DepertmentName, aDepertment.DepertmentCode); //*****Database Operation Starts******** connection.Open(); aCommand = new SqlCommand(query, connection); int isAffected = aCommand.ExecuteNonQuery(); connection.Close(); //*****Database Operation Ends******** return(isAffected); }
public string CheckAndSave(Depertment aDepertment) { if (aDepertment.DepertmentName != string.Empty || aDepertment.DepertmentCode != string.Empty) { if (DepertmentNotAlreadyExists(aDepertment)) { int isAffected = aDepertmentGateway.SaveInDatabase(aDepertment); if (isAffected > 0) { return("Data Saved In DataBase"); } else { return("Something Wrong with Insertion"); } } return("Data is already Exist"); } return(@"Fill up all the fields"); }
public bool Check(Depertment aDepertment) { string name = aDepertment.DepertmentName; string query = string.Format("SELECT * FROM DepertmentInfo WHERE DeptName='{0}'", name); //*****Database Operation Starts******** connection.Open(); aCommand = new SqlCommand(query, connection); aReader = aCommand.ExecuteReader(); if (aReader.HasRows) { return(false); } connection.Close(); //*****Database Operation Ends******** return(true); }
private bool DepertmentNotAlreadyExists(Depertment aDepertment) { return(aDepertmentGateway.Check(aDepertment)); }
private void saveButton_Click(object sender, EventArgs e) { aDepertment = new Depertment(departmentCodeTextBox.Text,DepartmentNameTextBox.Text); MessageBox.Show("Department Created"); }
Task <Depertment> IRepository <Depertment> .UpdateRange(Depertment entity) { throw new NotImplementedException(); }
Task <bool> IRepository <Depertment> .Delete(Depertment entity) { throw new NotImplementedException(); }
Task <Depertment> IRepository <Depertment> .Add(Depertment entity) { throw new NotImplementedException(); }