private static void TypesOfWork()
{
bool IsSelect = ConnectToDataBase.MainImport(MainParentClass.DefaultConnection,
"SELECT [TypeOfWork],[ShortDesignation] " +
"FROM TypesOfWork",
out DataTable @table_Programs,
new ProgressOfUpdateAtStructAttribute());
if (IsSelect)
{
foreach (DataRow row in @table_Programs.Rows)
{
string @TypeOfWork = row[0] + "";
string @ShortDesignation = row[1] + "";
bool IsInsert = ConnectToDataBase.MainExport(MainParentClass.DefaultConnection,
"INSERT INTO[TypesOfWork] ([TypeOfWork],[ShortDesignation]) " +
"VALUES (@TypeOfWork,@ShortDesignation)",
new ProgressOfUpdateAtStructAttribute(),
new DbParameter[]
{
ConnectToDataBase.GetParammeter("@TypeOfWork", @TypeOfWork, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@ShortDesignation", @ShortDesignation, MainParentClass.DefaultConnection),
});
}
}
}
private static void TypeOfRecord()
{
bool IsSelect = ConnectToDataBase.MainImport(MainParentClass.DefaultConnection,
"SELECT [TypeOfRecord] " +
"FROM [TypeOfRecord]",
out DataTable @table_Programs,
new ProgressOfUpdateAtStructAttribute());
if (IsSelect)
{
foreach (DataRow row in @table_Programs.Rows)
{
string TypeOfRecord = row[0] + "";
bool IsInsert = ConnectToDataBase.MainExport(MainParentClass.DefaultConnection,
"INSERT INTO[TypeOfRecord] (TypeOfRecord) " +
"VALUES (@TypeOfRecord)",
new ProgressOfUpdateAtStructAttribute(),
new DbParameter[]
{
ConnectToDataBase.GetParammeter("@TypeOfRecord", TypeOfRecord, MainParentClass.DefaultConnection),
});
}
}
}
public List <User> GetUsers(SQLiteConnection SQLiteConnection)
{
List <User> Users = new List <User>();
string query = "SELECT [Login],[Password],[FkId_Worker] " +
"FROM [User] ";
bool IsSelect = ConnectToDataBase.MainImport(SQLiteConnection,
query,
out DataTable dataTable,
new ProgressOfUpdateAtStructAttribute(),
out TimeSpan TimeOnQuerySelect);
if (dataTable.Rows.Count > 0)
{
foreach (DataRow row in dataTable.Rows)
{
string Login = (row[0] + "").Trim();
string Password = (row[1] + "").Trim();
int FkId_Worker = int.TryParse((row[2] + "").Trim(), out int IP) ? IP : default;
Users.Add(new User()
{
Login = Login,
Password = Password,
HR_Worker = HR_Methods.GetWorker(FkId_Worker, SQLiteConnection)
});
}
}
else
{
}
return(Users);
}
private static void Statistic_WorkPlaces()
{
bool IsSelect = ConnectToDataBase.MainImport(MainParentClass.DefaultConnection,
"SELECT (SELECT [Name] FROM[Statistic_WorksArea] WHERE[Id] = [Fk_Id_WorkArea]),[Name] " +
"FROM Statistic_WorkPlaces",
out DataTable @table_Programs,
new ProgressOfUpdateAtStructAttribute());
if (IsSelect)
{
foreach (DataRow row in @table_Programs.Rows)
{
string NameArea = row[0] + "";
string Name = row[1] + "";
bool IsInsert = ConnectToDataBase.MainExport(MainParentClass.DefaultConnection,
"INSERT INTO[Statistic_WorkPlaces] ([Fk_Id_WorkArea],[Name]) " +
"VALUES ((SELECT [Id] FROM[Statistic_WorksArea] WHERE[Name] = @NameArea),@Name)",
new ProgressOfUpdateAtStructAttribute(),
new DbParameter[]
{
ConnectToDataBase.GetParammeter("@NameArea", NameArea, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@Name", Name, MainParentClass.DefaultConnection),
});
}
}
}
private static void Statistic_WorksArea()
{
bool IsSelect = ConnectToDataBase.MainImport(MainParentClass.DefaultConnection,
"SELECT [Name],[RemarksText],[Name_RussianEquivalent] " +
"FROM [Statistic_WorksArea]",
out DataTable @table_Programs,
new ProgressOfUpdateAtStructAttribute());
if (IsSelect)
{
foreach (DataRow row in @table_Programs.Rows)
{
string @Name = row[0] + "";
string @RemarksText = row[1] + "";
string @Name_RussianEquivalent = row[2] + "";
bool IsInsert = ConnectToDataBase.MainExport(MainParentClass.DefaultConnection,
"INSERT INTO[Statistic_WorksArea]([Name],[RemarksText],[Name_RussianEquivalent]) " +
"VALUES (@Name, @RemarksText, @Name_RussianEquivalent)",
new ProgressOfUpdateAtStructAttribute(),
new DbParameter[]
{
ConnectToDataBase.GetParammeter("@Name", @Name, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@RemarksText", @RemarksText, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@Name_RussianEquivalent", @Name_RussianEquivalent, MainParentClass.DefaultConnection),
});
}
}
}
private static void Statistic_Sessions()
{
bool IsSelect = ConnectToDataBase.MainImport(MainParentClass.DefaultConnection,
"SELECT (SELECT [Surname] FROM[Users] WHERE[Id] = [Fk_Id_User])," +
"(SELECT [Name] FROM[Statistic_WorkPlaces] WHERE[Id] = [Fk_Id_WorkPlace])," +
"[IpAddress],[DateStart],[DateEnd] " +
"FROM [Statistic_Sessions]",
out DataTable @table_Programs,
new ProgressOfUpdateAtStructAttribute());
if (IsSelect)
{
foreach (DataRow row in @table_Programs.Rows)
{
string Surname = row[0] + "";
string Name = row[1] + "";
string @IpAddress = row[2] + "";
DateTime @DateStart = DateTime.TryParse(row[3] + "", out DateTime DDateStart) ? DDateStart : default(DateTime);
DateTime @DateEnd = DateTime.TryParse(row[4] + "", out DateTime DDateEnd) ? DDateEnd : default(DateTime);
bool IsInsert = ConnectToDataBase.MainExport(MainParentClass.DefaultConnection,
"INSERT INTO[Statistic_Sessions] ([Fk_Id_User],[Fk_Id_WorkPlace],[IpAddress],[DateStart],[DateEnd]) " +
"VALUES ((SELECT [Id] FROM[Users] WHERE[Surname] = @Surname),(SELECT [Id] FROM[Statistic_WorkPlaces] WHERE[Name] = @Name),@IpAddress,@DateStart,@DateEnd)",
new ProgressOfUpdateAtStructAttribute(),
new DbParameter[]
{
ConnectToDataBase.GetParammeter("@Surname", Surname, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@Name", Name, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@IpAddress", @IpAddress, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@DateStart", @DateStart, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@DateEnd", @DateEnd, MainParentClass.DefaultConnection),
});
}
}
}
// PUT: api/Shedule/5
public void Put(Schedule value)
{
if (value != null && value.Id != 0)
{
using (var connection = ConnectToDataBase.GetConnection())
{
connection.Open();
using (var context = new TestProjectContext())
{
context.Schedules.Load();
var r = context.Schedules.Find(value.Id);
if (r != null)
{
r.TeacherId = value.TeacherId;
r.Data = value.Data;
r.DisciplineId = value.DisciplineId;
r.EndTime = value.EndTime;
r.StartTime = value.StartTime;
r.GroupId = value.GroupId;
context.SaveChanges();
}
}
}
}
}
private static void Professionss()
{
bool IsSelect = ConnectToDataBase.MainImport(MainParentClass.DefaultConnection,
"SELECT [NameOfProfession] " +
"FROM Professionss",
out DataTable @table_Programs,
new ProgressOfUpdateAtStructAttribute());
if (IsSelect)
{
foreach (DataRow row in @table_Programs.Rows)
{
string NameOfProfession = row[0] + "";
bool IsInsert = ConnectToDataBase.MainExport(MainParentClass.DefaultConnection,
"INSERT INTO[Professionss] ([NameOfProfession]) " +
"VALUES (@NameOfProfession)",
new ProgressOfUpdateAtStructAttribute(),
new DbParameter[]
{
ConnectToDataBase.GetParammeter("@NameOfProfession", NameOfProfession, MainParentClass.DefaultConnection),
});
}
}
}
//GET: api/User
public string Get()
{
try
{
var users = new List <User>();
using (var connection = ConnectToDataBase.GetConnection())
{
connection.Open();
using (var context = new TestProjectContext())
{
context.Users.Load();
users = context.Users.ToList();
return(JsonConvert.SerializeObject(users, Formatting.None,
new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}));
}
}
}
catch (Exception e)
{
Debug.WriteLine(e);
throw;
}
}
// POST: api/Authorization
public string Post([FromBody] User value)
{
User user = null;
using (var connection = ConnectToDataBase.GetConnection())
{
connection.Open();
using (SQLiteCommand fmd = connection.CreateCommand())
{
fmd.CommandText = $"Select * from user t where t.login ='******' and t.password='******'";
fmd.CommandType = CommandType.Text;
SQLiteDataReader reader = fmd.ExecuteReader();
while (reader.Read())
{
user = new User
{
GroupId = Convert.ToInt32(reader["group_id"]),
FullName = Convert.ToString(reader["fullname"]),
Login = Convert.ToString(reader["login"]),
Password = Convert.ToString(reader["password"])
};
}
return(user != null
? JsonConvert.SerializeObject(user, Formatting.None,
new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
})
: null);
}
}
}
public void Send(string PublisherUrl)
{
Console.WriteLine("MyHub connected to server");
System.IO.Directory.SetCurrentDirectory(System.AppDomain.CurrentDomain.BaseDirectory);
string topic = "device";
string url = PublisherUrl;
using (var context = new ZContext())
using (var subscriber = new ZSocket(context, ZSocketType.SUB))
{
//Create the Subscriber Connection
subscriber.Connect(url);
Console.WriteLine("Subscriber started for Topic with URL : {0} {1}", topic, url);
subscriber.Subscribe(topic);
int subscribed = 0;
//List<ThomsonData> lstLocationData = new List<ThomsonData>();
List <LocationData> lstLocationData = new List <LocationData>();
while (true)
{
using (ZMessage message = subscriber.ReceiveMessage())
{
subscribed++;
string contents = message[1].ReadString();
Console.WriteLine(contents);
LocationData objLocationData = JsonConvert.DeserializeObject <ListOfArea>(contents).device_notification.records.FirstOrDefault();
DateTime macFoundDatetime = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Local).AddSeconds(objLocationData.last_seen_ts);
objLocationData.LastSeenDatetime = macFoundDatetime;
//Remove the data if not present on the list for 30 minutes
//lstLocationData.Remove(lstLocationData.FirstOrDefault(m => m.LastSeenDatetime.AddMinutes(10) < DateTime.Now));
if (lstLocationData.Any(m => m.mac == objLocationData.mac))
{
Console.WriteLine("Enter into the section to Update old macAddress");
//Update the particular MacAddress from the List of data
var LocationDataObject = lstLocationData.FirstOrDefault(m => m.mac == objLocationData.mac);
//If old MacAddress then just update the x and y axis of the column
LocationDataObject.x = objLocationData.x;
LocationDataObject.y = objLocationData.y;
}
else
{
if (ConnectToDataBase.CheckMacAdressIsTrackableOrNot(objLocationData.mac) == 1)
{
Console.WriteLine("Enter into the section to Add new macAddress");
lstLocationData.Add(objLocationData);
}
}
string strReturn = JsonConvert.SerializeObject(lstLocationData);
Clients.All.addMessage(strReturn);
Console.Write("Added successfully to server");
Thread.Sleep(1000);
}
}
}
}
public static void UpdateConfig(ProgressOfUpdateAtStructAttribute Parent)
{
string CurrDirect = Directory.GetParent(LocalSettings.ApplicationBasePath).Parent.Parent.Parent.Parent.FullName;
NewBasePath = Path.Combine(CurrDirect, "ForSYSTECH_DB.db");
Tuple <SQLiteConnection, string> tuple = ConnectToDataBase.TryToConnectToSQLite(NewBasePath);
ConnectToDataBase.sqlite_conn = tuple.Item1;
}
private static void statistic()
{
bool IsSelect = ConnectToDataBase.MainImport(MainParentClass.DefaultConnection,
"SELECT [end_datetime],[expected_time],[list_name],[loading_time],[machine_time],[real_time],[setup_time],[start_datetime],[task_number]," +
"(SELECT [Name] FROM[Statistic_WorkPlaces] WHERE[Id] = [Fk_Id_Laser])," +
"[ChangedByManual],[CreatedByGenerateLog],[IsNightProgram],[IsNotSelected] " +
"FROM statistic",
out DataTable @table_Programs,
new ProgressOfUpdateAtStructAttribute());
if (IsSelect)
{
foreach (DataRow row in @table_Programs.Rows)
{
DateTime @end_datetime = DateTime.TryParse(row[0] + "", out DateTime Dend_datetime) ? Dend_datetime : default(DateTime);
string @expected_time = row[1] + "";
string @list_name = row[2] + "";
string @loading_time = row[3] + "";
string @machine_time = row[4] + "";
string @real_time = row[5] + "";
string @setup_time = row[6] + "";
DateTime @start_datetime = DateTime.TryParse(row[7] + "", out DateTime dstart_datetime) ? dstart_datetime : default(DateTime);
int @task_number = int.TryParse(row[8] + "", out int itask_number) ? itask_number : default(int);
string NameLaser = row[9] + "";
bool @ChangedByManual = bool.TryParse(row[10] + "", out bool bChangedByManual) ? bChangedByManual : default(bool);
bool @CreatedByGenerateLog = bool.TryParse(row[11] + "", out bool bCreatedByGenerateLog) ? bCreatedByGenerateLog : default(bool);
bool @IsNightProgram = bool.TryParse(row[12] + "", out bool bIsNightProgram) ? bIsNightProgram : default(bool);
bool @IsNotSelected = bool.TryParse(row[13] + "", out bool bIsNotSelected) ? bIsNotSelected : default(bool);
bool IsInsert = ConnectToDataBase.MainExport(MainParentClass.DefaultConnection,
"INSERT INTO[statistic] ([end_datetime],[expected_time],[list_name],[loading_time],[machine_time],[real_time],[setup_time],[start_datetime],[task_number],[Fk_Id_Laser],[ChangedByManual],[CreatedByGenerateLog],[IsNightProgram],[IsNotSelected]) " +
"VALUES (@end_datetime,@expected_time,@list_name,@loading_time,@machine_time,@real_time,@setup_time,@start_datetime,@task_number,(SELECT [Id] FROM[Statistic_WorkPlaces] WHERE[Name] = @NameLaser),@ChangedByManual,@CreatedByGenerateLog,@IsNightProgram,@IsNotSelected)",
new ProgressOfUpdateAtStructAttribute(),
new DbParameter[]
{
ConnectToDataBase.GetParammeter("@end_datetime", @end_datetime, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@expected_time", @expected_time, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@list_name", @list_name, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@loading_time", @loading_time, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@machine_time", @machine_time, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@real_time", @real_time, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@setup_time", @setup_time, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@start_datetime", @start_datetime, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@task_number", @task_number, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@NameLaser", NameLaser, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@ChangedByManual", @ChangedByManual, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@CreatedByGenerateLog", @CreatedByGenerateLog, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@IsNightProgram", @IsNightProgram, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@IsNotSelected", @IsNotSelected, MainParentClass.DefaultConnection)
});
}
}
}
private static DataTable GetTable(int FkId_Chief, SQLiteConnection SQLiteConnection)
{
string query = "SELECT [Name],[EnrollmentDate],[BaseRate],[FkId_Group],[Id] " +
"FROM [HR_Worker] " +
"WHERE [FkId_Chief] = @FkId_Chief";
bool IsSelect = ConnectToDataBase.MainImport(SQLiteConnection,
query,
out DataTable dataTable,
new ProgressOfUpdateAtStructAttribute(),
out TimeSpan TimeOnQuerySelect,
new DbParameter[]
private static DataTable GetTable(SQLiteConnection SQLiteConnection)
{
string query = "SELECT [Name],[EnrollmentDate],[BaseRate],[FkId_Group],[Id] " +
"FROM [HR_Worker] ";
bool IsSelect = ConnectToDataBase.MainImport(SQLiteConnection,
query,
out DataTable dataTable,
new ProgressOfUpdateAtStructAttribute(),
out TimeSpan TimeOnQuerySelect);
return(dataTable);
}
// POST: api/User
public void Post([FromBody] User value)
{
using (var connection = ConnectToDataBase.GetConnection())
{
connection.Open();
using (var context = new TestProjectContext())
{
context.Users.Load();
if (value != null)
{
context.Users.Add(value);
context.SaveChanges();
}
}
}
}
private static void root_tasks()
{
bool IsSelect = ConnectToDataBase.MainImport(MainParentClass.DefaultConnection,
"SELECT task_number,s_task_name,s_process_time,s_time_left,t_ellapsed_time,t_list_time,t_machine_time,t_setup_time,cut_length,holes,idle_length,priority " +
"FROM root_tasks",
out DataTable @table_Programs,
new ProgressOfUpdateAtStructAttribute());
if (IsSelect)
{
foreach (DataRow row in @table_Programs.Rows)
{
int task_number = int.TryParse(row[0] + "", out int Itask) ? Itask : default(int);
string s_task_name = row[1] + "";
string s_process_time = row[2] + "";
string s_time_left = row[3] + "";
string t_ellapsed_time = row[4] + "";
string t_list_time = row[5] + "";
string t_machine_time = row[6] + "";
string t_setup_time = row[7] + "";
float cut_length = float.TryParse(row[8] + "", out float fCut) ? fCut : default(float);
int holes = int.TryParse(row[9] + "", out int Iholes) ? Iholes : default(int);
float idle_length = float.TryParse(row[10] + "", out float fidle_length) ? fidle_length : default(float);
int priority = int.TryParse(row[11] + "", out int Ipriority) ? Ipriority : default(int);
bool IsInsert = ConnectToDataBase.MainExport(MainParentClass.DefaultConnection,
"INSERT INTO[root_tasks] (task_number,s_task_name,s_process_time,s_time_left,t_ellapsed_time,t_list_time,t_machine_time,t_setup_time,cut_length,holes,idle_length,priority) " +
"VALUES (@task_number,@s_task_name,@s_process_time,@s_time_left,@t_ellapsed_time,@t_list_time,@t_machine_time,@t_setup_time,@cut_length,@holes,@idle_length,@priority)",
new ProgressOfUpdateAtStructAttribute(),
new DbParameter[]
{
ConnectToDataBase.GetParammeter("@task_number", task_number, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@s_task_name", s_task_name, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@s_process_time", s_process_time, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@s_time_left", s_time_left, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@t_ellapsed_time", t_ellapsed_time, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@t_list_time", t_list_time, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@t_machine_time", t_machine_time, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@t_setup_time", t_setup_time, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@cut_length", cut_length, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@holes", holes, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@idle_length", idle_length, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@priority", priority, MainParentClass.DefaultConnection),
});
}
}
}
// GET: api/Discipline/5
public Discipline Get(int id)
{
using (var connection = ConnectToDataBase.GetConnection())
{
connection.Open();
var d = new Discipline();
using (var context = new TestProjectContext())
{
context.Disciplines.Load();
if (context.Disciplines.Find(id) != null)
{
d = context.Disciplines.Find(id);
}
}
return(d);
}
}
// GET: api/Group/5
public Group Get(int id)
{
using (var connection = ConnectToDataBase.GetConnection())
{
connection.Open();
var g = new Group();
using (var context = new TestProjectContext())
{
context.Groups.Load();
if (context.Groups.Find(id) != null)
{
g = context.Groups.Find(id);
}
}
return(g);
}
}
// GET: api/Shedule/5
public Schedule Get(int id)
{
using (var connection = ConnectToDataBase.GetConnection())
{
connection.Open();
var t = new Schedule();
using (var context = new TestProjectContext())
{
context.Schedules.Load();
if (context.Schedules.Find(id) != null)
{
t = context.Schedules.Find(id);
}
}
return(t);
}
}
// GET: api/User/5
public User Get(int id)
{
using (var connection = ConnectToDataBase.GetConnection())
{
connection.Open();
var u = new User();
using (var context = new TestProjectContext())
{
context.Users.Load();
if (context.Users.Find(id) != null)
{
u = context.Users.Find(id);
}
}
return(u);
}
}
// DELETE: api/User/5
public void Delete(int id)
{
using (var connection = ConnectToDataBase.GetConnection())
{
connection.Open();
using (var context = new TestProjectContext())
{
var temp = context.Users.Find(id);
if (temp != null)
{
context.Users.Load();
context.Users.Remove(temp);
context.SaveChanges();
}
}
}
}
public override MainParentClass Menu_Virtual(ProgressOfUpdateAtStructAttribute Parent)
{
Users Users = new Users();
ProgressOfUpdateAtStructAttribute Progress = Parent.NonSerializedConfig.GetOnEntry;
Progress.SetName(nameof(HR_Methods));
Progress.NonSerializedConfig.Method = new Action(() =>
{
Tuple <SQLiteConnection, string> tuple = ConnectToDataBase.TryToConnectToSQLite(LocalSettings.NewBasePath);
using (SQLiteConnection SQLiteConnection = tuple.Item1)
{
Users.User_s = GetUsers(SQLiteConnection);
}
});
Progress.Start();
return(Users);
}
// PUT: api/Group/5
public void Put(Group value)
{
using (var connection = ConnectToDataBase.GetConnection())
{
connection.Open();
using (var context = new TestProjectContext())
{
context.Groups.Load();
var r = context.Groups.Find(value.Id);
if (r != null)
{
r.GroupName = value.GroupName;
r.StartDate = value.StartDate;
r.EndDate = value.EndDate;
context.SaveChanges();
}
}
}
}
// PUT: api/User/5
public void Put(User value)
{
using (var connection = ConnectToDataBase.GetConnection())
{
connection.Open();
using (var context = new TestProjectContext())
{
context.Users.Load();
var r = context.Users.Find(value.Id);
if (r != null)
{
r.FullName = value.FullName;
r.Login = value.Login;
r.Password = value.Password;
r.GroupId = value.GroupId;
context.SaveChanges();
}
}
}
}
private static void Statistic_Relations_SessionsPrograms()
{
bool IsSelect = ConnectToDataBase.MainImport(MainParentClass.DefaultConnection,
"SELECT (SELECT [MaskFor_KeyWord]FROM[Detail_Record] WHERE[Id] = [Fk_Id_Program_RecordArea]), " +
"(SELECT[KeyWord] FROM[Detail_Record] WHERE[Id] = [Fk_Id_Program_RecordArea])," +
"(SELECT [list_name] FROM[statistic] WHERE[Id] = [Fk_Id_Program_RecordLaser])," +
"(SELECT [DateStart] FROM[Statistic_Sessions] Where[Id] = [Fk_Id_Session])," +
"[NameOfTableOfProgram] " +
"FROM Statistic_Relations_SessionsPrograms",
out DataTable @table_Programs,
new ProgressOfUpdateAtStructAttribute());
if (IsSelect)
{
foreach (DataRow row in @table_Programs.Rows)
{
string MaskFor_KeyWord = row[0] + "";
string KeyWord = row[1] + "";
string list_name = row[2] + "";
DateTime @DateStart = DateTime.TryParse(row[3] + "", out DateTime IFk_Id_Session) ? IFk_Id_Session : default(DateTime);
string @NameOfTableOfProgram = row[4] + "";
bool IsInsert = ConnectToDataBase.MainExport(MainParentClass.DefaultConnection,
"INSERT INTO [Statistic_Relations_SessionsPrograms] ([Fk_Id_Program_RecordArea],[Fk_Id_Program_RecordLaser],[Fk_Id_Session],[NameOfTableOfProgram]) " +
"VALUES (" +
"(SELECT [Id] FROM Detail_Record WHERE [KeyWord] = @KeyWord AND [MaskFor_KeyWord] = @MaskFor_KeyWord)," +
"(SELECT [Id] FROM [statistic] WHERE [list_name] = @list_name)," +
"(SELECT [Id] FROM[Statistic_Sessions] Where[DateStart] = @DateStart)," +
"@NameOfTableOfProgram)",
new ProgressOfUpdateAtStructAttribute(),
new DbParameter[]
{
ConnectToDataBase.GetParammeter("@MaskFor_KeyWord", MaskFor_KeyWord, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@KeyWord", KeyWord, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@list_name", list_name, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@DateStart", @DateStart, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@NameOfTableOfProgram", @NameOfTableOfProgram, MainParentClass.DefaultConnection),
});
}
}
}
// PUT: api/Teacher/5
public void Put(Teacher value)
{
if (value != null && value.Id != 0)
{
using (var connection = ConnectToDataBase.GetConnection())
{
connection.Open();
using (var context = new TestProjectContext())
{
context.Teachers.Load();
var r = context.Teachers.Find(value.Id);
if (r != null)
{
r.FullName = value.FullName;
r.Phone = value.Phone;
context.SaveChanges();
}
}
}
}
}
// PUT: api/Discipline/5
public void Put(Discipline value)
{
if (value != null && value.DisciplineId != 0)
{
using (var connection = ConnectToDataBase.GetConnection())
{
connection.Open();
using (var context = new TestProjectContext())
{
context.Disciplines.Load();
var r = context.Disciplines.Find(value.DisciplineId);
if (r != null)
{
r.DisciplineName = value.DisciplineName;
r.TeacherId = value.TeacherId;
context.SaveChanges();
}
}
}
}
}
private static void details()
{
bool IsSelect = ConnectToDataBase.MainImport(MainParentClass.DefaultConnection,
"SELECT [i_count],(SELECT [s_subtask_name] FROM [subtasks] WHERE[Id] = [details].[i_parent_id]),[s_detail_name],[s_size],[t_process_time],(SELECT [s_task_name] FROM[root_tasks] WHERE[Id] = (SELECT [i_parent_id] FROM [subtasks] WHERE[Id] = [details].[i_parent_id])),(SELECT [subtasks].[i_parent_id] FROM [subtasks] WHERE[Id] = [details].[i_parent_id]),[i_parent_id] " +
"FROM[details]",
out DataTable @table_Programs,
new ProgressOfUpdateAtStructAttribute());
int ICount = 0;
if (IsSelect)
{
foreach (DataRow row in @table_Programs.Rows)
{
ICount++;
int @i_count = int.TryParse(row[0] + "", out int Ii_count) ? Ii_count : default(int);
string @s_subtask_name = row[1] + "";
string @s_detail_name = row[2] + "";
string @s_size = row[3] + "";
string @t_process_time = row[4] + "";
string s_task_name = row[5] + "";
bool IsInsert = ConnectToDataBase.MainExport(MainParentClass.DefaultConnection,
"INSERT INTO[details] ([i_count],[i_parent_id],[s_detail_name],[s_size],[t_process_time]) " +
"VALUES (@i_count,(SELECT [Id] FROM [subtasks] WHERE[s_subtask_name] = @s_subtask_name AND [i_parent_id] = (SELECT [Id] FROM[root_tasks] WHERE[s_task_name] = @s_task_name)),@s_detail_name,@s_size,@t_process_time)",
new ProgressOfUpdateAtStructAttribute(),
new DbParameter[]
{
ConnectToDataBase.GetParammeter("@i_count", @i_count, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@s_subtask_name", @s_subtask_name, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@s_detail_name", @s_detail_name, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@s_size", @s_size, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@t_process_time", @t_process_time, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@s_task_name", s_task_name, MainParentClass.DefaultConnection),
});
Console.WriteLine("{0}/{1}", ICount, @table_Programs.Rows.Count);
}
}
}
private static void Users()
{
bool IsSelect = ConnectToDataBase.MainImport(MainParentClass.DefaultConnection,
"SELECT [Surname],[MiddleName],[FirstName]," +
"(SELECT [NameOfProfession] FROM[Professionss] WHERE[Id] = [Fk_Id_Profession])," +
"[Id_User_InRegistrControlTime]," +
"(SELECT [TypeOfWork] FROM[TypesOfWork] WHERE[Id] = [Fk_Id_Default_TypeOfWork]) " +
"FROM Users",
out DataTable @table_Programs,
new ProgressOfUpdateAtStructAttribute());
if (IsSelect)
{
foreach (DataRow row in @table_Programs.Rows)
{
string @Surname = row[0] + "";
string @MiddleName = row[1] + "";
string @FirstName = row[2] + "";
string NameOfProfession = row[3] + "";
int @Id_User_InRegistrControlTime = int.TryParse(row[4] + "", out int iId_User_InRegistrControlTime) ? iId_User_InRegistrControlTime : default(int);
string TypeOfWork = row[5] + "";
bool IsInsert = ConnectToDataBase.MainExport(MainParentClass.DefaultConnection,
"INSERT INTO[Users] ([Surname],[MiddleName],[FirstName],[Fk_Id_Profession],[Id_User_InRegistrControlTime],[Fk_Id_Default_TypeOfWork]) " +
"VALUES (@Surname,@MiddleName,@FirstName,(SELECT [Id] FROM[Professionss] WHERE [NameOfProfession] = @NameOfProfession),@Id_User_InRegistrControlTime,(SELECT [Id] FROM[TypesOfWork] WHERE[TypeOfWork] = @TypeOfWork))",
new ProgressOfUpdateAtStructAttribute(),
new DbParameter[]
{
ConnectToDataBase.GetParammeter("@Surname", @Surname, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@MiddleName", @MiddleName, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@FirstName", @FirstName, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@NameOfProfession", NameOfProfession, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@Id_User_InRegistrControlTime", @Id_User_InRegistrControlTime, MainParentClass.DefaultConnection),
ConnectToDataBase.GetParammeter("@TypeOfWork", TypeOfWork, MainParentClass.DefaultConnection),
});
}
}
}
