/// <summary>
/// Created by: VIJAYA
/// Created On: 2018/04/19
/// To Delete an Indicator from Dashboard Widgets List...
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int DeleteDBWidgetIndicator(int DashboardWidgetsListId, string CompanyShortCode, int UserID)
{
try
{
System.Data.Objects.ObjectResult <int?> returnValue = objEntities.uspDeleteDBWidgetsListByCompanyAndUserID(DashboardWidgetsListId, CompanyShortCode, UserID);
var result = returnValue.FirstOrDefault <int?>();
if (result.HasValue)
{
if (result > 0)
{
//on Success
return(1);
}
else
{
// when the user is trying to add same UserRole name then donot allow to insert/Add
return(0);
}
}
else
{
// on failure
return(0);
}
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// Created By : Raghuveer
/// Created On : 22 June 2017
/// For Delete Favourite List name based on CompanyShortCode, UserID and FavouriteListName
/// </summary>
/// <param name="CompanyShortCode"></param>
/// <param name="UserID"></param>
/// <param name="FavouriteListName"></param>
/// <returns></returns>
public int DeleteFavouriteList(string CompanyShortCode, int UserID, string FavouriteListName)
{
try
{
System.Data.Objects.ObjectResult <int?> returnValue = objEntities.uspDeleteFavoriteListByCompanyAndUserID(CompanyShortCode, UserID, FavouriteListName);
var result = returnValue.FirstOrDefault <int?>();
if (result.HasValue)
{
if (result > 0)
{
//on Success
return(1);
}
else
{
// when the user is trying to add same UserRole name then donot allow to insert/Add
return(0);
}
}
else
{
// on failure
return(0);
}
}
catch (Exception ex)
{
return(0);
}
return(1);
}
/// <summary>
/// Created By : Raghuveer
/// Created Date : 21 July 2017
/// For Getting AllResults table count based on CustomerDataSetID
/// </summary>
/// <returns></returns>
public int GetAllResultsCount(int CustomerDataSetID)
{
int finalResult = 0;
try
{
System.Data.Objects.ObjectResult <int?> returnValue = objEntities.uspSelectAllResultsCountByDataSetID(CustomerDataSetID);
var result = returnValue.FirstOrDefault <int?>();
if (result.HasValue)
{
if (result > 0)
{
//on Success
return(1);
}
else
{
// when the user is trying to add same UserRole name then donot allow to insert/Add
return(0);
}
}
else
{
// on failure
return(0);
}
}
catch (Exception ex)
{
throw ex;
}
return(finalResult);
}
/// <summary>
/// Created By: Vijaya
/// Created On:04/03/2018
/// Clear specific Dataset's analysis and returns the result
/// </summary>
/// <param name="customerDataSetID"></param>
/// <returns></returns>
public int ClearDataSetAnalysis(int customerDataSetID)
{
int finalResult = 0;
try
{
//System.Data.Objects.ObjectResult<int?>
System.Data.Objects.ObjectResult <int?> ID = objEntities.uspClearDataSetAnalysis(customerDataSetID);
var result = ID.FirstOrDefault <int?>();
if (result.HasValue)
{
if (result > 0)
{
finalResult = result.Value;
}
}
else
{
finalResult = 0;
}
}
catch (Exception ex)
{
throw ex;
}
return(finalResult);
}
/// <summary>
/// Created By:Vishnu
/// Created On: 23-Aug-2016
/// Inserts the Customer Datasets to DataBase
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int InsertInsertCustomerDataSet(TemplateModel model)
{
int finalResult = 0;
try
{
//System.Data.Objects.ObjectResult<int?>
System.Data.Objects.ObjectResult <int?> ID = objEntities.uspInsertCustomerDataSet(model.AccountID, model.DivisionID, model.DatasetName, model.DatasetDescription, model.CustomerID, model.CompanyName, model.DataType,
model.Base, model.Units, model.CompanyWebsite, model.MonthYears, model.AdjValues, model.UserName, model.IsDataPortalAdmin, model.CreatedBy, model.CreatedDate, model.AccountName);
var result = ID.FirstOrDefault <int?>();
if (result.HasValue)
{
if (result > 0)
{
//on Success
finalResult = result.Value;
}
}
else
{
// on failure
finalResult = 0;
}
}
catch (Exception ex)
{
throw ex;
}
return(finalResult);
}
/// <summary>
/// Created By : Raghuveer
/// Created On : 7 -June 2017
/// For Adding Favourite List Name from ITR Customer Portal
/// </summary>
/// <param name="Company"></param>
/// <param name="Indicators"></param>
/// <param name="UserID"></param>
/// <param name="FavouriteListName"></param>
/// <param name="CreatedBy"></param>
/// <param name="CreatedDate"></param>string Company,string Indicators,int UserID,string FavouriteListName,string CreatedBy,DateTime CreatedDate
/// <returns></returns>
public int InsertFavouriteList(string Company, string Indicators, int UserID, string FavouriteListName, string CreatedBy, DateTime CreatedDate)
{
int finalResult = 0;
try
{
//System.Data.Objects.ObjectResult<int?>
System.Data.Objects.ObjectResult <int?> ID = objEntities.uspInsertFavouriteListForDatacast(Company, Indicators, UserID, FavouriteListName, CreatedBy, CreatedDate);
var result = ID.FirstOrDefault <int?>();
if (result.HasValue)
{
if (result > 0)
{
//on Success
finalResult = result.Value;
}
}
else
{
// on failure
finalResult = 0;
}
}
catch (Exception ex)
{
throw ex;
}
return(finalResult);
}
/// <summary>
/// Created By:Nagendra
/// Created On: 30-Aug-2016
/// Delete the row from Customer Datasets
/// </summary>
/// <param name="prodID"></param>
/// <returns></returns>
public int DeleteRowFromDataSet(int prodID)
{
int finalResult = 0;
try
{
System.Data.Objects.ObjectResult <int?> ID = objEntities.uspDeleteRowFromDataSet(prodID);
var result = ID.FirstOrDefault <int?>();
if (result.HasValue)
{
if (result > 0)
{
finalResult = result.Value;
}
}
else
{
finalResult = 0;
}
}
catch (Exception ex)
{
throw ex;
}
return(finalResult);
}
/// <summary>
/// Created By:Nagendra
/// Created On: 29-Aug-2016
/// Updates the Customer Datasets
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateCustomerDataSet(UpdateDataset model)
{
int finalResult = 0;
try
{
System.Data.Objects.ObjectResult <int?> ID = objEntities.uspUpdateCustomerDataSet(model.ProdID, model.MonthYears, model.AdjValues, model.DatasetDescription, model.ModifiedBy, model.ModifiedDate);
var result = ID.FirstOrDefault <int?>();
if (result.HasValue)
{
if (result > 0)
{
//on Success
finalResult = result.Value;
}
}
else
{
// on failure
finalResult = 0;
}
}
catch (Exception ex)
{
throw ex;
}
return(finalResult);
}
public int InsertStudentCTESetupRequest(int StudentId, int CTEProgramOptionPL, int CTEStudentProgramStatusPL, int CreatedBy, DateTime CreatedDate)
{
int finalResult = 0;
try
{
System.Data.Objects.ObjectResult <int?> requestId = objEntities.uspInsertStudentCTESetupRequest(StudentId,
CTEProgramOptionPL,
CTEStudentProgramStatusPL,
CreatedBy,
CreatedDate);
var result = requestId.FirstOrDefault <int?>();
if (result.HasValue)
{
if (result > 0)
{
//on Success
finalResult = result.Value;
}
}
else
{
// on failure
finalResult = 0;
}
return(finalResult);
}
catch (Exception ex)
{
finalResult = 0;
throw ex;
}
}
/// <summary>
/// Created By : Raghuveer
/// Created On : 8 Dec 2017
/// For Insert Last Popup Accessed Date
/// </summary>
/// <param name="CompanyShortCode"></param>
/// <param name="UserID"></param>
/// <param name="FavouriteListName"></param>
/// <returns></returns>
public int InsertPopupAccessDate(int UserID, string CompanyShortCode, DateTime LastAccessDate, int CreatedBy, DateTime CreatedDate)
{
try
{
System.Data.Objects.ObjectResult <int?> returnValue = objEntities.uspInsertPopupAccessingDate(UserID, CompanyShortCode, LastAccessDate, CreatedBy, CreatedDate);
var result = returnValue.FirstOrDefault <int?>();
if (result.HasValue)
{
if (result > 0)
{
//on Success
return(1);
}
else
{
// when the user is trying to add same UserRole name then donot allow to insert/Add
return(0);
}
}
else
{
// on failure
return(0);
}
}
catch (Exception ex)
{
return(0);
}
return(1);
}
public static List <FavoritesForPage> GetFavoritesByCookies(string uid)
{
using (var ctx = new RentooloEntities())
{
System.Data.Objects.ObjectResult <spGetFavoritesByCookies_Result> result = ctx.spGetFavoritesByCookies(uid);
List <FavoritesForPage> list = new List <FavoritesForPage>();
foreach (var item in result)
{
list.Add(new FavoritesForPage
{
Id = item.Id,
AdvertId = item.AdvertId,
CreatedFavorites = item.CreatedFavorites,
Category = item.Category,
Name = item.Name,
Description = item.Description,
CreatedAdverts = item.CreatedAdverts.Value,
CreatedUserId = item.CreatedUserId.Value,
Price = item.Price.Value,
Address = item.Address,
Phone = item.Phone,
MessageType = item.MessageType.Value,
Position = item.PositionString
});
}
return(list);
}
}
public string GuardarInfraestructuraDetalle(Infraestructura_Detalle infraestructuraDetalle)
{
System.Data.Objects.ObjectResult objectResponse = _entitiesManager.Context.InsertInfraDetalle(infraestructuraDetalle.Id_Infra, infraestructuraDetalle.Tamano, infraestructuraDetalle.Descripcion);
foreach (string r in objectResponse)
{
return(r);
}
return("");
}
public bool ModificarEdificio(Edificio edificio)
{
System.Data.Objects.ObjectResult objectResponse = _entitiesManager.Context.msp_ModificarEdificio(edificio.Id, edificio.Inmueble.Id_Ubi_Detalle, edificio.Nombre, edificio.Inmueble.A_Construccion, edificio.N_Plantas, edificio.Inmueble.Inf_adicional, edificio.Inmueble.Foto, edificio.Inmueble.Id);
foreach (int r in objectResponse)
{
return(r == 1 ? true : false);
}
return(false);
}
public string GuardarApartamento(Apartamento apartamento)
{
System.Data.Objects.ObjectResult objectResponse = _entitiesManager.Context.InsertApartamento(apartamento.Id_Edificio, apartamento.N_Piso, apartamento.N_Puerta, apartamento.Bloque);
foreach (string r in objectResponse)
{
return(r);
}
return("");
}
public string GuardarFotosEdificio(Foto_Edificio fedificio)
{
System.Data.Objects.ObjectResult objectResponse = _entitiesManager.Context.InsertFotoEdificio(fedificio.Id_Edificio, fedificio.Foto, fedificio.Descripcion);
foreach (string r in objectResponse)
{
return(r);
}
return("");
}
public string GuardarCasa(Casa casa)
{
System.Data.Objects.ObjectResult objectResponse = _entitiesManager.Context.InsertCasa(casa.Id_TipoCasa, casa.Mts2, casa.Inmueble.Id_Ubi_Detalle, casa.Inmueble.A_Construccion, casa.Inmueble.Inf_adicional, casa.Inmueble.Foto, casa.Inmueble.Direccion);
foreach (string r in objectResponse)
{
return(r);
}
return("");
}
public string GuardarFotosApartamento(Fotos_Apartamento foto_Apart)
{
System.Data.Objects.ObjectResult objectResponse = _entitiesManager.Context.InsertFotosApartamento(foto_Apart.Foto, foto_Apart.Id_Infra_Detalle, foto_Apart.Id_Apartamento, foto_Apart.Descripcion);
foreach (string r in objectResponse)
{
return(r);
}
return("");
}
public string GuardarServicio(Servicios servicio)
{
System.Data.Objects.ObjectResult objectResponse = _entitiesManager.Context.InsertServicio(servicio.Nombre, servicio.Tipo, servicio.Descripcion);
foreach (string r in objectResponse)
{
return(r);
}
return("");
}
public string GuardarInfraestructuraApartamento(Infraestructura_Apartamento infraestructuraApartamento)
{
System.Data.Objects.ObjectResult objectResponse = _entitiesManager.Context.InsertInfra_Apartamento(infraestructuraApartamento.Id_Apartamento, infraestructuraApartamento.Id_Infrac_Detalle, infraestructuraApartamento.Cantidad);
foreach (string r in objectResponse)
{
return(r);
}
return("");
}
public string GuardarEdificio(Edificio edificio, string pathImageOrigen)
{
//System.IO.File.Copy(pathImageOrigen, edificio.mainfoto, true);
System.Data.Objects.ObjectResult objectResponse = _entitiesManager.Context.InsertEdificio(edificio.Inmueble.Id_Ubi_Detalle, edificio.Nombre, edificio.Inmueble.A_Construccion, edificio.N_Plantas, edificio.Inmueble.Inf_adicional, edificio.Inmueble.Foto, edificio.Inmueble.Direccion);
foreach (string r in objectResponse)
{
return(r);
}
return("");
}
// Task 10 - Create a stored procedures in the Northwind database for finding the
// total incomes for given supplier name and period (start date, end date).
// Implement a C# method that calls the stored procedure and returns the retuned record set.
public static System.Data.Objects.ObjectResult <decimal?> GetTotalIncome(DateTime?startDate, DateTime?endDate, string companyName)
{
System.Data.Objects.ObjectResult <decimal?> result = null;
NorthwindEntities northwindDb = new NorthwindEntities();
using (northwindDb)
{
result = northwindDb.usp_GetTotalIncome(startDate, endDate, companyName);
}
return(result);
}
public bool EliminarEdificio(string Id_Edificio)
{
try
{
System.Data.Objects.ObjectResult objectResponse = _entitiesManager.Context.sp_EliminarEdificio(Id_Edificio);
foreach (int r in objectResponse)
{
return(r == 1 ? true : false);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
}
public static string GenerateRequestCode(int storeID)
{
PGSDBEntities dbContext = EQ_MainForm.dbContext;
string year = DateTime.Now.Year.ToString().Substring(2);
System.Data.Objects.ObjectResult <int?> maxRequestCodeObjectResult = (dbContext.GetMaxRequestCode(storeID));
int?maxRequestCodeNumber = maxRequestCodeObjectResult.First();
int newRequestNumber = 1;
if (maxRequestCodeNumber.HasValue)
{
newRequestNumber = maxRequestCodeNumber.Value + 1;
}
string storeCode = dbContext.Stores.First(s => s.Store_ID == storeID).StoreCode;
return(newRequestNumber + storeCode + year);
}
public static List <ArticleCategory> GetAllChildrenNodesOfSelectedNode(string CategoryCode, string CultureCode, string Status)
{
using (ArticleEntities dbContext = new ArticleEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
System.Data.Objects.ObjectResult <ArticleCategory> obj_result = dbContext.ArticleCategories_GetAllChildrenNodesOfSelectedNode(CategoryCode);
var query = obj_result.AsQueryable();
if (!string.IsNullOrEmpty(CultureCode))
{
query = query.Where(x => x.CultureCode.Trim() == CultureCode);
}
if (!string.IsNullOrEmpty(Status))
{
query = query.Where(x => x.Status.Trim() == Status);
}
return(query.ToList());
}
}
public List <ArticleComment> GetListByArticleIdStatus(int ArticleId, string status)
{
using (ArticleEntities dbContext = new ArticleLibrary.ArticleEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
System.Data.Objects.ObjectResult <ArticleComment> obj_result = dbContext.sp_ArticleComments_GetList();
IQueryable <ArticleComment> query = obj_result.AsQueryable();
if (ArticleId > 0)
{
query = query.Where(x => x.ArticleId == ArticleId);
}
if (!string.IsNullOrEmpty(status))
{
query = query.Where(x => x.Publish == status);
}
return(query.ToList());
}
}
internal object AddAgencyRoute()
{
try
{
System.Data.Objects.ObjectResult <decimal?> result = Context.AgencyRouteInsert(this.AgencyID,
this.RouteID,
this.Date,
this.TravilTime,
this.AvailableTickets,
this.Price,
this.Description);
return(new { Status = 1, RouteID = result });
}
catch (Exception ex)
{
return(ExcptionHandler.OnModelMethodeException(ex));
}
}
/// <summary>
/// Created by: Ram Mohan
/// Created On: 01-09-2016
/// Inserts the Exception Log Details
/// </summary>
/// <param name=""></param>
/// <param name="model"></param>
public int InsertExceptionLogDetails(string CustomerID, string ExceptionMessage, string PageName, string CreatedBy)
{
System.Data.Objects.ObjectResult <int?> newRoleID = objEntities.uspInsertExceptionLog(CustomerID, ExceptionMessage, PageName, CreatedBy, DateTime.Now);
var result = newRoleID.FirstOrDefault <int?>();
if (result.HasValue)
{
if (result > 0)
{
//on Success
return(1);
}
else
{
// when the user is trying to add same UserRole name then donot allow to insert/Add
return(2);
}
}
else
{
// on failure
return(0);
}
}
public ActionResult History()
{
string shebei_code = Request["code"] ?? "";
ViewData["shebei_code"] = shebei_code;
string start_time = Request["start_time"] ?? DateTime.Now.ToShortDateString();
string end_time = Request["end_time"] ?? DateTime.Now.AddDays(1).ToShortDateString();
string Chang = (Request["Chang"] ?? "").Trim();
string Zhan = (Request["Zhan"] ?? "").Trim();
string GuoLu = (Request["GuoLu"] ?? "").Trim();
string ShuXing = (Request["ShuXing"] ?? "").Trim();
var sx_list = new List <object>();
List <string> Chang_list = null;
List <string> Zhan_list = null;
List <string> GuoLu_list = null;
Dictionary <string, string> ShuXing_list = null;
//获取该锅炉的24小时数据
using (var context = new gatewayEntities())
{
System.Data.Objects.ObjectResult <ShuXingData> time_list = null;
if (!string.IsNullOrEmpty(ShuXing))
{
time_list = context.ExecuteStoreQuery <ShuXingData>("select " + ShuXing + " as ShuXing, ShiJian from Data1 where Chang={0} and Zhan={1} and GuoLu={2} and ShiJian>={3} and ShiJian<{4}", Chang, Zhan, GuoLu, start_time + " 00:00:00", end_time + " 00:00:00");
}
if (time_list != null)
{
var tempList = time_list.ToList();
foreach (var item in tempList)
{
string temp_str = ((DateTime)item.ShiJian).Day.ToString() + "日" + ((DateTime)item.ShiJian).Hour + "时";
sx_list.Add(new { x = temp_str, y = item.ShuXing });
}
}
GuoLu_list = context.Data1.Select(i => i.GuoLu.Trim()).Distinct().ToList();
Chang_list = context.Data1.Select(i => i.Chang.Trim()).Distinct().ToList();
Zhan_list = context.Data1.Select(i => i.Zhan.Trim()).Distinct().ToList();
GuoLu_list = context.Data1.Select(i => i.GuoLu.Trim()).Distinct().ToList();
ShuXing_list = new Dictionary <string, string>();
#region 属性配置
ShuXing_list.Add("ZQWD01", "蒸汽温度℃");
ShuXing_list.Add("YQHY20", "烟气含氧量%");
ShuXing_list.Add("ZQGD17", "蒸汽干度%");
ShuXing_list.Add("ZQYL02", "蒸汽压力Mpa");
ShuXing_list.Add("GSLL10", "给水流量t/h");
ShuXing_list.Add("FSWD09", "辐入温度℃");
ShuXing_list.Add("DRWD08", "对流入口温度℃");
ShuXing_list.Add("DCWD07", "对流出口温度℃");
ShuXing_list.Add("RYYL", "燃油压力Mpa");
ShuXing_list.Add("GBWD05", "管壁温度℃");
ShuXing_list.Add("WKWD04", "瓦口温度℃");
ShuXing_list.Add("PYWD03", "排烟温度℃");
ShuXing_list.Add("RQLJ", "燃气累计m3");
ShuXing_list.Add("RYLJ", "燃油累计t");
ShuXing_list.Add("SLLJQ", "水量累计t(燃气时)");
ShuXing_list.Add("SLLJY", "水量累计t(燃油时)");
ShuXing_list.Add("RQDH", "燃气单耗m3/t");
ShuXing_list.Add("RYDH", "燃油单耗m3/t");
ShuXing_list.Add("YDDH", "用电单耗 kw.h/t");
ShuXing_list.Add("YDLJ", "用电累计kw.h");
ShuXing_list.Add("GFPL14", "鼓风频率");
//ShuXing_list.Add("RYLJ", "燃油流量t/h");??????????????????????????????????
ShuXing_list.Add("RYLL16", "燃气流量m3/h");
#endregion
}
var seri = new System.Web.Script.Serialization.JavaScriptSerializer();
var day_arr = new
{
xScale = "ordinal",
type = "line-dotted",
yScale = "linear",
main = new List <object>()
{
new { data = sx_list }
}
};
ViewData["Chang"] = Chang;
ViewData["Zhan"] = Zhan;
ViewData["GuoLu"] = GuoLu;
ViewData["ShuXing"] = ShuXing;
ViewData["time_data"] = seri.Serialize(day_arr);
ViewData["action"] = "history_data";
ViewData["Chang_list"] = Chang_list;
ViewData["Zhan_list"] = Zhan_list;
ViewData["GuoLu_list"] = GuoLu_list;
ViewData["ShuXing_list"] = ShuXing_list;
ViewData["GuoLu"] = GuoLu;
ViewData["start_time"] = start_time;
ViewData["end_time"] = end_time;
return(View());
}
