/// <summary>
/// Delete the current DashboardIndicators based on the DashboardIndicators ID passed in the DashboardIndicatorsModel
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns></returns>
public ActionResult DeleteDashboardIndicators(int id)
{
using (var bal = new DashboardIndicatorsBal())
{
//Get DashboardIndicators model object by current DashboardIndicators ID
var model = bal.GetDashboardIndicatorsById(id);
var isDeleted = false;
var list = new List <DashboardIndicatorsCustomModel>();
//Check If DashboardIndicators model is not null
if (model != null)
{
model.IsActive = 0;
//Update Operation of current DashboardIndicators
isDeleted = bal.DeleteIndicator(model);
//return deleted ID of current DashboardIndicators as Json Result to the Ajax Call.
using (var dashboardIndicatorDataBal = new DashboardIndicatorDataBal())
{
dashboardIndicatorDataBal.BulkInactiveDashboardIndicatorData(model.IndicatorNumber, Helpers.GetSysAdminCorporateID());
}
bal.UpdateIndicatorsOtherDetail(model);
}
//var orderByExpression = HtmlExtensions.GetOrderByExpression<DashboardIndicatorsCustomModel>("Dashboard");
//list = HtmlExtensions.OrderByDir<DashboardIndicatorsCustomModel>(list, "ASC", orderByExpression);
//return PartialView(PartialViews.DashboardIndicatorsList, list);
return(Json(isDeleted));
}
//Pass the ActionResult with List of DashboardIndicatorsViewModel object to Partial View DashboardIndicatorsList
}
/// <summary>
/// Get the details of the DashboardIndicators View in the Model DashboardIndicators such as DashboardIndicatorsList, list of countries etc.
/// </summary>
/// <returns>
/// returns the actionresult in the form of current object of the Model DashboardIndicators to be passed to View DashboardIndicators
/// </returns>
public ActionResult IndexV1()
{
//Initialize the DashboardIndicators BAL object
using (var bal = new DashboardIndicatorsBal())
{
var corporateId = Helpers.GetSysAdminCorporateID();
//Get the Entity list
var list = bal.GetDashboardIndicatorsListByCorporate(corporateId, Helpers.GetDefaultFacilityId());
var orderByExpression = HtmlExtensions.GetOrderByExpression <DashboardIndicatorsCustomModel>("Dashboard");
var data = HtmlExtensions.OrderByDir(list, "ASC", orderByExpression);
//Intialize the View Model i.e. DashboardIndicatorsView which is binded to Main View Index.cshtml under DashboardIndicators
var viewModel = new DashboardIndicatorsView
{
DashboardIndicatorsList = data,
CurrentDashboardIndicators = new DashboardIndicators
{
IndicatorNumber = bal.GetIndicatorNextNumber(corporateId),
OwnerShip = bal.GetNameByUserId(Helpers.GetLoggedInUserId())
}
};
//Pass the View Model in ActionResult to View DashboardIndicators
return(View(viewModel));
}
}
/// <summary>
/// Determines whether [is indicator number unique] [the specified indicator number].
/// </summary>
/// <param name="indicatorNumber">The indicator number.</param>
/// <param name="id">The indicator identifier.</param>
/// <param name="subCategory1"></param>
/// <param name="subCategory2"></param>
/// <returns></returns>
public ActionResult IsIndicatorNumberExists(string indicatorNumber, int id, string subCategory1, string subCategory2)
{
using (var bal = new DashboardIndicatorsBal())
{
var isIndicatorNumberExist = bal.IsIndicatorExist(indicatorNumber, id, Helpers.GetSysAdminCorporateID(), subCategory1, subCategory2);
return(Json(isIndicatorNumberExist, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// Add New or Update the DashboardIndicators based on if we pass the DashboardIndicators ID in the DashboardIndicatorsViewModel object.
/// </summary>
/// <param name="model">The model.</param>
/// <returns>
/// returns the newly added or updated ID of DashboardIndicators row
/// </returns>
public ActionResult SaveDashboardIndicatorsV1(DashboardIndicators model)
{
var userId = Helpers.GetLoggedInUserId();
var currentDate = Helpers.GetInvariantCultureDateTime();
var list = new List <DashboardIndicatorsCustomModel>();
//Check if Model is not null
if (model != null)
{
model.CorporateId = Helpers.GetSysAdminCorporateID();
using (var bal = new DashboardIndicatorsBal())
{
if (model.IndicatorID == 0)
{
model.CreatedBy = userId;
model.CreatedDate = currentDate;
}
using (var dashboardIndicatorDataBal = new DashboardIndicatorDataBal())
{
switch (model.IsActive)
{
case 0:
dashboardIndicatorDataBal.BulkInactiveDashboardIndicatorData(model.IndicatorNumber,
Helpers.GetSysAdminCorporateID());
break;
default:
dashboardIndicatorDataBal.BulkActiveDashboardIndicatorData(model.IndicatorNumber,
Helpers.GetSysAdminCorporateID());
break;
}
}
using (var oDashboardIndicatorDataBal = new DashboardIndicatorDataBal())
{
oDashboardIndicatorDataBal.GenerateIndicatorEffects(model);
}
list = bal.SaveDashboardIndicatorsV1(model);
//Add by shashank to check the Special case for the Indicator i.e. is the Target/Budget is static for indicator
//.... Should only Call for Dashboard type = Budget (Externalvalue1='1')
if (!string.IsNullOrEmpty(model.IndicatorNumber) && model.ExternalValue4.ToLower() == "true")
{
using (var ibal = new DashboardIndicatorDataBal())
ibal.SetStaticBudgetTargetIndciators(model);
}
using (var oDashboardIndicatorDataBal = new DashboardIndicatorDataBal())
{
oDashboardIndicatorDataBal.GenerateIndicatorEffects(model);
oDashboardIndicatorDataBal.UpdateCalculateIndicatorUpdate(model);
}
//Call the AddDashboardIndicators Method to Add / Update current DashboardIndicators
var orderByExpression = HtmlExtensions.GetOrderByExpression <DashboardIndicatorsCustomModel>("Dashboard");
list = HtmlExtensions.OrderByDir <DashboardIndicatorsCustomModel>(list, "ASC", orderByExpression);
}
}
//Pass the ActionResult with List of DashboardIndicatorsViewModel object to Partial View DashboardIndicatorsList
return(PartialView(PartialViews.DashboardIndicatorsList, list));
}
public ActionResult CheckDuplicateSortOrder(int sortOrder, int indicatorIdPk)
{
var result = false;
using (var bal = new DashboardIndicatorsBal())
result = bal.CheckDuplicateSortOrder(sortOrder, indicatorIdPk);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult BindDashboardIndicatorsList()
{
var list = new List <DashboardIndicatorsCustomModel>();
var oDashboardIndicatorsBal = new DashboardIndicatorsBal();
Int32 corporateId = Helpers.GetSysAdminCorporateID();
Int32 facilityId = 0;
list = oDashboardIndicatorsBal.GetDashboardIndicatorsListByCorporate(corporateId, facilityId);
return(PartialView(PartialViews.DashboardIndicatorsList, list));
}
public ActionResult BindDataIndicatorsByOrder(string sort, string sortdir, int showInActive)
{
using (var bal = new DashboardIndicatorsBal())
{
//Get the Entity list
var list = bal.GetDashboardIndicatorsListActiveInActiveNew(Helpers.GetSysAdminCorporateID(), sort, sortdir, showInActive);
//Pass the View Model in ActionResult to View DashboardIndicators
return(PartialView(PartialViews.DashboardIndicatorsList, list));
}
}
/// <summary>
/// Gets the dashboard indicators details by number.
/// </summary>
/// <param name="number">The number.</param>
/// <returns></returns>
public JsonResult GetDashboardIndicatorsDetailsByNumber(string number)
{
using (var bal = new DashboardIndicatorsBal())
{
//Call the AddDashboardIndicators Method to Add / Update current DashboardIndicators
var current = bal.GetDashboardIndicatorsByNumber(number);
//Pass the ActionResult with the current DashboardIndicatorsViewModel object as model to PartialView DashboardIndicatorsAddEdit
return(Json(current));
}
}
/// <summary>
/// Gets the indicatorby corporate.
/// </summary>
/// <returns></returns>
public ActionResult GetIndicatorbyCorporate()
{
using (var bal = new DashboardIndicatorsBal())
{
//Get the Entity list
var list = bal.GetDashboardIndicatorsListByCorporate(Helpers.GetSysAdminCorporateID(), Helpers.GetDefaultFacilityId());
//Pass the View Model in ActionResult to View DashboardIndicators
var orderByExpression = HtmlExtensions.GetOrderByExpression <DashboardIndicatorsCustomModel>("Dashboard");
var data = HtmlExtensions.OrderByDir <DashboardIndicatorsCustomModel>(list, "ASC", orderByExpression);
//Pass the View Model in ActionResult to View DashboardIndicators
return(PartialView(PartialViews.DashboardIndicatorsList, data));
}
}
/// <summary>
/// Binds the indicators by order.
/// </summary>
/// <param name="sort">The sort.</param>
/// <param name="sortdir">The sortdir.</param>
/// <param name="showInActive"></param>
/// <returns></returns>
public ActionResult BindIndicatorsByOrder(string sort, string sortdir, int showInActive)
{
using (var bal = new DashboardIndicatorsBal())
{
//Get the Entity list
var list = bal.GetDashboardIndicatorsListActiveInActive(Helpers.GetSysAdminCorporateID(), showInActive);
//Intialize the View Model i.e. DashboardIndicatorsView which is binded to Main View Index.cshtml under DashboardIndicators
var orderByExpression = HtmlExtensions.GetOrderByExpression <DashboardIndicatorsCustomModel>(sort);
var data = HtmlExtensions.OrderByDir <DashboardIndicatorsCustomModel>(list, sortdir, orderByExpression);
//Pass the View Model in ActionResult to View DashboardIndicators
return(PartialView(PartialViews.DashboardIndicatorsList, data));
}
}
/// <summary>
/// Gets the indicators.
/// </summary>
/// <returns></returns>
public ActionResult GetIndicators()
{
using (var bal = new DashboardIndicatorsBal())
{
var indicatorsObjList = bal.GetDashboardIndicatorsListByCorporate(Helpers.GetSysAdminCorporateID(), 0);
var list = new List <SelectListItem>();
if (indicatorsObjList.Any())
{
list.AddRange(indicatorsObjList.Select(item => new SelectListItem
{
Text = item.Dashboard,
Value = item.IndicatorNumber
}));
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
public void CheckActiveInactive()
{
model.IndicatorNumber = "227";
model.CorporateId = 12;
model.FacilityId = 17;
model.IsActive = 1;
model.SubCategory1 = "0";
model.SubCategory2 = "0";
using (var dashbal = new DashboardIndicatorsBal())
{
//dashbal.MakeIndicatorInActive(model);
using (var mBal = new ManualDashboardBal())
{
IEnumerable <DashboardIndicatorData> mList
= mBal.GetIndicatorsDataForIndicatorNumber(Convert.ToInt32(model.CorporateId), Convert.ToInt32(model.FacilityId),
"2016", model.IndicatorNumber, "1", "0", "0");
Assert.IsNotNull(mList);
dashbal.UpdateIndicatorsOtherDetail(model);
IEnumerable <DashboardIndicatorData> mList1
= mBal.GetIndicatorsDataForIndicatorNumber(Convert.ToInt32(model.CorporateId), Convert.ToInt32(model.FacilityId),
"2016", model.IndicatorNumber, "1", "0", "0");
DashboardIndicatorData dashboardObj = mList.FirstOrDefault();
if (dashboardObj != null)
{
Assert.AreEqual(dashboardObj.IsActive, false);
}
model.IsActive = 0;
dashbal.UpdateIndicatorsOtherDetail(model);
//if (Convert.ToBoolean(mList.))
// {
// model.IsActive = 1;
// dashbal.MakeIndicatorInActive(model);
// }
}
}
}
/// <summary>
/// Exports to excel.
/// </summary>
/// <returns></returns>
public ActionResult ExportToExcel(int?showInActive)
{
var workbook = new HSSFWorkbook();
var sheet = workbook.CreateSheet("DashboardIndicatorsData");
var format = workbook.CreateDataFormat();
sheet.CreateFreezePane(0, 1, 0, 1);
sheet.SetAutoFilter(CellRangeAddress.ValueOf("A1:L1"));
// Add header labels
var rowIndex = 0;
var row = sheet.CreateRow(rowIndex);
row.CreateCell(0).SetCellValue("Indicator Number");
row.CreateCell(1).SetCellValue("Dashboard");
row.CreateCell(2).SetCellValue("Description");
row.CreateCell(3).SetCellValue("Defination");
row.CreateCell(4).SetCellValue("Sub Category 1");
row.CreateCell(5).SetCellValue("Sub Category 2");
row.CreateCell(6).SetCellValue("Format Type");
row.CreateCell(7).SetCellValue("Decimal Numbers");
row.CreateCell(8).SetCellValue("Ferquency Type");
row.CreateCell(9).SetCellValue("OwnerShip");
row.CreateCell(10).SetCellValue("Facility");
row.CreateCell(11).SetCellValue("SortOrder");
rowIndex++;
using (var bal = new DashboardIndicatorsBal())
{
var indicatorsData = bal.GetDashboardIndicatorsListActiveInActive(Helpers.GetSysAdminCorporateID(), showInActive);
indicatorsData = indicatorsData.OrderBy(x => Convert.ToInt32(x.IndicatorNumber)).ToList();
var cellStyle = workbook.CreateCellStyle();
cellStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("0.00");
foreach (var item in indicatorsData)
{
row = sheet.CreateRow(rowIndex);
row.CreateCell(0).SetCellType(CellType.Numeric);
row.CreateCell(0).CellStyle = cellStyle;
row.CreateCell(0).SetCellValue(Convert.ToDouble(item.IndicatorNumber));
row.CreateCell(1).SetCellValue(item.Dashboard);
row.CreateCell(2).SetCellValue(item.Description);
row.CreateCell(3).SetCellValue(item.Defination);
row.CreateCell(4).SetCellValue(item.SubCategoryFirst);
row.CreateCell(5).SetCellValue(item.SubCategorySecond);
row.CreateCell(6).SetCellValue(item.FormatTypeStr);
row.CreateCell(7).SetCellType(CellType.Numeric);
row.CreateCell(7).CellStyle = cellStyle;
row.CreateCell(7).SetCellValue(item.DecimalNumbers);
row.CreateCell(8).SetCellValue(item.FerquencyTypeStr);
row.CreateCell(9).SetCellValue(item.OwnerShip);
row.CreateCell(10).SetCellValue(item.FacilityNameStr);
row.CreateCell(11).SetCellValue(Convert.ToInt32(item.SortOrder));
rowIndex++;
}
}
using (var exportData = new MemoryStream())
{
var currentDateTime = Helpers.GetInvariantCultureDateTime();
var cookie = new HttpCookie("Downloaded", "True");
Response.Cookies.Add(cookie);
workbook.Write(exportData);
var saveAsFileName = string.Format("DashboardIndicatorsData-{0:d}.xls", currentDateTime).Replace("/", "-");
return(File(exportData.ToArray(), "application/vnd.ms-excel", string.Format("{0}", saveAsFileName)));
}
}
