public ActionResult Update(int id)
{
var a = id;
//DateTime reqDateParam = DateTime.Parse(beginDate);
//var met = DB.Summaries.Where(a => a.STATION_ID == stationId && a.tarih.Year == reqDateParam.Year
// && a.tarih.Month == reqDateParam.Month && a.tarih.Day == reqDateParam.Day)
// .Select(a => new Meteoroloji_DTO
// {
// date = a.tarih,
// irradiation = (float)Math.Round((float)a.isinim, 1),
// pyranometer = (float)Math.Round((float)a.PYRANOMETER, 1),
// wind = (float)Math.Round((float)a.ruzgarHizi),
// cell_temp = (float)Math.Round((float)a.hucreSicakligi),
// external_temp = (float)Math.Round((float)a.sicaklik)
// }).OrderBy(a => a.date).ToList();
//return Json(met, JsonRequestBehavior.AllowGet);
var user = User.Identity.GetUserId();
EssoEntities DBModel = new EssoEntities();
var item = DBModel.AlarmStatus.Where(x => x.ID == id).FirstOrDefault();
using (EssoEntities DB = new EssoEntities())
{
if (item != null)
{
try
{
DB.Entry(new TBL_ALARM_STATUS()
{
ID = item.ID,
START_DATE = item.START_DATE,
END_DATE = item.END_DATE,
ERROR_NUMBER = item.ERROR_NUMBER,
STATION_ID = item.STATION_ID,
INVERTER_ID = item.INVERTER_ID,
STATUS = item.STATUS,
PROCESS_STEP = 1,
USER_ID = User.Identity.GetUserId()
}).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
DB.Commit();
}
catch (Exception ex)
{
throw;
}
}
}
return(View());
}
public static double GetEndDataBuyingUSD()
{
double _kur = 0;
try
{
EssoEntities DB = new EssoEntities();
_kur = DB.exchange.OrderByDescending(a => a.EXCHANGE_DATE).FirstOrDefault().BUYING_VALUE.Value;
}
catch (Exception ex)
{
_kur = 0;
}
return(Math.Round(_kur, 4));
}
public EssoEntities Init()
{
return(dbContext ?? (dbContext = new EssoEntities()));
}
public ActionResult GetData(string stationId, string startDate, string endDate)
{
CultureHelper.SetCultureInfo();
int start = Convert.ToInt32(Request["start"]);
int length = Convert.ToInt32(Request["length"]);
string searchValue = Request["search[value]"];
string sortColumnName = Request["columns[" + Request["order[0][column]"] + "][data]"];
string sortDirection = Request["order[0][dir]"];
var role = User.IsInRole("DEMO");
int station_id = Convert.ToInt32(stationId);
var EndDate = Convert.ToDateTime(endDate).AddDays(1);
var StartDate = Convert.ToDateTime(startDate);
// var _list = DB.AlarmStatus.Where(x => x.STATION_ID == int.Parse(stationId) && x.STATUS != 2).OrderBy(x => x.START_DATE).ToList();
using (EssoEntities db = new EssoEntities())
{
try
{
var _Alarm_list = (from AS in db.AlarmStatus
where AS.STATION_ID == station_id && AS.STATUS != 2 && EndDate >= AS.START_DATE && StartDate <= AS.START_DATE
join AD in db.AlarmDesc on AS.ERROR_NUMBER equals AD.ERROR_NUMBER.ToString() into yG1
from y1 in yG1.DefaultIfEmpty()
join Inv in db.Inverters on AS.INVERTER_ID equals Inv.ID into yG2
from y2 in yG2.DefaultIfEmpty()
join sT in db.Stations on AS.STATION_ID equals sT.ID into yG3
from y3 in yG3.DefaultIfEmpty()
select new
{
ID = AS.ID,
INVERTER_NAME = y2.NAME == null ? y3.NAME.ToString() : y2.NAME.ToString(),
STATUS = AS.STATUS,
START_DATE = AS.START_DATE,
END_DATE = AS.END_DATE,
ERROR_NUMBER = y1.ERROR_DESC,
TYPE = y1.TYPE
}).ToList().Select(o => new
{
ID = o.ID,
INVERTER_NAME = o.INVERTER_NAME == null ? "-" : o.INVERTER_NAME.ToString(),
STATUS = o.STATUS,
START_DATE = o.START_DATE,
END_DATE = o.END_DATE,
ERROR_NUMBER = o.ERROR_NUMBER,
TYPE = o.TYPE
}).ToList();
int totalrows = _Alarm_list.Count;
if (!string.IsNullOrEmpty(searchValue))
{//filter
_Alarm_list = _Alarm_list.Where(x => x.ID.ToString().ToLower().Contains(searchValue.ToLower()) || x.INVERTER_NAME.ToString().ToLower().Contains(searchValue.ToLower()) || x.STATUS.ToString().ToLower().Contains(searchValue.ToLower()) ||
x.START_DATE.ToString().ToLower().Contains(searchValue.ToLower()) || x.END_DATE.ToString().ToLower().Contains(searchValue.ToLower()) || x.ERROR_NUMBER.ToLower().Contains(searchValue.ToLower())).ToList();
}
int totalrowsafterfiltering = _Alarm_list.Count();
_Alarm_list = _Alarm_list.OrderBy(sortColumnName + " " + sortDirection).ToList();
_Alarm_list = _Alarm_list.Skip(start).Take(length).ToList();
return(Json(new
{
data = _Alarm_list.Select(o => new
{
ID = o.ID,
INVERTER_NAME = o.INVERTER_NAME,
STATUS = o.STATUS,
START_DATE = o.START_DATE.Value.ToString("dd/MM/yyyy HH:mm:ss"),
END_DATE = o.END_DATE == null ? "-" : o.END_DATE.Value.ToString("dd/MM/yyyy HH:mm:ss"),
ERROR_NUMBER = o.ERROR_NUMBER,
TYPE = o.TYPE
}).ToList(),
draw = Request["draw"],
recordsTotal = totalrows,
recordsFiltered = totalrowsafterfiltering
}, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var a = ex.ToString();
}
}
return(View());
}
public ActionResult ExportExcel(int stationId, string startDate, string endDate, string searchValue)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("tr-TR");
int start = Convert.ToInt32(Request["start"]);
int length = Convert.ToInt32(Request["length"]);
//string searchValue = Request["search[value]"];
string sortColumnName = Request["columns[" + Request["order[0][column]"] + "][data]"];
string sortDirection = Request["order[0][dir]"];
var role = User.IsInRole("DEMO");
MemoryStream result = new MemoryStream();
string excelreportPath = DateTime.Now + ".Alarmlar.xlsx";
EssoEntities db = new EssoEntities();
var StartDate = Convert.ToDateTime(startDate);
var EndDate = Convert.ToDateTime(endDate).AddDays(1);
var _Alarm_list = (from AS in db.AlarmStatus
where AS.STATION_ID == stationId && AS.STATUS != 2 && EndDate >= AS.START_DATE && StartDate <= AS.START_DATE
join AD in db.AlarmDesc on AS.ERROR_NUMBER equals AD.ERROR_NUMBER.ToString() into yG1
from y1 in yG1.DefaultIfEmpty()
join Inv in db.Inverters on AS.INVERTER_ID equals Inv.ID into yG2
from y2 in yG2.DefaultIfEmpty()
join sT in db.Stations on AS.STATION_ID equals sT.ID into yG3
from y3 in yG3.DefaultIfEmpty()
select new
{
ID = AS.ID,
INVERTER_NAME = y2.NAME == null ? y3.NAME.ToString() : y2.NAME.ToString(),
STATUS = AS.STATUS,
START_DATE = AS.START_DATE,
END_DATE = AS.END_DATE,
ERROR_NUMBER = y1.ERROR_DESC,
TYPE = y1.TYPE
}).ToList().Select(o => new
{
ID = o.ID,
INVERTER_NAME = o.INVERTER_NAME == null ? "-" : o.INVERTER_NAME.ToString(),
STATUS = o.STATUS,
START_DATE = o.START_DATE,
END_DATE = o.END_DATE,
ERROR_NUMBER = o.ERROR_NUMBER,
TYPE = o.TYPE
}).OrderByDescending(x => x.START_DATE).ToList();
int totalrows = _Alarm_list.Count;
if (!string.IsNullOrEmpty(searchValue))
{
_Alarm_list = _Alarm_list.Where(x => x.ID.ToString().ToLower().Contains(searchValue.ToLower()) || x.INVERTER_NAME.ToString().ToLower().Contains(searchValue.ToLower()) || x.STATUS.ToString().ToLower().Contains(searchValue.ToLower()) ||
x.START_DATE.ToString().ToLower().Contains(searchValue.ToLower()) || x.END_DATE.ToString().ToLower().Contains(searchValue.ToLower()) || x.ERROR_NUMBER.ToLower().Contains(searchValue.ToLower())).ToList();
}
using (ExcelPackage pck = new ExcelPackage())
{
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Report");
ws.Column(1).Width = 30;
ws.Column(2).Width = 20;
ws.Column(3).Width = 20;
ws.Column(4).Width = 25;
ws.Cells["A1"].Value = @Resources.Error_Name;
ws.Cells["B1"].Value = Resources.Error_Type;
ws.Cells["C1"].Value = @Resources.Start_Date;
ws.Cells["D1"].Value = @Resources.End_Date;
ws.Cells["A1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["B1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["C1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["D1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["A1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
ws.Cells["B1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
ws.Cells["C1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
ws.Cells["D1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
for (int i = 0; i < _Alarm_list.Count; i++)
{
var item = _Alarm_list[i];
ws.Cells["A" + (i + 2)].Value = _Alarm_list[i].ERROR_NUMBER;
ws.Cells["B" + (i + 2)].Value = _Alarm_list[i].INVERTER_NAME;
ws.Cells["C" + (i + 2)].Value = _Alarm_list[i].START_DATE.Value.ToString("dd/MM/yyyy HH:mm:ss");
ws.Cells["D" + (i + 2)].Value = _Alarm_list[i].END_DATE == null ? "-" : _Alarm_list[i].END_DATE.Value.ToString("dd/MM/yyyy HH:mm:ss");
if (_Alarm_list[i].TYPE == 1)
{
ws.Cells["A" + (i + 2)].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["B" + (i + 2)].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["C" + (i + 2)].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["D" + (i + 2)].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["A" + (i + 2)].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#ff0000")));
ws.Cells["B" + (i + 2)].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#ff0000")));
ws.Cells["C" + (i + 2)].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#ff0000")));
ws.Cells["D" + (i + 2)].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#ff0000")));
}
else if (_Alarm_list[i].TYPE == 2)
{
ws.Cells["A" + (i + 2)].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["B" + (i + 2)].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["C" + (i + 2)].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["D" + (i + 2)].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["A" + (i + 2)].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#ffc400")));
ws.Cells["B" + (i + 2)].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#ffc400")));
ws.Cells["C" + (i + 2)].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#ffc400")));
ws.Cells["D" + (i + 2)].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#ffc400")));
}
}
var reportBuffer = pck.GetAsByteArray();
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=" + excelreportPath);
Response.ContentType = "application/vnd.openxmlformats - officedocument.spreadsheetml.sheet";
Response.BinaryWrite(reportBuffer);
result.WriteTo(Response.OutputStream);
Response.Flush();
Response.Close();
Response.End();
}
return(View());
}
public JsonResult GetProgress(string stationId)
{
Progress mwc = new Progress();
Thread.CurrentThread.CurrentCulture = new CultureInfo("tr-TR");
int station_id = Convert.ToInt32(stationId);
// && EndDate >= Os.CREATED_DATE && StartDate <= Os.CREATED_DATE
var DatetimeMonth = DateTime.Now.Month;
var DatetimeYear = DateTime.Now.Year;
using (EssoEntities db = new EssoEntities())
{
try
{
var OsosList = (from Os in db.Osos
where Os.STATION_ID == station_id && DatetimeMonth == Os.CREATED_DATE.Month && DatetimeYear == Os.CREATED_DATE.Year
orderby Os.CREATED_DATE
select new
{
ID = Os.ID,
STATION_ID = Os.STATION_ID,
DEMAND = Os.DEMAND,
P_180 = Os.P_180,
RI_580 = Os.RI_580,
RC_880 = Os.RC_880,
P_280 = Os.P_280,
RI_680 = Os.RI_680,
RC_780 = Os.RC_780,
INSERT_DATE = Os.INSERT_DATE,
CREATED_DATE = Os.CREATED_DATE,
INDUCTIVE_REAKTIF_RATE = Os.INDUCTIVE_REAKTIF_RATE,
CAPACITIVE_REAKTIF_RATE = Os.CAPACITIVE_REAKTIF_RATE
}).ToList();
var OsosFirstDayofMonth = (from Os in db.Osos
where Os.STATION_ID == station_id && DatetimeMonth == Os.CREATED_DATE.Month && DatetimeYear == Os.CREATED_DATE.Year && Os.CREATED_DATE.Day == 1
orderby Os.CREATED_DATE
select new
{
ID = Os.ID,
STATION_ID = Os.STATION_ID,
DEMAND = Os.DEMAND,
P_180 = Os.P_180,
RI_580 = Os.RI_580,
RC_880 = Os.RC_880,
P_280 = Os.P_280,
RI_680 = Os.RI_680,
RC_780 = Os.RC_780,
INSERT_DATE = Os.INSERT_DATE,
CREATED_DATE = Os.CREATED_DATE,
INDUCTIVE_REAKTIF_RATE = Os.INDUCTIVE_REAKTIF_RATE,
CAPACITIVE_REAKTIF_RATE = Os.CAPACITIVE_REAKTIF_RATE
}).ToList();
float?mountly_INDUCTIVE_REAKTIF_RATE = 0;
float?mountly_CAPACITIVE_REAKTIF_RATE = 0;
if (OsosFirstDayofMonth.Count != 0)
{
mountly_INDUCTIVE_REAKTIF_RATE = ((OsosList[OsosList.Count - 1].RI_580 - (OsosList[0].RI_580)) / (OsosList[OsosList.Count - 1].P_180 - (OsosList[0].P_180))) * 100;
mountly_CAPACITIVE_REAKTIF_RATE = ((OsosList[OsosList.Count - 1].RC_880 - (OsosList[0].RC_880)) / (OsosList[OsosList.Count - 1].P_180 - (OsosList[0].P_180))) * 100;
}
mwc.Progress1 = mountly_INDUCTIVE_REAKTIF_RATE.ToString().Replace(",", ".");
mwc.Progress2 = mountly_CAPACITIVE_REAKTIF_RATE.ToString().Replace(",", ".");
mwc.isSuccess = true;
mwc.ErrorMessage = "";
return(Json(mwc, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
mwc.Progress1 = "";
mwc.Progress2 = "";
mwc.isSuccess = false;
mwc.ErrorMessage = ex.ToString();
var a = ex.ToString();
return(Json(mwc, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult ExportExcel(int stationId, string startDate, string endDate)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("tr-TR");
int start = Convert.ToInt32(Request["start"]);
int length = Convert.ToInt32(Request["length"]);
string sortColumnName = Request["columns[" + Request["order[0][column]"] + "][data]"];
string sortDirection = Request["order[0][dir]"];
var role = User.IsInRole("DEMO");
MemoryStream result = new MemoryStream();
string excelreportPath = DateTime.Now + ".OsosKayitlar.xlsx";
var EndDate = Convert.ToDateTime(endDate).AddDays(1);
var StartDate = Convert.ToDateTime(startDate);
using (EssoEntities db = new EssoEntities())
{
var OsosList = (from Os in db.Osos
where Os.STATION_ID == stationId && EndDate >= Os.CREATED_DATE && StartDate <= Os.CREATED_DATE
orderby Os.CREATED_DATE
select new
{
ID = Os.ID,
STATION_ID = Os.STATION_ID,
DEMAND = Os.DEMAND,
P_180 = Os.P_180,
RI_580 = Os.RI_580,
RC_880 = Os.RC_880,
P_280 = Os.P_280,
RI_680 = Os.RI_680,
RC_780 = Os.RC_780,
INSERT_DATE = Os.INSERT_DATE,
CREATED_DATE = Os.CREATED_DATE,
INDUCTIVE_REAKTIF_RATE = Os.INDUCTIVE_REAKTIF_RATE,
CAPACITIVE_REAKTIF_RATE = Os.CAPACITIVE_REAKTIF_RATE,
}).ToList();
using (ExcelPackage pck = new ExcelPackage())
{
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Report");
ws.Column(1).Width = 25;
ws.Column(1).Width = 20;
ws.Column(3).Width = 15;
ws.Column(4).Width = 15;
ws.Column(5).Width = 20;
ws.Column(6).Width = 20;
ws.Column(7).Width = 15;
ws.Column(8).Width = 15;
ws.Column(9).Width = 25;
ws.Column(10).Width = 25;
ws.Cells["A1"].Value = "Tarih";
ws.Cells["B1"].Value = "Demand";
ws.Cells["C1"].Value = "-P(2.8.0)";
ws.Cells["D1"].Value = "+Rc(7.8.0)";
ws.Cells["E1"].Value = "-Ri(6.8.0)";
ws.Cells["F1"].Value = "+P(1.8.0)";
ws.Cells["G1"].Value = "+Ri(5.8.0)";
ws.Cells["H1"].Value = "-Rc(8.8.0)";
ws.Cells["I1"].Value = "Endüktif Reaktif Oran";
ws.Cells["J1"].Value = "Kapasitif Reaktif Oran";
ws.Cells["A1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["B1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["C1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["D1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["E1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["F1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["G1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["H1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["I1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["J1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
ws.Cells["A1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
ws.Cells["B1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
ws.Cells["C1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
ws.Cells["D1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
ws.Cells["E1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
ws.Cells["F1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
ws.Cells["G1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
ws.Cells["H1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
ws.Cells["I1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
ws.Cells["J1"].Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml(string.Format("#6aa5e4")));
for (int i = 0; i < OsosList.Count; i++)
{
ws.Cells["B" + (i + 2)].Style.Numberformat.Format = "#,##0.00";
ws.Cells["C" + (i + 2)].Style.Numberformat.Format = "#,##0.00";
ws.Cells["D" + (i + 2)].Style.Numberformat.Format = "#,##0.00";
ws.Cells["E" + (i + 2)].Style.Numberformat.Format = "#,##0.00";
ws.Cells["F" + (i + 2)].Style.Numberformat.Format = "#,##0.00";
ws.Cells["G" + (i + 2)].Style.Numberformat.Format = "#,##0.00";
ws.Cells["H" + (i + 2)].Style.Numberformat.Format = "#,##0.00";
ws.Cells["I" + (i + 2)].Style.Numberformat.Format = "#,##0.00";
ws.Cells["J" + (i + 2)].Style.Numberformat.Format = "#,##0.00";
var item = OsosList[i];
ws.Cells["A" + (i + 2)].Value = OsosList[i].CREATED_DATE.ToString("dd/MM/yyyy HH:mm:ss");
ws.Cells["B" + (i + 2)].Value = OsosList[i].DEMAND;
ws.Cells["C" + (i + 2)].Value = OsosList[i].P_280;
ws.Cells["D" + (i + 2)].Value = OsosList[i].RI_680;
ws.Cells["E" + (i + 2)].Value = OsosList[i].RC_780;
ws.Cells["F" + (i + 2)].Value = OsosList[i].P_180;
ws.Cells["G" + (i + 2)].Value = OsosList[i].RI_580;
ws.Cells["H" + (i + 2)].Value = OsosList[i].RC_880;
ws.Cells["I" + (i + 2)].Value = OsosList[i].INDUCTIVE_REAKTIF_RATE;
ws.Cells["J" + (i + 2)].Value = OsosList[i].CAPACITIVE_REAKTIF_RATE;
}
var reportBuffer = pck.GetAsByteArray();
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=" + excelreportPath);
Response.ContentType = "application/vnd.openxmlformats - officedocument.spreadsheetml.sheet";
Response.BinaryWrite(reportBuffer);
result.WriteTo(Response.OutputStream);
Response.Flush();
Response.Close();
Response.End();
}
}
return(View());
}
public ActionResult GetData(string stationId, string startDate, string endDate)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("tr-TR");
int start = Convert.ToInt32(Request["start"]);
int length = Convert.ToInt32(Request["length"]);
string sortColumnName = Request["columns[" + Request["order[0][column]"] + "][data]"];
string sortDirection = Request["order[0][dir]"];
int station_id = Convert.ToInt32(stationId);
var EndDate = Convert.ToDateTime(endDate).AddDays(1);
var StartDate = Convert.ToDateTime(startDate);
using (EssoEntities db = new EssoEntities())
{
try
{
var OsosList = (from Os in db.Osos
where Os.STATION_ID == station_id && EndDate >= Os.CREATED_DATE && StartDate <= Os.CREATED_DATE
select new
{
ID = Os.ID,
STATION_ID = Os.STATION_ID,
DEMAND = Os.DEMAND,
P_180 = Os.P_180,
RI_580 = Os.RI_580,
RC_880 = Os.RC_880,
P_280 = Os.P_280,
RI_680 = Os.RI_680,
RC_780 = Os.RC_780,
INSERT_DATE = Os.INSERT_DATE,
CREATED_DATE = Os.CREATED_DATE,
INDUCTIVE_REAKTIF_RATE = Os.INDUCTIVE_REAKTIF_RATE,
CAPACITIVE_REAKTIF_RATE = Os.CAPACITIVE_REAKTIF_RATE
}).ToList();
int totalrows = OsosList.Count;
int totalrowsafterfiltering = OsosList.Count();
OsosList = OsosList.OrderBy(sortColumnName + " " + sortDirection).ToList();
OsosList = OsosList.Skip(start).Take(length).ToList();
return(Json(new
{
data = OsosList.Select(o => new
{
ID = o.ID,
STATION_ID = o.STATION_ID,
DEMAND = o.DEMAND,
P_180 = o.P_180,
RI_580 = o.RI_580,
RC_880 = o.RC_880,
P_280 = o.P_280,
RI_680 = o.RI_680,
RC_780 = o.RC_780,
INDUCTIVE_REAKTIF_RATE = o.INDUCTIVE_REAKTIF_RATE,
CAPACITIVE_REAKTIF_RATE = o.CAPACITIVE_REAKTIF_RATE,
INSERT_DATE = o.INSERT_DATE.ToString("dd/MM/yyyy HH:mm:ss"),
CREATED_DATE = o.CREATED_DATE.ToString("dd/MM/yyyy HH:mm:ss"),
}).ToList(),
draw = Request["draw"],
recordsTotal = totalrows,
recordsFiltered = totalrowsafterfiltering
}, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var a = ex.ToString();
}
}
return(View());
}
public ActionResult GetData(string stationId)
{
int start = Convert.ToInt32(Request["start"]);
int length = Convert.ToInt32(Request["length"]);
string searchValue = Request["search[value]"];
string sortColumnName = Request["columns[" + Request["order[0][column]"] + "][data]"];
string sortDirection = Request["order[0][dir]"];
List <TBL_MODBUS_CMD_LOG> LogList = new List <TBL_MODBUS_CMD_LOG>();
int station_id = Convert.ToInt32(stationId);
using (EssoEntities db = new EssoEntities())
{
try
{
var LogList1 = (from ML in db.ModbusLog
where ML.STATION_ID == station_id
join Us in db.Users on ML.USER_ID equals Us.Id.ToString() into yG1
from y1 in yG1.DefaultIfEmpty()
join Md in db.ModbusTag on ML.ADDRESS equals Md.ADDRESS into yG2
from y2 in yG2.DefaultIfEmpty()
select new
{
ML.ID,
INSERT_DATE = ML.INSERT_DATE,
ML.OLD_VALUE,
ADDRESS = y2.NAME,
ML.STATION_ID,
UserName = y1.UserName,
ML.VALUE
}).ToList().Select(o => new
{
o.ID,
INSERT_DATE = o.INSERT_DATE,
OLD_VALUE = o.OLD_VALUE == 2 ? "KAPALI" : o.OLD_VALUE == 1 ? "AÇIK" : o.OLD_VALUE.ToString(),
ADDRESS = o.ADDRESS == null ? "-" : o.ADDRESS.ToString(),
o.STATION_ID,
UserName = o.UserName == null ? "-" : o.UserName,
VALUE = o.VALUE == 2 ? "KAPALI" : o.VALUE == 1 ? "AÇIK" : o.VALUE.ToString(),
}).ToList();
int totalrows = LogList1.Count;
if (!string.IsNullOrEmpty(searchValue))
{//filter
LogList1 = LogList1.Where(x => x.ADDRESS.ToString().ToLower().Contains(searchValue.ToLower()) || x.INSERT_DATE.ToString().ToLower().Contains(searchValue.ToLower()) || x.VALUE.ToString().ToLower().Contains(searchValue.ToLower()) ||
x.STATION_ID.ToString().ToLower().Contains(searchValue.ToLower()) || x.OLD_VALUE.ToString().ToLower().Contains(searchValue.ToLower()) || x.UserName.ToLower().Contains(searchValue.ToLower())).ToList();
}
int totalrowsafterfiltering = LogList1.Count();
LogList1 = LogList1.OrderBy(sortColumnName + " " + sortDirection).ToList();
LogList1 = LogList1.Skip(start).Take(length).ToList();
return(Json(new
{
data = LogList1.Select(o => new
{
o.ID,
INSERT_DATE = o.INSERT_DATE.ToString("dd/MM/yyyy HH:mm:ss"),
OLD_VALUE = o.OLD_VALUE,
ADDRESS = o.ADDRESS,
o.STATION_ID,
UserName = o.UserName,
VALUE = o.VALUE,
}).ToList(),
draw = Request["draw"],
recordsTotal = totalrows,
recordsFiltered = totalrowsafterfiltering
}, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var a = ex.ToString();
}
}
return(View());
}
public static float GetMonthlyTarget(EssoEntities DB, int stationId, int _ay)
{
if (_ay == 1)
{
float trgt = DB.targets.Where(a => a.IS_DELETED == false && a.STATION_ID == stationId).Select(a => a.JAN_PRODUCTION.Value).FirstOrDefault();
return((float)Math.Round(trgt, 2));
}
else if (_ay == 2)
{
float trgt = DB.targets.Where(a => a.IS_DELETED == false && a.STATION_ID == stationId).Select(a => a.FEB_PRODUCTION.Value).FirstOrDefault();
return((float)Math.Round(trgt, 2));
}
else if (_ay == 3)
{
float trgt = DB.targets.Where(a => a.IS_DELETED == false && a.STATION_ID == stationId).Select(a => a.MARCH_PRODUCTION.Value).FirstOrDefault();
return((float)Math.Round(trgt, 2));
}
else if (_ay == 4)
{
float trgt = DB.targets.Where(a => a.IS_DELETED == false && a.STATION_ID == stationId).Select(a => a.APRIL_PRODUCTION.Value).FirstOrDefault();
return((float)Math.Round(trgt, 2));
}
else if (_ay == 5)
{
float trgt = DB.targets.Where(a => a.IS_DELETED == false && a.STATION_ID == stationId).Select(a => a.MAY_PRODUCTION.Value).FirstOrDefault();
return((float)Math.Round(trgt, 2));
}
else if (_ay == 6)
{
float trgt = DB.targets.Where(a => a.IS_DELETED == false && a.STATION_ID == stationId).Select(a => a.JUNE_PRODUCTION.Value).FirstOrDefault();
return((float)Math.Round(trgt, 2));
}
else if (_ay == 7)
{
float trgt = DB.targets.Where(a => a.IS_DELETED == false && a.STATION_ID == stationId).Select(a => a.JULY_PRODUCTION.Value).FirstOrDefault();
return((float)Math.Round(trgt, 2));
}
else if (_ay == 8)
{
float trgt = DB.targets.Where(a => a.IS_DELETED == false && a.STATION_ID == stationId).Select(a => a.AUGUST_PRODUCTION.Value).FirstOrDefault();
return((float)Math.Round(trgt, 2));
}
else if (_ay == 9)
{
float trgt = DB.targets.Where(a => a.IS_DELETED == false && a.STATION_ID == stationId).Select(a => a.SEP_PRODUCTION.Value).FirstOrDefault();
return((float)Math.Round(trgt, 2));
}
else if (_ay == 10)
{
float trgt = DB.targets.Where(a => a.IS_DELETED == false && a.STATION_ID == stationId).Select(a => a.OKT_PRODUCTION.Value).FirstOrDefault();
return((float)Math.Round(trgt, 2));
}
else if (_ay == 11)
{
float trgt = DB.targets.Where(a => a.IS_DELETED == false && a.STATION_ID == stationId).Select(a => a.NOV_PRODUCTION.Value).FirstOrDefault();
return((float)Math.Round(trgt, 2));
}
else if (_ay == 12)
{
float trgt = DB.targets.Where(a => a.IS_DELETED == false && a.STATION_ID == stationId).Select(a => a.DEC_PRODUCTION.Value).FirstOrDefault();
return((float)Math.Round(trgt, 2));
}
return(0);
}
static GridViewSettings CreateStationGridSettings()
{
EssoEntities DB2 = new EssoEntities();
GridViewSettings settings = new GridViewSettings();
settings.Name = "gvStation";
settings.KeyFieldName = "ID";
settings.CallbackRouteValues = new { Controller = "Station", Action = "GridStationPartial" };
settings.Width = Unit.Percentage(100);
settings.InitNewRow += grid_InitNewRow;
settings.SettingsEditing.Mode = GridViewEditingMode.EditForm;
settings.SettingsEditing.AddNewRowRouteValues = new { Controller = "Station", Action = "SaveStation" };
settings.SettingsEditing.UpdateRowRouteValues = new { Controller = "Station", Action = "UpdateStation" };
settings.SettingsEditing.DeleteRowRouteValues = new { Controller = "Station", Action = "DeleteStation" };
settings.SettingsBehavior.ConfirmDelete = true;
settings.SettingsBehavior.AllowGroup = true;
settings.SettingsBehavior.AllowSort = true;
settings.Settings.VerticalScrollBarMode = ScrollBarMode.Visible;
settings.Settings.VerticalScrollableHeight = 500;
settings.SettingsPager.PageSize = 20;
settings.SettingsPager.Position = PagerPosition.Bottom;
//settings.SettingsPager.FirstPageButton.Visible = true;
//settings.SettingsPager.LastPageButton.Visible = true;
//settings.SettingsPager.PageSizeItemSettings.Visible = true;
//settings.SettingsPager.PageSizeItemSettings.Items = new string[] { "10", "20", "50" };
settings.Settings.ShowFilterRow = true;
settings.Settings.ShowFilterRowMenu = true;
settings.ClientSideEvents.BeginCallback = "OnStationBeginCallback";
//settings.Columns.Add(c =>
//{
// c.FieldName = "PHOTO";
// c.EditorProperties().BinaryImage(p =>
// {
// p.ImageHeight = 170;
// p.ImageWidth = 160;
// p.EnableServerResize = true;
// p.ImageSizeMode = ImageSizeMode.FitProportional;
// p.CallbackRouteValues = new { Action = "BinaryImageColumnPhotoUpdate", Controller = "Station" };
// p.EditingSettings.Enabled = true;
// p.EditingSettings.UploadSettings.UploadValidationSettings.MaxFileSize = 4194304;
// });
//});
settings.Columns.Add(c =>
{
c.FieldName = "NAME";
c.Caption = "Plant Name";
});
settings.Columns.Add(c =>
{ c.FieldName = "SIZE";
c.Caption = "Size"; c.Width = Unit.Pixel(150); });
//settings.Columns.Add(c =>
//{
// c.FieldName = "NAME";
// c.Caption = "Group Name";
// c.Visible = false;
// c.GroupIndex = 0;
// c.EditFormSettings.Visible = DefaultBoolean.False;
// c.EditorProperties().ComboBox(p =>
// {
// p.BindList(DB2.StationGroups.Where(x => x.IS_DELETED == false).Select(x => x.NAME).ToList());
// });
//});
settings.Columns.Add(column => {
column.FieldName = "GROUP_ID";
column.Caption = "Grup";
column.EditorProperties().ComboBox(p =>
{
p.TextField = "NAME";
p.ValueField = "ID";
p.ValueType = typeof(int);
p.DataSource = DB2.StationGroups.Where(x => x.IS_DELETED == false).Select(x => new { x.NAME, x.ID }).ToList();
});
});
//settings.Columns.Add(column =>
//{
// column.FieldName = "GROUP_ID";
// column.Caption = "Group";
// //column.GroupIndex = 0;
// //column.EditFormSettings.Visible = DefaultBoolean.False;
// //column.EditorProperties().ComboBox(p =>
// //{
// // p.BindList(DB2.StationGroups.Where(x => x.IS_DELETED == false).Select(x => x.NAME).ToList());
// //});
//});
settings.Columns.Add(column =>
{
column.FieldName = "USERS";
column.Caption = "Users";
column.EditFormSettings.Visible = DefaultBoolean.False;
});
settings.Columns.Add(column =>
{
column.FieldName = "IP_ADDRESS";
column.Caption = "Ip Address";
});
settings.Columns.Add(column =>
{
column.FieldName = "PORT";
column.Caption = "PORT";
});
settings.Columns.Add(column =>
{
column.FieldName = "ALARM_TEMP_ID";
column.Caption = "Alarm Tipi";
column.Visible = false;
column.EditFormSettings.Visible = DefaultBoolean.True;
});
settings.Columns.Add(column =>
{
column.FieldName = "IS_ACTIVE";
column.Caption = "Active";
column.Width = Unit.Pixel(50);
column.ColumnType = MVCxGridViewColumnType.CheckBox;
});
settings.Columns.Add(column =>
{
column.FieldName = "IS_LOCKED";
column.Caption = "Locked";
column.Width = Unit.Pixel(50);
column.ColumnType = MVCxGridViewColumnType.CheckBox;
});
settings.Columns.Add(c => { c.FieldName = "INSTALL_DATE"; c.Caption = "Installation Date"; c.Width = Unit.Pixel(200); });
settings.Columns.Add(c => { c.FieldName = "CREATED_DATE"; c.Caption = "Inserted Date"; c.Width = Unit.Pixel(200); }); //"CREATED_DATE").SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
settings.Columns.Add(column =>
{
column.FieldName = "ADDRESS";
column.Caption = "Address";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.Columns.Add(column =>
{
column.FieldName = "DESCRIPTION";
column.Caption = "Desription";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.Columns.Add(column =>
{
column.FieldName = "PLC_INTERFACE";
column.Caption = "PLC INTERFACE";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.Columns.Add(column =>
{
column.FieldName = "EKK_INTERFACE";
column.Caption = "EKK INTERFACE";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.Columns.Add(column =>
{
column.FieldName = "IRRADIATION_SCALE";
column.Caption = "Irradiation Scale(%)";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.BeforeGetCallbackResult = (sender, e) =>
{
MVCxGridView grid = (MVCxGridView)sender;
grid.GroupBy(grid.Columns["GROUP_ID"]);
};
settings.PreRender = (sender, e) =>
{
ASPxGridView grid = (ASPxGridView)sender;
grid.ExpandRow(0);
};
return(settings);
}
