// public ActionResult ExportToExcel(int test, string TestType , string SearchBy)
public void ExportToExcel(DataGridoption ExportDataFilter)
{
_logger.Debug("ExportToExcel");
string TestType = ExportDataFilter.Screen;
try
{
switch (TestType.Trim())
{
case "Tension":
ExportTension(ExportDataFilter);
break;
case "Compression":
ExportCompression(ExportDataFilter);
break;
case "OpticalMount":
ExportOpticalMount(ExportDataFilter);
break;
default: break;
}
}
catch (Exception ex)
{
_logger.Error(ex);
}
// return RedirectToAction("Reports");
}
public ActionResult GetData(DataGridoption option)
{
// comment here
LMSDBContext context = null;
List <TestModel1> lstTestModel = null;
int total = 0;
IQueryable <TestModel1> query = null;
try
{
context = new LMSDBContext();
//query = context.TestModel1;
if (!string.IsNullOrEmpty(option.searchBy) && !option.searchBy.Equals(""))
{
query = from p in query
where (p.MyProperty1.ToLower().Contains(option.searchBy) ||
p.MyProperty2.ToLower().Contains(option.searchBy) ||
p.MyProperty3.ToLower().Contains(option.searchBy)
)
select p;
}
lstTestModel = query.OrderBy(x => x.TestModel1Id).Skip(option.pageSize * option.pageIndex).Take(option.pageSize).ToList();
//total = context.TestModel1.Count();
}
catch (Exception ex)
{
throw ex;
}
return(Json(new { items = lstTestModel, total = total }, JsonRequestBehavior.AllowGet));
}
private static void AddSearchFilter(DataGridoption option, Dictionary <string, object> SQLParameters)
{
#region searchby
if (option != null && !string.IsNullOrEmpty(option.searchBy))
{
string[] searchSplit = option.searchBy.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
if (searchSplit != null && searchSplit.Length > 0)
{
foreach (var item in searchSplit)
{
if (!string.IsNullOrEmpty(item))
{
var itemSplit = item.Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
if (itemSplit != null && itemSplit.Length == 2)
{
if (!string.IsNullOrEmpty(itemSplit[1]) && itemSplit[1] != "-1")
{
if (itemSplit[0] == "Spec")
{
SQLParameters["Spec"] = itemSplit[1];
}
if (itemSplit[0] == "Alloy")
{
SQLParameters["Alloy"] = itemSplit[1];
}
if (itemSplit[0] == "Temper")
{
SQLParameters["Temper"] = itemSplit[1];
}
if (itemSplit[0] == "UACPart")
{
SQLParameters["UACPart"] = itemSplit[1];
}
if (itemSplit[0] == "CustPart")
{
SQLParameters["CustPart"] = itemSplit[1];
}
if (itemSplit[0] == "Plant")
{
SQLParameters["Plant"] = itemSplit[1];
}
if (itemSplit[0] == "Severity")
{
SQLParameters["Severity"] = itemSplit[1];
}
}
// lstSqlParameter.Add(new SqlParameter("@" + itemSplit[0], itemSplit[1]));
}
}
}
}
}
#endregion
}
///// <summary>
/// Retrieve the Assign Material data and Assign to Grid
/// </summary>
/// <param name="option"></param>
/// <returns></returns>
private DataSearch <RNDMaterial> GetAssignMaterial(DataGridoption option)
{
AdoHelper ado = new AdoHelper();
List <RNDMaterial> lstAssignMaterial = new List <RNDMaterial>();
List <SqlParameter> lstSqlParameter = new List <SqlParameter>();
lstSqlParameter.Add(new SqlParameter("@CurrentPage", option.pageIndex));
lstSqlParameter.Add(new SqlParameter("@NoOfRecords", option.pageSize));
AddSearchFilter(option, lstSqlParameter);
using (SqlDataReader reader = ado.ExecDataReaderProc("RNDAssignMaterial_Read", "RND", lstSqlParameter.Cast <object>().ToArray()))
{
if (reader.HasRows)
{
RNDMaterial AM = null;
while (reader.Read())
{
AM = new RNDMaterial();
AM.total = Convert.ToInt32(reader["total"]);
AM.RecID = Convert.ToInt32(reader["RecID"]);
AM.WorkStudyID = Convert.ToString(reader["WorkStudyID"]);
AM.SoNum = Convert.ToString(reader["SoNum"]);
AM.MillLotNo = Convert.ToInt32(reader["MillLotNo"]);
AM.CustPart = Convert.ToString(reader["CustPart"]);
AM.UACPart = Convert.ToDecimal(reader["UACPart"]);
AM.Alloy = Convert.ToString(reader["Alloy"]);
AM.Temper = Convert.ToString(reader["Temper"]);
AM.GageThickness = Convert.ToString(reader["GageThickness"]);
AM.Location2 = Convert.ToString(reader["Location2"]);
AM.Hole = Convert.ToString(reader["Hole"]);
AM.PieceNo = Convert.ToString(reader["PieceNo"]);
AM.Comment = Convert.ToString(reader["Comment"]);
AM.EntryDate = (!string.IsNullOrEmpty(reader["EntryDate"].ToString())) ? Convert.ToDateTime(reader["EntryDate"]) : (DateTime?)null;
AM.EntryBy = Convert.ToString(reader["EntryBy"]);
AM.DBCntry = Convert.ToString(reader["DBCntry"]);
// AM.RCS = Convert.ToChar(reader["RCS"]);
lstAssignMaterial.Add(AM);
}
}
if (ado._conn != null && ado._conn.State == System.Data.ConnectionState.Open)
{
ado._conn.Close(); ado._conn.Dispose();
}
}
DataSearch <RNDMaterial> ds = new DataSearch <RNDMaterial>
{
items = lstAssignMaterial,
total = (lstAssignMaterial != null && lstAssignMaterial.Count > 0) ? lstAssignMaterial[0].total : 0
};
return(ds);
}
/// <summary>
/// Retrieve the Assign Material data and Assign to Grid
/// </summary>
/// <param name="option"></param>
/// <returns></returns>
private DataSearch <RNDMaterial> GetUACPartList(DataGridoption option)
{
AdoHelper ado = new AdoHelper();
//SqlDataReader reader = null;
List <RNDMaterial> lstAssignMaterial = new List <RNDMaterial>();
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("RNDUACPartList_Read", "RND", lstSqlParameter.Cast <object>().ToArray()))
{
if (reader.HasRows)
{
int RecID = 0;
RNDMaterial AM = null;
while (reader.Read())
{
AM = new RNDMaterial();
AM.total = Convert.ToInt32(reader["total"]);
AM.RecID = Convert.ToInt32(reader["RecID"]);
AM.UACPart = Convert.ToDecimal(reader["UACPart"]);
AM.GageThickness = Convert.ToString(reader["GageThickness"]);
AM.Location2 = Convert.ToString(reader["Location2"]);
lstAssignMaterial.Add(AM);
RecID++;
}
}
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 <RNDMaterial> ds = new DataSearch <RNDMaterial>
{
items = lstAssignMaterial,
total = (lstAssignMaterial != null && lstAssignMaterial.Count > 0) ? lstAssignMaterial[0].total : 0
};
return(ds);
}
public ActionResult ExportToExcel(string Spec, string Alloy, string Temper, string Plant)
{
DataGridoption ExportDataFilter = new DataGridoption();
string SearchBy = "";
if (!string.IsNullOrEmpty(Spec))
{
SearchBy = SearchBy + ";" + "Spec:" + Spec;
}
if (!string.IsNullOrEmpty(Alloy))
{
SearchBy = SearchBy + ";" + "Alloy:" + Alloy;
}
if (!string.IsNullOrEmpty(Temper))
{
SearchBy = SearchBy + ";" + "Temper:" + Temper;
}
if (!string.IsNullOrEmpty(Plant))
{
SearchBy = SearchBy + ";" + "Plant:" + Plant;
}
ExportDataFilter.Screen = "ExceptionList";
ExportDataFilter.filterBy = "all";
ExportDataFilter.pageIndex = 0;
ExportDataFilter.pageSize = 10000;
ExportDataFilter.searchBy = SearchBy;
List <ProdExceptions> lstException = new List <ProdExceptions>();
DataSearch <ProdExceptions> ds = null;
try
{
ds = new ExceptionsData().GetList(ExportDataFilter);
if (ds != null && ds.items != null && ds.items.Count > 0)
{
lstException = ds.items;
string fileName = "ExceptionList" + "_" + DateTime.Now.ToString().Replace(" ", "").Replace("-", "").Replace(":", "");
GetExcelFile <ProdExceptions>(lstException, fileName);
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("ExceptionList"));
}
public ActionResult GetExceptionList(DataGridoption dataoptions)
{
DataSearch <ProdExceptions> ds = new DataSearch <ProdExceptions>();
try
{
ds = new ExceptionsData().GetList(dataoptions);
}
catch (Exception ex)
{
ds.Message = ex.Message.ToString();
ds.total = 0;
}
return(Json(new { items = ds.items, total = ds.total }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Retrieve the Registered User Details data and Assign to Grid
/// </summary>
/// <param name="option"></param>
/// <returns></returns>
private DataSearch <RNDLogin> GetRegisteredUser(DataGridoption option)
{
AdoHelper ado = new AdoHelper();
//SqlDataReader reader = null;
List <RNDLogin> lstRNDLogin = new List <RNDLogin>();
List <SqlParameter> lstSqlParameter = new List <SqlParameter>();
lstSqlParameter.Add(new SqlParameter("@CurrentPage", option.pageIndex));
lstSqlParameter.Add(new SqlParameter("@NoOfRecords", option.pageSize));
AddSearchFilter(option, lstSqlParameter);
using (SqlDataReader reader = ado.ExecDataReaderProc("RNDRegisteredUser_Read", "RND", lstSqlParameter.Cast <object>().ToArray()))
{
if (reader.HasRows)
{
RNDLogin UD = null;
while (reader.Read())
{
UD = new RNDLogin();
UD.total = Convert.ToInt32(reader["total"]);
UD.UserId = Convert.ToInt32(reader["UserId"]);
UD.UserName = Convert.ToString(reader["UserName"]);
UD.FirstName = Convert.ToString(reader["FirstName"]);
UD.LastName = Convert.ToString(reader["LastName"]);
UD.PermissionLevel = Convert.ToString(reader["PermissionLevel"]);
UD.Created_By = Convert.ToString(reader["CreatedBy"]);
UD.Created_On = Convert.ToString(reader["CreatedOn"]);
UD.StatusCode = Convert.ToString(reader["StatusCode"]);
lstRNDLogin.Add(UD);
}
}
if (ado._conn != null && ado._conn.State == System.Data.ConnectionState.Open)
{
ado._conn.Close(); ado._conn.Dispose();
}
}
DataSearch <RNDLogin> ds = new DataSearch <RNDLogin>
{
items = lstRNDLogin,
total = (lstRNDLogin != null && lstRNDLogin.Count > 0) ? lstRNDLogin[0].total : 0
};
return(ds);
}
private void ExportOpticalMount(DataGridoption ExportDataFilter)
{
var client = GetHttpClient();
List <OpticalMountViewModel> lstExportOpticalMount = new List <OpticalMountViewModel>();
DataSearch <OpticalMountViewModel> objOpticalMount = null;
var OpticalMounttask = client.PostAsJsonAsync(Api + "api/Grid", ExportDataFilter).ContinueWith((res) =>
{
if (res.Result.IsSuccessStatusCode)
{
objOpticalMount = JsonConvert.DeserializeObject <DataSearch <OpticalMountViewModel> >(res.Result.Content.ReadAsStringAsync().Result);
}
});
OpticalMounttask.Wait();
if (objOpticalMount != null && objOpticalMount.items != null && objOpticalMount.items.Count > 0)
{
lstExportOpticalMount = objOpticalMount.items;
string fileName = "OpticalMount" + "_" + DateTime.Now.ToString().Replace(" ", "").Replace("-", "").Replace(":", "");
GetExcelFile <OpticalMountViewModel>(lstExportOpticalMount, fileName);
}
}
/// <summary>
/// Validate the search filter conditions
/// </summary>
/// <param name="option"></param>
/// <param name="lstSqlParameter"></param>
private static void AddSearchFilter(DataGridoption option, List <SqlParameter> lstSqlParameter)
{
if (option != null && !string.IsNullOrEmpty(option.searchBy))
{
string[] searchSplit = option.searchBy.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
if (searchSplit != null && searchSplit.Length > 0)
{
foreach (var item in searchSplit)
{
if (!string.IsNullOrEmpty(item))
{
var itemSplit = item.Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
if (itemSplit != null && itemSplit.Length == 2)
{
if (!string.IsNullOrEmpty(itemSplit[1]) && itemSplit[1] != "-1")
{
lstSqlParameter.Add(new SqlParameter("@" + itemSplit[0], itemSplit[1]));
}
}
}
}
}
}
}
private DataSearch <CompressionViewModel> GetCompressionReports(DataGridoption option)
{
_logger.Debug("GetCompressionReports");
AdoHelper ado = new AdoHelper();
//SqlDataReader reader = null;
List <CompressionViewModel> lstReports = new List <CompressionViewModel>();
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("RNDCompressionReports_Read", "RND", lstSqlParameter.Cast <object>().ToArray()))
{
if (reader.HasRows)
{
CompressionViewModel reports = null;
while (reader.Read())
{
reports = new CompressionViewModel();
reports.RecID = Convert.ToInt32(reader["RecID"]);
reports.WorkStudyID = Convert.ToString(reader["WorkStudyID"]);
reports.TestNo = Convert.ToInt32(reader["TestNo"]);
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.SubConduct = Convert.ToDecimal(reader["SubConduct"]);
reports.SurfConduct = Convert.ToDecimal(reader["SurfConduct"]);
reports.FcyKsi = Convert.ToDecimal(reader["FcyKsi"]);
reports.EcModulusMpsi = Convert.ToDecimal(reader["EcModulusMpsi"]);
reports.SpeciComment = Convert.ToString(reader["SpeciComment"]);
reports.Operator = Convert.ToString(reader["Operator"]);
reports.TestDate = Convert.ToString(reader["TestDate"]); //(!string.IsNullOrEmpty(reader["TestDate"].ToString())) ? Convert.ToDateTime(reader["TestDate"]) : (DateTime?)null;
reports.TestTime = Convert.ToString(reader["TestTime"]);
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 <CompressionViewModel> ds = new DataSearch <CompressionViewModel>
{
items = lstReports,
total = (lstReports != null && lstReports.Count > 0) ? lstReports[0].total : 0
};
return(ds);
}
public DataSearch <ProdExceptions> GetList(DataGridoption option)
{
string message = "success";
List <ProdExceptions> lstExceptions = new List <ProdExceptions>();
try
{
StoredProcedureName = "PlantExceptionRulesGetExceptionsList";
this.ConnectionString = ConfigurationManager.AppSettings["DBConnection"].ToString();
SQLParameters = new Dictionary <string, object>();
SQLParameters["CurrentPage"] = option.pageIndex;
SQLParameters["NoOfRecords"] = option.pageSize;
SQLParameters["sortBy"] = option.sortBy;
SQLParameters["sortDirection"] = option.sortDirection;
AddSearchFilter(option, SQLParameters);
// ProdExceptions exception = null;
DataTable result = Execute();
int j;
foreach (DataRow row in result.Rows)
{
ProdExceptions exception = new ProdExceptions();
j = 0;
exception.Total = Convert.ToInt32(row[j]); j++;
exception.ExceptionID = Convert.ToInt32(row[j]); j++;
exception.Spec = Convert.ToString(row[j]); j++;
exception.SpecRev = Convert.ToString(row[j]); j++;
exception.Alloy = Convert.ToString(row[j]); j++;
exception.Temper = Convert.ToString(row[j]); j++;
exception.MinSecThick = Convert.ToDecimal(row[j]); j++;
exception.MaxSecThick = Convert.ToDecimal(row[j]); j++;
exception.CustPart = Convert.ToString(row[j]); j++;
exception.UACPart = Convert.ToDecimal(row[j]); j++;
exception.Plant = Convert.ToInt32(row[j]); j++;
exception.Severity = Convert.ToInt32(row[j]); j++;
exception.Note = Convert.ToString(row[j]); j++;
exception.Approval = Convert.ToChar(row[j]); j++;
exception.Enabled = Convert.ToInt16(row[j]); j++;
if (exception.Enabled == 1)
{
exception.RuleTurnedOn = "Yes";
}
else
{
exception.RuleTurnedOn = "No";
}
exception.PlantDescription = Convert.ToString(row[j]); j++;
lstExceptions.Add(exception);
}
}
catch (Exception ex)
{
// throw ex;
message = ex.ToString();
lstExceptions[0].Total = 0;
}
DataSearch <ProdExceptions> ds = new DataSearch <ProdExceptions>
{
Message = message,
items = lstExceptions,
total = (lstExceptions != null && lstExceptions.Count > 0) ? lstExceptions[0].Total : 0
};
return(ds);
}
public ActionResult ExportToExcel(string searchWorkStudyNumber, List <string> StudyType, List <string> Plant, List <string> StudyStatus)
{
_logger.Debug("WorkSutdyList ExportToExcel");
string SearchBy = "";
DataGridoption ExportDataFilter = new DataGridoption();
if (!string.IsNullOrEmpty(searchWorkStudyNumber))
{
SearchBy = SearchBy + ";" + "WorkStudyID:" + searchWorkStudyNumber;
}
if (!string.IsNullOrEmpty(StudyType[0].ToString()))
{
SearchBy = SearchBy + ";" + "StudyType:" + StudyType[0].ToString();
}
if (!string.IsNullOrEmpty(Plant[0].ToString()))
{
SearchBy = SearchBy + ";" + "Plant:" + Plant[0].ToString();
}
if (!string.IsNullOrEmpty(StudyStatus[0].ToString()))
{
SearchBy = SearchBy + ";" + "StudyStatus:" + StudyStatus[0].ToString();
}
ExportDataFilter.Screen = "WorkStudy";
ExportDataFilter.filterBy = "all";
ExportDataFilter.pageIndex = 0;
ExportDataFilter.pageSize = 10000;
ExportDataFilter.searchBy = SearchBy;
List <RNDWorkStudyViewModel> lstExportWorkStudy = new List <RNDWorkStudyViewModel>();
DataSearch <RNDWorkStudyViewModel> objWorkstudy = null;
try
{
var client = GetHttpClient();
var task = client.PostAsJsonAsync(Api + "api/Grid", ExportDataFilter).ContinueWith((res) =>
{
if (res.Result.IsSuccessStatusCode)
{
objWorkstudy = JsonConvert.DeserializeObject <DataSearch <RNDWorkStudyViewModel> >(res.Result.Content.ReadAsStringAsync().Result);
}
});
task.Wait();
if (objWorkstudy != null && objWorkstudy.items != null && objWorkstudy.items.Count > 0)
{
lstExportWorkStudy = objWorkstudy.items;
string fileName = "WorkSutdyList" + "_" + DateTime.Now.ToString().Replace(" ", "").Replace("-", "").Replace(":", "");
GetExcelFile <RNDWorkStudyViewModel>(lstExportWorkStudy, fileName);
}
}
catch (Exception ex)
{
_logger.Error(ex);
}
return(RedirectToAction("WorkSutdyList"));
}
/// <summary>
/// Retrieve the WorkStudy Details
/// </summary>
/// <param name="option"></param>
/// <returns></returns>
private DataSearch <RNDWorkStudy> GetWorkStudies(DataGridoption option)
{
AdoHelper ado = new AdoHelper();
//SqlDataReader reader = null;
List <RNDWorkStudy> lstWorkStudy = new List <RNDWorkStudy>();
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("RNDWorkStudy_Read", "RND", lstSqlParameter.Cast <object>().ToArray()))
{
if (reader.HasRows)
{
RNDWorkStudy WS = null;
while (reader.Read())
{
WS = new RNDWorkStudy();
WS.total = Convert.ToInt32(reader["total"]);
WS.RecId = Convert.ToInt32(reader["RecId"]);
WS.WorkStudyID = Convert.ToString(reader["WorkStudyID"]);
WS.StudyType = Convert.ToString(reader["StudyType"]);
WS.StudyTypeDesc = Convert.ToString(reader["StudyTypeDesc"]);
WS.StudyTitle = Convert.ToString(reader["StudyDesc"]);
WS.StudyDesc = Convert.ToString(reader["StudyDesc"]);
WS.PlanOSCost = Convert.ToDecimal(reader["PlanOSCost"]);
WS.AcctOSCost = Convert.ToDecimal(reader["AcctOSCost"]);
WS.StudyStatus = Convert.ToString(reader["StudyStatus"]);
WS.StudyStatusDesc = Convert.ToString(reader["StudyStatusDesc"]);
WS.StartDate = Convert.ToString(reader["StartDate"]);
WS.DueDate = Convert.ToString(reader["DueDate"]);
// WS.DueDate = (!string.IsNullOrEmpty(reader["DueDate"].ToString())) ? Convert.ToDateTime(reader["DueDate"]) : (DateTime?)null;
WS.CompleteDate = Convert.ToString(reader["CompleteDate"]);
WS.Plant = Convert.ToString(reader["Plant"]);
WS.PlantDesc = Convert.ToString(reader["PlantDesc"]);
WS.TempID = Convert.ToString(reader["TempID"]);
WS.EntryBy = Convert.ToString(reader["EntryBy"]);
WS.EntryDate = (!string.IsNullOrEmpty(reader["EntryDate"].ToString())) ? Convert.ToDateTime(reader["EntryDate"]) : (DateTime?)null;
WS.Experimentation = Convert.ToString(reader["Experimentation"]);
WS.FinalSummary = Convert.ToString(reader["FinalSummary"]);
WS.Uncertainty = Convert.ToString(reader["Uncertainty"]);
lstWorkStudy.Add(WS);
}
}
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 <RNDWorkStudy> ds = new DataSearch <RNDWorkStudy>
{
items = lstWorkStudy,
total = (lstWorkStudy != null && lstWorkStudy.Count > 0) ? lstWorkStudy[0].total : 0
};
return(ds);
}
/// <summary>
/// Retrieve the data and assign to Grid
/// </summary>
/// <param name="option"></param>
/// <returns></returns>
public HttpResponseMessage Post(DataGridoption option)
{
CurrentUser user = ApiUser;
dynamic ds = null;
try
{
if (option != null)
{
switch (option.Screen)
{
case "WorkStudy":
ds = GetWorkStudies(option);
break;
case "AssignMaterial":
ds = GetAssignMaterial(option);
break;
case "UACPartList":
ds = GetUACPartList(option);
break;
case "RegisteredUser":
ds = GetRegisteredUser(option);
break;
case "ProcessingMaterial":
ds = GetProcessingMaterial(option);
break;
case "TestingMaterial":
ds = GetTestingMaterial(option);
break;
case "Tension":
ds = GetTensionReports(option);
break;
case "Compression":
ds = GetCompressionReports(option);
break;
case "OpticalMount":
ds = GetOpticalMountReports(option);
break;
case "Results":
ds = GetResults(option);
break;
default:
break;
}
}
return(Serializer.ReturnContent(ds, this.Configuration.Services.GetContentNegotiator(), this.Configuration.Formatters, this.Request));
}
catch (Exception ex)
{
_logger.Error(ex.Message);
return(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
}
private DataSearch <ImportDataViewModel> GetResults(DataGridoption option)
{
_logger.Debug("GetResults");
string message1 = "Records cannot be Entered Manully:";
string message = message1.Trim();
AdoHelper ado = new AdoHelper();
//SqlDataReader reader = null;
List <ImportDataViewModel> lstResults = new List <ImportDataViewModel>();
List <SqlParameter> lstSqlParameter = new List <SqlParameter>();
lstSqlParameter.Add(new SqlParameter("@CurrentPage", option.pageIndex));
lstSqlParameter.Add(new SqlParameter("@NoOfRecords", option.pageSize));
try
{
#region Manual Entry
SqlParameter param0 = new SqlParameter("@SelectedTests", option.searchBy);
using (SqlDataReader reader = ado.ExecDataReaderProc("RNDCheckTestType_READ", "RND", new object[] { param0 }))
{
if (reader.HasRows)
{
ImportDataViewModel ID = null;
while (reader.Read())
{
ID = new ImportDataViewModel();
ID.TestingNo = Convert.ToInt32(reader["TestingNo"]);
ID.TestType = Convert.ToString(reader["TestType"]);
ID.Active = Convert.ToChar(reader["Active"]);
if (ID.Active != '3')
{
if (message.Trim() == message1.Trim())
{
message += ID.TestType;
}
else
{
message += ", " + ID.TestType;
}
}
else
{
lstResults.Add(ID);
}
}
}
if (ado._conn != null && ado._conn.State == System.Data.ConnectionState.Open)
{
ado._conn.Close(); ado._conn.Dispose();
}
}
#endregion
}
catch (Exception ex)
{
_logger.Error(ex.Message);
}
DataSearch <ImportDataViewModel> ds = new DataSearch <ImportDataViewModel>
{
items = lstResults,
// total = (lstResults != null && lstResults.Count > 0) ? lstResults[0].total : 0,
total = (lstResults != null && lstResults.Count > 0) ? lstResults.Count : 0,
Message = message
};
return(ds);
}
private DataSearch <RNDTesting> GetTestingMaterial(DataGridoption option)
{
_logger.Debug("GetTestingMaterial");
AdoHelper ado = new AdoHelper();
//SqlDataReader reader = null;
List <RNDTesting> lstTestingMaterial = new List <RNDTesting>();
List <SqlParameter> lstSqlParameter = new List <SqlParameter>();
lstSqlParameter.Add(new SqlParameter("@CurrentPage", option.pageIndex));
lstSqlParameter.Add(new SqlParameter("@NoOfRecords", option.pageSize));
AddSearchFilter(option, lstSqlParameter);
using (SqlDataReader reader = ado.ExecDataReaderProc("RNDTestingMaterial_Read", "RND", lstSqlParameter.Cast <object>().ToArray()))
{
if (reader.HasRows)
{
RNDTesting TM = null;
while (reader.Read())
{
TM = new RNDTesting();
TM.total = Convert.ToInt32(reader["total"]);
TM.TestingNo = Convert.ToInt32(reader["TestingNo"]);
TM.WorkStudyID = Convert.ToString(reader["WorkStudyID"]);
TM.LotID = Convert.ToString(reader["LotID"]);
TM.MillLotNo = Convert.ToInt32(reader["MillLotNo"]);
TM.SoNum = Convert.ToString(reader["SoNum"]);
TM.Hole = Convert.ToString(reader["Hole"]);
TM.PieceNo = Convert.ToString(reader["PieceNo"]);
TM.Alloy = Convert.ToString(reader["Alloy"]);
TM.Temper = Convert.ToString(reader["Temper"]);
TM.CustPart = Convert.ToString(reader["CustPart"]);
TM.UACPart = Convert.ToInt32(reader["UACPart"]);
TM.GageThickness = Convert.ToString(reader["GageThickness"]);
TM.Orientation = Convert.ToString(reader["Orientation"]);
TM.Location1 = Convert.ToString(reader["Location1"]);
TM.Location2 = Convert.ToString(reader["Location2"]);
TM.Location3 = Convert.ToString(reader["Location3"]);
TM.SpeciComment = Convert.ToString(reader["SpeciComment"]);
TM.TestType = Convert.ToString(reader["TestType"]);
TM.SubTestType = Convert.ToString(reader["SubTestType"]);
TM.Status = Convert.ToChar(reader["Status"]);
TM.Selected = Convert.ToChar(reader["Selected"]);
TM.EntryDate = (!string.IsNullOrEmpty(reader["EntryDate"].ToString())) ? Convert.ToDateTime(reader["EntryDate"]) : (DateTime?)null;
TM.EntryBy = Convert.ToString(reader["EntryBy"]);
TM.TestLab = Convert.ToString(reader["TestLab"]);
TM.Printed = Convert.ToChar(reader["Printed"]);
TM.Replica = Convert.ToString(reader["Replica"]);
// TM.RCS = (!string.IsNullOrEmpty(reader["RCS"].ToString())) ? Convert.ToChar(reader["RCS"]) : (char?)null;
lstTestingMaterial.Add(TM);
}
}
if (ado._conn != null && ado._conn.State == System.Data.ConnectionState.Open)
{
ado._conn.Close(); ado._conn.Dispose();
}
}
DataSearch <RNDTesting> ds = new DataSearch <RNDTesting>
{
items = lstTestingMaterial,
total = (lstTestingMaterial != null && lstTestingMaterial.Count > 0) ? lstTestingMaterial[0].total : 0
};
return(ds);
}
/// <summary>
/// Retrieve the Processing Material data and Assign to Grid
/// </summary>
/// <param name="option"></param>
/// <returns></returns>
private DataSearch <RNDProcessing> GetProcessingMaterial(DataGridoption option)
{
_logger.Debug("GetProcessingMaterial");
//SqlDataReader reader = null;
AdoHelper ado = new AdoHelper();
List <RNDProcessing> lstProcessingMaterial = new List <RNDProcessing>();
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("RNDProcessingMaterial_Read", "RND", lstSqlParameter.Cast <object>().ToArray()))
{
if (reader.HasRows)
{
RNDProcessing PM = null;
while (reader.Read())
{
PM = new RNDProcessing();
PM.RecID = Convert.ToInt32(reader["RecID"]);
PM.WorkStudyID = Convert.ToString(reader["WorkStudyID"]);
PM.MillLotNo = Convert.ToInt32(reader["MillLotNo"]);
PM.Hole = Convert.ToString(reader["Hole"]);
PM.PieceNo = Convert.ToString(reader["PieceNo"]);
PM.Sonum = Convert.ToString(reader["Sonum"]);
PM.ProcessNo = Convert.ToByte(reader["ProcessNo"]);
PM.ProcessID = Convert.ToString(reader["ProcessID"]);
PM.HTLogNo = Convert.ToInt32(reader["HTLogNo"]);
PM.HTLogID = Convert.ToString(reader["HTLogID"]);
PM.AgeLotNo = Convert.ToInt32(reader["AgeLotNo"]);
PM.AgeLotID = Convert.ToString(reader["AgeLotID"]);
PM.SHTTemp = Convert.ToString(reader["SHTTemp"]);
PM.SHSoakHrs = Convert.ToString(reader["SHSoakHrs"]);
PM.SHSoakMns = Convert.ToString(reader["SHSoakMns"]);
PM.SHTStartHrs = Convert.ToString(reader["SHTStartHrs"]);
PM.SHTStartMns = Convert.ToString(reader["SHTStartMns"]);
//PM.SHTDate = (!string.IsNullOrEmpty(reader["SHTDate"].ToString())) ? Convert.ToDateTime(reader["SHTDate"]) : (DateTime?)null;
PM.SHTDate = Convert.ToString(reader["SHTDate"]);
PM.StretchPct = Convert.ToString(reader["StretchPct"]);
PM.AfterSHTHrs = Convert.ToString(reader["AfterSHTHrs"]);
PM.AfterSHTMns = Convert.ToString(reader["AfterSHTMns"]);
PM.NatAgingHrs = Convert.ToString(reader["NatAgingHrs"]);
PM.NatAgingMns = Convert.ToString(reader["NatAgingMns"]);
PM.ArtStartHrs = Convert.ToString(reader["ArtStartHrs"]);
PM.ArtStartMns = Convert.ToString(reader["ArtStartMns"]);
//PM.ArtAgeDate = (!string.IsNullOrEmpty(reader["ArtAgeDate"].ToString())) ? Convert.ToDateTime(reader["ArtAgeDate"]) : (DateTime?)null;
PM.ArtAgeDate = Convert.ToString(reader["ArtAgeDate"]);
PM.ArtAgeTemp1 = Convert.ToString(reader["ArtAgeTemp1"]);
PM.ArtAgeHrs1 = Convert.ToString(reader["ArtAgeHrs1"]);
PM.ArtAgeMns1 = Convert.ToString(reader["ArtAgeMns1"]);
PM.ArtAgeTemp2 = Convert.ToString(reader["ArtAgeTemp2"]);
PM.ArtAgeHrs2 = Convert.ToString(reader["ArtAgeHrs2"]);
PM.ArtAgeMns2 = Convert.ToString(reader["ArtAgeMns2"]);
PM.ArtAgeTemp3 = Convert.ToString(reader["ArtAgeTemp3"]);
PM.ArtAgeHrs3 = Convert.ToString(reader["ArtAgeHrs3"]);
PM.ArtAgeMns3 = Convert.ToString(reader["ArtAgeMns3"]);
PM.FinalTemper = Convert.ToString(reader["FinalTemper"]);
PM.TargetCount = Convert.ToString(reader["TargetCount"]);
PM.ActualCount = Convert.ToString(reader["ActualCount"]);
// PM.RCS = Convert.ToString(reader["RCS"]);
PM.RNDLotID = Convert.ToString(reader["RNDLotID"]);
PM.total = Convert.ToInt32(reader["total"]);
lstProcessingMaterial.Add(PM);
}
}
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 <RNDProcessing> ds = new DataSearch <RNDProcessing>
{
items = lstProcessingMaterial,
total = (lstProcessingMaterial != null && lstProcessingMaterial.Count > 0) ? lstProcessingMaterial[0].total : 0
};
return(ds);
}
