// GET: Results
public HttpResponseMessage Post(OpticalMountViewModel ManulEntryData)
{
ApiViewModel sendMessage = new ApiViewModel();
try
{
CurrentUser user = ApiUser;
AdoHelper ado = new AdoHelper();
SqlParameter param1 = new SqlParameter("@SelectedTests", ManulEntryData.SelectedTests);
SqlParameter param2 = new SqlParameter("@EntryBy", user.UserName);
SqlParameter param3 = new SqlParameter("@EntryDate", DateTime.Now);
SqlParameter param4 = new SqlParameter("@SpeciComment", ManulEntryData.SpeciComment);
SqlParameter param5 = new SqlParameter("@Operator", ManulEntryData.Operator);
SqlParameter param6 = new SqlParameter("@TestDate", ManulEntryData.TestDate);
SqlParameter param7 = new SqlParameter("@TimeHrs", ManulEntryData.TimeHrs);
SqlParameter param8 = new SqlParameter("@TimeMns", ManulEntryData.TimeMns);
sendMessage.Message = "";
using (SqlDataReader reader = ado.ExecDataReaderProc("RNDOpticalMountResults_Insert", "RND", new object[]
{ param1, param2, param3, param4, param5, param6, param7, param8 }))
{
if (reader.HasRows)
{
while (reader.Read())
{
sendMessage.Custom = Convert.ToInt32(reader["TestingNo"]);
if (sendMessage.Message == "")
{
sendMessage.Message += sendMessage.Custom;
}
else
{
sendMessage.Message += ", " + sendMessage.Custom;
}
}
sendMessage.Success = true;
}
if (ado._conn != null && ado._conn.State == System.Data.ConnectionState.Open)
{
ado._conn.Close(); ado._conn.Dispose();
}
}
}
catch (Exception ex)
{
_logger.Error(ex.Message);
sendMessage.Success = false;
// return new HttpResponseMessage(HttpStatusCode.InternalServerError);
}
return(Serializer.ReturnContent(sendMessage, this.Configuration.Services.GetContentNegotiator(), this.Configuration.Formatters, this.Request));
}
private DataSearch <OpticalMountViewModel> GetOpticalMountReports(DataGridoption option)
{
_logger.Debug("GetOpticalMountReports");
AdoHelper ado = new AdoHelper();
List <OpticalMountViewModel> lstReports = new List <OpticalMountViewModel>();
List <SqlParameter> lstSqlParameter = new List <SqlParameter>();
lstSqlParameter.Add(new SqlParameter("@CurrentPage", option.pageIndex));
lstSqlParameter.Add(new SqlParameter("@NoOfRecords", option.pageSize));
AddSearchFilter(option, lstSqlParameter);
try
{
using (SqlDataReader reader = ado.ExecDataReaderProc("RNDOpticalMountReports_Read", "RND", lstSqlParameter.Cast <object>().ToArray()))
{
if (reader.HasRows)
{
OpticalMountViewModel reports = null;
while (reader.Read())
{
reports = new OpticalMountViewModel();
reports.RecID = Convert.ToInt32(reader["RecID"]);
reports.WorkStudyID = Convert.ToString(reader["WorkStudyID"]);
reports.TestingNo = Convert.ToInt32(reader["TestingNo"]);
reports.Alloy = Convert.ToString(reader["Alloy"]);
reports.Temper = Convert.ToString(reader["Temper"]);
reports.CustPart = Convert.ToString(reader["CustPart"]);
reports.UACPart = Convert.ToDecimal(reader["UACPart"]);
// reports.TestType = Convert.ToString(reader["TestType"]);
reports.SpeciComment = Convert.ToString(reader["SpeciComment"]);
reports.Operator = Convert.ToString(reader["Operator"]);
reports.TestDate = (!string.IsNullOrEmpty(reader["TestDate"].ToString())) ? Convert.ToDateTime(reader["TestDate"]) : (DateTime?)null;
reports.TimeHrs = Convert.ToString(reader["TimeHrs"]);
reports.TimeMns = Convert.ToString(reader["TimeMns"]);
reports.EntryDate = (!string.IsNullOrEmpty(reader["EntryDate"].ToString())) ? Convert.ToDateTime(reader["EntryDate"]) : (DateTime?)null;
reports.EntryBy = Convert.ToString(reader["EntryBy"]);
reports.Completed = Convert.ToChar(reader["Completed"]);
reports.total = Convert.ToInt32(reader["total"]);
lstReports.Add(reports);
}
}
if (ado._conn != null && ado._conn.State == System.Data.ConnectionState.Open)
{
ado._conn.Close(); ado._conn.Dispose();
}
}
}
catch (Exception ex)
{
_logger.Error(ex.Message);
}
DataSearch <OpticalMountViewModel> ds = new DataSearch <OpticalMountViewModel>
{
items = lstReports,
total = (lstReports != null && lstReports.Count > 0) ? lstReports[0].total : 0
};
return(ds);
}
