public void Edit(SalaryModel salaryModel)
{
double amount = salaryModel.SalaryPaidAmount;
int empId = salaryModel.EmployeeId;
// actorName = actor.ActorName;
var InsertQuery = "UPDATE salary" +
" SET salary_amount_paid = @amount" +
" WHERE Fk_EmployeeId = @empId ";
SqlDataAccess d = new SqlDataAccess(con.GetConnectionForSql());
d.Connection.Open();
var cmd = d.Command(InsertQuery);
// AddObjectParameter(d, cmd, "actorId", actorId);
AddObjectParameter(d, cmd, "amount", amount);
AddObjectParameter(d, cmd, "empId", empId);
d.ExecuteInlineSqlQueryForUpdate(cmd);
}
public void Edit(EmployeeModel employeeModel)
{
string Name = employeeModel.Name;
int id = employeeModel.Id;
// string Desig = employeeModel.Designation;
// actorName = actor.ActorName;
var InsertQuery = "UPDATE employee" +
" SET Name = @Name" +
" WHERE Id = @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);
AddObjectParameter(d, cmd, "Id", id);
d.ExecuteInlineSqlQueryForUpdate(cmd);
}
