public static void ReplaceMachineRecrod(MachineRecord r)
{
if (r != null)
{
var collection = iDatabase.GetCollection <MachineRecord>(Collections.machine_records.ToString());
var filter = Builders <MachineRecord> .Filter.Eq(e => e.id, r.id);
collection.ReplaceOne(filter, r);
collection = iDatabase.GetCollection <MachineRecord>(Collections.machine_records_other.ToString());
collection.ReplaceOne(filter, r);
}
}
//static public List<Device> getAllDevices()
//{
// MongoCollection<Device> collection = database.GetCollection<Device>(Collections.device.ToString());
// MongoCursor<Device> all = collection.FindAll();
// List<Device> list = new List<Device>();
// foreach (Device m in all)
// {
// list.Add(m);
// }
// return list;
//}
#endregion
#region GetSetDocument
#region Save
//static public string SaveDevice(Device d)
//{
// if (d != null)
// {
// if (DeviceExists(d))
// return "";
// ObjectId adressid = SaveAddress(d.getAddress());
// var col = database.GetCollection(Collections.device.ToString());
// d.instalation_address = adressid;
// var dev = d;
// WriteConcernResult res = col.Save(dev);
// Global.log("SaveDevice: " + res.UpdatedExisting.ToString());
// return dev.serial_number;
// }
// else
// {
// return "";
// }
//}
//static private ObjectId SaveAddress(Address d)
//{
// if (d != null)
// {
// var col = database.GetCollection(Collections.addresses.ToString());
// var obj = d;
// WriteConcernResult res = col.Save(obj);
// Global.log("SaveAddress: " + res.UpdatedExisting.ToString());
// return obj.id;
// }
// else
// {
// return new ObjectId();
// }
//}
private static ObjectId SaveMachineRecord_Deleted(MachineRecord r)
{
if (r != null)
{
var col = database.GetCollection(CollectionsDeleted.machine_record_deleted.ToString());
var obj = r;
WriteConcernResult res = col.Save(obj);
Global.Log("SaveMachineRecord_Deleted: " + res.UpdatedExisting.ToString());
return((ObjectId)obj.id);
}
else
{
return(new ObjectId());
}
}
public int Compare(MachineRecord x, MachineRecord y)
{
// Sprawdzanie datą
int datetime_compare = DateTime.Compare(x.datetime, y.datetime);
if (datetime_compare > 0)
{
return(1);
}
else if (datetime_compare < 0)
{
return(-1);
}
return(0);
}
static public bool DeleteMachineRecord(MachineRecord r)
{
if (r == null)
{
throw new ArgumentNullException("Machine record in Database.MongoTB.DeleteMachineRecord is null");
}
var collection = database.GetCollection <MachineRecord>(Collections.machine_records.ToString());
var entityQuery = Query <MachineRecord> .EQ(e => e.id, r.id);
WriteConcernResult result = collection.Remove(entityQuery);
r.id = new ObjectId();
if (r.parsed_by_email == false)
{
DeleteHTMLSerial(r.full_serialnumber);
DeleteHTMLCounter(r.full_counter);
}
SaveMachineRecord_Deleted(r);
return(true);
}
static internal MachineRecord GetFirstInMonth(string serial_number, DateTime month)
{
if (serial_number != null)
{
//var collection = database.GetCollection<MachineRecord>(Collections.machine_records.ToString());
//var filter = Builders<MachineRecord>.Filter.Gte(e => e.datetime, month) & Builders<MachineRecord>.Filter.Eq(e => e.serial_number, serial_number);
//var entityQuery = Query<MachineRecord>(filter);
var collection = _database.GetCollection <MachineRecord>(Collections.machine_records.ToString());
var filter = Builders <MachineRecord> .Filter.Gte(e => e.datetime, month) & Builders <MachineRecord> .Filter.Eq(e => e.serial_number, serial_number);
IMongoCollection <MachineRecord> col;
MachineRecord record = collection.Find <MachineRecord>(filter).FirstOrDefault();
if (record != null)
{
record.InitValues();
}
return(record);
}
return(null);
}
internal static void ReplaceMachineRecord(MachineRecord record)
{
MongoTB.ReplaceMachineRecrod(record);
}
internal static void DeleteMachineRecord(MachineRecord additionalItem)
{
MongoTB.DeleteMachineRecord(additionalItem);
}
/// <summary>
/// This method is inherited from the IComparer interface. It compares the two objects passed using a case insensitive comparison.
/// </summary>
/// <param name="x">First object to be compared</param>
/// <param name="y">Second object to be compared</param>
/// <returns>The result of the comparison. "0" if equal, negative if 'x' is less than 'y' and positive if 'x' is greater than 'y'</returns>
public int Compare(object x, object y)
{
int compareResult = 0;
Copyinfo.Forms.Controls.ListView.TBListViewItem listviewX, listviewY;
// Cast the objects to be compared to ListViewItem objects
listviewX = (Copyinfo.Forms.Controls.ListView.TBListViewItem)x;
listviewY = (Copyinfo.Forms.Controls.ListView.TBListViewItem)y;
string a = listviewX.SubItems[ColumnToSort].Text;
string b = listviewY.SubItems[ColumnToSort].Text;
// Compare the two items
if (ItsColumnWithInt(ColumnToSort))
{
compareResult = ObjectCompare.Compare(int.Parse(a), int.Parse(b));
}
else
if (ItsColumnWithDate(ColumnToSort))
{
switch (this.additionalItemType)
{
case Copyinfo.Forms.Controls.ListView.TBListViewItem.AdditionalItemClassType.None:
compareResult = 0;
break;
case Copyinfo.Forms.Controls.ListView.TBListViewItem.AdditionalItemClassType.MachineRecord:
Copyinfo.Database.MachineRecord recordX = (Copyinfo.Database.MachineRecord)listviewX.additionalItem;
Copyinfo.Database.MachineRecord recordY = (Copyinfo.Database.MachineRecord)listviewY.additionalItem;
compareResult = DateTime.Compare(recordX.datetime, recordY.datetime);
break;
case Copyinfo.Forms.Controls.ListView.TBListViewItem.AdditionalItemClassType.Device:
Copyinfo.Database.Device deviceX = (Copyinfo.Database.Device)listviewX.additionalItem;
Copyinfo.Database.Device deviceY = (Copyinfo.Database.Device)listviewY.additionalItem;
compareResult = DateTime.Compare(deviceX.instalation_datetime, deviceY.instalation_datetime);
break;
}
}
else
{
compareResult = ObjectCompare.Compare(a, b);
}
// Calculate correct return value based on object comparison
if (OrderOfSort == SortOrder.Ascending)
{
// Ascending sort is selected, return normal result of compare operation
return(compareResult);
}
else if (OrderOfSort == SortOrder.Descending)
{
// Descending sort is selected, return negative result of compare operation
return(-compareResult);
}
else
{
// Return '0' to indicate they are equal
return(0);
}
//int compareResult;
//System.Windows.Forms.ListViewItem listviewX, listviewY;
//// Cast the objects to be compared to ListViewItem objects
//listviewX = (System.Windows.Forms.ListViewItem)x;
//listviewY = (System.Windows.Forms.ListViewItem)y;
//string a = listviewX.SubItems[ColumnToSort].Text;
//string b = listviewY.SubItems[ColumnToSort].Text;
//// Compare the two items
//if (itsColumnWithInt(ColumnToSort))
// compareResult = ObjectCompare.Compare(int.Parse(a), int.Parse(b));
//else
//if (itsColumnWithDate(ColumnToSort))
//{
// Copyinfo.Forms.TBListViewItem_MachineRecord recordA = (Copyinfo.Forms.TBListViewItem_MachineRecord)x;
// Copyinfo.Forms.TBListViewItem_MachineRecord recordB = (Copyinfo.Forms.TBListViewItem_MachineRecord)y;
// compareResult = DateTime.Compare(recordA.record.datetime, recordB.record.datetime);
//}
//else
//{
// compareResult = ObjectCompare.Compare(a, b);
//}
//// Calculate correct return value based on object comparison
//if (OrderOfSort == SortOrder.Ascending)
//{
// // Ascending sort is selected, return normal result of compare operation
// return compareResult;
//}
//else if (OrderOfSort == SortOrder.Descending)
//{
// // Descending sort is selected, return negative result of compare operation
// return (-compareResult);
//}
//else
//{
// // Return '0' to indicate they are equal
// return 0;
//}
}