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));
}
