public static int Update(Record obj)
{
if (Settings.DataProvider == DataProviderType.SqlServer)
{
int ret = 0;
using (SqlConnection connection = new SqlConnection(DBConnector.GetBuilder().ConnectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(SQL_UPDATE, connection);
command.Parameters.AddWithValue("@PaidDate", obj.PaidDate);
command.Parameters.AddWithValue("@ID", obj.ID);
ret = command.ExecuteNonQuery();
}
return(ret);
}
else
{
xmlDoc.Load(filePath);
XmlNode root = xmlDoc.DocumentElement;
XmlNodeList list = root.SelectNodes("Record");
XmlNode objNode = null;
foreach (XmlNode node in list)
{
XmlNodeList childs = node.ChildNodes;
foreach (XmlNode child in childs)
{
if (child.Name == "ID" && child.InnerText == obj.ID.ToString())
{
objNode = node;
Console.WriteLine(objNode.InnerXml);
break;
}
}
if (objNode != null)
{
break;
}
}
foreach (XmlNode child in objNode.ChildNodes)
{
if (child.Name == "Ammount")
{
child.InnerText = obj.Ammount.ToString();
}
if (child.Name == "PointsTaken")
{
child.InnerText = obj.PointsTaken.ToString();
}
if (child.Name == "DateOfEntry")
{
child.InnerText = obj.DateOfEntry.ToString();
}
if (child.Name == "ExpireDate")
{
child.InnerText = obj.ExpireDate.ToString();
}
if (child.Name == "PaidDate")
{
child.InnerText = obj.PaidDate.ToString();
}
if (child.Name == "driverID")
{
child.InnerText = obj.driverID.ToString();
}
if (child.Name == "employeeID")
{
child.InnerText = obj.employeeID.ToString();
}
if (child.Name == "fineTypeID")
{
child.InnerText = obj.fineTypeID.ToString();
}
}
XMLSaveDocument();
return(1);
}
}
public static int Save(Record obj)
{
if (Settings.DataProvider == DataProviderType.SqlServer)
{
int recordID = -1;
using (SqlConnection connection = new SqlConnection(DBConnector.GetBuilder().ConnectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(SQL_INSERT, connection))
{
command.Parameters.AddWithValue("@Ammount", obj.Ammount);
command.Parameters.AddWithValue("@PointsTaken", obj.PointsTaken);
command.Parameters.AddWithValue("@DateOfEntry", obj.DateOfEntry);
command.Parameters.AddWithValue("@ExpireDate", obj.ExpireDate);
if (obj.PaidDate == null)
{
command.Parameters.AddWithValue("@PaidDate", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@PaidDate", obj.PaidDate);
}
command.Parameters.AddWithValue("@driverID", obj.driverID);
command.Parameters.AddWithValue("@employeeID", obj.employeeID);
command.Parameters.AddWithValue("@fineTypeID", obj.fineTypeID);
recordID = (int)command.ExecuteScalar();
}
}
return(recordID);
}
else
{
XmlElement root = xmlDoc.DocumentElement;
XmlElement elem = xmlDoc.CreateElement("Record");
XmlElement id = xmlDoc.CreateElement("ID");
id.InnerText = freeID.ToString();
obj.ID = freeID;
freeID = freeID + 1;
elem.AppendChild(id);
XmlElement Ammount = xmlDoc.CreateElement("Ammount");
Ammount.InnerText = obj.Ammount.ToString();
elem.AppendChild(Ammount);
XmlElement PointsTaken = xmlDoc.CreateElement("PointsTaken");
PointsTaken.InnerText = obj.PointsTaken.ToString();
elem.AppendChild(PointsTaken);
XmlElement DateOfEntry = xmlDoc.CreateElement("DateOfEntry");
DateOfEntry.InnerText = obj.DateOfEntry.ToString();
elem.AppendChild(DateOfEntry);
XmlElement ExpireDate = xmlDoc.CreateElement("ExpireDate");
ExpireDate.InnerText = obj.ExpireDate.ToString();
elem.AppendChild(ExpireDate);
XmlElement PaidDate = xmlDoc.CreateElement("PaidDate");
PaidDate.InnerText = obj.PaidDate.ToString();
elem.AppendChild(PaidDate);
XmlElement driverID = xmlDoc.CreateElement("driverID");
driverID.InnerText = obj.driverID.ToString();
elem.AppendChild(driverID);
XmlElement employeeID = xmlDoc.CreateElement("employeeID");
employeeID.InnerText = obj.employeeID.ToString();
elem.AppendChild(employeeID);
XmlElement fineTypeID = xmlDoc.CreateElement("fineTypeID");
fineTypeID.InnerText = obj.fineTypeID.ToString();
elem.AppendChild(fineTypeID);
root.AppendChild(elem);
XMLSaveDocument();
return(1);
}
}