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