public ActionResult SetCalculated()
{
try
{
int calId = Request.Form["CalId"].ParseInt();
decimal inputC = Request.Form["inputC"].ParseDecimal();
int inputDegree = Request.Form["inputDegree"].ParseInt();
int modelId = Request.Form["inputModel"].ParseInt();
decimal inputSafeLoad = Request.Form["inputSafeLoad"].ParseDecimal();
TblCalLoad ob = db.TblCalLoad.Find(calId) ?? new TblCalLoad()
{
CreatedBy = CurrentUID,
CreatedDate = CurrentDate
};
ob.InputC = inputC;
ob.InputDegree = inputDegree;
ob.ModelId = modelId;
ob.InputSafeLoad = inputSafeLoad;
ob.ProjectName = Request.Form["ProjectName"];
ob.CalRemark = Request.Form["CalRemark"];
ob.UpdatedBy = CurrentUID;
ob.UpdatedDate = CurrentDate;
if (ob.CalId <= 0)
{
db.TblCalLoad.Add(ob);
}
else
{
db.Entry(ob).State = EntityState.Modified;
}
db.SaveChanges();
{ return(RedirectToAction("Index", "Soil", new { msg = "Data saved.", msgType = AlertMsgType.Success })); }
}
catch (Exception ex)
{ return(RedirectToAction("Index", "Soil", new { msg = "Something wrong. [" + ex.GetMessage() + "]", msgType = AlertMsgType.Danger })); }
}
public ActionResult Delete(int id)
{
try
{
SysRole role = CurrentUser.Role(3).Role();
bool canDelete = role.SysRolePermission.Where(x => x.MenuId == 3220 && x.PermissionId == 3 && x.PermissionFlag).Count() > 0;
if (!canDelete)
{
return(RedirectToAction("Index", "Soil", new { msg = "ไม่มีสิทธิ์ในการลบข้อมูล", msgType = AlertMsgType.Danger }));
}
TblCalLoad ob = db.TblCalLoad.Find(id);
if (ob == null)
{
return(RedirectToAction("Index", "Soil", new { msg = "ไม่พบข้อมูลที่ต้องการ", msgType = AlertMsgType.Warning }));
}
db.TblCalLoad.Remove(ob);
db.SaveChanges();
return(RedirectToAction("Index", "Soil", new { msg = "ลบข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success }));
}
catch (Exception ex)
{ return(RedirectToAction("Index", "Soil", new { msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); }
}
public ActionResult ExportCal(int id)
{
try
{
TblCalLoad ob = db.TblCalLoad.Find(id);
if (ob == null)
{
throw new Exception("Data not found.");
}
SoilCalculatedModel md = new SoilCalculatedModel(uow)
{
inputC = ob.InputC,
inputDegree = ob.InputDegree,
ModelId = ob.ModelId,
inputSafeload = ob.InputSafeLoad
};
string sourceFile = Server.MapPath("~/files/KEMREXCalculated.xlsx");
byte[] byteArray = IOFile.ReadAllBytes(sourceFile);
using (MemoryStream stream = new MemoryStream())
{
stream.Write(byteArray, 0, (int)byteArray.Length);
using (SpreadsheetDocument spreadsheetDoc = SpreadsheetDocument.Open(stream, true))
{
IEnumerable <Sheet> sheets = spreadsheetDoc.WorkbookPart.Workbook.GetFirstChild <Sheets>().Elements <Sheet>().Where(s => s.Name == "Calculated");
if (sheets.Count() <= 0)
{
throw new Exception("Cannot find 'Calculated' sheet in source file.");
}
string relationshipId = sheets.First().Id.Value;
WorksheetPart worksheetPart = (WorksheetPart)spreadsheetDoc.WorkbookPart.GetPartById(relationshipId);
if (worksheetPart == null)
{
throw new Exception("Cannot load 'Calculated' sheet.");
}
Worksheet sheet = worksheetPart.Worksheet;
UpdateCell(ref sheet, "E", 5, md.inputC.ToString());
UpdateCell(ref sheet, "E", 6, md.inputDegree.ToString());
UpdateCell(ref sheet, "E", 7, md.ModelInfo.PileName);
UpdateCell(ref sheet, "E", 11, md.inputC.ToString());
UpdateCell(ref sheet, "E", 12, md.ModelInfo.PileDia.ToString("#,##0.000"));
UpdateCell(ref sheet, "E", 13, md.ClayAb.ToString("#,##0.00000"));
UpdateCell(ref sheet, "E", 15, md.Qu.ToString("#,##0.00"));
UpdateCell(ref sheet, "E", 18, md.ShearH.ToString("#,##0"));
UpdateCell(ref sheet, "E", 19, md.ShearArea.ToString("#,##0.000"));
UpdateCell(ref sheet, "E", 21, md.ShearResist.ToString("#,##0.00"));
UpdateCell(ref sheet, "E", 24, md.UltCompressForce.ToString("#,##0"));
UpdateCell(ref sheet, "E", 26, md.ShearResist.ToString("#,##0.00"));
UpdateCell(ref sheet, "E", 31, md.UpliftH.ToString("#,##0.000"));
UpdateCell(ref sheet, "E", 32, md.UpliftHcone.ToString("#,##0.000"));
UpdateCell(ref sheet, "E", 33, md.WeightOfSoil.ToString("#,##0"));
UpdateCell(ref sheet, "E", 34, md.ShearResist.ToString("#,##0.00"));
UpdateCell(ref sheet, "E", 36, md.UltUpliftForce.ToString("#,##0"));
UpdateCell(ref sheet, "E", 37, md.Quplift.ToString("#,##0.00"));
}
//IOFile.WriteAllBytes("C:\\temp\\newName.xlsx", stream.ToArray());
string mimeType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename= KEMREXCalculated-" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xlsx");
Response.BinaryWrite(stream.ToArray());
Response.Flush(); // send it to the client to download
Response.End();
}
return(View());
}
catch (Exception ex)
{ return(RedirectToAction("Index", "Soil", new { msg = "Something wrong. [" + ex.GetMessage() + "]", msgType = AlertMsgType.Danger })); }
}
public ActionResult Export(int id)
{
try
{
TblCalLoad ob = db.TblCalLoad
.Where(x => x.CalId == id)
.FirstOrDefault();
if (ob == null)
{
throw new Exception("Data not found.");
}
SoilCalculatedModel md = new SoilCalculatedModel(uow)
{
inputC = ob.InputC,
inputDegree = ob.InputDegree,
ModelId = ob.ModelId,
inputSafeload = ob.InputSafeLoad
};
ReportDataSource rptData = new ReportDataSource("db", new List <SysParameter>());
ReportViewer rptViewer = new ReportViewer();
rptViewer.ProcessingMode = ProcessingMode.Local;
rptViewer.LocalReport.ReportPath = Server.MapPath("~/reports/rptLoadCalculator.rdlc");
rptViewer.LocalReport.EnableExternalImages = true;
string imagePath = new Uri(Server.MapPath("~/" + ob.PileModel().TblPileSeries.SeriesImage)).AbsoluteUri;
rptViewer.LocalReport.SetParameters(new ReportParameter("imagePile", imagePath));
rptViewer.LocalReport.SetParameters(new ReportParameter("pileWidth", (md.ModelInfo.PileDia * 1000).ToString("#,##0")));
rptViewer.LocalReport.SetParameters(new ReportParameter("pileLength", md.ModelInfo.PileLength.ToString("#,##0")));
rptViewer.LocalReport.SetParameters(new ReportParameter("inputC", md.inputC.ToString()));
rptViewer.LocalReport.SetParameters(new ReportParameter("inputDegree", md.inputDegree.ToString()));
rptViewer.LocalReport.SetParameters(new ReportParameter("inputModel", md.ModelInfo.PileName));
rptViewer.LocalReport.SetParameters(new ReportParameter("dataSu", md.inputC.ToString()));
rptViewer.LocalReport.SetParameters(new ReportParameter("dataDia", md.ClayDia.ToString("#,##0.000")));
rptViewer.LocalReport.SetParameters(new ReportParameter("dataAb", md.ClayAb.ToString("#,##0.00000")));
rptViewer.LocalReport.SetParameters(new ReportParameter("dataQb", md.Qu.ToString("#,##0.00")));
rptViewer.LocalReport.SetParameters(new ReportParameter("dataShearH", md.ShearH.ToString()));
rptViewer.LocalReport.SetParameters(new ReportParameter("dataShearArea", md.ShearArea.ToString("#,##0.000")));
rptViewer.LocalReport.SetParameters(new ReportParameter("dataShearResist", md.ShearResist.ToString("#,##0.00")));
rptViewer.LocalReport.SetParameters(new ReportParameter("dataQComp", md.UltCompressForce.ToString("#,##0")));
rptViewer.LocalReport.SetParameters(new ReportParameter("dataSafeLoadComp", md.Qcomp.ToString("#,##0.00")));
rptViewer.LocalReport.SetParameters(new ReportParameter("dataHCone", md.UpliftH.ToString("#,##0.000")));
rptViewer.LocalReport.SetParameters(new ReportParameter("dataWeightOfSoil", md.WeightOfSoil.ToString("#,##0")));
rptViewer.LocalReport.SetParameters(new ReportParameter("dataQUplift", md.UltUpliftForce.ToString("#,##0")));
rptViewer.LocalReport.SetParameters(new ReportParameter("dataSafeLoadUplift", md.Quplift.ToString("#,##0.00")));
rptViewer.LocalReport.DataSources.Clear();
rptViewer.LocalReport.DataSources.Add(rptData);
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string filenameExtension;
byte[] bytes = rptViewer.LocalReport.Render(
"PDF", null, out mimeType, out encoding, out filenameExtension,
out streamids, out warnings);
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename= LoadCalc-" + CurrentDate.ToString("yyyy-MM-dd_HHmmss") + "." + filenameExtension);
Response.OutputStream.Write(bytes, 0, bytes.Length); // create the file
Response.Flush(); // send it to the client to download
Response.End();
return(View());
}
catch (Exception ex)
{ return(RedirectToAction("Index", "KPT", new { msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); }
}
