public bool DeleteCondition(CalculationConditionItem item)
{
string cmdText = "delete from tempCondition where id=@id";
SQLiteParameter[] cmdParameters =
{
new SQLiteParameter("@id",item.Id),
};
return SqliteHelper.ExecuteNonQuery(cmdText, cmdParameters) > 0;
}
public bool UpdateCondition(CalculationConditionItem item)
{
string cmdText = "update tempcondition set groupname=@groupname,materialName=@materialName,moleWeight=@moleWeight,at=@at where id=@id";
SQLiteParameter[] cmdParameters =
{
new SQLiteParameter("@groupname",item.GroupName),
new SQLiteParameter("@materialName",item.MaterialName),
new SQLiteParameter("@moleWeight",item.MoleWeight),
new SQLiteParameter("@at",item.At),
new SQLiteParameter("@id",item.Id)
};
return SqliteHelper.ExecuteNonQuery(cmdText, cmdParameters) > 0;
}
public bool AddCondition(CalculationConditionItem item)
{
string cmdText = "insert into tempcondition (id,groupname,materialName,moleWeight,at) values (@id,@groupname,@materialName,@moleWeight,@at) ";
SQLiteParameter[] cmdParameters =
{
new SQLiteParameter("@id",item.Id),
new SQLiteParameter("@groupname",item.GroupName),
new SQLiteParameter("@materialName",item.MaterialName),
new SQLiteParameter("@moleWeight",item.MoleWeight),
new SQLiteParameter("@at",item.At)
};
return SqliteHelper.ExecuteNonQuery(cmdText, cmdParameters) > 0;
}
public IList<CalculationConditionItem> GetAllConditions()
{
IList<CalculationConditionItem> results = new List<CalculationConditionItem>();
string cmdText = "select id,groupname,materialname,moleweight,at from tempcondition order by groupname";
SQLiteDataReader dr = SqliteHelper.ExecuteReader(cmdText, null);
while (dr.Read())
{
CalculationConditionItem tmp = new CalculationConditionItem();
tmp.Id = dr.GetGuid(0);
tmp.GroupName = dr.GetString(1);
tmp.MaterialName = dr.GetString(2);
tmp.MoleWeight = dr.GetDouble(3);
tmp.At = dr.GetDouble(4);
results.Add(tmp);
}
dr.Close();
return results;
}
private void DeleteConditionAction(CalculationConditionItem item)
{
string warningMsg = Application.Current.TryFindResource("dialogDeleteCondition").ToString();
if (dialogService.ShowDialog(warningMsg, "Delete"))
{
mainDataService.DeleteCondition(item);
LoadConditions();
}
}
private void EditConditionAction(CalculationConditionItem item)
{
CalculationConditionItem tmpItem = new CalculationConditionItem();
tmpItem.Id = item.Id;
tmpItem.GroupName = item.GroupName;
tmpItem.MaterialName = item.MaterialName;
tmpItem.MoleWeight = item.MoleWeight;
tmpItem.At = item.At;
NotificationMessage<object> msg = new NotificationMessage<object>(this, "EditCondition", tmpItem, "OpenWindow");
Messenger.Default.Send<NotificationMessage<object>>(msg);
}
private void AddConditionAction()
{
CalculationConditionItem item = new CalculationConditionItem() { GroupName = "1",MaterialName="default",MoleWeight=100, At = 10 };
NotificationMessage<object> msg = new NotificationMessage<object>(this, "EditCondition", item, "OpenWindow");
Messenger.Default.Send<NotificationMessage<object>>(msg);
}
public bool AddSingleConditionByProjectId(CalculationConditionItem item,Guid projectId)
{
string cmdText = "insert into projectitem (id,groupname,materialName,moleWeight,at,projectid) values (@id,@groupname,@materialName,@moleWeight,@at,@projectid) ";
SQLiteParameter[] cmdParameters =
{
new SQLiteParameter("@id",Guid.NewGuid()),
new SQLiteParameter("@groupname",item.GroupName),
new SQLiteParameter("@materialName",item.MaterialName),
new SQLiteParameter("@moleWeight",item.MoleWeight),
new SQLiteParameter("@at",item.At),
new SQLiteParameter("@projectid",projectId)
};
return SqliteHelper.ExecuteNonQuery(cmdText, cmdParameters) > 0;
}
public List<CalculationConditionItem> GetCalculationsByProjectId(Guid projectId)
{
List<CalculationConditionItem> results = new List<CalculationConditionItem>();
string cmdText = "select id,groupname,materialname,moleweight,at from projectitem where projectid=@projectid order by groupname";
SQLiteParameter[] cmdParameters = new SQLiteParameter[]
{
new SQLiteParameter("@projectid",projectId)
};
SQLiteDataReader dr = SqliteHelper.ExecuteReader(cmdText, cmdParameters);
while (dr.Read())
{
CalculationConditionItem tmp = new CalculationConditionItem();
tmp.Id = dr.GetGuid(0);
tmp.GroupName = dr.GetString(1);
tmp.MaterialName = dr.GetString(2);
tmp.MoleWeight = dr.GetDouble(3);
tmp.At = dr.GetDouble(4);
results.Add(tmp);
}
dr.Close();
return results;
}
