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