public IEnumerable <Person> GetALLInf(SearchCriteria searchCriteria)
{
try
{
_sqlConnection.Open();
var command = new SqlCommand(Procedures.GetAllPersons, _sqlConnection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Page", searchCriteria.Page);
command.Parameters.AddWithValue("@Count", searchCriteria.Count);
var outputParametr = new SqlParameter("@Total", SqlDbType.Int);
outputParametr.Direction = ParameterDirection.Output;
command.Parameters.Add(outputParametr);
var entities = command.GetData <Person>();
return(entities);
}
catch (Exception e)
{
ILogger logger = new Log_InDB();
logger.ErrorToDB(e.Message);
throw new NotImplementedException();
}
finally
{
_sqlConnection.Close();
}
}
public Person GetEntity(SearchCriteria searchCriteria)
{
try
{
_sqlConnection.Open();
SqlTransaction transaction = _sqlConnection.BeginTransaction();
var command = new SqlCommand(Procedures.GetPersonByID, _sqlConnection)
{
CommandType = CommandType.StoredProcedure
};
command.Transaction = transaction;
try
{
command.Parameters.Add(new SqlParameter("@ID", searchCriteria.ID));
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var person = new Person();
person.ID = searchCriteria.ID;
person.FirstName = reader.GetString(1);
person.LastName = reader.GetString(2);
person.PhoneNumber = reader.GetString(3);
person.City = reader.GetString(4);
person.Address = reader.GetString(5);
return(person);
}
}
transaction.Commit();
}
}
catch (Exception e)
{
transaction.Rollback();
ILogger logger = new Log_InDB();
logger.ErrorToDB(e.Message);
}
}
finally
{
_sqlConnection.Close();
}
throw new KeyNotFoundException();
}
public void XML_Generating()
{
try
{
var xmlSerializer = new XmlSerializer(typeof(IEnumerable <TEntity>));
using (var fs = new FileStream(XML_Service._Path, FileMode.OpenOrCreate))
{
xmlSerializer.Serialize(fs, XML_Service.Entities);
}
using (var fs = new FileStream(XML_Service._Path, FileMode.Open))
{
byte[] array = new byte[fs.Length];
fs.Read(array, 0, array.Length);
XmlString = System.Text.Encoding.Default.GetString(array);
}
}
catch (Exception e)
{
ILogger logger = new Log_InDB();
logger.ErrorToDB(e.Message);
}
}
public void XSD_Generating()
{
try
{
XmlReader reader = XmlReader.Create(new StringReader(XmlString));
XmlSchemaInference schema = new XmlSchemaInference();
XmlSchemaSet schemaSet = schema.InferSchema(reader);
foreach (XmlSchema s in schemaSet.Schemas())
{
using (var stringWriter = new StringWriter())
{
XmlWriterSettings settings = new XmlWriterSettings {
Indent = true
};
using (var writer = XmlWriter.Create(stringWriter, settings))
{
s.Write(writer);
XsdString = stringWriter.ToString();
}
}
}
var XSDpath = Path.Combine(Path.GetFileNameWithoutExtension(XML_Service._Path) + ".xsd");
using (var fs = new FileStream(XSDpath, FileMode.OpenOrCreate))
{
byte[] array = Encoding.Default.GetBytes(XsdString);
fs.Write(array, 0, array.Length);
}
}
catch (Exception e)
{
ILogger logger = new Log_InDB();
logger.ErrorToDB(e.Message);
}
}
