public ListTestResultViewModel(SampleTest sampleTest)
{
_sampleTest = sampleTest;
AddAllowed = true;
DeleteAllowed = true;
List.AddFilter(() => e => e.SampleTestId == sampleTest.Id);
List.OrderBy = e => e.Start;
Columns
.Column("{Name}", s => s.Name)
.Column("{Start}", s => s.Start)
.Column("{End}", s => s.End)
.Column("{Result}", s => s.Result)
.Icon("{State}", s => s.StateId != null ? GetStateIcon(s.StateId.Value) : "", s => s.StateId)
.Icon("{Stage}", s => GetStateIcon(s.Stage), s => s.Stage)
.Localize("{Stage}", s => GetStateCaption(s.Stage), s => s.Stage)
.Hidden("IsSelected", s => s.Id == s.SampleTest.Result?.Id)
.Hidden("IsValid", s => s.Stage != SampleTestResultWorkflow.Invalidated.Name)
;
using (List.Suspender.Get())
{
DeleteAllowed = true;
AddAllowed = true;
}
}
//Edit
public ActionResult CreateTTube(int?id, int?lt, int?sc, string asid, int?ttid)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (lt == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (sc == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (asid == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (ttid == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SampleTest atest = db.SampleTests.Find(ttid);
return(View(atest));
}
public ActionResult ConfirmScheduledAssay([Bind(Include = "StartDate")] Assay placeholderAssay, FormCollection form)
{
int AssayID = Int32.Parse(form["AssayID"]);
int NoOfSamples = Int32.Parse(form["Samples"]);
if (ModelState.IsValid)
{
Assay assay = db.Assays.Find(AssayID);
assay.StartDate = placeholderAssay.StartDate;
assay.StatusID = 3;
ViewBag.AssayID = assay.AssayID;
ViewBag.StartDate = assay.StartDate;
// create a SampleTest row in SampleTest table for each sample
for (int i = 1; i <= NoOfSamples; i++)
{
SampleTest sampleTest = new SampleTest();
sampleTest.LTNumber = assay.LTNumber;
sampleTest.AssayID = assay.AssayID;
sampleTest.CompoundSeqCode = i;
db.SampleTests.Add(sampleTest);
db.SaveChanges();
}
db.Entry(assay).State = EntityState.Modified;
db.SaveChanges();
return(View());
}
return(View());
}
public ActionResult DeleteConfirmed(int id)
{
SampleTest sampleTest = db.SampleTests.Find(id);
db.SampleTests.Remove(sampleTest);
db.SaveChanges();
return(Redirect("/Samples/Details/" + sampleTest.SampleId));
}
public int UpdateWithDynamicParameters(SampleTest obj)
{
DynamicParameters param = new DynamicParameters();
param.Add("@SampleTestId", obj.SampleTestId);
param.Add("@Name", obj.Name);
param.Add("@CreatedBy", obj.CreatedBy);
return(QueryExecutor.ExecuteWithParameter(StoreProcedures.spUpdateSampleTest.ToString(), param));
}
public ActionResult CreateTTube([Bind(Include = "TestTubeID,ScheduledDate,Concentration,LT,SequenceCode,AssayID,TestID")] SampleTest test)
{
if (ModelState.IsValid)
{
db.Entry(test).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(test));
}
public ActionResult UploadResults(HttpPostedFileBase UploadedFile, FormCollection form)
{
// parse incoming form
int SampleTestID = Int32.Parse(form["SampleTestID"]);
String TestTubeNumber = form["TestTubeNumber"];
String AssayID = form["AssayID"];
if (UploadedFile != null)
{
if (UploadedFile.ContentLength > 0)
{
if (Path.GetExtension(UploadedFile.FileName) == ".txt")
{
String reportType = form["ReportType"];
string fileName = "";
if (reportType == "Qual")
{
fileName = TestTubeNumber + "-" + "AssayNo_" + AssayID + "-Qual-" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-ffff") + ".txt";
}
else if (reportType == "Quant")
{
fileName = TestTubeNumber + "-" + "AssayNo_" + AssayID + "-Quant-" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-ffff") + ".txt";
}
string folderPath = Path.Combine(Server.MapPath("~/UploadedFiles/txt"), fileName);
// save path to server
SampleTest st = db.SampleTests.Find(SampleTestID);
if (reportType == "Qual")
{
st.QualResultsPath = folderPath;
}
else if (reportType == "Quant")
{
st.QuantResultsPath = folderPath;
}
db.Entry(st).State = EntityState.Modified;
db.SaveChanges();
UploadedFile.SaveAs(folderPath);
ViewBag.Message = "File Uploaded Successfully.";
// done saving to folder
return(RedirectToAction("FileUploadSuccess", "Assays", new { AssayID = st.AssayID }));
}
else
{
ViewBag.Message = "Extension not supported.";
}
}
}
else
{
ViewBag.Message = "File not selected.";
}
return(View());
}
public int InsertWithDynamicParametersAndReturnValueOutPutParameter(SampleTest obj)
{
string ReturnValue = "ReturnValue";
DynamicParameters param = new DynamicParameters();
param.Add("@Name", obj.Name);
param.Add("@CreatedBy", obj.CreatedBy);
param.Add("@ReturnValue", dbType: DbType.Int32, direction: ParameterDirection.Output);
return(QueryExecutor.ExecuteWithReturnValue <int>(StoreProcedures.spInsertSampleTest.ToString(), ReturnValue, param));
}
static void Main(string[] args)
{
int[] testData = new int[] { 4, 1, 5, 6, 2 };
SampleTest.GetNumber(testData);
int n = 213;
string result1 = GetSibling.GetSiblingThroughString(n).ToString();
string result2 = GetSibling.GetSiblingWithoutConverting(n).ToString();
int[] trees = new int[] { 5, 5, 5, 7, 7, 7 };
TreesInForest.GetWidestPath(trees);
}
public ActionResult Edit([Bind(Include = "Id,SampleId,TestId,Notes,Active")] SampleTest sampleTest)
{
if (ModelState.IsValid)
{
db.Entry(sampleTest).State = EntityState.Modified;
db.SaveChanges();
return(Redirect("/Samples/Details/" + sampleTest.SampleId));
}
ViewBag.SampleId = new SelectList(db.Samples, "SampleId", "SampleId", sampleTest.SampleId);
ViewBag.TestId = new SelectList(db.Tests, "TestId", "TestName", sampleTest.TestId);
return(View(sampleTest));
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SampleTest sampleTest = db.SampleTests.Find(id);
if (sampleTest == null)
{
return(HttpNotFound());
}
return(View(sampleTest));
}
public List <SampleTest> GetReadDataTableToList()
{
var result = new List <SampleTest>();
var dt = QueryExecutor.GetDataTable(SQLs.GetSampleTest.ToString(), null, CommandType.Text);
for (int i = 0; i < dt.Rows.Count; i++)
{
var be = new SampleTest();
be.SampleTestId = Convert.ToInt32(dt.Rows[i]["SampleTestId"]);
be.Name = Convert.ToString(dt.Rows[i]["Name"]);
be.CreatedBy = Convert.ToString(dt.Rows[i]["CreatedBy"]);
result.Add(be);
}
return(result);
}
void Start()
{
instance = this;
cube.OneselfName("cube");
this.BuZhouTiShi("1111111请点击cube,请点击cube");
playerPos.StartMoves(0, 2f, 1).OnComplete(() =>
{
cube.OnHightligher().AddClickedObj(clickedObj).SetClick(CubeClicked);
});
btn.SetUIClick((ff) => { Debug.Log(ff.name); Debug.Log("点击的是世界Button"); });
btn.OnUIHightligher();
this.SetDelay(3, () => btn.OffUIHightligher());
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SampleTest sampleTest = db.SampleTests.Find(id);
if (sampleTest == null)
{
return(HttpNotFound());
}
ViewBag.SampleId = new SelectList(db.Samples, "SampleId", "SampleId", sampleTest.SampleId);
ViewBag.TestId = new SelectList(db.Tests, "TestId", "TestName", sampleTest.TestId);
return(View(sampleTest));
}
public TestResultsListViewModel(SampleTest sampleTest) : base(c => c
.StaticFilter(e => e.SampleTestId == sampleTest.Id)
.Column()
.Header("{Selected}")
//.Content(s => s.SampleTest.ResultId == s.Id)
.Icon(s => (s.SampleTest.ResultId == s.Id) ? "Icons/Conformity/Selected" : "Icons/Conformity/NotSelected", 20)
.Width(70)
.Column()
.Header("{Name}")
.Link(s => s.Name)
.Width(70)
.Column()
.Header("{Start}")
.Link(s => s.Start)
.Width(100)//.OrderByOrder(0)
.Column()
.Header("{End}")
.Link(s => s.End)
.Width(100)
.Column()
.Header("{Result}")
.Link(s => s.Result)
.Width(80)
.ConformityColumn(s => s.ConformityId)
.StageColumn(default(SampleTestResultWorkflow), s => s.StageId)
.Column()
.Hidden()
.Id("IsSelected")
.Content(s => s.Id == s.SampleTest.Result?.Id)
.Column()
.Hidden()
.Id("IsValid")
.Content(s => s.Stage != SampleTestResultWorkflow.Invalidated)
)
{
_sampleTest = sampleTest;
}
public ActionResult UploadResults(int?SampleTestID, String reportType)
{
SampleTest st = db.SampleTests.Find(SampleTestID);
ViewBag.SampleTestID = SampleTestID;
ViewBag.TestTubeNumber = (st.LTNumber.ToString() + "-" + st.CompoundSeqCode.ToString());
ViewBag.AssayID = st.AssayID.ToString();
if (reportType == "Qual")
{
ViewBag.Type = "Qualitative";
}
else if (reportType == "Quant")
{
ViewBag.Type = "Quantitative";
}
return(View());
}
public void Test4()
{
var testCase = new int[] { 2 };
Assert.That(SampleTest.solution(testCase) == 1);
}
public void Test2()
{
var testCase = new int[] { 1, 2, 3 };
Assert.That(SampleTest.solution(testCase) == 4);
}
public void Test1()
{
var testCase = new int[] { 1, 3, 6, 4, 1, 2 };
Assert.That(SampleTest.solution(testCase) == 5);
}
private void Do()
{
SampleTest test = new SampleTest(organizationServiceMock.Object);
test.TestSample();
}
public int UpdateWithParameters(SampleTest obj)
{
return(QueryExecutor.Execute(StoreProcedures.spUpdateSampleTest.ToString(), new { SampleTestId = obj.SampleTestId, Name = obj.Name, Address = obj.CreatedBy }));
}
public int Update(SampleTest obj)
{
return(QueryExecutor.Execute(StoreProcedures.sp_UpdateSampleTestName.ToString(), new { obj.SampleTestId, obj.Name, obj.CreatedBy }));
}
public int Insert(SampleTest obj)
{
return(QueryExecutor.Execute(StoreProcedures.sp_InsertSampleTestName.ToString(), new { obj.Name, obj.CreatedBy }));
}
