public int Delete()
{
string deleteQuery = " DELETE FROM [dbo].[Doors] WHERE Id = " + Id;
int sonuc = DbOperation.ExecuteCommand(deleteQuery);
if (sonuc > 0)
{
//basarili
}
else
{
//sorun var!!!!!!!
}
return(sonuc);
}
public int Insert()
{
string insertQuery = " INSERT INTO [dbo].[Doors] ([Name],[DepartmentId]) VALUES ('" + Name + "','" + DepartmentId + "') ";
int sonuc = DbOperation.ExecuteCommand(insertQuery);
if (sonuc > 0)
{
//basarili
}
else
{
//sorun var!!!!!!!
}
return(sonuc);
}
public int Update()
{
string updateQuery = " UPDATE [dbo].[Doors] SET [Name] = '" + Name + "',[DepartmentId] = '" + DepartmentId + "' WHERE Id = " + Id;
int sonuc = DbOperation.ExecuteCommand(updateQuery);
if (sonuc > 0)
{
//basarili
}
else
{
//sorun var!!!!!!!
}
return(sonuc);
}
public int Insert()
{
string insertQuery = " INSERT INTO [dbo].[EmployeesRoles] ([EmployeeId],[RoleId]) VALUES ('" + EmployeeId + "','" + RoleId + "') ";
int sonuc = DbOperation.ExecuteCommand(insertQuery);
if (sonuc > 0)
{
//basarili
}
else
{
//sorun var!!!!!!!
}
return(sonuc);
}
public int Update()
{
string updateQuery = " UPDATE [dbo].[Employees] SET [FirstName] = '" + FirstName + "' ,[LastName] = '" + LastName + "' WHERE Id = " + Id;
int sonuc = DbOperation.ExecuteCommand(updateQuery);
if (sonuc > 0)
{
//basarili
}
else
{
//sorun var!!!!!!!
}
return(sonuc);
}
public int Insert()
{
string insertQuery = " INSERT INTO [dbo].[Employees] ([FirstName],[LastName]) VALUES('" + FirstName + "','" + LastName + "') ";
int sonuc = DbOperation.ExecuteCommand(insertQuery);
if (sonuc > 0)
{
//basarili
}
else
{
//sorun var!!!!!!!
}
return(sonuc);
}
public int Update()
{
string updateQuery = " UPDATE [dbo].[Authorizations] SET [RoleId] = '" + RoleId + "',[DoorId] = '" + DoorId + "' WHERE Id = " + Id;
int sonuc = DbOperation.ExecuteCommand(updateQuery);
if (sonuc > 0)
{
//basarili
}
else
{
//sorun var!!!!!!!
}
return(sonuc);
}
public static int DisableEmployeeRoleWithEmployeeId(int employeeId)
{
string updateQuery = @"UPDATE [dbo].[EmployeesRoles] SET [Status] = 'False',[EndDate] = getdate() WHERE EmployeeId = " + employeeId;
return(DbOperation.ExecuteCommand(updateQuery));
}
