public int AddEmployee(EmployeeModel employeeModel)
{
string Name = employeeModel.Name;
// actorName = actor.ActorName;
var InsertQuery = "INSERT INTO Employee(Name ) " +
"VALUES (@Name) ;SELECT @@IDENTITY AS 'ID';";
SqlDataAccess d = new SqlDataAccess(con.GetConnectionForSql());
d.Connection.Open();
var cmd = d.Command(InsertQuery);
// AddObjectParameter(d, cmd, "actorId", actorId);
AddObjectParameter(d, cmd, "Name", Name);
int i = d.ExecuteInlineSqlQueryNew(cmd);
return(i);
}
public int AddSalary(SalaryModel salaryModel)
{
double salary = salaryModel.SalaryPaidAmount;
DateTime salaryDate = salaryModel.Date;
int empId = salaryModel.EmployeeId;
// actorName = actor.ActorName;
var InsertQuery = "INSERT INTO salary(salary_amount_paid,Fk_EmployeeId ) " +
"VALUES (@salary,@empId) ;SELECT @@IDENTITY AS 'ID'; ";
SqlDataAccess d = new SqlDataAccess(con.GetConnectionForSql());
d.Connection.Open();
var cmd = d.Command(InsertQuery);
// AddObjectParameter(d, cmd, "actorId", actorId);
AddObjectParameter(d, cmd, "salary", salary);
AddObjectParameter(d, cmd, "empId", empId);
int i = d.ExecuteInlineSqlQueryNew(cmd);
// d.Connection.Close();
return(i);
}