private List <STANDARDData> ConvertfileToSTD(HttpPostedFile file) { Stream stream = file.InputStream; IExcelDataReader reader = null; string PCName = HttpContext.Current.Request.LogonUserIdentity.Name; reader = ExcelReaderFactory.CreateOpenXmlReader(stream); DataSet result = reader.AsDataSet(); reader.Close(); var table = result.Tables[0]; List <STANDARDData> STD_List = new List <STANDARDData>(); for (var i = 1; i < table.Rows.Count; i++) { var Rowdata = table.Rows[i]; var STD = new STANDARDData() { SurfaceID = Rowdata.ItemArray[0].ToString(), SlopeX = Rowdata.ItemArray[1].ToString(), SlopeY = Rowdata.ItemArray[2].ToString(), constantX = Rowdata.ItemArray[3].ToString(), constantY = Rowdata.ItemArray[4].ToString(), Base = Convert.ToDouble(Rowdata.ItemArray[5]), Addition = Convert.ToDouble(Rowdata.ItemArray[6]), Material = Rowdata.ItemArray[7].ToString(), Design = Rowdata.ItemArray[8].ToString(), CreateBy = PCName }; STD_List.Add(STD); } return(STD_List); }
public async Task <IHttpActionResult> DeleteSTANDARDData(string id) { CRUD_Data dataResult = new CRUD_Data(); List <string> prob = new List <string>(); try { STANDARDData sTANDARDData = await db.STANDARDDatas.FindAsync(id); if (sTANDARDData == null) { dataResult.StatusDetails = "Not found " + id + " in system."; return(BadRequest(dataResult.StatusDetails)); } db.STANDARDDatas.Remove(sTANDARDData); await db.SaveChangesAsync(); dataResult.StatusCode = "200"; return(Ok(dataResult)); } catch (Exception ex) { Log.Info(ex); dataResult.StatusDetails = "We found the problem in 'Delete Stan process'(DateTime: " + DateTime.Now + " ). Please contact admin."; return(BadRequest(dataResult.StatusDetails)); } }
public async Task <IHttpActionResult> PostSTANDARDData(STANDARDData sTANDARDData) { STD_Result dataResult = new STD_Result(); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { if (STANDARDDataExists(sTANDARDData.SurfaceID)) { return(Ok(sTANDARDData.SurfaceID)); } else { db.STANDARDDatas.Add(sTANDARDData); await db.SaveChangesAsync(); dataResult.StatusCode = "200"; } } catch (DbEntityValidationException e) { var newException = new FormattedDbEntityValidationException(e); Log.Info(newException); dataResult.StatusDetails = "We found the problem in 'Add CLBS process'( " + sTANDARDData.SurfaceID + ") (DateTime: " + DateTime.Now + " ). Please contact admin."; } return(Ok(dataResult.StatusCode)); }
public async Task <IHttpActionResult> PutSTANDARDData(string SurfaceID, STANDARDData sTANDARDData) { STD_Result dataResult = new STD_Result(); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (SurfaceID != sTANDARDData.SurfaceID) { dataResult.StatusDetails = "" + SurfaceID + "is not match in System"; return(BadRequest(dataResult.StatusDetails)); } db.Entry(sTANDARDData).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException ex) { if (!STANDARDDataExists(SurfaceID)) { dataResult.StatusDetails = "Not found " + SurfaceID + " in System"; return(BadRequest(dataResult.StatusDetails)); } else { Log.Info(ex); dataResult.StatusDetails = "We found the problem in 'Update CLBS process' (DateTime: " + DateTime.Now + " ). Please contact admin."; return(BadRequest(dataResult.StatusDetails)); } } dataResult.StatusCode = "200"; return(Ok(dataResult)); }
public async Task <IHttpActionResult> GetSTANDARDData(string id) { STD_Result dataResult = new STD_Result(); try { STANDARDData sTANDARDData = await db.STANDARDDatas.FindAsync(id); if (sTANDARDData == null) { dataResult.StatusCode = "404"; dataResult.StatusDetails = "Not found " + id + " in System"; return(Ok(dataResult)); } dataResult.DataResult = new vStandardData { SurfaceID = sTANDARDData.SurfaceID, SlopeX = sTANDARDData.SlopeX, SlopeY = sTANDARDData.SlopeY, constantX = sTANDARDData.constantX, constantY = sTANDARDData.constantY, Base = sTANDARDData.Base, Addition = sTANDARDData.Addition, Material = sTANDARDData.Material, Design = sTANDARDData.Design, CreateBy = sTANDARDData.CreateBy }; dataResult.StatusCode = "200"; return(Ok(dataResult)); } catch (Exception ex) { Log.Info(ex); dataResult.StatusCode = "409"; dataResult.StatusDetails = "We found the problem in 'Get Standard data process' (DateTime: " + DateTime.Now + " ). Please contact admin."; return(BadRequest(dataResult.StatusDetails)); } }