// GET: AssignMaterial /// <summary> /// Retrieve Assign Material List details /// </summary> /// <param name="recId"></param> /// <param name="workStudyID"></param> /// <returns></returns> public ActionResult AssignMaterialList(int recId, string workStudyID) { _logger.Debug("AssignMaterialList"); /* * List<SelectListItem> ddlAlloy = null; * List<SelectListItem> ddlTemper = null; */ RNDMaterial material = null; try { var client = GetHttpClient(); var task = client.GetAsync(Api + "api/AssignMaterial?recID=0").ContinueWith((res) => { if (res.Result.IsSuccessStatusCode) { RNDMaterial rndMaterial = JsonConvert.DeserializeObject <RNDMaterial>(res.Result.Content.ReadAsStringAsync().Result); } }); task.Wait(); material = new RNDMaterial { WorkStudyID = workStudyID }; } catch (Exception ex) { _logger.Error(ex); } return(View(material)); }
///// <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); }
/// <summary> /// Retrieve the UAC details /// </summary> /// <param name="material"></param> /// <returns></returns> public HttpResponseMessage Post(RNDMaterial material) { ApiViewModel VM = null; try { CurrentUser user = ApiUser; VM = new ApiViewModel(); if (material != null && !string.IsNullOrEmpty(material.records)) // if (material.RecID > 0) { AdoHelper ado = new AdoHelper(); SqlParameter param1 = new SqlParameter("@Ids", material.records); SqlParameter param2 = new SqlParameter("@WorkStudyID", material.WorkStudyID); SqlParameter param3 = new SqlParameter("@SoNum", material.SoNum); SqlParameter param4 = new SqlParameter("@MillLotNo", material.MillLotNo); SqlParameter param5 = new SqlParameter("@CustPart", material.CustPart); SqlParameter param6 = new SqlParameter("@UACPart", material.UACPart); SqlParameter param7 = new SqlParameter("@Alloy", material.Alloy); SqlParameter param8 = new SqlParameter("@Temper", material.Temper); SqlParameter param9 = new SqlParameter("@Hole", material.Hole); SqlParameter param10 = new SqlParameter("@PieceNo", material.PieceNo); SqlParameter param11 = new SqlParameter("@Comment", material.Comment); SqlParameter param12 = new SqlParameter("@DBCntry", material.DBCntry); SqlParameter param13 = new SqlParameter("@EntryBy", user.UserName); ado.ExecScalarProc("RNDUACPartListing_Insert", "RND", new object[] { param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13 }); VM.Message = MessageConstants.Saved; VM.Success = true; } } catch (Exception ex) { _logger.Error(ex.Message); return(new HttpResponseMessage(HttpStatusCode.InternalServerError)); } return(Serializer.ReturnContent(VM, this.Configuration.Services.GetContentNegotiator(), this.Configuration.Formatters, this.Request)); }
public ActionResult SaveAssignMaterial(RNDMaterial model) { var client = GetHttpClient(); if (model.IsCopy) { model.RecID = 0; model.IsCopy = false; } var task = client.PostAsJsonAsync(Api + "api/AssignMaterial", model).ContinueWith((res) => { if (res.Result.IsSuccessStatusCode) { RNDMaterial RNDMaterial = JsonConvert.DeserializeObject <RNDMaterial>(res.Result.Content.ReadAsStringAsync().Result); if (RNDMaterial != null) { } } }); task.Wait(); return(RedirectToAction("AssignMaterialList", new { recId = model.RecID, workStudyID = model.WorkStudyID })); }
// POST: api/AssignMaterial /// <summary> /// Save or Update the Assign Material /// </summary> /// <param name="AssignMaterial"></param> /// <returns></returns> public HttpResponseMessage Post(RNDMaterial AssignMaterial) { _logger.Debug("Assign Material Post Called"); string data = string.Empty; try { CurrentUser user = ApiUser; AdoHelper ado = new AdoHelper(); if (AssignMaterial.Hole == null) { AssignMaterial.Hole = ""; } if (AssignMaterial.PieceNo == null) { AssignMaterial.PieceNo = ""; } if (AssignMaterial.DBCntry == null) { AssignMaterial.DBCntry = "NO"; } if (AssignMaterial.CustPart == null) { AssignMaterial.CustPart = ""; } SqlParameter param1 = new SqlParameter("@WorkStudyID", AssignMaterial.WorkStudyID); SqlParameter param2 = new SqlParameter("@SoNum", AssignMaterial.SoNum); SqlParameter param3 = new SqlParameter("@MillLotNo", AssignMaterial.MillLotNo); SqlParameter param4 = new SqlParameter("@CustPart", AssignMaterial.CustPart); SqlParameter param5 = new SqlParameter("@UACPart", AssignMaterial.UACPart); SqlParameter param6 = new SqlParameter("@Alloy", AssignMaterial.Alloy); SqlParameter param7 = new SqlParameter("@Temper", AssignMaterial.Temper); SqlParameter param8 = new SqlParameter("@GageThickness", AssignMaterial.GageThickness); SqlParameter param9 = new SqlParameter("@Location2", AssignMaterial.Location2); SqlParameter param10 = new SqlParameter("@Hole", AssignMaterial.Hole); SqlParameter param11 = new SqlParameter("@PieceNo", AssignMaterial.PieceNo); SqlParameter param12 = new SqlParameter("@Comment", AssignMaterial.Comment); SqlParameter param13 = new SqlParameter("@EntryDate", DateTime.Now); SqlParameter param14 = new SqlParameter("@EntryBy", user.UserName); SqlParameter param15 = new SqlParameter("@DBCntry", AssignMaterial.DBCntry); // SqlParameter param16 = new SqlParameter("@RCS", AssignMaterial.RCS); if (AssignMaterial.RecID > 0) { SqlParameter param17 = new SqlParameter("@RecId", AssignMaterial.RecID); ado.ExecScalarProc("RNDAssignMaterial_Update", "RND", new object[] { param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13, param14, param15, param17 }); } else { ado.ExecScalarProc("RNDAssignMaterial_Insert", "RND", new object[] { param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13, param14, param15 }); } } catch (Exception ex) { _logger.Error(ex.Message); return(new HttpResponseMessage(HttpStatusCode.InternalServerError)); } return(Serializer.ReturnContent(AssignMaterial, this.Configuration.Services.GetContentNegotiator(), this.Configuration.Formatters, this.Request)); }
/// <summary> /// Retrieve the Assign Material /// </summary> /// <param name="recID"></param> /// <returns></returns> public HttpResponseMessage Get(int recID) { _logger.Debug("Assign Material Get Called"); RNDMaterial AM = null; try { CurrentUser user = ApiUser; AM = new RNDMaterial(); AdoHelper ado = new AdoHelper(); AM.ddlAlloy = new List <SelectListItem>() { GetInitialSelectItem() }; AM.ddlTemper = new List <SelectListItem>() { GetInitialSelectItem() }; if (recID > 0) { SqlParameter param1 = new SqlParameter("@RecId", recID); using (SqlDataReader reader = ado.ExecDataReaderProc("RNDAssignMaterial_ReadByID", "RND", new object[] { param1 })) { if (reader.HasRows) { if (reader.Read()) { 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"]); } } if (ado._conn != null && ado._conn.State == System.Data.ConnectionState.Open) { ado._conn.Close(); ado._conn.Dispose(); } } } return(Serializer.ReturnContent(AM, this.Configuration.Services.GetContentNegotiator(), this.Configuration.Formatters, this.Request)); } catch (Exception ex) { _logger.Error(ex.Message); return(new HttpResponseMessage(HttpStatusCode.InternalServerError)); } }
/// <summary> /// Retrieve the MillLotNo /// </summary> /// <param name="MillLotNo"></param> /// <param name="recID"></param> /// <returns></returns> // public HttpResponseMessage Get(int MillLotNo, int recID) // public HttpResponseMessage Get(int MillLotNo, int recID, string DataBaseName) //{ // _logger.Debug("Assign Material Mill Lot No Get Called"); // // SqlDataReader reader = null; // RNDMaterial AM = null; // string DBName;// = "RDBPROD"; // try // { // CurrentUser user = ApiUser; // AM = new RNDMaterial(); // AdoHelper ado = new AdoHelper(); // AM.ddlAlloy = new List<SelectListItem>() { GetInitialSelectItem() }; // if (MillLotNo > 0) // // if (UACPART > 0) // { // SqlParameter param1 = new SqlParameter("@MillLotID", MillLotNo); // // SqlParameter param1 = new SqlParameter("@UACPART", UACPART); // switch (DataBaseName) // { // case "ROM": // DBName = "ROPROD";//Romania Productin Database // break; // case "USA": // DBName = "RDBPROD";//US Production Database // break; // case "NO": // //No Database selected // DBName = "NO"; // break; // default: // DBName = "RDBPROD";//US Production Database // break; // } // if (DBName != "NO") // { // using (SqlDataReader reader = ado.ExecDataReaderProc("RNDUACPART_READ", DBName, new object[] { param1 })) // { // if (reader.HasRows) // { // if (reader.Read()) // { // AM.MillLotNo = Convert.ToInt32(reader["MillLotID"]); // //AM.RecID = Convert.ToInt32(reader["RecID"]); // AM.CustPart = Convert.ToString(reader["CustPartNo"]); // AM.UACPart = Convert.ToDecimal(reader["UACPart"]); // AM.Alloy = Convert.ToString(reader["Alloy"]); // AM.Temper = Convert.ToString(reader["Temper"]); // AM.SoNum = Convert.ToString(reader["SoNum"]); // } // } // if (ado._conn != null && ado._conn.State == System.Data.ConnectionState.Open) // { // ado._conn.Close(); ado._conn.Dispose(); // } // } // } // else // { // AM.MillLotNo = -1; // } // } // } // catch (Exception ex) // { // _logger.Error(ex.Message); // AM.MillLotNo = 0; // AM.Comment = ex.Message; // } // return Serializer.ReturnContent(AM, this.Configuration.Services.GetContentNegotiator(), this.Configuration.Formatters, this.Request); // } public HttpResponseMessage Get(int MillLotNo, int recID, string DataBaseName) { _logger.Debug("Assign Material Mill Lot No Get Called"); // SqlDataReader reader = null; RNDMaterial AM = null; string DBName;// = "RDBPROD"; string storeProc = "RNDUACPART_READ"; try { CurrentUser user = ApiUser; AM = new RNDMaterial(); AdoHelper ado = new AdoHelper(); AM.ddlAlloy = new List <SelectListItem>() { GetInitialSelectItem() }; if (MillLotNo > 0) { SqlParameter param1 = new SqlParameter("@MillLotID", MillLotNo); switch (DataBaseName) { case "ROM": // DBName = "ROPROD";//Romania Productin Database DBName = "RDBPROD"; // using US Production Database for RO and USA storeProc = "RNDUACPART_READ_RO"; break; case "USA": DBName = "RDBPROD"; //US Production Database storeProc = "RNDUACPART_READ"; break; case "NO": //No Database selected DBName = "NO"; storeProc = "RNDUACPART_READ"; break; default: DBName = "RDBPROD"; //US Production Database break; } if (DBName != "NO") { //using (SqlDataReader reader = ado.ExecDataReaderProc("RNDUACPART_READ", DBName, new object[] { param1 })) using (SqlDataReader reader = ado.ExecDataReaderProc(storeProc, DBName, new object[] { param1 })) { if (reader.HasRows) { if (reader.Read()) { AM.MillLotNo = Convert.ToInt32(reader["MillLotID"]); //AM.RecID = Convert.ToInt32(reader["RecID"]); AM.CustPart = Convert.ToString(reader["CustPartNo"]); AM.UACPart = Convert.ToDecimal(reader["UACPart"]); AM.Alloy = Convert.ToString(reader["Alloy"]); AM.Temper = Convert.ToString(reader["Temper"]); AM.SoNum = Convert.ToString(reader["SoNum"]); } } if (ado._conn != null && ado._conn.State == System.Data.ConnectionState.Open) { ado._conn.Close(); ado._conn.Dispose(); } } } else { AM.MillLotNo = -1; } } } catch (Exception ex) { _logger.Error(ex.Message); AM.MillLotNo = 0; AM.Comment = ex.Message; } return(Serializer.ReturnContent(AM, this.Configuration.Services.GetContentNegotiator(), this.Configuration.Formatters, this.Request)); }
public ActionResult SaveAssignMaterial(int id, string workStudyId) { RNDMaterial Material = new RNDMaterial(); List <SelectListItem> DataBase = null; DataBase = new List <SelectListItem>(); // AM.ddlAlloy = new List<SelectListItem>() { GetInitialSelectItem() }; DataBase.Add(new SelectListItem { Value = "NO", Text = "None", Selected = true, }); DataBase.Add(new SelectListItem { // Value = "RO", Value = "ROM", // Text = "RO", Text = "Romania Database", Selected = true, }); DataBase.Add(new SelectListItem { Value = "USA", Text = "US Database", Selected = true, }); try { if (id > 0) { var client = GetHttpClient(); var task = client.GetAsync(Api + "api/AssignMaterial?recID=" + id).ContinueWith((res) => { if (res.Result.IsSuccessStatusCode) { Material = JsonConvert.DeserializeObject <RNDMaterial>(res.Result.Content.ReadAsStringAsync().Result); if (Material != null) { if (!string.IsNullOrEmpty(workStudyId)) { Material.WorkStudyID = workStudyId; } } } }); task.Wait(); } else { Material.WorkStudyID = workStudyId; } ViewBag.ddDataBase = DataBase; } catch (Exception ex) { _logger.Error(ex); } return(View(Material)); }