public void exportExcel()
{
try
{
table_name = this.Request["tableName"];
string record = this.Request["record"];
string header = this.Request["header"];
List <ColumnInfo> headers = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(header);
List <object> dataList = null;
List <ColumnInfo> parameters = new List <ColumnInfo>();
MasterDataBll bll = new MasterDataBll();
if (record != null)
{
parameters = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(record);
}
dataList = bll.GetSelectedRecords(table_name, parameters);
if (dataList != null)
{
UtilExcel.ExportToExcel(bll.GetDynamicType(table_name), Response, table_name, headers, dataList);
}
}
catch (Exception ex)
{
string message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_QueryFail, ex, true) + "'}";
Response.Output.Write(message);
}
}
private List <ColumnMdl> getColumns(string tableName)
{
MasterDataBll bll = new MasterDataBll(tableName);
List <ColumnMdl> columns = bll.GetColumns();
return(columns);
}
public void importExcel()
{
string message = "{}";
try
{
table_name = this.Request["tableName"];
string cols = this.Request["cols"];
HttpPostedFileBase file = null;
for (int i = 0; i < Request.Files.Count; i++)
{
file = Request.Files[i];
}
if (file != null)
{
string fileFullName = file.FileName;
string fileExtension = Path.GetExtension(fileFullName).ToLower();
if (fileExtension.ToLower().Equals(".xls"))
{
string tempPath = Path.GetTempPath();
string fileName = Path.GetFileName(fileFullName);
string savedFileFullName = tempPath + fileName;
file.SaveAs(savedFileFullName);
MasterDataBll bll = new MasterDataBll(table_name);
string excelDataSource = ConfigReader.getDBConnectionString_Excel().Replace("File.xls", savedFileFullName);
List <ColumnInfo> list = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(cols);
bll.InsertFromExcel(table_name, excelDataSource, list);
message = "{success:true, status:'success',msg:'" + HRMSRes.Public_Message_ImportWell + "'}";
FileInfo fileInfo = new FileInfo(savedFileFullName);
fileInfo.Delete();
}
else
{
throw new Exception(HRMSRes.Public_Message_FileNotEmpty);
}
}
else
{
throw new Exception();
}
}
catch (Exception ex)
{
message = "{errors:'',status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_ImportBad, ex, true) + ")'}";
}
Response.Output.Write(message);
}
public void list()
{
try
{
string startStr = this.Request["start"];
int start = 0;
if (startStr != null)
{
start = Convert.ToInt32(startStr);
}
string limitStr = this.Request["limit"];
int limit = 0;
if (limitStr != null)
{
limit = Convert.ToInt32(limitStr);
}
table_name = this.Request["tableName"];
string record = this.Request["record"];
int total = 0;
MasterDataBll bll = new MasterDataBll();
object dataList = null;
List <ColumnInfo> parameters = new List <ColumnInfo>();
if (record != null)
{
parameters = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(record);
}
dataList = bll.GetSelectedRecords(table_name, parameters, true, start, start + limit, ref total);
string json = JavaScriptConvert.SerializeObject(dataList);
Response.Write("{results:" + total + ",rows:" + json + "}");
}
catch (Exception ex)
{
string message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_QueryFail, ex, true) + "'}";
Response.Output.Write(message);
}
}
public ActionResult index()
{
try
{
table_name = this.Request["tableName"];
string tabId = this.Request["menuId"];
List <ColumnMdl> columns = this.getColumns(table_name);
MasterDataBll bll = new MasterDataBll(table_name);
bool isLocked = false;
#region MUF
var q = (from p in (List <string>)HttpContext.Session[Constant.SESSION_CURRENT_MUF]
where p == tabId.Substring(1, tabId.Length - 1)
select p).ToList();
bool muf = q.Count > 0 ? true : false;
#endregion
ViewData["config"] = responseJson(columns, tabId, table_name, isLocked, muf);
StringBuilder auth = new StringBuilder();
object obj = HttpContext.Session[Constant.SESSION_AUTHORIZATION];
if (obj != null)
{
AuthorizationMdl authorization = (AuthorizationMdl)obj;
string pageName = this.GetType().Name.GetPageName();
string funId = pageName + "_" + tabId + "_masterdata_add";
bool isValid = authorization.checkPermissionByFuncUrl(funId);
auth.Append(tabId).Append("_masterdata_add:\"").Append(isValid).Append("\",");
funId = pageName + "_" + tabId + "_masterdata_edit";
isValid = authorization.checkPermissionByFuncUrl(funId);
auth.Append(tabId).Append("_masterdata_edit:\"").Append(isValid).Append("\",");
funId = pageName + "_" + tabId + "_masterdata_delete";
isValid = authorization.checkPermissionByFuncUrl(funId);
auth.Append(tabId).Append("_masterdata_delete:\"").Append(isValid).Append("\",");
funId = pageName + "_" + tabId + "_masterdata_export";
isValid = authorization.checkPermissionByFuncUrl(funId);
auth.Append(tabId).Append("_masterdata_export:\"").Append(isValid).Append("\",");
funId = pageName + "_" + tabId + "_masterdata_import";
isValid = authorization.checkPermissionByFuncUrl(funId);
auth.Append(tabId).Append("_masterdata_import:\"").Append(isValid).Append("\",");
funId = pageName + "_" + tabId + "_masterdata_query";
isValid = authorization.checkPermissionByFuncUrl(funId);
auth.Append(tabId).Append("_masterdata_query:\"").Append(isValid).Append("\"");
}
ViewData["authorization"] = "{" + auth.ToString() + "}";
}
catch (UtilException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new UtilException(ex.Message, ex);
}
return(this.View("MasterData"));
}
