/// <summary>
/// Check system suspending and user’s permission
/// </summary>
/// <param name="sParam"></param>
/// <returns></returns>
public ActionResult CTS290_Authority(CTS290_ScreenParameter sParam)
{
ObjectResultData res = new ObjectResultData();
try
{
//Check suspending
if (CheckIsSuspending(res) == true)
{
return(Json(res));
}
//Check screen permission
if (CheckUserPermission(ScreenID.C_SCREEN_ID_SEARCH_NEARLY_EXPIRED_WARRANTY_SALE_CONTRACT, FunctionID.C_FUNC_ID_OPERATE) == false)
{
res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0053);
return(Json(res));
}
sParam = new CTS290_ScreenParameter();
}
catch (Exception ex)
{
res.AddErrorMessage(ex);
return(Json(res));
}
return(InitialScreenEnvironment <CTS290_ScreenParameter>("CTS290", sParam, res));
}
//public CsvActionResult CTS290_DownloadAsCSV_Test()
//{
// ObjectResultData res = new ObjectResultData();
// List<CTS290_SearchResultGridData> resultGridData;
// DataTable dtResultData = new DataTable();
// try
// {
// CTS290_ScreenParameter sParam = GetScreenObject<CTS290_ScreenParameter>();
// if (sParam == null)
// sParam = new CTS290_ScreenParameter();
// resultGridData = sParam.doSearchResultGridData;
// dtResultData = CommonUtil.ConvertDoListToDataTable<CTS290_SearchResultGridData>(resultGridData);
// return new CsvActionResult(dtResultData) { FileDownloadName = "NearlyExpiredWarrantySaleContract.csv" };
// }
// catch (Exception ex)
// {
// res.AddErrorMessage(ex);
// }
// return null;
//}
/// <summary>
/// Download the result list as CSV file when click [Download as CSV] button
/// </summary>
public void CTS290_DownloadAsCSV()
{
//string strHeader = CommonUtil.CsvHeaderGrid("Contract\\CTS290");
//string strData = string.Empty;
//CTS290_ScreenParameter sParam = GetScreenObject<CTS290_ScreenParameter>();
//if (sParam != null && sParam.doSearchResultGridData != null)
//{
// string strContractCodeAndOCC = string.Empty;
// string strSaleWarrantyPeriod = string.Empty;
// string strOfficeNameAndInChargeName = string.Empty;
// string strSiteCodeAndOptOfficeName = string.Empty;
// string strRealCustomerName = string.Empty;
// string strSiteName = string.Empty;
// string strSaleProductName = string.Empty;
// int iNo = 1;
// foreach(CTS290_SearchResultGridData data in sParam.doSearchResultGridData)
// {
// strContractCodeAndOCC = String.IsNullOrEmpty(data.ContractCodeAndOCC) ? string.Empty : String.Format("\"{0}\"", data.ContractCodeAndOCC.Replace("<br/>", ""));
// strSaleWarrantyPeriod = String.IsNullOrEmpty(data.SaleWarrantyPeriod) ? string.Empty : String.Format("\"{0}\"", data.SaleWarrantyPeriod.Replace("<br/>", ""));
// strOfficeNameAndInChargeName = String.IsNullOrEmpty(data.OfficeNameAndInChargeName) ? string.Empty : String.Format("\"{0}\"", data.OfficeNameAndInChargeName.Replace("<br/>", ""));
// strSiteCodeAndOptOfficeName = String.IsNullOrEmpty(data.SiteCodeAndOptOfficeName) ? string.Empty : String.Format("\"{0}\"", data.SiteCodeAndOptOfficeName.Replace("<br/>", ""));
// strRealCustomerName = String.IsNullOrEmpty(data.RealCustomerName) ? string.Empty : String.Format("\"{0}\"", data.RealCustomerName.Replace("<br/>", ""));
// strSiteName = String.IsNullOrEmpty(data.SiteName) ? string.Empty : String.Format("\"{0}\"", data.SiteName.Replace("<br/>", ""));
// strSaleProductName = String.IsNullOrEmpty(data.SaleProductName) ? string.Empty : String.Format("\"{0}\"", data.SaleProductName.Replace("<br/>", ""));
// strData = string.Format("{0}{1},{2},{3},{4},{5},{6},{7},{8}\n", strData, iNo, strContractCodeAndOCC, strSaleWarrantyPeriod, strOfficeNameAndInChargeName, strSiteCodeAndOptOfficeName, strRealCustomerName, strSiteName, strSaleProductName);
// iNo++;
// }
//}
//string strCSVResultData = String.Format("{0}\n{1}", strHeader, strData);
//Response.Clear();
//Response.AddHeader("Content-Disposition", "attachment; filename=NearlyExpiredWarrantySaleContract.csv");
//Response.ContentType = "text/csv"; //"application/force-download";
//Response.Charset = "windows-874";
//Response.ContentEncoding = System.Text.Encoding.GetEncoding(874); //System.Text.Encoding.GetEncoding("UTF-8");
//Response.Write(strCSVResultData);
//Response.End();
CTS290_ScreenParameter sParam = GetScreenObject <CTS290_ScreenParameter>();
List <CTS290_SearchResultCSVData> csvData = CommonUtil.ClonsObjectList <dtSearchSaleWarrantyExpireResult, CTS290_SearchResultCSVData>(sParam.dtSearchSaleWarrantyExpireResultData);
string strCSVResultData = CSVReportUtil.GenerateCSVData <CTS290_SearchResultCSVData>(csvData, false);
this.DownloadCSVFile("NearlyExpiredWarrantySaleContract.csv", strCSVResultData);
}
/// <summary>
/// Get result data of SaleWarrantyExpire Condition when click [Search] button on ‘Specify search condition’ section
/// </summary>
/// <param name="cond"></param>
/// <returns></returns>
public ActionResult CTS290_GetSearchResultData(doSearchSaleWarrantyExpireCondition cond)
{
ObjectResultData res = new ObjectResultData();
res.MessageType = MessageModel.MESSAGE_TYPE.WARNING;
IMaintenanceHandler maintainHandler;
List <dtSearchSaleWarrantyExpireResult> gridDataList = new List <dtSearchSaleWarrantyExpireResult>();
CTS290_ValidateSaleWarrantyExpirePeriod validateWarrantyExpirePeriod;
try
{
//Validate required criteria
validateWarrantyExpirePeriod = CommonUtil.CloneObject <doSearchSaleWarrantyExpireCondition, CTS290_ValidateSaleWarrantyExpirePeriod>(cond);
ValidatorUtil.BuildErrorMessage(res, new object[] { validateWarrantyExpirePeriod }, null, false);
if (res.IsError)
{
return(Json(res));
}
//Validate expire warranty month
DateTime dtWarrantyFrom = new DateTime(cond.ExpireWarrantyYearFrom, cond.ExpireWarrantyMonthFrom, 1);
DateTime dtWarrantyTo = new DateTime(cond.ExpireWarrantyYearTo, cond.ExpireWarrantyMonthTo, 1);
if (dtWarrantyFrom > dtWarrantyTo)
{
res.AddErrorMessage(MessageUtil.MODULE_COMMON, MessageUtil.MessageList.MSG0062, new string[] { "Expire warranty (From)", "Expire warranty (To)" }, new string[] { "WarrantyMonthFrom", "WarrantyYearFrom", "WarrantyMonthTo", "WarrantyYearTo" });
return(Json(res));
}
if (String.IsNullOrEmpty(cond.OperationOfficeCode))
{
cond.OperationOfficeCode = GetAllOperationOfficeCode_CTS290();
}
if (String.IsNullOrEmpty(cond.SaleContractOfficeCode))
{
cond.SaleContractOfficeCode = GetAllContractOfficeCode_CTS290();
}
maintainHandler = ServiceContainer.GetService <IMaintenanceHandler>() as IMaintenanceHandler;
gridDataList = maintainHandler.SearchSaleWarrantyExpireList(cond);
List <CTS290_SearchResultGridData> resultGridData = CommonUtil.ClonsObjectList <dtSearchSaleWarrantyExpireResult, CTS290_SearchResultGridData>(gridDataList);
if (resultGridData != null && resultGridData.Count > 0)
{
resultGridData = (from t in resultGridData
orderby t.SiteName, t.SaleProductName
select t).ToList <CTS290_SearchResultGridData>();
}
CTS290_ScreenParameter sParam = GetScreenObject <CTS290_ScreenParameter>();
if (sParam.doSearchResultGridData == null)
{
sParam.doSearchResultGridData = new List <CTS290_SearchResultGridData>();
}
sParam.doSearchResultGridData = resultGridData;
sParam.dtSearchSaleWarrantyExpireResultData = gridDataList;
UpdateScreenObject(sParam);
res.ResultData = CommonUtil.ConvertToXml <CTS290_SearchResultGridData>(resultGridData, "Contract\\CTS290", CommonUtil.GRID_EMPTY_TYPE.SEARCH);
}
catch (Exception ex)
{
res.AddErrorMessage(ex);
}
return(Json(res));
}