internal string Insertmanager(Entity.EmployeeEntity employee)
{
using (var sqlCon = new SqlConnection(con))
{
//var command = new SqlCommand(@"INSERT INTO EmpTable (EmpId, EmpName,ActiveEmp) Values(@empId,@name,@ActiveEmp)", sqlCon);
var command1 = new SqlCommand(@" INSERT INTO EmployeeManager(ManagerId, ActiveEmp, PrimaryManager,Id) VALUES (@ManagerId,@Active,@PrimaryManager,@Id)", sqlCon);
sqlCon.Open();
command1.Parameters.AddWithValue("@ManagerId", employee.ManagerId);
command1.Parameters.AddWithValue("@Active", employee.Active);
command1.Parameters.AddWithValue("@PrimaryManager", employee.PrimaryManager);
command1.Parameters.AddWithValue("@Id", employee.Id);
if (Convert.ToInt32(command1.ExecuteNonQuery()) > 0)
{
return("Success");
}
return("something worng in insert operation. try again...");
}
}
//internal List<Entity.EmployeeEntity> GetManagerDetails(int Id)
//{
// var employees = new List<Entity.EmployeeEntity>();
// using (var sqlCon = new SqlConnection(con))
// {
// sqlCon.Open();
// //var command = new SqlCommand(@"select EmpId, EmpName, ManagerId from Employee1 as t1 where ManagerId = @empId or exists (select* from Employee1 as t2 where EmpId = t1.ManagerId and( ManagerId = @empId or exists (select * from Employee1 as t3 where EmpId = t2.ManagerId and ManagerId = @empId))) " , sqlCon);
// var command = new SqlCommand(@"SELECT b.Id , a.FirstName ManagerName FROM Employees a INNER JOIN EmployeeManager b ON b.ManagerId = a.Id where b.Id =@id ", sqlCon);
// //var command = new SqlCommand(@"SELECT DISTINCT e.EmpId AS 'ManagerId', e.EmpName AS 'ManagerName' FROM Employees e, Employees m WHERE e.ManagerId = @id", sqlCon);
// command.Parameters.AddWithValue("@id", Id);
// using (var reader = command.ExecuteReader())
// {
// while (reader.Read())
// {
// employees.Add(new Entity.EmployeeEntity
// {
// Id = reader.GetInt32(0),
// //FirstName = reader.GetString(1),
// //LastName = reader.GetString(2),
// //Active = reader.GetBoolean(3),
// //UserName = reader.GetString(4),
// //Password = reader.GetString(5),
// //Mobile = reader.GetString(6),
// //Address1 = reader.GetString(7),
// //Address2 = reader.GetString(8),
// //City = reader.GetString(9),
// //State = reader.GetString(10),
// //Zip = reader.GetString(11),
// //Dob = reader.GetDateTime(12),
// //JoiningDate = reader.GetDateTime(13),
// //ManagerId = reader.GetInt32(14),
// //ActiveEmp = reader.GetBoolean(15),
// //PrimaryManager = reader.GetBoolean(16),
// ManagerName = reader.GetString(17),
// });
// }
// return employees;
// }
// }
//}
internal string UpdateManager(Entity.EmployeeEntity employees, int Id)
{
using (var sqlCon = new SqlConnection(con))
{
var command = new SqlCommand(@"update EmployeeManager set ManagerId = @managerId, ActiveEmp =@activeEmp, PrimaryManager = @primaryManager where Id = @id", sqlCon);
//var command = new SqlCommand(@"UPDATE Employee1 SET EmpName = @name, EmpAddress= @address WHERE ManagerId = @managerId", sqlCon);
sqlCon.Open();
command.Parameters.AddWithValue("@id", Id);
command.Parameters.AddWithValue("@managerId", employees.ManagerId);
command.Parameters.AddWithValue("@activeEmp", employees.ActiveEmp);
command.Parameters.AddWithValue("@primaryManager", employees.PrimaryManager);
if (Convert.ToInt32(command.ExecuteNonQuery()) > 0)
{
return("Success");
}
return("something worng in insert operation. try again...");
}
}
