public void CreateTemplate(LabWorkTemplate template) { var connect = "INSERT INTO LabWork" + "(ID, Name, Description, University, Title, WhoDone, " + "WhoAccepted, Year, Theory, Task, ProgressWork, Conclusion) Values" + $"('{template._id}', '{template._name}', '{template._description}', '{template._university}', '{template._title}', '{template._whoDone}', '{template._whoAccepted}', '{template._year}', '{template._theory}', '{template._task}', '{template._progressWork}', '{template._conclusion}')"; MethodsForDB.Create(connect); }
void ITemplate.DeleteTemplate(LabWorkTemplate labWork) { }
void ITemplate.CreateTemplate(LabWorkTemplate template) { }
public void DeleteTemplate(LabWorkTemplate labWork) { realTemplate.DeleteTemplate(realTemplate); }
public void CreateTemplate(LabWorkTemplate template) { realTemplate.CreateTemplate(realTemplate); }
public ProxyTemplate() { realTemplate = new LabWorkTemplate(); declarationTemplate = new DeclarationTemplate(); }
public LabWorkTemplate OpenLabTemplate(string name) { LabWorkTemplate labWorkTemplate = null; var connection = MethodsForDB.Connection; string query = $"Select * From LabWork WHERE Name = '{name}'"; var command = new SqlCommand(query, connection); connection.Open(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { labWorkTemplate = new LabWorkTemplate(reader.GetGuid(0)) { _name = reader.GetString(1), _description = reader.GetString(2), _university = reader.GetString(3), _title = reader.GetString(4), _whoDone = reader.GetString(5), _whoAccepted = reader.GetString(6), _year = reader.GetString(7), _theory = reader.GetString(8), _task = reader.GetString(9), _progressWork = reader.GetString(10), _conclusion = reader.GetString(11) }; } } return labWorkTemplate; }
public void DeleteTemplate(LabWorkTemplate labWork) { var connect = $"DELETE FROM LabWork WHERE ID = '{labWork._id}'"; MethodsForDB.Delete(connect); }