public ActionResult AuthorizeIndex(string u)
{
MstIndexDAO indexMasterDAO = new MstIndexDAO(this.mapper);
SysUserModels userSession = (SysUserModels)Session["UserSession"];
string indexCode = StringUtils.base64Decode(u);
bool result = indexMasterDAO.UpdateIndexMaster(
indexCode// string indexCode
, null// string indexTypeCode
, null// string indexName
, -1// string seqNo
, Constants.Type.Authority// string securityType
, null// string indexStatus
, userSession.userCode// string userCode
, null
);
return this.Json(result, JsonRequestBehavior.AllowGet);
}
public Title CreateThumbColumnTitle(string indexCode, float fontSize, string term)
{
Title title = new Title();
MstIndexDAO mstIndexDAO = new MstIndexDAO(this.mapper);
MstIndexModels mstIndex = mstIndexDAO.GetIndexMaster(indexCode, null, null, term);
title.Text = mstIndex.indexName;
title.ShadowColor = Color.FromArgb(32, 0, 0, 0);
title.Font = new Font("Trebuchet MS", fontSize, FontStyle.Bold);
title.ShadowOffset = 3;
title.ForeColor = Color.FromArgb(26, 59, 105);
return title;
}
/**
* Create bar chart
* **/
public FileResult CreateColumnChart(string indexCode, int width, int height, string fontSize, string term)
{
indexCode = StringUtils.base64Decode(indexCode);
SeriesChartType chartType = SeriesChartType.Column;
Chart chart = new Chart();
chart.Width = width;//900;
chart.Height = height;//300;
//chart.BackColor = Color.FromArgb(211, 223, 240);
chart.BackColor = ColorTranslator.FromHtml("#80C0DB");
chart.BorderlineDashStyle = ChartDashStyle.Solid;
chart.BackSecondaryColor = Color.White;
chart.BackGradientStyle = GradientStyle.TopBottom;
chart.BorderlineWidth = 1;
chart.Palette = ChartColorPalette.BrightPastel;
chart.BorderlineColor = Color.FromArgb(26, 59, 105);
chart.RenderType = RenderType.BinaryStreaming;
chart.BorderSkin.SkinStyle = BorderSkinStyle.Emboss;
chart.AntiAliasing = AntiAliasingStyles.All;
chart.TextAntiAliasingQuality = TextAntiAliasingQuality.Normal;
MemoryStream ms = new MemoryStream();
// Check index
MstIndexDAO mstIndexDAO = new MstIndexDAO(this.mapper);
string userCode = string.Empty;
if (Session != null) {
SysUserModels userSession = (SysUserModels) Session["UserSession"];
if (userSession != null && userSession.userCode != null)
{
userCode = userSession.userCode;
}
}
// If not right -> redirect to Rule page
if (!mstIndexDAO.IsUserHasIndexRight(userCode, indexCode))
{
chart.Titles.Add(this.CreateNoAuthorizeTitle());
chart.SaveImage(ms);
return File(ms.GetBuffer(), @"image/png");
}
IdxIndexDAO indexDAO = new IdxIndexDAO(this.mapper);
DateTime? indexTime = null;
//if (StringUtils.IsEmpty(userCode))
//{
// indexTime = DateUtils.GetLastFriday();
//}
IList<IndexChartModels> indexList = indexDAO.GetIndexListChart(indexCode, indexTime, term);
IList<MoneyChartModels> moneyList = indexDAO.GetMoneyListChart(indexCode, indexTime, term);
if (indexList.Count != 0)
{
chart.Titles.Add(this.CreateColumnTitle(indexCode, float.Parse(fontSize), indexList[indexList.Count - 1].strIndexTime, term));
}
else
{
chart.Titles.Add(this.CreateColumnTitle(indexCode, float.Parse(fontSize), string.Empty, term));
}
//chart.Legends.Add(this.CreateLegend());
chart.Series.Add(this.CreateColumnSeries(indexList, chartType));
if (this.isShowMoneyLine(moneyList))
{
chart.Series.Add(this.CreateLineSeries(moneyList, SeriesChartType.Line));
}
// *** The following code should not normally be modified ***
chart.ChartAreas.Add(this.CreateColumnChartArea());
chart.SaveImage(ms);
return File(ms.GetBuffer(), @"image/png");
}
public ActionResult SearchMaster(MstIndexSearchModels model)
{
MstIndexTypeDAO indexTypeDAO = new MstIndexTypeDAO(this.mapper);
model.indexTypeList = indexTypeDAO.GetIndexTypeList(null, Constants.Status.Active);
MstIndexTypeModels allType = new MstIndexTypeModels();
model.indexTypeList.Insert(0, allType);
//if (model.isPublic)
//{
// model.securityType = Constants.Type.Public;
//}
//else
//{
// model.securityType = Constants.Type.Authority;
//}
if (model.isActive)
{
model.indexStatus = Constants.Status.Active;
}
else
{
model.indexStatus = Constants.Status.Inactive;
}
MstIndexDAO indexDAO = new MstIndexDAO(this.mapper);
model = indexDAO.searchIndex(model, Constants.Term.ShortTerm);
return View("IndexMaster", model);
}
public JsonResult JSONGetIndex(string q = "")
{
MstIndexDAO mstIndexDAO = new MstIndexDAO(this.mapper);
IList<MstIndexModels> lsIndex = mstIndexDAO.GetIndexMasterList(q, Constants.Term.ShortTerm);
return Json(lsIndex, JsonRequestBehavior.AllowGet);
}
public ActionResult IndexMaster()
{
MstIndexSearchModels model = new MstIndexSearchModels();
MstIndexDAO indexDAO = new MstIndexDAO(this.mapper);
model.pageIndex = 1;
model.securityType = Constants.Type.Public;
model.securityType = Constants.Status.Active;
model.isPublic = true;
model.isActive = true;
//model = indexDAO.searchIndex(model);
MstIndexTypeDAO indexTypeDAO = new MstIndexTypeDAO(this.mapper);
model.indexTypeList = indexTypeDAO.GetIndexTypeList(null, Constants.Status.Active);
MstIndexTypeModels allType = new MstIndexTypeModels();
model.indexTypeList.Insert(0, allType);
return View(model);
}
public IList<IdxIndexModels> GetIndexFromExcel(DataTable dtIndex, ISqlMapper mapper, out string errorMsg)
{
string term = null;
IList<IdxIndexModels> indexList = new List<IdxIndexModels>();
errorMsg = "";
// Check file type
if (!StringUtils.IsEmpty(dtIndex.Columns[0].ColumnName) && dtIndex.Columns[0].ColumnName.Equals(Constants.FileType.ShortIndex))
{
term = Constants.Term.ShortTerm;
}
else if (!StringUtils.IsEmpty(dtIndex.Columns[0].ColumnName) && dtIndex.Columns[0].ColumnName.Equals(Constants.FileType.MiddleIndex))
{
term = Constants.Term.MidTerm;
}
else if (!StringUtils.IsEmpty(dtIndex.Columns[0].ColumnName) && dtIndex.Columns[0].ColumnName.Equals(Constants.FileType.LongIndex))
{
term = Constants.Term.LongTerm;
}
else
{
errorMsg = string.Format(Resource.MsgErrWrongSelection, Resource.IndexFile);
return null;
}
// Get Index TypeCode
string indexTypeCode = "";
// Exact indexCode
MstIndexDAO mstIndexDAO = new MstIndexDAO(mapper);
int seqNo = 0;
string previousItemCode = "";
List<IdxIndexModels> indexCodeList = new List<IdxIndexModels>();
int i = 0;
foreach (DataRow row in dtIndex.Rows)
{
i++;
IdxIndexModels index = new IdxIndexModels();
string indexName = row[0].ToString();
if (indexName.Equals(Resource.ExcelEndChar)
|| StringUtils.IsEmpty(indexName)
) break;
if (StringUtils.IsEmpty(indexName))
{
index.indexCode = previousItemCode;
seqNo++;
index.seqNo = seqNo;
}
else
{
MstIndexModels indexModels = mstIndexDAO.GetIndexCode(indexName.Trim(), "", term);
if (indexModels == null)
{
errorMsg = string.Format(Resource.MsgErrIndexNotExist, indexName.Trim());
return null;
}
indexTypeCode = indexModels.indexTypeCode;
String indexCode = indexModels.indexCode;
if (indexCode == null)
{
errorMsg = string.Format(Resource.MsgErrNotExistIndexNameUploadExcelFile, new String[] { i.ToString(), "1", indexName });
return null;
}
previousItemCode = indexCode; // = ws.Cell(i, 1).Value;
index.indexCode = previousItemCode;
index.seqNo = 0;
seqNo = 0;
}
index.indexTypeCode = indexTypeCode;
indexCodeList.Add(index);
}
// Get Index TypeCode
MstIndexTypeDAO indexTypeDAO = new MstIndexTypeDAO(mapper);
MstIndexTypeModels indexTypeModel = indexTypeDAO.GetIndexType(indexTypeCode);
if (indexTypeModel == null)
{
errorMsg = string.Format(Resource.MsgErrIndexTypeNotExist, indexTypeCode);
return null;
}
string timeFormat = indexTypeModel.typeTimeFormat;
// Exact time
IList<DateTime> timeList = new List<DateTime>();
for (i=1; i<dtIndex.Columns.Count; i++)
{
string time = dtIndex.Columns[i].ToString();
if (time.Equals(Resource.ExcelEndChar)
|| StringUtils.IsEmpty(time)
|| time.Contains("Column")
) break;
try
{
timeList.Add(DateTime.ParseExact(time, timeFormat, null));
}
catch (Exception e)
{
errorMsg = string.Format(Resource.MsgErrDateFormatUploadExcelFile, new String[] { "1", i.ToString(), time });
return null;
}
}
// Exact index
for (int currentRowIndex = 0; currentRowIndex < indexCodeList.Count; currentRowIndex++)
{
IdxIndexModels indexCode = indexCodeList[currentRowIndex];
for (int currentColumnIndex = 0; currentColumnIndex < timeList.Count; currentColumnIndex++)
{
IdxIndexModels index = new IdxIndexModels();
index.indexTypeCode = indexCode.indexTypeCode.Trim();
index.indexCode = indexCode.indexCode.Trim();
index.seqNo = indexCode.seqNo;
index.indexTime = timeList[currentColumnIndex];
try
{
index.indexField = double.Parse(dtIndex.Rows[currentRowIndex][currentColumnIndex+1].ToString());
}
catch (Exception e)
{
errorMsg = string.Format(Resource.MsgErrNumberFormatUploadExcelFile
, new String[] { (currentRowIndex+2).ToString(), (currentColumnIndex+2).ToString(), dtIndex.Rows[currentRowIndex][currentColumnIndex+1].ToString() });
return null;
}
index.term = term;
indexList.Add(index);
}
}
return indexList;
}
