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));
}
