public ActionResult Http404()
{
ViewData["SessionExpired"] = false;
ViewData["Title"] = EidssMessages.Get("Error_Custom");
ViewData["Description"] = EidssMessages.Get("Error_PageNotFound");
return(View());
}
private void validateMandatory(int?val, string name, Func <bool> predicate)
{
if ((!val.HasValue || val.Value == 0) && predicate())
{
AddError(name, String.Format(EidssMessages.Get("msg506MandatoryField"), name));
}
}
public ModelValidationException(string strId, object[] pars)
{
ValidationMessage =
pars == null
? EidssMessages.Get(strId)
: string.Format(EidssMessages.Get(strId), pars);
}
public static string GetLocation
(string language, string countryName, long?regionId, string regionName, long?rayonId, string rayonName, bool swapRegionRayon = false, bool useRayonSuffix = true)
{
string location;
if (regionId.HasValue)
{
if (rayonId.HasValue)
{
if (useRayonSuffix && language == Localizer.lngRu && !m_CityList.Contains(rayonId.Value))
{
rayonName += (" " + EidssMessages.Get("report_rayon_suffix").Trim());
}
string regionRayonFormat = (swapRegionRayon && regionId.Value != BakuId) ? "{1}, {0}" : "{0}, {1}";
location = regionId.Value == OtherRayonsId || regionId.Value == TransportCheId
? rayonName
: string.Format(regionRayonFormat, regionName, rayonName);
}
else
{
location = regionName;
}
}
else
{
location = countryName;
}
return(location);
}
public QueryTablePacketDTO GetCachedQueryTablePacket(long queryCasheId, int packetNumber, int totalPacketCount)
{
try
{
if (queryCasheId < 0)
{
return(new QueryTablePacketDTO());
}
TraceMethodCall(queryCasheId, packetNumber);
QueryTablePacketDTO packet = AvrDbHelper.GetQueryCachePacket(queryCasheId, packetNumber);
m_Trace.Trace(m_TraceTitle, "Packet {0} of {1} for Query Cashe {2} received", packetNumber + 1, totalPacketCount,
queryCasheId);
return(packet);
}
catch (Exception ex)
{
m_Trace.TraceMethodException(ex, Utils.GetCurrentMethodName(), m_TraceTitle, queryCasheId, packetNumber);
string format = EidssMessages.Get("msgCouldNotGetQueryCachePacket",
"Could not get packet of query cashe table. QueryCasheID={0}, Packet No={1}");
string msg = String.Format(format, queryCasheId, packetNumber + 1);
throw new AvrDataException(msg, ex);
}
}
private void validateRef(string val, string name, Func <bool> predicate)
{
if (!String.IsNullOrEmpty(val) && !predicate())
{
AddError(name, String.Format(EidssMessages.Get("msg506UnknownReferenceValue"), name));
}
}
public ActionResult MessagesScript(string version)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("var EIDSS = { BvMessages: {");
g_ResKeys.ForEach(key =>
{
string val = BvMessages.Get(key);
if (val == null || val == key)
{
val = EidssMessages.Get(key);
}
if (val == null || val == key)
{
val = EidssFields.Get(key);
}
if (val == null || val == key)
{
val = EidssMenu.Get(key, null);
}
if (val == null || val == key)
{
val = key;
}
val = val.Replace("'", "\\'");
sb.AppendFormat("'{0}': '{1}',", key, val);
sb.AppendLine();
});
sb.AppendLine("} }");
return(JavaScript(sb.ToString()));
}
public string GetHerdName()
{
switch (this.idfsPartyType)
{
case (int)PartyTypeEnum.Herd: return(strName);
case (int)PartyTypeEnum.Farm: return(EidssMessages.Get("VetFarmTree_Total"));
case (int)PartyTypeEnum.Species:
if (VetFarmTreeList != null)
{
var list = VetFarmTreeList.Target as EditableList <VetFarmTree>;
if (list != null)
{
var f = list.FirstOrDefault(x => x.idfParty == this.idfParentParty);
if (f != null)
{
return(f.strName);
}
}
}
return("");
default: return("");
}
}
private void validateMandatory(DateTime?val, string name)
{
if (!val.HasValue)
{
AddError(name, String.Format(EidssMessages.Get("msg506MandatoryField"), name));
}
}
private bool MarkDuplicatedItems(HashSet <Upload506Item> items)
{
bool result = true;
using (var e = items.GetEnumerator())
{
var buffer = new List <Upload506Item>();
while (e.MoveNext())
{
foreach (var item in buffer)
{
if (Math.Abs((item.DATEDEFINE - e.Current.DATEDEFINE).GetValueOrDefault().Days) <= 30)
{
item.AddError("Duplicate",
String.Format(EidssMessages.Get("msg506RecordIsDuplicate"),
e.Current.idfsUpload506Item + 2));
e.Current.AddError("Duplicate",
String.Format(EidssMessages.Get("msg506RecordIsDuplicate"),
item.idfsUpload506Item + 2));
result = false;
}
}
buffer.Add(e.Current);
}
}
return(result);
}
public int WriteResultToExcelStream(Stream stream)
{
try
{
var sheet = m_ExcelFileWrapper.Workbook.GetSheetAt(0);
var headerRow = m_ExcelFileWrapper.CreateHeaderRow(m_FieldsList, false);
var cellCaseID = headerRow.CreateCell(headerRow.LastCellNum);
cellCaseID.SetCellValue("EIDSS Case ID");
var cellResult = headerRow.CreateCell(headerRow.LastCellNum);
cellResult.SetCellValue("Status");
for (int i = 0; i < UploadMaster.Items.Count; i++)
{
var item = UploadMaster.Items[i];
var row = GetRow(sheet, i, false);
cellCaseID = row.CreateCell(row.LastCellNum);
cellCaseID.SetCellValue(item.strCaseID);
cellResult = row.CreateCell(row.LastCellNum);
if (item.Resolution.HasValue)
{
cellResult.SetCellValue(EidssMessages.Get(Resolutions[item.Resolution.Value]));
}
}
m_ExcelFileWrapper.Workbook.Write(stream);
stream.Close();
return(0);
}
catch (Exception ex)
{
LogError(ex);
return(1);
}
}
public static string TryToPrepareMapData(AvrPivotViewModel viewModel, out DataSet data)
{
string columnName = viewModel.ViewHeader.MapAdminUnitViewColumn;
if (viewModel.ViewData.Columns.Contains(columnName + "hasc"))
{
columnName = columnName + "hasc";
}
// remember columns for future DataTable
List <AvrViewColumn> mapColumns = FillSeriesColumns(viewModel.ViewHeader, viewModel.ViewHeader.GetColumnsBooleans("IsMapDiagramSeries"), viewModel.ViewHeader.GradientColumn);
// remember rows for future DataTable
Dictionary <int, DataRow> xAxisRows = FillXAxisData(viewModel.ViewData, columnName, viewModel.ViewHeader);
//remove * strings
xAxisRows.ToList().FindAll(d => ((string)d.Value[columnName]).Equals("*")).ForEach(d => xAxisRows.Remove(d.Key));
// have we duplicates? - remove everything
var l = new List <DataRow>(xAxisRows.Values);
if (AvrViewHelper.hasDuplicates(l.ConvertAll(v => v[columnName])))
{
data = new DataSet();
return(EidssMessages.Get("msgDuplicatesInAdmUnit"));
}
// fill DataSet with 2 DataTable !!!
data = CreateDataForMap(columnName, mapColumns, xAxisRows, viewModel.ViewHeader);
return(String.Empty);
}
private bool ValidateAvrService()
{
if (TabControlMain.TabPages.IndexOf(TabPageAVRService) < 0)
{
return(true);
}
try
{
using (var wrapper = new AvrServiceClientWrapper(txtAvrServiceUrl.Text))
{
wrapper.GetServiceVersion();
AppConfigWriter.Instance.SetItem("AVRServiceHostURL", txtAvrServiceUrl.Text);
AppConfigWriter.Instance.Save();
}
}
catch (Exception ex)
{
Trace.WriteLine(ex);
if (!WinUtils.ConfirmMessage(EidssMessages.Get("msgIncorrectAvrServiceUrl")))
{
TabControlMain.SelectedTabPage = TabPageAVRService;
txtAvrServiceUrl.Select();
return(false);
}
}
return(true);
}
private static bool selectNewName(ref string mapName)
{
string message = EidssMessages.Get("gis_Message_SaveMapExist",
"Map with that name already exists. Do you want to save map under a different name?",
ModelUserContext.CurrentLanguage);
string caption = EidssMessages.Get("Save", "Save", ModelUserContext.CurrentLanguage);
string title = EidssMessages.Get("gis_Caption_SaveMap", "Select map name", ModelUserContext.CurrentLanguage);
string strFilter = EidssMessages.Get("gis_Filter_Map", "Map files | *.map", ModelUserContext.CurrentLanguage);
var result = MessageForm.Show(message, caption, MessageBoxButtons.YesNo);
if (result == DialogResult.No)
{
return(false);
}
else
{
var saveFileDialog = new SaveFileDialog
{
Title = title,
OverwritePrompt = true,
Filter = strFilter,
InitialDirectory = MapProjectsStorage.CustomProjectsPath
};
if (saveFileDialog.ShowDialog(null) == DialogResult.OK)
{
mapName = saveFileDialog.FileName;
}
return(true);
}
}
private void validateMandatory(string val, string name)
{
if (String.IsNullOrEmpty(val))
{
AddError(name, String.Format(EidssMessages.Get("msg506MandatoryField"), name));
}
}
public ActionResult ObjectExpired()
{
ViewData["Description"] = EidssMessages.Get("Error_ObjectExpired");
ViewData["Title"] = EidssMessages.Get("Error_Custom");
ViewData["SessionExpired"] = true;
return(View("Error"));
}
public static string GetErrorMessage(ValidationEventArgs args)
{
if (args.Type == typeof(RequiredValidator))
{
return(string.Format(EidssMessages.Get(args.MessageId), GetString(args.Pars[0].ToString())));
}
return(string.Format(EidssMessages.Get(args.MessageId), args.Pars));
}
private int AddItemFromSheetRow(IRow row)
{
int result = 0;
using (var manager = DbManagerFactory.Factory.Create(EidssUserContext.Instance))
{
var item = Upload506Item.Accessor.Instance(null).CreateNewT(manager, UploadMaster);
bool emptyLine = true;
foreach (var caption in m_Upload506Cells)
{
try
{
var cell = row.GetCell(m_CellsMap[caption], MissingCellPolicy.RETURN_NULL_AND_BLANK);
if (cell == null)
{
continue;
}
var value = m_ExcelFileWrapper.GetCellValue(cell);
if (value != null && value.ToString() != string.Empty)
{
item.SetValue(caption, value.ToString());
if (item.GetValue(caption) == null)
{
item.AddError(caption,
string.Format(EidssMessages.Get("msg506DataTypeError"), caption));
result = 4;
}
else
{
emptyLine = false;
if (m_MaxCellLengths.ContainsKey(caption) &&
m_MaxCellLengths[caption] < value.ToString().Length)
{
item.AddError(caption,
string.Format(EidssMessages.Get("msg506MaxLengthError"), caption));
result = 4;
}
}
}
}
catch (Exception ex)
{
LogError(ex);
result = 4;
}
}
if (!emptyLine)
{
item.idfsUpload506Item = UploadMaster.Items.Count;
UploadMaster.Items.Add(item);
}
else
{
return(-1);
}
}
return(result);
}
public void ResetLanguage(string langID)
{
if (Localizer.SupportedLanguages.ContainsKey(langID) == false)
{
return;
}
if (ModelUserContext.CurrentLanguage == langID)
{
return;
}
ModelUserContext.CurrentLanguage = langID;
Thread.CurrentThread.CurrentUICulture = new CultureInfo(CustomCultureHelper.GetCustomCultureName(langID));
string organization = txtOrganization.Text;
string activeControlName = "";
if (ActiveControl != null)
{
activeControlName = ActiveControl.Name;
if (activeControlName == "" && ActiveControl.Parent != null)
{
activeControlName = ActiveControl.Parent.Name;
}
}
SuspendLayout();
Visible = false;
while (Controls.Count > 0)
{
Controls[0].Dispose();
}
InitializeComponent();
Visible = true;
WinClientContext.InitFont();
LayoutCorrector.ApplySystemFont(this);
ResumeLayout();
txtOrganization.Text = organization;
btnOk.Text = BvMessages.Get("strOK_Id");
btnCancel.Text = BvMessages.Get("strCancel_Id");
TabPageMain.Text = EidssMessages.Get("EIDSS_Short_Caption");
TabControlMain.Height = btnOk.Top - TabControlMain.Top - 4;
ControlsLastLanguage = new Dictionary <Control, string> {
{ txtUserName, "en" }, { txtPassword, "en" }
};
if (m_LoginType == LoginType.Simple)
{
TabControlMain.TabPages.Remove(TabPageSQL);
TabControlMain.TabPages.Remove(TabPageArchive);
}
foreach (Control ctl in Controls)
{
if (ctl.Name == activeControlName)
{
ctl.Select();
break;
}
}
}
protected override void OnCreateControl()
{
base.OnCreateControl();
btnOk.Text = BvMessages.Get("strOK_Id");
btnCancel.Text = BvMessages.Get("strCancel_Id");
TabPageMain.Text = EidssMessages.Get("EIDSS_Short_Caption");
UpdateTabsVisibility();
}
// returns (Select All) for web
public static AvrViewColumn GetSelectAll(AvrView view)
{
var col = new AvrViewColumn(-1, "-1", "(" + EidssMessages.Get("strSelectAll_Id", "Select All") + ")", 0);
col.FullPath = col.DisplayText;
col.UniquePath = col.LayoutSearchFieldName;
col.Owner = view;
col.ViewID = view.LayoutID;
return(col);
}
public string GetHerdName()
{
switch (this.idfsPartyType)
{
case (int)PartyTypeEnum.Herd: return(strName);
case (int)PartyTypeEnum.Farm: return(EidssMessages.Get("VetFarmTree_Total"));
default: return("");
}
}
public static void InitWarnings()
{
m_DefaultFolderExists = EidssMessages.Get("msgNoUniqueFolderName",
"A folder with the name you specified already exists. Specify a different folder name.");
m_NationalFolderExists = EidssMessages.Get("msgNoUniqueNatFolderName",
"A folder with the national name you specified already exists. Specify a different folder name.");
m_DefaultLayoutExists = EidssMessages.Get("msgNoUniqueLayoutName",
"Layout with the name you specified already exists. Specify a different layout name.");
m_NationalLayoutExists = EidssMessages.Get("msgNoUniqueNatLayoutName",
"Layout with the national name you specified already exists. Specify a different layout name.");
}
public JsonResult CanDeleteTreeNode(long id)
{
var tree = GetQueryTree();
var node = tree.FirstOrDefault(c => c.ID == id);
var errStr = String.Empty;
if (node != null && !node.IsPublished)
{
if (node.IsFolder)
{
//нужно проверить, что у этого каталога нет дочерних элементов
//иначе его нельзя удалять
using (var manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance))
{
var ps = new List <object>
{
manager.Parameter("ID", id),
manager.Parameter(ParameterDirection.Output, "Result", DbType.Boolean)
};
var command = manager.SetSpCommand("dbo.spAsFolder_CanDelete", ps.ToArray());
var result = Convert.ToBoolean(command.ExecuteScalar <bool>(ScalarSourceType.OutputParameter, "Result"));
if (!result)
{
errStr = EidssMessages.Get("QueryLayoutTree_CantDeleteWithChildren");
}
}
/*
* if (tree.Any(c => c.ParentID == node.ID))
* {
* errStr = EidssMessages.Get("QueryLayoutTree_CantDeleteWithChildren");
* }
*/
}
}
else
{
errStr = EidssMessages.Get("QueryLayoutTree_CantDeletePublished");
}
// show confirmation
return(new JsonResult
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new
{
result = errStr.Length == 0 ? "OK" : "ERROR",
errorString = errStr
}
});
}
private void ChangeUser()
{
if (
MessageForm.Show(EidssMessages.Get("mbSureToSwitchUser"),
EidssMessages.Get("msgMessage"),
MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) ==
DialogResult.Yes)
{
//if (BaseForm.SaveAllOpenedForms == true)
//{
Login();
//}
}
}
public static DatabaseNames GetDatabaseNames()
{
string eidssActualDbName;
string eidssArchiveDbName = null;
string avrDbName;
try
{
using (DbManagerProxy manager = DbManagerFactory.Factory.Create())
{
eidssActualDbName = GetDatabaseName(manager);
}
}
catch (Exception ex)
{
string message = EidssMessages.Get("msgAvrServiceActualDbError", "AVR Service could not connect to Actual EIDSS Database");
throw new AvrDataException(message, ex);
}
try
{
if (ArchiveSqlHelper.IsCredentialsCorrect())
{
using (DbManagerProxy archiveManager = DbManagerFactory.Factory[DatabaseType.Archive].Create())
{
eidssArchiveDbName = GetDatabaseName(archiveManager);
}
}
}
catch (Exception ex)
{
string message = EidssMessages.Get("msgAvrServiceArchiveDbError", "AVR Service could not connect to Archive EIDSS Database");
throw new AvrDataException(message, ex);
}
try
{
using (DbManagerProxy avrManager = DbManagerFactory.Factory[DatabaseType.Avr].Create())
{
avrDbName = GetDatabaseName(avrManager);
}
}
catch (Exception ex)
{
string message = EidssMessages.Get("msgAvrServiceDbError", "AVR Service could not connect to AVR Service Database");
throw new AvrDataException(message, ex);
}
return(new DatabaseNames(eidssActualDbName, eidssArchiveDbName, avrDbName));
}
private void validateRef(int?val, string name, Func <bool> predicate)
{
try
{
if (val.HasValue && val.Value != 0 && !predicate())
{
AddError(name, String.Format(EidssMessages.Get("msg506UnknownReferenceValue"), name));
}
}
catch (Exception ex)
{
string e = ex.Message;
throw;
}
}
public long CopyLayout(long layoutId, string lang)
{
try
{
TraceMethodCall(layoutId, AvrDbHelper.GetLayoutNameForLog(layoutId), lang);
EidssAvrServiceInitializer.CheckAndInitEidssCore();
return(VirtualLayoutCopier.CreateLayoutCopyInAvrService(layoutId, lang, m_Container));
}
catch (Exception ex)
{
m_Trace.TraceMethodException(ex, Utils.GetCurrentMethodName(), m_TraceTitle);
string format = EidssMessages.Get("msgCouldNotCreateLayoutCopy", "Could not create layout copy. Layout ID={0}, Language={1}");
throw new AvrDataException(String.Format(format, layoutId, lang), ex);
}
}
public Version GetServiceVersion()
{
try
{
TraceMethodCall();
Assembly asm = Assembly.GetExecutingAssembly();
return(asm.GetName().Version);
}
catch (Exception ex)
{
m_Trace.TraceMethodException(ex, Utils.GetCurrentMethodName(), m_TraceTitle);
string message = EidssMessages.Get("msgAvrServiceVersionError", "Could not get service version due to internal error.");
throw new AvrDataException(message, ex);
}
}
public DateTime?GetsQueryCacheUserRequestDate(long queryId)
{
try
{
TraceMethodCall(queryId, AvrDbHelper.GetQueryNameForLog(queryId));
return(AvrDbHelper.GetsQueryCacheUserRequestDate(queryId));
}
catch (Exception ex)
{
m_Trace.TraceMethodException(ex, Utils.GetCurrentMethodName(), m_TraceTitle);
string format = EidssMessages.Get("msgCouldNotGetQueryCacheUserRequestDate",
"Could not get date when user requestet query cashe for Query ID={0}");
throw new AvrDataException(String.Format(format, queryId), ex);
}
}
