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), }); } } }