public ActionResponse Authenticate(string username, string password) { ActionResponse response = new ActionResponse(); try { var context = DbContextFactory.GetDbContext(); bool hasAny = context.Users.Any(u => u.Username == username && u.Password == password); if (hasAny) { response.IsSuccess = true; } else { response.Error = ErrorFactory.InvalidUsernameOrPassword; } } catch (Exception exc) { Elmah.ErrorSignal.FromCurrentContext().Raise(exc); response.Error = ErrorFactory.ConnectingToDatabaseFailure; } return response; }
public ActionResponse Edit(TestW testW) { var response = new ActionResponse(); var test = db.Tests.Single(c => c.Id == testW.Id); test.Name = testW.Name; test.TestCategoryId = testW.TestCategoryId; test.AcredetationLevelId = testW.AcredetationLevelId; test.Temperature = testW.Temperature; test.UnitName = testW.UnitName; test.TypeId = testW.TypeId; test.MethodValue = testW.MethodValue; //test.TestMethods = testW.TestMethods; try { var toDelete = new List<TestMethod>(); //1 add all to be deleted that not existing in the new list foreach (var item in test.TestMethods) { if (!testW.TestMethods.Any(m => m.Method == item.Method)) { toDelete.Add(item); //test.TestMethods.Remove(item); //db.TestMethods.Remove(item); } } //1.5 Remove them foreach (var item in toDelete) { db.TestMethods.Remove(item); } //2 now insert all that are new for the list foreach (var item in testW.TestMethods) { if (!test.TestMethods.Any(m => m.Method == item.Method)) { var method = new TestMethod(); method.Id = Guid.NewGuid(); method.Method = item.Method; test.TestMethods.Add(method); } } response.IsSuccess = true; db.SaveChanges(); } catch (Exception exc) { Elmah.ErrorSignal.FromCurrentContext().Raise(exc); response.IsSuccess = false; response.Error = ErrorFactory.MethodInUseError; } return response; }
public ActionResponse ArchiveDiary(Guid diaryId) { var res = new ActionResponse(); try { var diary = db.Diaries.Single(d => d.Id == diaryId); ArchivedDiary archivedDiary = new ArchivedDiary(); archivedDiary.Id = Guid.NewGuid(); archivedDiary.Number = diary.Number; archivedDiary.AcceptanceDateAndTime = diary.AcceptanceDateAndTime; archivedDiary.LetterNumber = diary.LetterNumber != null ? diary.LetterNumber.ToString() : ""; archivedDiary.LetterDate = diary.LetterDate; archivedDiary.Contractor = diary.Contractor; archivedDiary.Client = diary.Client.Name; archivedDiary.ClientMobile = diary.Client.Mobile; archivedDiary.Comment = diary.Comment; var request = diary.Requests.First(); archivedDiary.RequestDate = request.Date; archivedDiary.RequestAcceptedBy = request.User.FirstName.Substring(0,1) + ". " + request.User.LastName; archivedDiary.RequestTestingPeriod = request.TestingPeriod; archivedDiary.Remark = new DiaryW(diary).Remark; var protocol = request.Protocols.First(); archivedDiary.ProtocolIssuedDate = protocol.IssuedDate; archivedDiary.ProtocolTesterMKB = protocol.TesterMKB; archivedDiary.ProtocolTesterFZH = protocol.TesterFZH; archivedDiary.ProtocolLabLeader = protocol.LabLeader; foreach (var remark in protocol.ProtocolsRemarks) { ArchivedProtocolRemark aremark = new ArchivedProtocolRemark(); aremark.Id = Guid.NewGuid(); aremark.ArchivedDiaryId = archivedDiary.Id; aremark.Remark = remark.Remark.Text; aremark.AcredetationLevel = remark.AcredetationLevel.Level; aremark.Number = remark.Number; db.ArchivedProtocolRemarks.Add(aremark); } db.ProtocolsRemarks.RemoveRange(protocol.ProtocolsRemarks); var products = diary.Products; foreach (var product in products) { ArchivedProduct aproduct = new ArchivedProduct(); aproduct.Id = Guid.NewGuid(); aproduct.Name = product.Name; aproduct.Number = product.Number; aproduct.Quantity = product.Quantity; var productTests = product.ProductTests; foreach (var ptest in productTests) { ArchivedProductTest aptest = new ArchivedProductTest(); aptest.Id = Guid.NewGuid(); aptest.TestName = ptest.Test.Name; aptest.TestUnitName = ptest.Test.UnitName; aptest.TestMethods = ptest.TestMethod.Method; aptest.TestAcredetationLevel = ptest.Test.AcredetationLevel.Level; aptest.TestTemperature = ptest.Test.Temperature; aptest.TestCategory = ptest.Test.TestCategory.Name; aptest.TestType = ptest.Test.TestType.Type; aptest.TestTypeShortName = ptest.Test.TestType.ShortName; aptest.MethodValue = ptest.MethodValue; aptest.Remark = ptest.Remark; //aptest.Units = ptest.Units; var protocolResults = ptest.ProtocolResults; foreach (var presult in protocolResults) { ArchivedProtocolResult apresult = new ArchivedProtocolResult(); apresult.Id = Guid.NewGuid(); apresult.Results = presult.Results; //apresult.MethodValue = presult.MethodValue; apresult.ResultNumber = presult.ResultNumber; apresult.ArchivedDiaryId = archivedDiary.Id; aptest.ArchivedProtocolResults.Add(apresult); } db.ProtocolResults.RemoveRange(ptest.ProtocolResults); aproduct.ArchivedProductTests.Add(aptest); } db.ProductTests.RemoveRange(product.ProductTests); archivedDiary.ArchivedProducts.Add(aproduct); } db.Products.RemoveRange(diary.Products); db.ArchivedDiaries.Add(archivedDiary); db.Protocols.RemoveRange(request.Protocols); db.Requests.Remove(request); db.Diaries.Remove(diary); db.SaveChanges(); res.IsSuccess = true; res.ResponseObject = archivedDiary.Id; res.SuccessMsg = "Архивирането на дневник: " + diary.Number + " премина успешно."; } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } catch (Exception exc) { Elmah.ErrorSignal.FromCurrentContext().Raise(exc); res.Error = ErrorFactory.UnableToArchiveDiary; } return res; }
public ActionResponse RegenerateArchivedProtocol(ArchivedDiaryW adiary) { var response = new ActionResponse(); try { var filesRep = new FilesRepository(); filesRep.RegenerateProtocolReport(adiary); response.IsSuccess = true; response.SuccessMsg = "Успешно опресняване на архивирания протокол!"; } catch (Exception exc) { Elmah.ErrorSignal.FromCurrentContext().Raise(exc); response.Error = ErrorFactory.UnableToRefreshArchivedProtocol; } return response; }