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