public string userCompleted(int ID, string mark) { QCTESTEntities QC_DB = new QCTESTEntities(); var pj = QC_DB.M_runTestCase.FirstOrDefault(t => t.ID == ID); pj.state = 2; pj.mark = mark; QC_DB.SaveChanges(); CaseDataModel cd = new CaseDataModel(pj); string json = JsonConvert.SerializeObject(cd); return(json); }
public string CaseErrorReset(int ID) { QCTESTEntities QC_DB = new QCTESTEntities(); var pj = QC_DB.M_runTestCase.FirstOrDefault(t => t.ID == ID); pj.state = null; pj.startDate = null; pj.endDate = null; pj.resultPath = null; pj.resultXML = null; QC_DB.SaveChanges(); CaseDataModel cd = new CaseDataModel(pj); string json = JsonConvert.SerializeObject(cd); return(json); }
public int InsertCase(CaseDataModel caseData) { const string insertCaseQuery = @"DECLARE @createdDateTime datetime SET @createdDateTime= GETDATE() DECLARE @CaseId int EXEC [spInsertCase] @CaseId output, @PoliceFileNumber, @EclCaseNumber, @Description, " + @"@DistrictId, @SiteId, @OffenceTypeId, @createdBy INSERT INTO UserCase VALUES (@UserId, @CaseId, 7) select @CaseId as CaseId"; var parameters = new List <SqlParameter> { new SqlParameter("@PoliceFileNumber", caseData.PoliceFileNumber), new SqlParameter("@EclCaseNumber", caseData.EclCaseNumber), new SqlParameter("@Description", caseData.Description), new SqlParameter("@DistrictId", caseData.DistrictId), new SqlParameter("@SiteId", caseData.SiteId), new SqlParameter("@OffenceTypeId", caseData.OffenceTypeId), new SqlParameter("@OffenceTypeId", caseData.OffenceTypeId), new SqlParameter("@UserId", caseData.CreatedById), }; try { using (var conn = new SqlConnection(ConnectionString)) { return(conn.SelectColumn <int>(insertCaseQuery, "CaseId", parameters).First()); } } catch (Exception e) { Console.Error.WriteLine("InsertCase failed [caseNumber = {0}] : {1}", caseData.EclCaseNumber, e.Message); throw; } }
public ExhibitHelperModel PrepareDbData(string evidencePath, AcquisitionFormatType type) { var exhibitDataModel = new ExhibitDataModel().GetDefault(); var caseDataModel = new CaseDataModel().GetDefault(); var mediaDataModel = new MediaDataModel().GetDefault(); caseDataModel.SiteId = new SiteTable(Config.GetConnectionString(DataStore.Central)).GetSiteId(); var caseId = Case.InsertCase(caseDataModel.PoliceFileNumber, caseDataModel.EclCaseNumber, caseDataModel.Description, caseDataModel.OfficerInChargeId, caseDataModel.DistrictId, caseDataModel.SiteId, caseDataModel.OffenceTypeId, caseDataModel.CreatedById); var exhibitId = EVE.BLL.Exhibit.CreateExhibit(caseId, caseDataModel.CreatedById, exhibitDataModel.EclExhibitNumber, exhibitDataModel.Description, exhibitDataModel.PoliceExhibitNumber); mediaDataModel.EvidencePath = Path.GetFullPath(evidencePath); var mediaId = Media.InsertMedia(exhibitId, mediaDataModel.MediaNumber, mediaDataModel.Description, mediaDataModel.EvidencePath, MediaStatus.Defined, type, string.Empty); return(new ExhibitHelperModel { ExhibitId = exhibitId, MediaId = mediaId, CaseId = caseId, CasePoliceNumber = caseDataModel.PoliceFileNumber, EclExhibitNumber = exhibitDataModel.EclExhibitNumber, MediaNumber = mediaDataModel.MediaNumber }); }
public CasesPage AddCase(CaseDataModel caseDataModel) { var addCasePage = ClickAddCaseLink(); return(addCasePage.AddCase(caseDataModel)); }