protected override void ReadProperties(DbDataReader reader)
{
try
{
System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("---> HH:mm:ss.fff"));
Creator = new User((int)reader["creator"], (string)reader["creatorName"]);
CreateDate = (DateTime)reader["createDate"];
System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff"));
period = (int)reader["period"];
docNumber = (int)reader["docNumber"];
permitState = new EnumerationItem((int)reader["permitState"], (string)reader["permitStateName"]);
System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff"));
dateFrom = (DateTime)reader["dateFrom"];
dateTo = (DateTime)reader["dateTo"];
System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff"));
cargo = new Cargo((int)reader["cargo"], (string)reader["cargoName"]);
vehicle = new Vehicle((int)reader["vehicle"], (string)reader["vehicleName"]);
driverName = (string)reader["driverName"];
contact = (string)reader["contact"];
System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff"));
if (DBNull.Value.Equals(reader["entryPointName"]))
{
EntryPoint = EntryPoint.Empty;
}
else
{
EntryPoint = new Classes.EntryPoint((int)reader["entryPoint"], (string)reader["entryPointName"]);
}
multiEntry = (short)reader["multiEntry"];
System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff"));
comment = "";
//if (DBNull.Value.Equals(reader["comment"]))
// comment = "";
//else
// comment = (string)reader["comment"];
System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff"));
}
catch (Exception ex)
{
throw ex;
}
}
private void LoadClosedPermitState(Connection connection)
{
try
{
int id = int.Parse(LoadConstant(connection, "closedPermitState"));
ClosedPermitState = new EnumerationItem(id, "Закрытый");
}
catch (Exception)
{
throw new NotImplementedException("ClosedPermitState value");
}
}
public static List <Contractor> LoadList(Database database, EnumerationItem group)
{
List <Contractor> contractorList = new List <Contractor>();
QueryParameters parameters = new QueryParameters("contractorGroup", group.Id);
using (DbDataReader reader = database.ExecuteReader(LoadListQuery, parameters))
{
while (reader.Read())
{
contractorList.Add(new Contractor(reader));
}
reader.Close();
}
return(contractorList);
}
public static int GetCount(Database database, DateTime dateStart, DateTime dateFinish,
EntryPoint entryPoint, EnumerationItem defaultState)
{
string query = EntryControl.Resources.Doc.Permit.GetCount;
QueryParameters parameters = new QueryParameters("dateStart", dateStart);
parameters.Add("dateFinish", dateFinish);
parameters.Add("entryPoint", entryPoint.Id);
parameters.Add("defaultState", defaultState.Id);
object result = database.ExecuteScalar(query, parameters);
if (result != null && !DBNull.Value.Equals(result))
{
return((int)result);
}
return(0);
}
public static List <Permit> LoadList(Database database, DateTime dateStart, DateTime dateFinish,
EntryPoint entryPoint, EnumerationItem defaultState, int page)
{
QueryParameters parameters = new QueryParameters("dateStart", dateStart);
parameters.Add("dateFinish", dateFinish);
parameters.Add("entryPoint", (entryPoint != null ? entryPoint.Id : 0));
parameters.Add("defaultState", defaultState.Id);
parameters.Add("page", page);
List <Permit> permitList = new List <Permit>();
using (DbDataReader reader = database.ExecuteReader(LoadListQuery, parameters))
{
while (reader.Read())
{
permitList.Add(new Permit(reader));
}
reader.Close();
}
return(permitList);
}
protected override void InitializeProperties()
{
Creator = User.Empty;
CreateDate = DateTime.Now;
period = DateTime.Today.Year;
// permitState = EntryControlDatabase.ConstantPermitState;
permitState = EntryControlDatabase.TemporaryPermitState;
dateFrom = DateTime.Today;
dateTo = new DateTime(dateFrom.Year, 12, 31);
cargo = Cargo.Empty;
vehicle = Vehicle.Empty;
driverName = "ФИО водителя";
contact = "Контактная информация";
EntryPoint = EntryPoint.Empty;
multiEntry = 1;
comment = "";
}
public static List <Permit> LoadList(Database database, DateTime dateStart, DateTime dateFinish,
EntryPoint entryPoint, EnumerationItem defaultState)
{
return(LoadList(database, dateStart, dateFinish, entryPoint, defaultState, 1));
}
public void LoadCloseMovingType(Connection connection)
{
int id = int.Parse(LoadConstant(connection, "closeMoving"));
closeMovingType = new EnumerationItem(id, EntryControl.Resources.Doc.Permit.CloseMoving);
}
private void LoadExitMovingType(Connection connection)
{
int id = int.Parse(LoadConstant(connection, "exitMoving"));
exitMovingType = new EnumerationItem(id, EntryControl.Resources.Doc.Permit.ExitMoving);
}
private void LoadTemporaryPermitState(Connection connection)
{
int id = int.Parse(LoadConstant(connection, "temporaryPermitState"));
temporaryPermitState = new Classes.EnumerationItem(id, "Временный");
}
private void LoadConstantPermitState(Connection connection)
{
int id = int.Parse(LoadConstant(connection, "constantPermitState"));
constantPermitState = new EnumerationItem(id, "Постоянный");
}
private void LoadOneTimePermitState(Connection connection)
{
int id = int.Parse(LoadConstant(connection, "oneTimePermitState"));
oneTimePermitState = new EnumerationItem(id, "Разовый");
}
private void LoadVehicleOwnerGroup(Connection connection)
{
int id = int.Parse(LoadConstant(connection, "vehicleOwnerGroup"));
vehicleOwnerGroup = new EnumerationItem(id, "Перевозчик");
}