internal ProjectObject(EnumerationItem item)
{
if (item == null)
{
throw new ArgumentNullException(nameof(item));
}
}
/// <summary>
/// создает новое состояние для транспорта
/// </summary>
/// <param name="apnt">транспорт</param>
/// <param name="dcSt">новое состояние</param>
public AppointState(Appoint apnt, EnumerationItem dcSt)
{
appoint = apnt;
docState = dcSt;
date = DateTime.Now;
reason = "";
Insert();
}
new void Insert(int index)
{
EnumerationItem item = Items[0].DocState, newItem = docStates.Find(item.Id + 1);
if (newItem == null)
{
newItem = item;
}
Insert(index, new AppointState(appoint, newItem));
}
new void Add()
{
EnumerationItem item = Items[0].DocState, newItem = docStates.Find(item.Id + 1);
if (newItem == null)
{
newItem = item;
}
Add(new AppointState(appoint, newItem));
}
/// <summary>
/// Deletes the enumeration item.
/// </summary>
/// <param name="item">The item.</param>
/// <returns>EnumerationItem.</returns>
public EnumerationItem DeleteEnumerationItem(EnumerationItem item)
{
var clt = CreateClient();
try
{
return(clt.DeleteEnumerationItem(item));
}
finally
{
CloseClient(clt);
}
}
/// <summary>
/// Saves the specified it.
/// </summary>
/// <param name="it">It.</param>
/// <returns>EnumerationItem.</returns>
public EnumerationItem Save(EnumerationItem it)
{
var clt = CreateClient();
try
{
return(clt.Save(it));
}
finally
{
CloseClient(clt);
}
}
/// <summary>
/// Registers the type of the enumeration.
/// </summary>
/// <param name="item">The item.</param>
/// <returns>EnumerationItem.</returns>
public EnumerationItem RegisterEnumerationType(EnumerationItem item)
{
var clt = CreateClient();
try
{
return(clt.RegisterEnumerationType(item));
}
finally
{
CloseClient(clt);
}
}
private int GetIndex(EnumerationItem parameter)
{
var filterConfig = parameter;
if (filterConfig == null)
{
return(-1);
}
var index = this.Items.IndexOf(filterConfig);
return(index);
}
private void SetCheckedBinding(EnumerationItem enumerationItem, RadioButton radioButton)
{
var binding = new Binding
{
Source = this,
Mode = BindingMode.TwoWay,
Path = new PropertyPath(nameof(SelectedItem)),
Converter = new EnumToBooleanConverter(), // would be more efficient as a singleton
ConverterParameter = enumerationItem.Value
};
radioButton.SetBinding(ToggleButton.IsCheckedProperty, binding);
}
public HistoryMoving(DbDataReader reader)
{
MovingTime = (DateTime)reader["movingTime"];
EntryPoint = new EntryPoint((int)reader["entryPoint"], (string)reader["entryPointName"]);
Vehicle = new Vehicle((int)reader["vehicle"], (string)reader["vehicleName"]);
DriverName = (string)reader["driverName"];
PermitId = (int)reader["permit"];
int period = (int)reader["period"];
int docNumber = (int)reader["docNumber"];
PermitNumber = period.ToString() + "-" + docNumber.ToString();
Moving = new EnumerationItem((int)reader["moving"], (string)reader["movingName"]);
Cargo = new Cargo((int)reader["cargo"], (string)reader["cargoName"]);
}
public EnumerationItem SaveEnumerationItem(EnumerationItem enumerationItem)
{
IExplorer clt = null;
try
{
clt = CreateClient();
return(clt.SaveEnumerationItem(enumerationItem));
}
finally
{
CloseClient(clt);
}
}
internal EnumerationObject(EnumerationItem item)
{
if (item == null)
{
throw new ArgumentNullException(nameof(item));
}
this.Id = item.Id;
this.Is_Default = item.IsDefault ? 1 : 0;
this.Active = item.IsActive ? 1 : 0;
this.Position = item.Position;
this.Name = item.Name;
this.Parent_Id = item.ParentId;
this.Position_Name = item.PositionName;
this.Project_Id = item.ProjectId;
this.Type = item.Type;
}
/// <summary>
///
/// </summary>
public static bool Generate()
{
LogInfo("Generate");
LogInfo("Creating agents");
_explorerAgent = ExplorerAgentFactory.CreateAgent(ExplorerAgentFactory.Key.Instance);
_mediaAgent = MediaAgentFactory.CreateMediaAgent();
using (var scope = new TransactionScope(TransactionScopeOption.Required))
{
LogInfo("Transaction begin");
try
{
LogInfo("Creating objects; perspectiveItemRoot, enumerationItemRoot and descriptionItems");
PerspectiveItem perspectiveItemRoot = GetPerspectiveItemRoot();
EnumerationItem enumerationItemRoot = GetEnumerationItemRoot();
IEnumerable <DescriptionItem> descriptionItems = GetDescriptionItems();
LogInfo("Saving enumerationItemRoot and perspectiveItemRoot");
if (SaveEnumerationItem(enumerationItemRoot) && SavePerspectiveItem(perspectiveItemRoot))
{
var language = CultureInfo.CurrentCulture.Name;
var items = from i in descriptionItems
where i.CultureId.Equals(language)
select i;
LogInfo("Saving descriptionItems for culture {0}", language);
if (SaveDescriptionItems(items))
{
scope.Complete();
return(LogInfo("Transaction complete"));
}
}
}
catch (Exception ex)
{
return(LogError("Method Generate throws exception;\n" + ex));
}
}
return(LogError("Generate = false"));
}
public Appoint(EPVDatabase database, Appoint copy, Units units, States states)
{
id = copy.Id;
string query = "select a.*, ";
query += "(select dateState from docAppointStates where appoint = a.id and docState = 0) as dateComing ";
query += ", (select PERMIT from docPlanAppoint where id = a.planAppoint) as permitId ";
query += "from docAppoints a where a.id = @id";
QueryParameters parameters = new QueryParameters("id", id);
DbDataReader reader = database.ExecuteReader(query, parameters);
reader.Read();
unit = units.Find((int)reader["idUnit"]);
trackMark = (string)(DBNull.Value.Equals(reader["trackMark"]) ? string.Empty : reader["trackMark"]);
licensePlate = (string)reader["licensePlate"];
trailer = (string)(DBNull.Value.Equals(reader["trailer"]) ? string.Empty : reader["trailer"]);
citizen = states.Find((int)reader["state"]);
driverName = (string)(DBNull.Value.Equals(reader["driverName"]) ? string.Empty : reader["driverName"]);
driverPhone = (string)(DBNull.Value.Equals(reader["driverPhone"]) ? string.Empty : reader["driverPhone"]);
warrant = (string)(DBNull.Value.Equals(reader["warrant"]) ? string.Empty : reader["warrant"]);
whereTo = (string)(DBNull.Value.Equals(reader["whereTo"]) ? string.Empty : reader["whereTo"]);
cargo = (string)(DBNull.Value.Equals(reader["cargo"]) ? string.Empty : reader["cargo"]);
idleReason = (string)(DBNull.Value.Equals(reader["idleReason"]) ? string.Empty : reader["idleReason"]);
dateComing = (DateTime)reader["dateComing"];
docState = copy.DocState;
docStateDate = copy.docStateDate;
if (DBNull.Value.Equals(reader["permitId"]))
{
HasPermit = false;
}
else
{
HasPermit = ((int)reader["permitId"] > 0);
permitId = (int)reader["permitId"];
}
reader.Close();
}
public Appoint(Unit unt, State ctzn, EnumerationItem stt)
{
unit = unt;
trackMark = "";
licensePlate = "";
trailer = "";
citizen = ctzn;
driverName = "";
driverPhone = "";
warrant = "";
whereTo = "";
cargo = "укажите груз...";
docState = stt;
docStateDate = DateTime.Now;
dateComing = DateTime.Now;
point = null;
dateToPoint = new DateTime(2100, 12, 31);
HasPermit = false;
Insert();
}
/// <summary>
/// Saves the enumeration item.
/// </summary>
/// <param name="enumerationItem">The hierarchy item.</param>
private static bool SaveEnumerationItem(EnumerationItem enumerationItem)
{
if (EnumerationItemExists(enumerationItem.Id))
{
return(true);
}
LogInfo("Saving enumerationItem");
EnumerationItem enumerationItemSaved = _explorerAgent.SaveEnumerationItem(enumerationItem);
if (enumerationItemSaved != null)
{
if (enumerationItemSaved.HasErrors)
{
LogInfo("EnumerationItem ( " + enumerationItem + ")");
LogInfo("EnumerationItemSaved ( " + enumerationItemSaved + ")");
return(LogError("AllErrors = " + enumerationItemSaved.AllErrors));
}
return(LogInfo("SaveEnumerationItem = true"));
}
return(LogError("_explorerAgent.SaveEnumerationItem returned null"));
}
private static IEnumerable<EnumerationItem> CreateEnumerationItemsFromCultureInfos(XmlNodeList nodes)
{
List<EnumerationItem> result = null;
if (nodes != null && nodes.Count > 0)
{
var cultureInfos = GetCultureInfos(nodes);
result = new List<EnumerationItem>();
int sortOrder = 1;
foreach (CultureInfo cultureInfo in cultureInfos)
{
EnumerationItem enumeration = new EnumerationItem
{
Id = cultureInfo.Name,
TypeId = EnumerationItemType.TypeIdLanguages,
Title = cultureInfo.EnglishName,
Image = new byte[] { },
SortOrder = sortOrder++,
DateModified = DateTime.Now
};
result.Add(enumeration);
}
}
return result;
}
public EnumerationItem SaveEnumerationItem(EnumerationItem enumerationItem)
{
throw new NotImplementedException();
}
//METHODS
private void ReadState()
{
state.Clear();
string[] ids = Request.Form.GetValues(IdFormName);
if (ids == null)
return;
string[] defaults = Request.Form.GetValues(DefaultFormName);
string[] deletes = Request.Form.GetValues(DeleteFormName);
foreach (string id in ids)
{
EnumerationItem item = new EnumerationItem();
item.IdValue = id;
item.Title = Request.Form[TitleFormPrefix + id];
item.XmlId = Request.Form[XmlIdFormPrefix + id];
int sort;
if (int.TryParse(Request.Form[SortFormPrefix + id], out sort))
item.Sort = sort;
item.IsDefault = (defaults != null && Array.IndexOf(defaults, id) != -1);
if (!item.IsNew)
item.Delete = (deletes != null && Array.IndexOf(deletes, id) != -1);
state.Add(item);
}
}
/// <summary>
/// Registers the type of the enumeration.
/// </summary>
/// <param name="item">The item.</param>
/// <returns>EnumerationItem.</returns>
public EnumerationItem RegisterEnumerationType(EnumerationItem item)
{
item.TypeId = EnumerationConst.TypeEnum;
return(Save(item));
}
/// <summary>
/// Saves the specified it.
/// </summary>
/// <param name="it">It.</param>
/// <returns>EnumerationItem.</returns>
public EnumerationItem Save(EnumerationItem it)
{
return(MediaProviderFactory
.CreateEnumerationProvider()
.Save(it));
}
/// <summary>
/// Deletes the enumeration item.
/// </summary>
/// <param name="item">The item.</param>
/// <returns>EnumerationItem.</returns>
/// <exception cref="System.NotImplementedException"></exception>
public EnumerationItem DeleteEnumerationItem(EnumerationItem item)
{
throw new System.NotImplementedException();
}
/// <summary>
/// Получает из БД список всех транспортов, находящихся в определенном состоянии на определенной точке
/// </summary>
/// <param name="database">База данных</param>
/// <param name="point">Точка погрузки/выгрузки</param>
/// <param name="docState">состояние</param>
/// <returns>набор записей</returns>
public static BindingList <AppointState> LoadList(EPVDatabase database, Point point, EnumerationItem docState)
{
Units unitList = new Units(database);
States stateList = new States(database);
Enumeration docStates = new Enumeration(database, "docState");
BindingList <AppointState> appointList = new BindingList <AppointState>();
QueryParameters parameters = new QueryParameters("pointId", point.Id);
parameters.Add("docState", docState.Id);
DbDataReader reader = database.ExecuteReader(Classes.Queries.PointStateAppoins, parameters);
while (reader.Read())
{
appointList.Add(new AppointState(reader, new Appoint(reader, unitList, stateList, docStates), docStates));
}
reader.Close();
return(appointList);
}
/// <summary>
/// возвращает список пропусков из БД
/// </summary>
/// <param name="database">соединение с БД</param>
/// <param name="dateStart">период действия с</param>
/// <param name="dateFinish">период действия по</param>
/// <param name="entryPoint">п. пропуска</param>
/// <param name="defaultState">фильтр состояния пропуска</param>
/// <param name="pageNum">страница списка</param>
/// <returns></returns>
private List <Permit> LoadPermitList(Database database, DateTime dateStart, DateTime dateFinish,
EntryPoint entryPoint, EnumerationItem defaultState, int pageNum)
{
return(Permit.LoadList(database, dateStart, dateFinish, entryPoint, defaultState, pageNum));
}
