private string DoesLabSheetExist()
{
int tempInt = -1;
string SamplingPlanName = "";
int Year = -1;
int Month = -1;
int Day = -1;
int RunNumber = -1;
int SubsectorTVItemID = -1;
DateTime SampleDate_Local = new DateTime(2050, 1, 1);
SamplingPlanTypeEnum SamplingPlanType = SamplingPlanTypeEnum.Error;
SampleTypeEnum SampleType = SampleTypeEnum.Error;
LabSheetTypeEnum LabSheetType = LabSheetTypeEnum.Error;
DateTime FileLastModifiedDate_Local = new DateTime(2050, 1, 1);
SamplingPlanName = Request.Params["SamplingPlanName"];
if (string.IsNullOrWhiteSpace(SamplingPlanName))
{
return(string.Format(LabSheetViewRes._IsRequired, "SamplingPlanName"));
}
int.TryParse(Request.Params["Year"], out Year);
if (Year == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "Year"));
}
int.TryParse(Request.Params["Month"], out Month);
if (Month == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "Month"));
}
int.TryParse(Request.Params["Day"], out Day);
if (Day == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "Day"));
}
int.TryParse(Request.Params["RunNumber"], out RunNumber);
if (RunNumber == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "RunNumber"));
}
int.TryParse(Request.Params["SubsectorTVItemID"], out SubsectorTVItemID);
if (SubsectorTVItemID == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "SubsectorTVItemID"));
}
int.TryParse(Request.Params["SamplingPlanType"], out tempInt);
if (tempInt == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "SamplingPlanType"));
}
SamplingPlanType = (SamplingPlanTypeEnum)tempInt;
int.TryParse(Request.Params["SampleType"], out tempInt);
if (tempInt == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "SampleType"));
}
SampleType = (SampleTypeEnum)tempInt;
int.TryParse(Request.Params["LabSheetType"], out tempInt);
if (tempInt == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "LabSheetType"));
}
LabSheetType = (LabSheetTypeEnum)tempInt;
using (CSSPEntities db = new CSSPEntities())
{
LabSheet labSheet = (from c in db.LabSheets
where c.SamplingPlanName == SamplingPlanName &&
c.Year == Year &&
c.Month == Month &&
c.Day == Day &&
c.RunNumber == RunNumber &&
c.SubsectorTVItemID == SubsectorTVItemID &&
c.SamplingPlanType == (int)SamplingPlanType &&
c.SampleType == (int)SampleType &&
c.LabSheetType == (int)LabSheetType
select c).FirstOrDefault();
if (labSheet == null)
{
return("[" + ((int)LabSheetStatusEnum.Error).ToString() + "]");
}
else
{
return("[" + labSheet.LabSheetStatus.ToString() + "]");
}
}
}
public void LabSheetExtraB_Every_Property_Has_Get_Set_Test()
{
string val1 = "Some text";
labSheetExtraB.LabSheetReportTest = val1;
Assert.AreEqual(val1, labSheetExtraB.LabSheetReportTest);
string val2 = "Some text";
labSheetExtraB.SubsectorText = val2;
Assert.AreEqual(val2, labSheetExtraB.SubsectorText);
string val3 = "Some text";
labSheetExtraB.MWQMRunText = val3;
Assert.AreEqual(val3, labSheetExtraB.MWQMRunText);
string val4 = "Some text";
labSheetExtraB.AcceptedOrRejectedByContactName = val4;
Assert.AreEqual(val4, labSheetExtraB.AcceptedOrRejectedByContactName);
string val5 = "Some text";
labSheetExtraB.LastUpdateContactText = val5;
Assert.AreEqual(val5, labSheetExtraB.LastUpdateContactText);
string val6 = "Some text";
labSheetExtraB.SamplingPlanTypeText = val6;
Assert.AreEqual(val6, labSheetExtraB.SamplingPlanTypeText);
string val7 = "Some text";
labSheetExtraB.SampleTypeText = val7;
Assert.AreEqual(val7, labSheetExtraB.SampleTypeText);
string val8 = "Some text";
labSheetExtraB.LabSheetTypeText = val8;
Assert.AreEqual(val8, labSheetExtraB.LabSheetTypeText);
string val9 = "Some text";
labSheetExtraB.LabSheetStatusText = val9;
Assert.AreEqual(val9, labSheetExtraB.LabSheetStatusText);
int val10 = 45;
labSheetExtraB.LabSheetID = val10;
Assert.AreEqual(val10, labSheetExtraB.LabSheetID);
int val11 = 45;
labSheetExtraB.OtherServerLabSheetID = val11;
Assert.AreEqual(val11, labSheetExtraB.OtherServerLabSheetID);
int val12 = 45;
labSheetExtraB.SamplingPlanID = val12;
Assert.AreEqual(val12, labSheetExtraB.SamplingPlanID);
string val13 = "Some text";
labSheetExtraB.SamplingPlanName = val13;
Assert.AreEqual(val13, labSheetExtraB.SamplingPlanName);
int val14 = 45;
labSheetExtraB.Year = val14;
Assert.AreEqual(val14, labSheetExtraB.Year);
int val15 = 45;
labSheetExtraB.Month = val15;
Assert.AreEqual(val15, labSheetExtraB.Month);
int val16 = 45;
labSheetExtraB.Day = val16;
Assert.AreEqual(val16, labSheetExtraB.Day);
int val17 = 45;
labSheetExtraB.RunNumber = val17;
Assert.AreEqual(val17, labSheetExtraB.RunNumber);
int val18 = 45;
labSheetExtraB.SubsectorTVItemID = val18;
Assert.AreEqual(val18, labSheetExtraB.SubsectorTVItemID);
int val19 = 45;
labSheetExtraB.MWQMRunTVItemID = val19;
Assert.AreEqual(val19, labSheetExtraB.MWQMRunTVItemID);
SamplingPlanTypeEnum val20 = (SamplingPlanTypeEnum)3;
labSheetExtraB.SamplingPlanType = val20;
Assert.AreEqual(val20, labSheetExtraB.SamplingPlanType);
SampleTypeEnum val21 = (SampleTypeEnum)3;
labSheetExtraB.SampleType = val21;
Assert.AreEqual(val21, labSheetExtraB.SampleType);
LabSheetTypeEnum val22 = (LabSheetTypeEnum)3;
labSheetExtraB.LabSheetType = val22;
Assert.AreEqual(val22, labSheetExtraB.LabSheetType);
LabSheetStatusEnum val23 = (LabSheetStatusEnum)3;
labSheetExtraB.LabSheetStatus = val23;
Assert.AreEqual(val23, labSheetExtraB.LabSheetStatus);
string val24 = "Some text";
labSheetExtraB.FileName = val24;
Assert.AreEqual(val24, labSheetExtraB.FileName);
DateTime val25 = new DateTime(2010, 3, 4);
labSheetExtraB.FileLastModifiedDate_Local = val25;
Assert.AreEqual(val25, labSheetExtraB.FileLastModifiedDate_Local);
string val26 = "Some text";
labSheetExtraB.FileContent = val26;
Assert.AreEqual(val26, labSheetExtraB.FileContent);
int val27 = 45;
labSheetExtraB.AcceptedOrRejectedByContactTVItemID = val27;
Assert.AreEqual(val27, labSheetExtraB.AcceptedOrRejectedByContactTVItemID);
DateTime val28 = new DateTime(2010, 3, 4);
labSheetExtraB.AcceptedOrRejectedDateTime = val28;
Assert.AreEqual(val28, labSheetExtraB.AcceptedOrRejectedDateTime);
string val29 = "Some text";
labSheetExtraB.RejectReason = val29;
Assert.AreEqual(val29, labSheetExtraB.RejectReason);
DateTime val30 = new DateTime(2010, 3, 4);
labSheetExtraB.LastUpdateDate_UTC = val30;
Assert.AreEqual(val30, labSheetExtraB.LastUpdateDate_UTC);
int val31 = 45;
labSheetExtraB.LastUpdateContactTVItemID = val31;
Assert.AreEqual(val31, labSheetExtraB.LastUpdateContactTVItemID);
bool val32 = true;
labSheetExtraB.HasErrors = val32;
Assert.AreEqual(val32, labSheetExtraB.HasErrors);
IEnumerable <ValidationResult> val99 = new List <ValidationResult>()
{
new ValidationResult("First CSSPError Message")
}.AsEnumerable();
labSheetExtraB.ValidationResults = val99;
Assert.AreEqual(val99, labSheetExtraB.ValidationResults);
}
public void LabSheetA1Sheet_Every_Property_Has_Get_Set_Test()
{
int val1 = 45;
labSheetA1Sheet.Version = val1;
Assert.AreEqual(val1, labSheetA1Sheet.Version);
SamplingPlanTypeEnum val2 = (SamplingPlanTypeEnum)3;
labSheetA1Sheet.SamplingPlanType = val2;
Assert.AreEqual(val2, labSheetA1Sheet.SamplingPlanType);
SampleTypeEnum val3 = (SampleTypeEnum)3;
labSheetA1Sheet.SampleType = val3;
Assert.AreEqual(val3, labSheetA1Sheet.SampleType);
LabSheetTypeEnum val4 = (LabSheetTypeEnum)3;
labSheetA1Sheet.LabSheetType = val4;
Assert.AreEqual(val4, labSheetA1Sheet.LabSheetType);
string val5 = "Some text";
labSheetA1Sheet.SubsectorName = val5;
Assert.AreEqual(val5, labSheetA1Sheet.SubsectorName);
string val6 = "Some text";
labSheetA1Sheet.SubsectorLocation = val6;
Assert.AreEqual(val6, labSheetA1Sheet.SubsectorLocation);
int val7 = 45;
labSheetA1Sheet.SubsectorTVItemID = val7;
Assert.AreEqual(val7, labSheetA1Sheet.SubsectorTVItemID);
string val8 = "Some text";
labSheetA1Sheet.RunYear = val8;
Assert.AreEqual(val8, labSheetA1Sheet.RunYear);
string val9 = "Some text";
labSheetA1Sheet.RunMonth = val9;
Assert.AreEqual(val9, labSheetA1Sheet.RunMonth);
string val10 = "Some text";
labSheetA1Sheet.RunDay = val10;
Assert.AreEqual(val10, labSheetA1Sheet.RunDay);
int val11 = 45;
labSheetA1Sheet.RunNumber = val11;
Assert.AreEqual(val11, labSheetA1Sheet.RunNumber);
string val12 = "Some text";
labSheetA1Sheet.Tides = val12;
Assert.AreEqual(val12, labSheetA1Sheet.Tides);
string val13 = "Some text";
labSheetA1Sheet.SampleCrewInitials = val13;
Assert.AreEqual(val13, labSheetA1Sheet.SampleCrewInitials);
string val14 = "Some text";
labSheetA1Sheet.IncubationStartSameDay = val14;
Assert.AreEqual(val14, labSheetA1Sheet.IncubationStartSameDay);
int val15 = 45;
labSheetA1Sheet.WaterBathCount = val15;
Assert.AreEqual(val15, labSheetA1Sheet.WaterBathCount);
string val16 = "Some text";
labSheetA1Sheet.IncubationBath1StartTime = val16;
Assert.AreEqual(val16, labSheetA1Sheet.IncubationBath1StartTime);
string val17 = "Some text";
labSheetA1Sheet.IncubationBath2StartTime = val17;
Assert.AreEqual(val17, labSheetA1Sheet.IncubationBath2StartTime);
string val18 = "Some text";
labSheetA1Sheet.IncubationBath3StartTime = val18;
Assert.AreEqual(val18, labSheetA1Sheet.IncubationBath3StartTime);
string val19 = "Some text";
labSheetA1Sheet.IncubationBath1EndTime = val19;
Assert.AreEqual(val19, labSheetA1Sheet.IncubationBath1EndTime);
string val20 = "Some text";
labSheetA1Sheet.IncubationBath2EndTime = val20;
Assert.AreEqual(val20, labSheetA1Sheet.IncubationBath2EndTime);
string val21 = "Some text";
labSheetA1Sheet.IncubationBath3EndTime = val21;
Assert.AreEqual(val21, labSheetA1Sheet.IncubationBath3EndTime);
string val22 = "Some text";
labSheetA1Sheet.IncubationBath1TimeCalculated = val22;
Assert.AreEqual(val22, labSheetA1Sheet.IncubationBath1TimeCalculated);
string val23 = "Some text";
labSheetA1Sheet.IncubationBath2TimeCalculated = val23;
Assert.AreEqual(val23, labSheetA1Sheet.IncubationBath2TimeCalculated);
string val24 = "Some text";
labSheetA1Sheet.IncubationBath3TimeCalculated = val24;
Assert.AreEqual(val24, labSheetA1Sheet.IncubationBath3TimeCalculated);
string val25 = "Some text";
labSheetA1Sheet.WaterBath1 = val25;
Assert.AreEqual(val25, labSheetA1Sheet.WaterBath1);
string val26 = "Some text";
labSheetA1Sheet.WaterBath2 = val26;
Assert.AreEqual(val26, labSheetA1Sheet.WaterBath2);
string val27 = "Some text";
labSheetA1Sheet.WaterBath3 = val27;
Assert.AreEqual(val27, labSheetA1Sheet.WaterBath3);
string val28 = "Some text";
labSheetA1Sheet.TCField1 = val28;
Assert.AreEqual(val28, labSheetA1Sheet.TCField1);
string val29 = "Some text";
labSheetA1Sheet.TCLab1 = val29;
Assert.AreEqual(val29, labSheetA1Sheet.TCLab1);
string val30 = "Some text";
labSheetA1Sheet.TCHas2Coolers = val30;
Assert.AreEqual(val30, labSheetA1Sheet.TCHas2Coolers);
string val31 = "Some text";
labSheetA1Sheet.TCField2 = val31;
Assert.AreEqual(val31, labSheetA1Sheet.TCField2);
string val32 = "Some text";
labSheetA1Sheet.TCLab2 = val32;
Assert.AreEqual(val32, labSheetA1Sheet.TCLab2);
string val33 = "Some text";
labSheetA1Sheet.TCFirst = val33;
Assert.AreEqual(val33, labSheetA1Sheet.TCFirst);
string val34 = "Some text";
labSheetA1Sheet.TCAverage = val34;
Assert.AreEqual(val34, labSheetA1Sheet.TCAverage);
string val35 = "Some text";
labSheetA1Sheet.ControlLot = val35;
Assert.AreEqual(val35, labSheetA1Sheet.ControlLot);
string val36 = "Some text";
labSheetA1Sheet.Positive35 = val36;
Assert.AreEqual(val36, labSheetA1Sheet.Positive35);
string val37 = "Some text";
labSheetA1Sheet.NonTarget35 = val37;
Assert.AreEqual(val37, labSheetA1Sheet.NonTarget35);
string val38 = "Some text";
labSheetA1Sheet.Negative35 = val38;
Assert.AreEqual(val38, labSheetA1Sheet.Negative35);
string val39 = "Some text";
labSheetA1Sheet.Bath1Positive44_5 = val39;
Assert.AreEqual(val39, labSheetA1Sheet.Bath1Positive44_5);
string val40 = "Some text";
labSheetA1Sheet.Bath2Positive44_5 = val40;
Assert.AreEqual(val40, labSheetA1Sheet.Bath2Positive44_5);
string val41 = "Some text";
labSheetA1Sheet.Bath3Positive44_5 = val41;
Assert.AreEqual(val41, labSheetA1Sheet.Bath3Positive44_5);
string val42 = "Some text";
labSheetA1Sheet.Bath1NonTarget44_5 = val42;
Assert.AreEqual(val42, labSheetA1Sheet.Bath1NonTarget44_5);
string val43 = "Some text";
labSheetA1Sheet.Bath2NonTarget44_5 = val43;
Assert.AreEqual(val43, labSheetA1Sheet.Bath2NonTarget44_5);
string val44 = "Some text";
labSheetA1Sheet.Bath3NonTarget44_5 = val44;
Assert.AreEqual(val44, labSheetA1Sheet.Bath3NonTarget44_5);
string val45 = "Some text";
labSheetA1Sheet.Bath1Negative44_5 = val45;
Assert.AreEqual(val45, labSheetA1Sheet.Bath1Negative44_5);
string val46 = "Some text";
labSheetA1Sheet.Bath2Negative44_5 = val46;
Assert.AreEqual(val46, labSheetA1Sheet.Bath2Negative44_5);
string val47 = "Some text";
labSheetA1Sheet.Bath3Negative44_5 = val47;
Assert.AreEqual(val47, labSheetA1Sheet.Bath3Negative44_5);
string val48 = "Some text";
labSheetA1Sheet.Blank35 = val48;
Assert.AreEqual(val48, labSheetA1Sheet.Blank35);
string val49 = "Some text";
labSheetA1Sheet.Bath1Blank44_5 = val49;
Assert.AreEqual(val49, labSheetA1Sheet.Bath1Blank44_5);
string val50 = "Some text";
labSheetA1Sheet.Bath2Blank44_5 = val50;
Assert.AreEqual(val50, labSheetA1Sheet.Bath2Blank44_5);
string val51 = "Some text";
labSheetA1Sheet.Bath3Blank44_5 = val51;
Assert.AreEqual(val51, labSheetA1Sheet.Bath3Blank44_5);
string val52 = "Some text";
labSheetA1Sheet.Lot35 = val52;
Assert.AreEqual(val52, labSheetA1Sheet.Lot35);
string val53 = "Some text";
labSheetA1Sheet.Lot44_5 = val53;
Assert.AreEqual(val53, labSheetA1Sheet.Lot44_5);
string val54 = "Some text";
labSheetA1Sheet.RunComment = val54;
Assert.AreEqual(val54, labSheetA1Sheet.RunComment);
string val55 = "Some text";
labSheetA1Sheet.RunWeatherComment = val55;
Assert.AreEqual(val55, labSheetA1Sheet.RunWeatherComment);
string val56 = "Some text";
labSheetA1Sheet.SampleBottleLotNumber = val56;
Assert.AreEqual(val56, labSheetA1Sheet.SampleBottleLotNumber);
string val57 = "Some text";
labSheetA1Sheet.SalinitiesReadBy = val57;
Assert.AreEqual(val57, labSheetA1Sheet.SalinitiesReadBy);
string val58 = "Some text";
labSheetA1Sheet.SalinitiesReadYear = val58;
Assert.AreEqual(val58, labSheetA1Sheet.SalinitiesReadYear);
string val59 = "Some text";
labSheetA1Sheet.SalinitiesReadMonth = val59;
Assert.AreEqual(val59, labSheetA1Sheet.SalinitiesReadMonth);
string val60 = "Some text";
labSheetA1Sheet.SalinitiesReadDay = val60;
Assert.AreEqual(val60, labSheetA1Sheet.SalinitiesReadDay);
string val61 = "Some text";
labSheetA1Sheet.ResultsReadBy = val61;
Assert.AreEqual(val61, labSheetA1Sheet.ResultsReadBy);
string val62 = "Some text";
labSheetA1Sheet.ResultsReadYear = val62;
Assert.AreEqual(val62, labSheetA1Sheet.ResultsReadYear);
string val63 = "Some text";
labSheetA1Sheet.ResultsReadMonth = val63;
Assert.AreEqual(val63, labSheetA1Sheet.ResultsReadMonth);
string val64 = "Some text";
labSheetA1Sheet.ResultsReadDay = val64;
Assert.AreEqual(val64, labSheetA1Sheet.ResultsReadDay);
string val65 = "Some text";
labSheetA1Sheet.ResultsRecordedBy = val65;
Assert.AreEqual(val65, labSheetA1Sheet.ResultsRecordedBy);
string val66 = "Some text";
labSheetA1Sheet.ResultsRecordedYear = val66;
Assert.AreEqual(val66, labSheetA1Sheet.ResultsRecordedYear);
string val67 = "Some text";
labSheetA1Sheet.ResultsRecordedMonth = val67;
Assert.AreEqual(val67, labSheetA1Sheet.ResultsRecordedMonth);
string val68 = "Some text";
labSheetA1Sheet.ResultsRecordedDay = val68;
Assert.AreEqual(val68, labSheetA1Sheet.ResultsRecordedDay);
string val69 = "Some text";
labSheetA1Sheet.DailyDuplicateRLog = val69;
Assert.AreEqual(val69, labSheetA1Sheet.DailyDuplicateRLog);
string val70 = "Some text";
labSheetA1Sheet.DailyDuplicatePrecisionCriteria = val70;
Assert.AreEqual(val70, labSheetA1Sheet.DailyDuplicatePrecisionCriteria);
string val71 = "Some text";
labSheetA1Sheet.DailyDuplicateAcceptableOrUnacceptable = val71;
Assert.AreEqual(val71, labSheetA1Sheet.DailyDuplicateAcceptableOrUnacceptable);
string val72 = "Some text";
labSheetA1Sheet.IntertechDuplicateRLog = val72;
Assert.AreEqual(val72, labSheetA1Sheet.IntertechDuplicateRLog);
string val73 = "Some text";
labSheetA1Sheet.IntertechDuplicatePrecisionCriteria = val73;
Assert.AreEqual(val73, labSheetA1Sheet.IntertechDuplicatePrecisionCriteria);
string val74 = "Some text";
labSheetA1Sheet.IntertechDuplicateAcceptableOrUnacceptable = val74;
Assert.AreEqual(val74, labSheetA1Sheet.IntertechDuplicateAcceptableOrUnacceptable);
string val75 = "Some text";
labSheetA1Sheet.IntertechReadAcceptableOrUnacceptable = val75;
Assert.AreEqual(val75, labSheetA1Sheet.IntertechReadAcceptableOrUnacceptable);
string val76 = "Some text";
labSheetA1Sheet.ApprovalYear = val76;
Assert.AreEqual(val76, labSheetA1Sheet.ApprovalYear);
string val77 = "Some text";
labSheetA1Sheet.ApprovalMonth = val77;
Assert.AreEqual(val77, labSheetA1Sheet.ApprovalMonth);
string val78 = "Some text";
labSheetA1Sheet.ApprovalDay = val78;
Assert.AreEqual(val78, labSheetA1Sheet.ApprovalDay);
string val79 = "Some text";
labSheetA1Sheet.ApprovedBySupervisorInitials = val79;
Assert.AreEqual(val79, labSheetA1Sheet.ApprovedBySupervisorInitials);
bool val80 = true;
labSheetA1Sheet.IncludeLaboratoryQAQC = val80;
Assert.AreEqual(val80, labSheetA1Sheet.IncludeLaboratoryQAQC);
string val81 = "Some text";
labSheetA1Sheet.BackupDirectory = val81;
Assert.AreEqual(val81, labSheetA1Sheet.BackupDirectory);
string val82 = "Some text";
labSheetA1Sheet.Log = val82;
Assert.AreEqual(val82, labSheetA1Sheet.Log);
string val83 = "Some text";
labSheetA1Sheet.SamplingPlanTypeText = val83;
Assert.AreEqual(val83, labSheetA1Sheet.SamplingPlanTypeText);
string val84 = "Some text";
labSheetA1Sheet.SampleTypeText = val84;
Assert.AreEqual(val84, labSheetA1Sheet.SampleTypeText);
string val85 = "Some text";
labSheetA1Sheet.LabSheetTypeText = val85;
Assert.AreEqual(val85, labSheetA1Sheet.LabSheetTypeText);
List <LabSheetA1Measurement> val86 = new List <LabSheetA1Measurement>()
{
new LabSheetA1Measurement(), new LabSheetA1Measurement()
};
labSheetA1Sheet.LabSheetA1MeasurementList = val86;
Assert.AreEqual(val86, labSheetA1Sheet.LabSheetA1MeasurementList);
bool val87 = true;
labSheetA1Sheet.HasErrors = val87;
Assert.AreEqual(val87, labSheetA1Sheet.HasErrors);
IEnumerable <ValidationResult> val264 = new List <ValidationResult>()
{
new ValidationResult("First CSSPError Message")
}.AsEnumerable();
labSheetA1Sheet.ValidationResults = val264;
Assert.AreEqual(val264, labSheetA1Sheet.ValidationResults);
}
public void SamplingPlanExtraB_Every_Property_Has_Get_Set_Test()
{
string val1 = "Some text";
samplingPlanExtraB.SamplingPlanReportTest = val1;
Assert.AreEqual(val1, samplingPlanExtraB.SamplingPlanReportTest);
string val2 = "Some text";
samplingPlanExtraB.ProvinceText = val2;
Assert.AreEqual(val2, samplingPlanExtraB.ProvinceText);
string val3 = "Some text";
samplingPlanExtraB.CreatorName = val3;
Assert.AreEqual(val3, samplingPlanExtraB.CreatorName);
string val4 = "Some text";
samplingPlanExtraB.SamplingPlanFileName = val4;
Assert.AreEqual(val4, samplingPlanExtraB.SamplingPlanFileName);
string val5 = "Some text";
samplingPlanExtraB.LastUpdateContactText = val5;
Assert.AreEqual(val5, samplingPlanExtraB.LastUpdateContactText);
string val6 = "Some text";
samplingPlanExtraB.SampleTypeText = val6;
Assert.AreEqual(val6, samplingPlanExtraB.SampleTypeText);
string val7 = "Some text";
samplingPlanExtraB.SamplingPlanTypeText = val7;
Assert.AreEqual(val7, samplingPlanExtraB.SamplingPlanTypeText);
string val8 = "Some text";
samplingPlanExtraB.LabSheetTypeText = val8;
Assert.AreEqual(val8, samplingPlanExtraB.LabSheetTypeText);
int val9 = 45;
samplingPlanExtraB.SamplingPlanID = val9;
Assert.AreEqual(val9, samplingPlanExtraB.SamplingPlanID);
bool val10 = true;
samplingPlanExtraB.IsActive = val10;
Assert.AreEqual(val10, samplingPlanExtraB.IsActive);
string val11 = "Some text";
samplingPlanExtraB.SamplingPlanName = val11;
Assert.AreEqual(val11, samplingPlanExtraB.SamplingPlanName);
string val12 = "Some text";
samplingPlanExtraB.ForGroupName = val12;
Assert.AreEqual(val12, samplingPlanExtraB.ForGroupName);
SampleTypeEnum val13 = (SampleTypeEnum)3;
samplingPlanExtraB.SampleType = val13;
Assert.AreEqual(val13, samplingPlanExtraB.SampleType);
SamplingPlanTypeEnum val14 = (SamplingPlanTypeEnum)3;
samplingPlanExtraB.SamplingPlanType = val14;
Assert.AreEqual(val14, samplingPlanExtraB.SamplingPlanType);
LabSheetTypeEnum val15 = (LabSheetTypeEnum)3;
samplingPlanExtraB.LabSheetType = val15;
Assert.AreEqual(val15, samplingPlanExtraB.LabSheetType);
int val16 = 45;
samplingPlanExtraB.ProvinceTVItemID = val16;
Assert.AreEqual(val16, samplingPlanExtraB.ProvinceTVItemID);
int val17 = 45;
samplingPlanExtraB.CreatorTVItemID = val17;
Assert.AreEqual(val17, samplingPlanExtraB.CreatorTVItemID);
int val18 = 45;
samplingPlanExtraB.Year = val18;
Assert.AreEqual(val18, samplingPlanExtraB.Year);
string val19 = "Some text";
samplingPlanExtraB.AccessCode = val19;
Assert.AreEqual(val19, samplingPlanExtraB.AccessCode);
double val20 = 87.9D;
samplingPlanExtraB.DailyDuplicatePrecisionCriteria = val20;
Assert.AreEqual(val20, samplingPlanExtraB.DailyDuplicatePrecisionCriteria);
double val21 = 87.9D;
samplingPlanExtraB.IntertechDuplicatePrecisionCriteria = val21;
Assert.AreEqual(val21, samplingPlanExtraB.IntertechDuplicatePrecisionCriteria);
bool val22 = true;
samplingPlanExtraB.IncludeLaboratoryQAQC = val22;
Assert.AreEqual(val22, samplingPlanExtraB.IncludeLaboratoryQAQC);
string val23 = "Some text";
samplingPlanExtraB.ApprovalCode = val23;
Assert.AreEqual(val23, samplingPlanExtraB.ApprovalCode);
int val24 = 45;
samplingPlanExtraB.SamplingPlanFileTVItemID = val24;
Assert.AreEqual(val24, samplingPlanExtraB.SamplingPlanFileTVItemID);
AnalyzeMethodEnum val25 = (AnalyzeMethodEnum)3;
samplingPlanExtraB.AnalyzeMethodDefault = val25;
Assert.AreEqual(val25, samplingPlanExtraB.AnalyzeMethodDefault);
SampleMatrixEnum val26 = (SampleMatrixEnum)3;
samplingPlanExtraB.SampleMatrixDefault = val26;
Assert.AreEqual(val26, samplingPlanExtraB.SampleMatrixDefault);
LaboratoryEnum val27 = (LaboratoryEnum)3;
samplingPlanExtraB.LaboratoryDefault = val27;
Assert.AreEqual(val27, samplingPlanExtraB.LaboratoryDefault);
string val28 = "Some text";
samplingPlanExtraB.BackupDirectory = val28;
Assert.AreEqual(val28, samplingPlanExtraB.BackupDirectory);
DateTime val29 = new DateTime(2010, 3, 4);
samplingPlanExtraB.LastUpdateDate_UTC = val29;
Assert.AreEqual(val29, samplingPlanExtraB.LastUpdateDate_UTC);
int val30 = 45;
samplingPlanExtraB.LastUpdateContactTVItemID = val30;
Assert.AreEqual(val30, samplingPlanExtraB.LastUpdateContactTVItemID);
bool val31 = true;
samplingPlanExtraB.HasErrors = val31;
Assert.AreEqual(val31, samplingPlanExtraB.HasErrors);
IEnumerable <ValidationResult> val96 = new List <ValidationResult>()
{
new ValidationResult("First CSSPError Message")
}.AsEnumerable();
samplingPlanExtraB.ValidationResults = val96;
Assert.AreEqual(val96, samplingPlanExtraB.ValidationResults);
}
private string GetterLabSheetAcceptedOrRejectedBy()
{
int tempInt = -1;
string SamplingPlanName = "";
int Year = -1;
int Month = -1;
int Day = -1;
int RunNumber = -1;
int SubsectorTVItemID = -1;
DateTime SampleDate_Local = new DateTime(2050, 1, 1);
SamplingPlanTypeEnum SamplingPlanType = SamplingPlanTypeEnum.Error;
SampleTypeEnum SampleType = SampleTypeEnum.Error;
LabSheetTypeEnum LabSheetType = LabSheetTypeEnum.Error;
DateTime FileLastModifiedDate_Local = new DateTime(2050, 1, 1);
StringBuilder sb = new StringBuilder();
SamplingPlanName = Request.Params["SamplingPlanName"];
if (string.IsNullOrWhiteSpace(SamplingPlanName))
{
return(string.Format(LabSheetViewRes._IsRequired, "SamplingPlanName"));
}
int.TryParse(Request.Params["Year"], out Year);
if (Year == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "Year"));
}
int.TryParse(Request.Params["Month"], out Month);
if (Month == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "Month"));
}
int.TryParse(Request.Params["Day"], out Day);
if (Day == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "Day"));
}
int.TryParse(Request.Params["RunNumber"], out RunNumber);
if (RunNumber == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "RunNumber"));
}
int.TryParse(Request.Params["SubsectorTVItemID"], out SubsectorTVItemID);
if (SubsectorTVItemID == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "SubsectorTVItemID"));
}
int.TryParse(Request.Params["SamplingPlanType"], out tempInt);
if (tempInt == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "SamplingPlanType"));
}
SamplingPlanType = (SamplingPlanTypeEnum)tempInt;
int.TryParse(Request.Params["SampleType"], out tempInt);
if (tempInt == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "SampleType"));
}
SampleType = (SampleTypeEnum)tempInt;
int.TryParse(Request.Params["LabSheetType"], out tempInt);
if (tempInt == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "LabSheetType"));
}
LabSheetType = (LabSheetTypeEnum)tempInt;
using (CSSPEntities db = new CSSPEntities())
{
LabSheet labSheet = (from c in db.LabSheets
where c.SamplingPlanName == SamplingPlanName &&
c.Year == Year &&
c.Month == Month &&
c.Day == Day &&
c.RunNumber == RunNumber &&
c.SubsectorTVItemID == SubsectorTVItemID &&
c.SamplingPlanType == (int)SamplingPlanType &&
c.SampleType == (int)SampleType &&
c.LabSheetType == (int)LabSheetType
select c).FirstOrDefault();
if (labSheet != null)
{
sb.AppendLine("OtherServerLabSheetID|||||[" + labSheet.OtherServerLabSheetID + "]");
sb.AppendLine("AcceptedOrRejectedBy|||||[" + labSheet.AcceptedOrRejectedBy + "]");
sb.AppendLine("Year|||||[" + labSheet.AcceptedOrRejectedDate_Local.Value.Year + "]");
sb.AppendLine("Month|||||[" + labSheet.AcceptedOrRejectedDate_Local.Value.Month + "]");
sb.AppendLine("Day|||||[" + labSheet.AcceptedOrRejectedDate_Local.Value.Day + "]");
sb.AppendLine("Hour|||||[" + labSheet.AcceptedOrRejectedDate_Local.Value.Hour + "]");
sb.AppendLine("Minute|||||[" + labSheet.AcceptedOrRejectedDate_Local.Value.Minute + "]");
sb.AppendLine("RejectReason|||||[" + labSheet.RejectReason + "]");
}
}
return(sb.ToString());
}
private string FillLabSheet()
{
int tempInt = -1;
string SamplingPlanName = "";
int Year = -1;
int Month = -1;
int Day = -1;
int RunNumber = -1;
int SubsectorTVItemID = -1;
SamplingPlanTypeEnum SamplingPlanType = SamplingPlanTypeEnum.Error;
SampleTypeEnum SampleType = SampleTypeEnum.Error;
LabSheetTypeEnum LabSheetType = LabSheetTypeEnum.Error;
string FileName = "";
string FileLastModifiedDate_LocalText = "";
DateTime FileLastModifiedDate_Local = new DateTime(2050, 1, 1);
string FileContent = "";
SamplingPlanName = Request.Params["SamplingPlanName"];
if (string.IsNullOrWhiteSpace(SamplingPlanName))
{
return(string.Format(LabSheetViewRes._IsRequired, "SamplingPlanName"));
}
int.TryParse(Request.Params["Year"], out Year);
if (Year == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "Year"));
}
int.TryParse(Request.Params["Month"], out Month);
if (Month == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "Month"));
}
int.TryParse(Request.Params["Day"], out Day);
if (Day == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "Day"));
}
int.TryParse(Request.Params["RunNumber"], out RunNumber);
if (RunNumber == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "RunNumber"));
}
int.TryParse(Request.Params["SubsectorTVItemID"], out SubsectorTVItemID);
if (SubsectorTVItemID == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "SubsectorTVItemID"));
}
int.TryParse(Request.Params["SamplingPlanType"], out tempInt);
if (tempInt == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "SamplingPlanType"));
}
SamplingPlanType = (SamplingPlanTypeEnum)tempInt;
int.TryParse(Request.Params["SampleType"], out tempInt);
if (tempInt == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "SampleType"));
}
SampleType = (SampleTypeEnum)tempInt;
int.TryParse(Request.Params["LabSheetType"], out tempInt);
if (tempInt == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "LabSheetType"));
}
LabSheetType = (LabSheetTypeEnum)tempInt;
FileName = Request.Params["FileName"];
if (string.IsNullOrWhiteSpace(FileName))
{
return(string.Format(LabSheetViewRes._IsRequired, "FileName"));
}
if (FileName.EndsWith("_S.txt"))
{
return(LabSheetViewRes.OnlyLabSheetEndingWithStxtIsAllowed);
}
FileLastModifiedDate_LocalText = Request.Params["FileLastModifiedDate_Local"];
List <string> stringList = FileLastModifiedDate_LocalText.Split(",".ToCharArray(), StringSplitOptions.None).ToList();
int FileYear = -1;
int.TryParse(stringList[0], out FileYear);
if (FileYear == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "FileLastModifiedDate_Local Year not valid"));
}
int FileMonth = -1;
int.TryParse(stringList[1], out FileMonth);
if (FileMonth == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "FileLastModifiedDate_Local Month not valid"));
}
int FileDay = -1;
int.TryParse(stringList[2], out FileDay);
if (FileDay == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "FileLastModifiedDate_Local Day not valid"));
}
int FileHour = -1;
int.TryParse(stringList[3], out FileHour);
if (FileHour == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "FileLastModifiedDate_Local Hour not valid"));
}
int FileMinute = -1;
int.TryParse(stringList[4], out FileMinute);
if (FileMinute == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "FileLastModifiedDate_Local Minute not valid"));
}
int FileSecond = -1;
int.TryParse(stringList[5], out FileSecond);
if (FileSecond == -1)
{
return(string.Format(LabSheetViewRes._IsRequired, "FileLastModifiedDate_Local Second not valid"));
}
FileLastModifiedDate_Local = new DateTime(FileYear, FileMonth, FileDay, FileHour, FileMinute, FileSecond);
FileContent = Request.Params["FileContent"];
if (string.IsNullOrWhiteSpace(FileContent))
{
return(string.Format(LabSheetViewRes._IsRequired, "FileContent"));
}
using (CSSPEntities db = new CSSPEntities())
{
LabSheet labSheet = (from c in db.LabSheets
where c.SamplingPlanName == SamplingPlanName &&
c.Year == Year &&
c.Month == Month &&
c.Day == Day &&
c.RunNumber == RunNumber &&
c.SubsectorTVItemID == SubsectorTVItemID &&
c.SamplingPlanType == (int)SamplingPlanType &&
c.SampleType == (int)SampleType &&
c.LabSheetType == (int)LabSheetType &&
c.FileName == FileName
select c).FirstOrDefault();
if (labSheet == null)
{
labSheet = new LabSheet()
{
SamplingPlanName = SamplingPlanName,
Year = Year,
Month = Month,
Day = Day,
RunNumber = RunNumber,
SubsectorTVItemID = SubsectorTVItemID,
SamplingPlanType = (int)SamplingPlanType,
SampleType = (int)SampleType,
LabSheetType = (int)LabSheetType,
FileName = FileName,
};
db.LabSheets.Add(labSheet);
}
labSheet.LabSheetStatus = (int)LabSheetStatusEnum.Created;
labSheet.FileLastModifiedDate_Local = FileLastModifiedDate_Local;
labSheet.FileContent = FileContent;
labSheet.LastUpdateDate_UTC = DateTime.UtcNow;
labSheet.LastUpdateContactTVItemID = 2;
try
{
db.SaveChanges();
}
catch (Exception ex)
{
return(ex.Message + (ex.InnerException != null ? " " + ex.InnerException.Message : ""));
}
}
return("");
}
