public bool CheckEntryPoint(Database database, Classes.EntryPoint EPoint) { string query = EntryControl.Resources.Doc.Permit.CheckPermitPoint; QueryParameters parameters = new QueryParameters("permit", Id); parameters.Add("point", EPoint.Id); return((int)database.ExecuteScalar(query, parameters) > 0); //return (EntryPoint.Equals(EntryPoint.Empty) // || EntryPoint.Equals(EPoint)); }
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; } }
public PermitPoint(Permit permit, DbDataReader reader) { Permit = permit; Point = new Classes.EntryPoint((int)reader["pointid"], (string)reader["pointName"]); isAllowed = ((int)reader["isAllowed"]) > 0; }
public EntryPointGroup(string groupName, DbDataReader reader) { GroupName = groupName; EntryPoint = new Classes.EntryPoint(reader); IsIncluded = !DBNull.Value.Equals(reader["groupName"]); }