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