public static void UpdateEmployee(CEmployee employee)
{
string Sql = string.Format(@"UPDATE [dbo].[Empoyee]
SET [SurName] = '{0}'
,[FirstName] = '{1}'
,[Patronymic] ='{2}'
,[DateOfBirth] = convert(varchar, convert(datetime, '{3}', 104), 121)
,[DocSeries] = '{4}'
,[DocNumber] ='{5}'
,[Position] = '{6}'
,[DepartmentID] = '{7}'
WHERE ID='{8}'
",
employee.FirstName,
employee.SurName,
employee.Patronymic,
Convert.ToDateTime(employee.DateOfBirth),
employee.DocSeries,
employee.DocNumber,
employee.Position,
employee.GetDepartmentID(),
employee.ID);
CBranch Branch = new CBranch(Sql);
Branch.ExecSql();
Branch.Dispose();
}
public static void InsertIntoEmployee(CEmployee employee)
{
string Sql = string.Format(@" INSERT INTO[dbo].[Empoyee]
([FirstName]
,[SurName]
,[Patronymic]
,[DateOfBirth]
,[DocSeries]
,[DocNumber]
,[Position]
,[DepartmentID])
VALUES (
'{0}',
'{1}',
'{2}',
convert(varchar, convert(datetime, '{3}', 104), 121),
'{4}',
'{5}',
'{6}',
'{7}')
",
employee.FirstName,
employee.SurName,
employee.Patronymic,
Convert.ToDateTime(employee.DateOfBirth),
employee.DocSeries,
employee.DocNumber,
employee.Position,
employee.GetDepartmentID());
CBranch Branch = new CBranch(Sql);
Branch.ExecSql();
Branch.Dispose();
}
public static void DeleteFromEmployee(CEmployee employee)
{
string Sql = string.Format(@"DELETE FROM [dbo].[Empoyee]
WHERE ID='{0}'
", employee.ID);
CBranch Branch = new CBranch(Sql);
Branch.ExecSql();
Branch.Dispose();
}
public static void UpdateDeptIDInEmployee(CEmployee employee)
{
string Sql = string.Format(@"UPDATE [dbo].[Empoyee]
SET [DepartmentID] = '{0}'
WHERE ID='{1}'
",
employee.GetDepartmentID(),
employee.ID);
CBranch Branch = new CBranch(Sql);
Branch.ExecSql();
Branch.Dispose();
}