public static List <PermitMoving> LoadList(Database database, Permit permit) { List <PermitMoving> permitMovingList = new List <PermitMoving>(); QueryParameters parameters = new QueryParameters("permit", permit.Id); using (DbDataReader reader = database.ExecuteReader(LoadListQuery, parameters)) { while (reader.Read()) { permitMovingList.Add(new PermitMoving(permit, reader)); } reader.Close(); } return(permitMovingList); }
public static List <PermitPoint> LoadPointList(Database database, Permit permit) { List <PermitPoint> pointList = new List <Classes.PermitPoint>(); string query = EntryControl.Resources.Doc.Permit.GetPermitPointList; QueryParameters parameters = new QueryParameters("permit", permit.Id); using (DbDataReader reader = database.ExecuteReader(query, parameters)) { while (reader.Read()) { pointList.Add(new Classes.PermitPoint(permit, reader)); } reader.Close(); } return(pointList); }
public static Permit LoadByNumber(EntryControlDatabase database, string fullNumber) { int period = DateTime.Today.Year; int docNumber = 0; if (!int.TryParse(fullNumber.Substring(0, 4), out period)) { throw new FormatException(EntryControl.Resources.Message.Error.WrongPermitNumber); } if (!int.TryParse(fullNumber.Substring(4, 8), out docNumber)) { throw new FormatException(EntryControl.Resources.Message.Error.WrongPermitNumber); } Permit permit = null; string query = EntryControl.Resources.Doc.Permit.LoadByNum; QueryParameters parameters = new QueryParameters("period", period); parameters.Add("docNumber", docNumber); using (DbDataReader reader = database.ExecuteReader(query, parameters)) { if (reader.Read()) { permit = new Permit(reader); } reader.Close(); } if (permit == null) { throw new ArgumentException(EntryControl.Resources.Message.Error.PermitNumberNotFound); } return(permit); }
public static Permit Load(Database database, int id) { QueryParameters parameters = new QueryParameters("permitId", id); Permit permit = null; using (DbDataReader reader = database.ExecuteReader(LoadQuery, parameters)) { if (reader.Read()) { permit = new Permit(reader); } reader.Close(); } if (permit == null) { throw new ArgumentException(EntryControl.Resources.Message.Error.WrongIdentifier); } return(permit); }
public PermitPoint(Permit permit, DbDataReader reader) { Permit = permit; Point = new Classes.EntryPoint((int)reader["pointid"], (string)reader["pointName"]); isAllowed = ((int)reader["isAllowed"]) > 0; }
public Permit LoadPermit(Database database) { return(Permit.Load(database, permitId)); }
public void SetProperties(Permit previousPermit) { Vehicle = previousPermit.Vehicle; DriverName = previousPermit.DriverName; Contact = previousPermit.Contact; }
public PermitMoving(Permit permit, DbDataReader reader) : this(reader) { Permit = permit; }
public PermitMoving(Permit permit) : this() { Permit = permit; }