public IEnumerable <PayrollForms> GetAllPayrollForms() { var result = new List <PayrollForms>(); using (var connection = MSSQLdb.GetConnection()) { SqlCommand cmd = new SqlCommand("GetAllPayrollForms", connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var payrollForms = new PayrollForms { IDEmployee = (int)reader["IDEmployee"], IDSalary = (int)reader["IDSalary"] }; result.Add(payrollForms); } } return(result); }
public static void AddPayrollForm() { Console.WriteLine("Введите ID зарплаты"); var idSalary = Console.ReadLine(); Console.WriteLine("Введите ID сотрудника"); var idEmployee = Console.ReadLine(); var currentinfo = new PayrollForms() { IDEmployee = Int32.Parse(idEmployee), IDSalary = Int32.Parse(idSalary) }; payrollFormsLogic.AddPayrollForm(currentinfo); }
//private string connnectionString = "Data Source=DESKTOP-EMEUIMH\\SQLEXPRESS; Initial Catalog = Company; Integrated Security = True"; public int AddPayrollForm(PayrollForms value) { using (var connection = MSSQLdb.GetConnection()) { SqlCommand cmd = connection.CreateCommand(); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "AddPayrollForm"; cmd.Parameters.Add(new SqlParameter("@IDEmployee", value.IDEmployee)); cmd.Parameters.Add(new SqlParameter("@IDSalary", value.IDSalary)); connection.Open(); Object tmp = cmd.ExecuteScalar(); if (tmp == null) { return(-1); } return((int)tmp); //return (int)cmd.ExecuteScalar(); } }
public int AddPayrollForm(PayrollForms value) { return(this.payrollFormsDao.AddPayrollForm(value)); }