public void DeleteProblem()
{
ProblemHistory problem = HistoryConvert();
new PersistencyFacade().MoveProblemToHistory(problem);
new PersistencyFacade().DeleteProblem(ApartmentViewModel.SelectedProblem);
var problems = new PersistencyFacade().GetProblems();
var historyProblems = new PersistencyFacade().GetProblemHistories();
ApartmentViewModel.ProblemHistoryCatalogSingleton.ProblemHistories.Clear();
ApartmentViewModel.ProblemCatalogSingleton.Problems.Clear();
foreach (var problem1 in problems)
{
ApartmentViewModel.ProblemCatalogSingleton.Problems.Add(problem1);
}
foreach (var problem2 in historyProblems)
{
ApartmentViewModel.ProblemHistoryCatalogSingleton.ProblemHistories.Add(problem2);
}
ApartmentViewModel.NewProblem.ApartmentID = 0;
ApartmentViewModel.NewProblem.Description = "";
ApartmentViewModel.NewProblem.Header = "";
ApartmentViewModel.NewProblem.ProblemID = 0;
}
//public void MoveProblemToHistory()
//{
// new PersistencyFacade().MoveProblemToHistory(HistoryConvert());
// DeleteProblem();
// var problems = new PersistencyFacade().GetProblemHistories();
//}
public ProblemHistory HistoryConvert()
{
Problem problem = ApartmentViewModel.SelectedProblem;
ProblemHistory problemHistory = new ProblemHistory()
{
ApartmentID = problem.ApartmentID,
Description = problem.Description,
Header = problem.Header,
ProblemID = problem.ProblemID,
Note = ApartmentViewModel.ProblemNote
};
return(problemHistory);
}
public void MoveProblemToHistory(ProblemHistory problemHistory)
{
using (var client = new HttpClient(handler))
{
client.BaseAddress = new Uri(ServerUrl);
client.DefaultRequestHeaders.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
try
{
var problemHistory1 = JsonConvert.SerializeObject(problemHistory);
var content = new StringContent(problemHistory1, Encoding.UTF8, "Application/json");
var problemHistoryList = client.PostAsync("api/ProblemHistories", content).Result;
}
catch (Exception ex)
{
new MessageDialog(ex.Message).ShowAsync();
}
}
}
public int Insert_ProblemHistory_mst(ProblemHistory ObjProblemHistory)
{
return (int)ExecuteNonQuery(Sp_ProblemHistory_Insert, new object[] { ObjProblemHistory.Operationtime, ObjProblemHistory.Problemid, ObjProblemHistory.Operationownerid, ObjProblemHistory.Operation, ObjProblemHistory.Description });
}
public CollectionBase GenerateProblemHistory_mstCollection(ref IDataReader returnData)
{
BLLCollection<ProblemHistory> col = new BLLCollection<ProblemHistory>();
while (returnData.Read())
{
ProblemHistory obj = new ProblemHistory();
DateTime Mydatetime = new DateTime();
Mydatetime = (DateTime)returnData["Operationtime"];
obj.Operationtime = Mydatetime.ToString();
obj.Problemid = (int)returnData["Problemid"];
obj.Historyid = (int)returnData["Historyid"];
obj.Operationownerid = (int)returnData["opertaionownerid"];
obj.Operation = (string)returnData["Operation"];
if (returnData["Description"] != DBNull.Value)
{
obj.Description = (string)returnData["Description"];
}
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
