public void openPeriod()
{
string message = string.Empty;
try
{
string record = this.Request["record"];
Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record);
//string year = ht["year"].ToString();
string period = ht["perd"].ToString();
stperiodBll bll = new stperiodBll();
tstperiod periodMdl = bll.GetPeriod(period);
Exception_ErrorMessage result = bll.OpenPeriod(periodMdl);
if (result.Equals(Exception_ErrorMessage.NoError))
{
message = "{status:'success',msg:'" + HRMSRes.Public_Message_OpenPeriodSuccess + "'}";
}
}
catch (Exception ex)
{
message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_OpenPeriodFail, ex, true) + "'}";
}
Response.Output.Write(message);
}
public void checkPeriodStatusOnly()
{
string message = string.Empty;
try
{
string record = this.Request["record"];
Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record);
stperiodBll periodBll = new stperiodBll();
tstperiod periodMdl = periodBll.GetPeriod(ht["period"].ToString());
periodBll.CheckSelectedPeriodStatus(periodMdl);
message = "{status:'success',msg:'" + HRMSRes.Public_Message_CheckPeriodStatusSuccess + "'}";
}
catch (UtilException ex)
{
if ((ex.Code == (int)Exception_ErrorMessage.PeriodIsUnused) ||
(ex.Code == (int)Exception_ErrorMessage.StepIsCompleted))
{
message = "{status:'ask',msg:'" + ExceptionPaser.Parse(ex, true) + "'}";
}
else
{
message = "{status:'fail',msg:'" + ExceptionPaser.Parse(ex, true) + "'}";
}
}
catch (Exception ex)
{
message = "{status:'fail',msg:'" + ExceptionPaser.Parse(ex, true) + "'}";
}
Response.Output.Write(message);
}
private void render()
{
this.ViewData["currentUser"] = Function.GetCurrentUser();
stperiodBll periodBll = new stperiodBll();
List <tstperiod> lstPeriodMdl = periodBll.GetPeriodByStatus(HRMS_Period_Status.Open.ToString());
StringBuilder builder = new StringBuilder();
if (lstPeriodMdl.Count <= 0)
{
string from = "19000101";
string to = "19000101";
builder.Append("{");
builder.Append("fullPeriod:\"").Append("1900").Append("01").Append("\",");
builder.Append("year:\"").Append("1900").Append("\",");
builder.Append("period:\"").Append("01").Append("\",");
builder.Append("start:\"").Append(from).Append("\",");
builder.Append("end:\"").Append(to).Append("\"");
builder.Append("}");
}
else
{
string from = lstPeriodMdl[0].pest.ToString("yyyyMMdd");
string to = lstPeriodMdl[0].peen.ToString("yyyyMMdd");
builder.Append("{");
builder.Append("fullPeriod:\"").Append(lstPeriodMdl[0].year).Append(lstPeriodMdl[0].mnth).Append("\",");
builder.Append("year:\"").Append(lstPeriodMdl[0].year).Append("\",");
builder.Append("month:\"").Append(lstPeriodMdl[0].mnth).Append("\",");
builder.Append("start:\"").Append(from).Append("\",");
builder.Append("end:\"").Append(to).Append("\"");
builder.Append("}");
}
this.ViewData["currentPeriod"] = builder.ToString();
}
//public void delete()
//{
// string msg = string.Empty;
// try
// {
// PeriodBll periodBll = new PeriodBll();
// string year = Request.Form["Year"];
// string period = Request.Form["Period"];
// Exception_ErrorMessage error = periodBll.DeletePeriod(year, period);
// if (error == Exception_ErrorMessage.NoError)
// {
// msg = "{status:'success',msg:'" + HRMSRes.Public_Message_DeleteWell + "'}";
// }
// }
// catch (Exception ex)
// {
// msg = "{status:'failure',msg:'" + HRMSRes.Public_Message_DeleteBad + "'}";
// }
// Response.Output.Write(msg);
//}
public void list()
{
string message = string.Empty;
try
{
string record = this.Request["record"];
string startStr = this.Request["start"];
string limitStr = this.Request["limit"];
if ((record == null) || (record.Length < 1))
{
record = "{\"year\":\"" + UtilDatetime.FormatDate3(DateTime.Now).Substring(0, 4) + "\"}";
}
Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record);
int start = 0;
if (startStr != null)
{
start = Convert.ToInt32(startStr);
}
int limit = 0;
if (limitStr != null)
{
limit = Convert.ToInt32(limitStr);
}
stperiodBll bll = new stperiodBll();
List <ColumnInfo> parameters = new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "year", ColumnValue = ht["year"].ToString()
}
};
int total = 0;
List <tstperiod> periodList = bll.GetSelectedRecords <tstperiod>(parameters, true, start, start + limit, ref total);
string json = JavaScriptConvert.SerializeObject(periodList);
json = "{results:" + total + ",rows:" + json + "}";
Response.Write(json);
}
catch (Exception ex)
{
message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_QueryFail, ex, true) + "'}";
Response.Output.Write(message);
}
}
public void listAllPeriod()
{
try
{
stperiodBll bll = new stperiodBll();
List <tstperiod> periodList = bll.GetAllPeriods();
string json = JavaScriptConvert.SerializeObject(periodList);
json = "{results:" + periodList.Count + ",rows:" + json + "}";
Response.Output.Write(json);
}
catch (Exception ex)
{
throw ex;
}
}
public void exportExcel()
{
string message = string.Empty;
try
{
string record = this.Request["record"];
string header = this.Request["header"];
if ((record == null) || (record.Length < 1))
{
record = "{\"year\":\"" + UtilDatetime.FormatDate3(DateTime.Now).Substring(0, 4) + "\"}";
}
if (header == null || header.Equals(string.Empty))
{
return;
}
Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record);
List <ColumnInfo> headers = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(header);
stperiodBll bll = new stperiodBll();
List <ColumnInfo> parameters = new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "year", ColumnValue = ht["year"].ToString()
}
};
List <tstperiod> yearList = bll.GetSelectedRecords <tstperiod>(parameters);
if (yearList != null)
{
UtilExcel.ExportToExcel(Response, this.GetType().Name.GetPageName(), headers, yearList);
}
}
catch (Exception ex)
{
message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_ExportExcelFail, ex, true) + "'}";
Response.Output.Write(message);
}
}
public void edit()
{
string msg = string.Empty;
try
{
stperiodBll stperiodBll = new stperiodBll();
string request = Request.Form["record"];
tstperiod stperiodMdl = JavaScriptConvert.DeserializeObject <tstperiod>(request);
Exception_ErrorMessage error = stperiodBll.UpdatePeriod(stperiodMdl);
if (error == Exception_ErrorMessage.NoError)
{
msg = "{status:'success',msg:'" + HRMSRes.Public_Message_EditWell + "'}";
}
}
catch (Exception ex)
{
msg = "{status:'failure',msg:'" + HRMSRes.Public_Message_EditBad + "'}";
}
Response.Output.Write(msg);
}
public void listPeriodYear()
{
try
{
stperiodBll bll = new stperiodBll();
List <string> yearList = bll.GetYearList();
StringBuilder json = new StringBuilder();
for (int i = 0; i < yearList.Count; i++)
{
if (!json.ToString().Equals(""))
{
json.Append(",");
}
json.Append("{year:'" + yearList[i] + "'}");
}
Response.Output.Write("{results:" + yearList.Count + ",rows:[" + json.ToString() + "]}");
}
catch (Exception ex)
{
throw ex;
}
}
