public EmployeeModel Get(string id) { EmployeeRequestObject req = new EmployeeRequestObject(); EmployeeModel e = null; int EmpId = Convert.ToInt32(id); int EmpID = EmpId; string getAllEmp = "select * from employee where Id=@id"; SqlDataAccess d = new SqlDataAccess(con.GetConnectionForSql()); d.Connection.Open(); var cmd = d.Command(getAllEmp); AddObjectParameter(d, cmd, "Id", EmpID); IDataReader d1 = d.ReadData(cmd); { if (d1.Read()) { e = new EmployeeModel(); var empid = d1["Id"]; e.Id = Convert.ToInt32(empid); //var empName = d1["Name"]; //e.Name = Convert.ToString(empName); } // e.Id = ddd.; } return(e); d.Connection.Close(); }
public List <EmployeeModel> GetAll() { List <EmployeeModel> lst = new List <EmployeeModel>(); string getAllEmp = "select * from employee"; SqlDataAccess d = new SqlDataAccess(con.GetConnectionForSql()); d.Connection.Open(); var cmd = d.Command(getAllEmp); DataSet ds = d.ExecuteDataSetForSqlQueryNew(cmd); var table = ds.Tables[0]; for (int i = 0; i < table.Rows.Count; i++) { var id = table.Rows[i]["Id"]; EmployeeModel e = new EmployeeModel(); e.Id = Convert.ToInt32(id); var Name = table.Rows[i]["Name"]; e.Name = Convert.ToString(Name); lst.Add(e); Console.WriteLine(id); Console.WriteLine(Name); } return(lst); }
public List <SalaryModel> GetAll() { List <SalaryModel> lst = new List <SalaryModel>(); string getAllEmp = "select * from salary"; SqlDataAccess d = new SqlDataAccess(con.GetConnectionForSql()); d.Connection.Open(); var cmd = d.Command(getAllEmp); DataSet ds = d.ExecuteDataSetForSqlQueryNew(cmd); var table = ds.Tables[0]; for (int i = 0; i < table.Rows.Count; i++) { var id = table.Rows[i]["Fk_EmployeeId"]; SalaryModel e = new SalaryModel(); e.EmployeeId = Convert.ToInt32(id); var amount = table.Rows[i]["salary_amount_paid"]; e.SalaryPaidAmount = Convert.ToDouble(amount); lst.Add(e); Console.WriteLine(id); Console.WriteLine(amount); } // return lst; return(lst); }
public SalaryModel Get(string id) { SalaryModel e = null; string getAllEmp = "select * from salary where Fk_EmployeeId=@id"; SqlDataAccess d = new SqlDataAccess(con.GetConnectionForSql()); d.Connection.Open(); var cmd = d.Command(getAllEmp); AddObjectParameter(d, cmd, "Id", Convert.ToInt32(id)); IDataReader d1 = d.ReadData(cmd); { if (d1.Read()) { e = new SalaryModel(); var empid = d1["Fk_EmployeeId"]; e.EmployeeId = Convert.ToInt32(empid); var salary = d1["salary_amount_paid"]; e.SalaryPaidAmount = Convert.ToDouble(salary); } // e.EmployeeId = ; } return(e); d.Connection.Close(); }
public void Delete(string id) { var DelQuery = "DELETE FROM Employee WHERE Id=@id "; SqlDataAccess d = new SqlDataAccess(con.GetConnectionForSql()); d.Connection.Open(); var cmd = d.Command(DelQuery); AddObjectParameter(d, cmd, "Id", Convert.ToInt32(id)); int count = d.ExecuteInlineSqlQuery(cmd); }
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 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); }
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); }