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