private void UpdateBidsList()
{
var cr = DataManagement.RetrieveTenderingContractorRequest(CurrentTendering);
foreach (var item in list)
{
double money = (double)item.Bid1;
item.Coefficient = money / (double)cr.Estimatation;
double pm = (1 - (double)item.Coefficient) * 100;
if (pm > 0)
{
item.Minus = pm;
item.Plus = 0;
}
else
{
item.Plus = -pm;
item.Minus = 0;
}
double i = 0;
if (Double.TryParse(ZaribTxt.Text, out i))
{
item.ImpactCoefficient = i;
}
//var x = ((double)item.Bid1 * 100) / (100 - (i * (100 - (double)item.QualityScore)));
//item.BalancedPrice = (decimal)x;
}
}
public static void Initialize()
{
foreach (TerytUslugaWs1.JednostkaTerytorialna province in DataManagement.getProvinces())
{
PROVINCES.Add(new Province(province.NAZWA.First().ToString().ToUpper() + province.NAZWA.Substring(1).ToLower()));
}
}
public void TestHiHat()
{
string closedFile = DataManagement.PathForDataFile("Test", "ClosedHiHat.wav");
Assert.IsTrue(WaveEncoding.SaveStream(
filepath: closedFile,
stream: InstrumentLookup.GetPercussion(PercussionMap.ClosedHiHat, 0xF7)
.SafeCache()
.SlowRangeFitter(),
overwrite: true));
string pedalFile = DataManagement.PathForDataFile("Test", "PedalHiHat.wav");
Assert.IsTrue(WaveEncoding.SaveStream(
filepath: pedalFile,
stream: InstrumentLookup.GetPercussion(PercussionMap.PedalHiHat, 0xF7)
.SafeCache()
.SlowRangeFitter(),
overwrite: true));
string openFile = DataManagement.PathForDataFile("Test", "OpenHiHat.wav");
Assert.IsTrue(WaveEncoding.SaveStream(
filepath: openFile,
stream: InstrumentLookup.GetPercussion(PercussionMap.OpenHiHat, 0xF7)
.SafeCache()
.SlowRangeFitter(),
overwrite: true));
}
private void SaveBtn_Click_1(object sender, RoutedEventArgs e)
{
try
{
if (CurrentTendering.PermanentRecord == true)
{
ErrorHandler.NotifyUser(Errors.Permanented);
return;
}
if (!CheckValidInputs(AdList))
{
return;
}
if (AdList.Count == 0)
{
ErrorHandler.ShowErrorMessage("موردی وارد نشده است.");
return;
}
DataManagement.UpdateAdveritsement(AdList, CurrentNotice);
AdList = DataManagement.RetrieveAdvertisement(CurrentNotice);
NoticeGrid.ItemsSource = AdList;
ErrorHandler.NotifyUser(ErrorHandler.ErrorMessages["SuccessfulSave"]);
}
catch
{
ErrorHandler.NotifyUser(ErrorHandler.ErrorMessages["FailedSave"]);
}
}
public static bool SaveFile(
string filePath,
MidiFile midiFile,
bool overwrite = false)
{
try
{
if (File.Exists(filePath))
{
if (overwrite)
{
File.Delete(filePath);
}
else
{
filePath = DataManagement.NextAvailableFilePath(filePath);
}
}
using (FileStream fileStream = new FileStream(filePath, FileMode.Create))
{
midiFile.Serialize(fileStream);
}
return(true);
}
catch (IOException excp)
{
Debug.LogException(excp);
return(false);
}
}
public void TestLoadSaveMidiFull()
{
string loadFile = DataManagement.PathForDataFile("Test", "MIDI_sample.mid");
string saveFile = DataManagement.PathForDataFile("Test", "MIDI_sample_copy.mid");
Assert.IsTrue(MidiEncoding.LoadFile(
filePath: loadFile,
midiFile: out MidiFile midiFile,
retainAll: true));
Debug.Log($"Format: {midiFile.headerInfo.format}");
Debug.Log($"FramesPerSecond: {midiFile.headerInfo.framesPerSecond}");
Debug.Log($"TicksPerFrame: {midiFile.headerInfo.ticksPerFrame}");
Debug.Log($"TicksPerQuarter: {midiFile.headerInfo.ticksPerQuarter}");
Debug.Log($"Tracks: {midiFile.headerInfo.tracks}");
Debug.Log($"Samples Per Tick: {1E-6 * midiFile.tracks[0].Tempo * 44100 / midiFile.headerInfo.ticksPerQuarter}");
Assert.IsTrue(MidiEncoding.SaveFile(
filePath: saveFile,
midiFile: midiFile,
overwrite: true));
Assert.IsTrue(File.Exists(saveFile));
}
private void page_Loaded(object sender, RoutedEventArgs e)
{
Header.CurrentRequest = DataManagement.RetrieveTenderingContractorRequest(CurrentTendering);
list = DataManagement.RetrieveBids(CurrentTendering);
dataGrid.ItemsSource = list;
dataGrid.Items.Refresh();
}
private void Awake()
{
if (instance == null)
{
instance = this;
}
else
if (instance != this)
{
Destroy(this);
}
Data = Instantiate(Data);
DataHandler.Money = Data.StartingMoney;
Stat[] stats = { Stat.Nourishment, Stat.Mood, Stat.Fitness, Stat.Social };
foreach (Stat s in stats)
{
DataHandler.DataTypes.Add(new DataType
{
stat = s,
Meter = Data.GetDataValue(s).InitialValue,
Bonus = 0
});
}
;
DataHandler.Relationships = Data.Relationships;
}
public static bool DownloadTenderingFile(int tenderingId, TenderingIndex docIndex, int?contractorId, string version, Grid layoutRoot, int?advertisementId = null, int?meetingId = null, int?warrantyId = null)
{
int docid = DataManagement.RetrieveTenderingDocumentId(docIndex);
if (docid == -1)
{
return(false);
}
layoutRoot.Children.Add(busy);
Task <bool> .Factory.StartNew(delegate
{
FileDataObject t = DataManagement.RetrieveTenderingFile(tenderingId, docid, contractorId, advertisementId, meetingId, warrantyId);
if (t == null)
{
return(false);
}
OpenFileHandler.OpenFileFromByte(t.FileContent, t.FileName);
t = null;
GC.Collect();
return(true);
}).ContinueWith(Pre =>
{
layoutRoot.Children.Remove(busy);
if (!Pre.Result)
{
ErrorHandler.ShowErrorMessage(ErrorHandler.ErrorMessages["NoFile"]);
}
}, TaskScheduler.FromCurrentSynchronizationContext());
return(true);
}
public static bool DeleteContractFile(int contractId, ContractIndex docIndex, int fileId, Grid layoutRoot)
{
if (!UserData.CurrentAccessRight.ContractDelete)
{
ErrorHandler.ShowErrorMessage("امکان انجام این عملیات وجود ندارد");
return(false);
}
int docid = (int)(docIndex);
if (docid == -1)
{
return(false);
}
if (ErrorHandler.PromptUserForPermision(ErrorHandler.ErrorMessages["Prompt"]) == MessageBoxResult.No)
{
return(false);
}
layoutRoot.Children.Add(busy);
Task.Factory.StartNew(delegate
{
DataManagement.DeleteContractFile(fileId);
}).ContinueWith(delegate
{
layoutRoot.Children.Remove(busy);
if (TransactionFinished != null)
{
TransactionFinished();
}
}, TaskScheduler.FromCurrentSynchronizationContext());
return(true);
}
public static bool DownloadContractFile(int contractId, ContractIndex docIndex, int?fileId, Grid layoutRoot)
{
int docid = (int)docIndex;
if (docid == -1)
{
return(false);
}
layoutRoot.Children.Add(busy);
Task <bool> .Factory.StartNew(delegate
{
FileDataObject t = DataManagement.RetrieveContractFile(contractId, docid, fileId);
if (t == null)
{
return(false);
}
OpenFileHandler.OpenFileFromByte(t.FileContent, t.FileName);
t = null;
GC.Collect();
return(true);
}).ContinueWith(Pre =>
{
layoutRoot.Children.Remove(busy);
if (!Pre.Result)
{
ErrorHandler.ShowErrorMessage(ErrorHandler.ErrorMessages["NoFile"]);
}
if (TransactionFinished != null)
{
TransactionFinished();
}
}, TaskScheduler.FromCurrentSynchronizationContext());
return(true);
}
public static void Serialize()
{
FileWriter.WriteJson(
path: DataManagement.PathForDataFile(dataDir, configFileName),
createJson: SerializeCalibration,
pretty: true);
}
void bw_DoWork(object sender, DoWorkEventArgs e)
{
var user = e.Argument as UserPackage;
RTM.User users = new RTM.User();
try
{
var entity = new RTMEntities();
users = DataManagement.AuthenticateUser(user.UserName, user.Password);
if (users != null)
{
UserData.CurrentUser = users;
UserData.CurrentPoistion = entity.Positions.Where(s => s.PositionId == UserData.CurrentUser.PositionId).First();
UserData.CurrentAccessRight = entity.AccessRights.Where(s => s.AccessId == UserData.CurrentUser.AccessId).First();
UserData.OrganizationalPosition = entity.OrganizationalCharts.Where(s => s.ChartNodeId == UserData.CurrentUser.OrganizationPosition).First();
entity.Users.Where(s => s.UserId == UserData.CurrentUser.UserId).FirstOrDefault().LastLogin = DateTime.Now;
entity.SaveChanges();
NavigationHandler.NavigateToPageThreadSafe(this, "UserManagement/StartPage.xaml", false);
}
else
{
ErrorHandler.ShowErrorMessage("نام کاربری یا کلمه عبور اشتباه است");
Password.Dispatcher.BeginInvoke((Action) delegate
{
Password.Password = "";
}, System.Windows.Threading.DispatcherPriority.Normal);
}
}
catch (System.Exception ex)
{
ErrorHandler.ShowErrorMessage("ارتباط با سرور امکان پذیر نیست" + ex.Message);
}
}
private void TenderNumberTxt_LostFocus(object sender, KeyboardFocusChangedEventArgs e)
{
var t = UniqueConstraints.ExistTenderingNumber(TenderNumberTxt.Text, CurrentContract);
if (t == null)
{
ErrorHandler.ShowErrorMessage(Errors.NotFoundTendering);
CurrentContract.TenderingSystemCode = "";
}
else
{
ErrorHandler.NotifyUser(Errors.FoundTendering);
CurrentContract.ContractTtile = t.TenderingTitle;
var c = DataManagement.RetrieveTenderingContractorRequest(t);
CurrentContract.SupervisingUnit = c.RequestingUnit;
CurrentContract.SupervisingUnitHigher = c.SupervisionId;
try
{
var res = DataManagement.SearchOrCreateTenderingResult(t);
CurrentContract.ContractorId = res.FirstContractorWinnerId;
CurrentContract.ContractBudget = (from items in DataManagement.RetrieveBids(t) where items.ContractorId == CurrentContract.ContractorId select items).FirstOrDefault().Bid1;
}
catch (System.Exception ex)
{
}
}
}
private void page_Loaded(object sender, RoutedEventArgs e)
{
if (SuperVisionCom.ItemsSource == null || RequestUnitCom.ItemsSource == null)
{
RequestUnitCom.ItemsSource = SuperVisionCom.ItemsSource = DataManagement.RetrieveOrganizationChart();
}
if (TenderCodeCom.ItemsSource == null)
{
TenderCodeCom.ItemsSource = DataManagement.RetrieveTenderingTitle();
}
NeededRankCom.ItemsSource = new List <int> {
1, 2, 3, 4, 5
};
NeededFieldCom.ItemsSource = new List <string> {
"ساختمان", "آب", "راه و ترابري", "صنعت و معدن", "نيرو", "تاسيسات و تجهيزات", "کاوشهاي زميني", "ارتباطات", "کشاورزي", "خدمات", "آثار باستاني"
};
TenderTypeCom.ItemsSource = new List <string> {
"عمومي يک مرحله اي", "عمومي دو مرحله اي", "محدود يک مرحله اي", "محدود دو مرحله اي", "ترک تشريفات", "انحصاري", "بين المللي"
};
CurrentTendering = DataManagement.RetrieveContractorRequestTendering(CurrentReq);
if (CurrentTendering != null)
{
TenderSystemCodeTxt.Text = CurrentTendering.TenderingNumber;
}
}
public DefaultData()
: base("Default", "Default")
{
if (File.Exists(PlayerFilePath))
{
Deserialize();
}
else
{
//Handle old Default data
string oldDefaultDataPath = DataManagement.PathForDataFile("SaveData", "Default.json");
if (File.Exists(oldDefaultDataPath))
{
FileReader.ReadJsonFile(
path: oldDefaultDataPath,
//If it is parsable, mark it as successfully loaded
successCallback: (JsonObject readData) =>
{
if (readData.ContainsKey("UserDicts"))
{
foreach (var data in readData["UserDicts"].AsJsonObject)
{
SetJsonValue(data.Key, data.Value);
}
}
});
File.Delete(oldDefaultDataPath);
}
//Create the data
Serialize();
}
}
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
if (CurrentTendering.RequestPermanentCheck == true)
{
ErrorHandler.NotifyUser("سند به تایید نهایی رسیده است");
return;
}
if (!FilingManager.HasTenderingFile(CurrentTendering.TenderingId, TenderingIndex.CeoOrder, null, null, this.layoutRoot))
{
ErrorHandler.ShowErrorMessage("بارگذاری تصویر برای ثبت الزامی است.");
return;
}
try
{
DataManagement.UpdateContractorRequest(CurrentReq);
ErrorHandler.NotifyUser(ErrorHandler.ErrorMessages["SuccessfulSave"]);
CurrentTendering.TenderingType = TenderTypeCom.Text;
DataManagement.UpdateTendering(CurrentTendering);
DataManagement.UpdateTenderingStage(CurrentTendering, Stages.CEO);
}
catch
{
ErrorHandler.NotifyUser(ErrorHandler.ErrorMessages["FailedSave"]);
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
if (CurrentContract.PermanentRecord == true)
{
ErrorHandler.NotifyUser("سند به ثبت نهایی رسیده است");
return;
}
if (UserData.CurrentUser.PaymentDraftCommittee == false)
{
ErrorHandler.NotifyUser(Errors.OperationNotAllowed);
return;
}
var t = dataGrid.SelectedItem as PaymentDraft;
if (t.PermanentRecord == true)
{
ErrorHandler.NotifyUser("این سند قبلا به تایید نهایی رسیده است");
return;
}
if (ErrorHandler.PromptUserForPermision("ثبت نهایی صورت گیرد ؟") == MessageBoxResult.No)
{
return;
}
t.PermanentRecord = true;
ErrorHandler.NotifyUser("سند به تایید نهایی رسید");
DataManagement.UpdatePaymentDrafts(t);
}
private void BrowseBtn_Click(object sender, RoutedEventArgs e)
{
if (CurrentContract.PermanentRecord == true)
{
ErrorHandler.NotifyUser("سند به ثبت نهایی رسیده است");
return;
}
FileDataObject d = FilingManager.GetFileDataObject(); // check if the file is empty or the selected item is nulland return
if (d == null)
{
return;
}
var f = new PaymentFile()
{
Index = 1,
Name = d.FileName,
FileContent = d.FileContent,
AttachedDate = DateTime.Now,
FileGuid = Guid.NewGuid(),
PaymentDraftId = (dataGrid.SelectedItem as PaymentDraft).PaymentDraftId
};
DataManagement.AddPaymentDraftFile(f);
ErrorHandler.NotifyUser("فایل ثبت شد");
}
private void PermanentBtn_Click(object sender, RoutedEventArgs e)
{
if (CurrentTendering.RequestPermanentCheck == true)
{
ErrorHandler.NotifyUser(Errors.Permanented);
return;
}
var t = DataManagement.SearchEvaluations(null, null, CurrentTendering.TenderingNumber, null, null, null, null, null, null).FirstOrDefault();
if (MessageBoxResult.No == MessageBox.Show("ثبت نهایی صورت بگیرد ؟", "اخطار", MessageBoxButton.YesNo))
{
return;
}
CurrentTendering.RequestPermanentCheck = true;
CurrentTendering.PermanentRecord = true;
var currentReq = DataManagement.RetrieveTenderingContractorRequest(CurrentTendering);
CurrentTendering.TenderingNumber = DataManagement.GenerateNoticeSystemCode(CurrentTendering, currentReq);
currentReq.NoticeNumber = CurrentTendering.TenderingNumber;
DataManagement.UpdateContractorRequest(currentReq);
if (DataManagement.UpdateTendering(CurrentTendering) != null)
{
ErrorHandler.NotifyUser(Errors.PermanentRecord);
}
else
{
ErrorHandler.ShowErrorMessage(Errors.FailedSave);
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
if (UserData.CurrentUser.PaymentDraftCommittee == false)
{
ErrorHandler.ShowErrorMessage(Errors.OperationNotAllowed);
return;
}
if (EditBtn.IsEnabled == false)
{
ErrorHandler.NotifyUser("سند تا کنون به ثبت نرسیده است");
return;
}
else if (CurrentContract.PermanentRecord == true)
{
ErrorHandler.NotifyUser("سند قبلا به ثبت نهایی رسیده است");
return;
}
else
{
if (Validate())
{
return;
}
CurrentContract.PermanentRecord = true;
DataManagement.UpdateContract(CurrentContract);
ErrorHandler.NotifyUser("سند به ثبت نهایی رسید");
}
}
private void RefreshUserBtn_Click(object sender, RoutedEventArgs e)
{
FirstNameTxt.Text = ""; LastNameTxt.Text = ""; OrgCom.SelectedIndex = -1; PositionTxt.SelectedIndex = -1;
var t = DataManagement.HasAccessToContract(ContractSearchGrid.SelectedItem as Contract);
SearchUserGrid.ItemsSource = null;
}
private void OpenFileBtn_Click(object sender, RoutedEventArgs e)
{
var t = DataManagement.SearchEvaluations(null, null, CurrentTendering.TenderingNumber, null, null, null, null, null, null).FirstOrDefault();
if (t == null || CurrentTendering.TenderingNumber == "" || CurrentTendering.TenderingNumber == null)
{
ErrorHandler.ShowErrorMessage("ارزیابی کیفی صورت نگرفته است");
return;
}
var t2 = DataManagement.RetrieveEvaluationFile(t.EvaluationId);
var x = DataManagement.HasEvaluationFileLocation(t.EvaluationId);
if (x == null)
{
ErrorHandler.NotifyUser("صورتجلسه ارزیابی کیفی تا کنون ثبت نشده است");
return;
}
layoutRoot.Children.Add(busy);
Task.Factory.StartNew(delegate
{
try
{
OpenFileHandler.OpenFileFromByte(DataManagement.RetrieveEvaluationFile(t.EvaluationId), x);
}
catch (System.Exception ex)
{
ErrorHandler.ShowErrorMessage("در حال حاضر امکان دسترسی به این فایل وجود ندارد");
}
}).ContinueWith(delegate
{
this.layoutRoot.Children.Remove(busy);
}, TaskScheduler.FromCurrentSynchronizationContext());
}
internal FlowchartView(DataManagement data, string path, string name, string type_code)
{
InitializeComponent();
flowchartPresenter = new MasterPresenter(data, path, this, name, type_code);
applyButton.Enabled = false;
declineButton.Enabled = false;
}
internal FlowchartView(DataManagement data, string name, bool isMaster, string reviewer)
{
InitializeComponent();
this.isMaster = isMaster;
if (isMaster && (reviewer == "" || reviewer == null))
{
flowchartPresenter = new MasterPresenter(data, this, name);
applyButton.Enabled = false;
declineButton.Enabled = false;
this.Text = "Flowchart Editor (Master Mode)";
}
else if (isMaster && reviewer != "" && reviewer != null)
{
flowchartPresenter = new MasterViewChangesPresenter(data, this, name);
commentTextBox.ReadOnly = true;
commentTextBox.Visible = false;
toDatabaseButton.Enabled = false;
addBlockButton.Visible = false;
editBlockButton.Visible = false;
removeButton.Visible = false;
this.Text = "Flowchart Editor (Master View Changes Mode)";
}
else
{
flowchartPresenter = new ReviewerPresenter(data, this, name);
applyButton.Enabled = false;
declineButton.Enabled = false;
this.Text = "Flowchart Editor (Reviewer Mode)";
}
vScrollBar1.Maximum = flowchartPresenter.GetScrollBarBValue();
DrawFlowchart();
}
private void button2_Click(object sender, RoutedEventArgs e)
{
SubSystem x = new SubSystem();
if (!hasAccess())
{
ErrorHandler.NotifyUser(Errors.OperationNotAllowed);
return;
}
if (SubsystemCom.Text == "مناقصات")
{
x = SubSystem.Tendering;
}
else if (SubsystemCom.Text == "قرارداد ها")
{
x = SubSystem.Contract;
}
else if (SubsystemCom.Text == "آیین نامه ها")
{
x = SubSystem.Regulation;
}
else if (SubsystemCom.Text == "مدیریت کاربران")
{
x = SubSystem.UserManagement;
}
else
{
x = SubSystem.TenderingArchive;
}
datagrid.ItemsSource = DataManagement.SearchLogs(x, Date1DP.SelectedDate, Date2DP.SelectedDate, (int?)UserCom.SelectedValue);
}
public ExampleForm()
{
InitializeComponent();
MyFormAppSession session = new MyFormAppSession("http://192.168.0.51/tc");
HomeFolder home = new HomeFolder(this);
Query query = new Query(this);
DataManagement dm = new DataManagement(this);
User user = session.login();
DataManagementService dmService = DataManagementService.getService(MyFormAppSession.getConnection());
String[] attributes = { "os_username" };
dmService.GetProperties(new ModelObject[] { user }, attributes);
appendTxt("User name: " + user.Os_username);
home.listHomeFolder(user);
query.queryItems();
dm.createReviseAndDelete();
session.logout();
}
private void BrowseBtn1_Click(object sender, RoutedEventArgs e)
{
if (EditBtn.IsEnabled == false)
{
ErrorHandler.NotifyUser("برای بارگذاری فایل پس از تکمیل سند و ثبت آن از طریق جستجو وارد شوید");
return;
}
if (dataGrid1.SelectedIndex == -1)
{
return;
}
if ((dataGrid1.SelectedItem as ContractFile).FileId > 0)
{
return;
}
if (CurrentContract.PermanentRecord == true)
{
ErrorHandler.NotifyUser("سند به ثبت نهایی رسیده است");
return;
}
FileDataObject temp = FilingManager.GetFileDataObject();
if (temp == null)
{
return;
}
ContractFile t = dataGrid1.SelectedItem as ContractFile;
t.FileContent = temp.FileContent;
t.Name = temp.FileName;
t.AttachedDate = DateTime.Now;
DataManagement.AddContractFile(CurrentContract.Contractid, ContractIndex.ComplementOrExtend, t);
ErrorHandler.NotifyUser(Errors.Saved);
}
public Report6_Viewer(Meeting x, Tendering y)
{
InitializeComponent();
CurrentMeet = x;
CurrentTender = y;
CurrentReq = DataManagement.RetrieveTenderingContractorRequest(y);
}
public static void LoadSystemConfig()
{
string path = DataManagement.PathForDataDirectory(systemSettingsDir);
string filePath = Path.Combine(path, systemSettingsFile);
bool updateConfigFile = false;
int prevSerializationVersion = -1;
FileReader.ReadJsonFile(
path: filePath,
successCallback: (JsonObject jsonConfigs) =>
{
prevSerializationVersion = jsonConfigs["SerializationVersion"];
});
//Update Serialization and system options
if (prevSerializationVersion < serializationVersion)
{
updateConfigFile = true;
}
if (updateConfigFile)
{
SaveConfiguration();
}
}
public ActionResult RefreshMap(DataManagement.Search model)
{
/*DataManagementService service = new DataManagementService();
var result = service.LoadSearch(model.Id);
if(result.Count() != 0)
{
return View("Search", result.First());
}*/
return View("Search", model);
}
public static void CreateTable(DataManagement.Configuration config, string tablePrefix = "")
{
var columns = new ColumnDefinition[]
{
new ColumnDefinition("Variable", DataType.LargeText),
new ColumnDefinition("Value", DataType.LargeText),
new ColumnDefinition("Timestamp", DataType.DateTime)
};
Table.Create(config, tablePrefix + Names.Variables, columns, primaryKey);
}
void Awake () {
if (datamanagement == null) {
DontDestroyOnLoad (gameObject); //непонятно
datamanagement = this;
}
else if (datamanagement != this)
{
Destroy (gameObject);
}
}
public static VariableData Get(DataManagement.Configuration config, string variableName, string tablePrefix = "")
{
VariableData Result = null;
DataRow row = Row.Get(config, tablePrefix + Names.Variables, "variable", variableName);
if (row != null)
{
Result = new VariableData();
if (row["variable"] != null) Result.Variable = row["variable"].ToString();
if (row["value"] != null) Result.Value = row["value"].ToString();
if (row["timestamp"] != null)
{
DateTime timestamp = DateTime.MinValue;
DateTime.TryParse(row["timestamp"].ToString(), out timestamp);
if (timestamp > DateTime.MinValue) Result.Timestamp = timestamp;
}
}
return Result;
}
public static void Update(DataManagement.Configuration config, VariableData[] infos, string tablePrefix = "")
{
if (infos.Length > 0)
{
List<string> columns = new List<string>();
columns.Add("Variable");
columns.Add("Value");
columns.Add("Timestamp");
var tableValues = new List<List<object>>();
foreach (var info in infos)
{
var match = Data.Find(x => x.Variable == info.Variable && x.UniqueId == info.UniqueId);
if (match == null)
{
Data.Add(info);
match = info;
}
if (match.Value != info.Value)
{
match.Value = info.Value;
var rowValues = new List<object>();
rowValues.Add(info.Variable);
rowValues.Add(info.Value);
rowValues.Add(info.Timestamp);
tableValues.Add(rowValues);
}
}
if (tableValues.Count > 0)
{
string query = Row.CreateInsertQuery(tablePrefix + Names.Variables, columns.ToArray(), tableValues, true);
//TrakHound.Servers.Processor.Server.DatabaseQueue.AddToQueue(query);
}
}
}
