protected void Button1_Click(object sender, EventArgs e)
{
string path = "";
string desPath = System.Configuration.ConfigurationManager.AppSettings["UploadPlan"];
T_PlaningDTO requestObj = new T_PlaningDTO();
T_PlaningBAL planBAL = null;
planBAL = new T_PlaningBAL();
requestObj.PID = "194,198";
requestObj.Year = "2018";
requestObj.CreateBy = "4F12E624-F166-4046-839E-EF24F2E12E43";
requestObj.UpdateBy = "4F12E624-F166-4046-839E-EF24F2E12E43";
Byte[] b = planBAL.ExportPlanForExcel(requestObj, desPath, "test.xlsx");
//Send output stream to client window
Response.AddHeader("Content-Type", "application/vnd.ms-excel");
Response.AddHeader("Content-Disposition", "attachment; filename=test.xlsx");
Response.BinaryWrite(b);
Response.Flush();
Response.End();
// ExportToPDF();
}
public HttpResponseMessage ClearPlan()
{
bal = new T_PlaningBAL();
ResposeType response = new ResposeType();
HttpResponseMessage mapMessage = null;
try
{
var context = HttpContext.Current;
T_PlaningDTO planingDTO = GetRequestToObject(context);
string UserID = context.Request.Form["UserID"];
if (ObjUtil.isEmpty(UserID))
{
throw new Exception("UserID is require");
}
planingDTO.CreateBy = UserID;
planingDTO.UpdateBy = UserID;
response.statusCode = bal.ClearAlll(planingDTO);
}
catch (Exception ex)
{
logger.error("ClearPlan error:" + ex.ToString());
response.statusText = ex.ToString();
}
mapMessage = Request.CreateResponse(HttpStatusCode.OK, response);
return(mapMessage);
}
public HttpResponseMessage Search()
{
var deserializer = new JavaScriptSerializer();
bal = new T_PlaningBAL();
ResposeType response = new ResposeType();
HttpResponseMessage mapMessage = null;
T_PlaningDTO dto = null;
List <T_PlaningDTO> objList = null;
try
{
var context = HttpContext.Current;
dto = ConvertX.GetReqeustForm <T_PlaningDTO>();
logger.debug("Search dto :" + dto.ToString());
objList = bal.FindByObjList(dto);
if (!ObjUtil.isEmpty(objList))
{
foreach (T_PlaningDTO obj in objList)
{
obj.SpecSDate = ConvertX.DDMMYY(obj.SpecSDate);
obj.SpecEDate = ConvertX.DDMMYY(obj.SpecEDate);
obj.POSDate = ConvertX.DDMMYY(obj.POSDate);
obj.POEDate = ConvertX.DDMMYY(obj.POEDate);
obj.ActionSDate = ConvertX.DDMMYY(obj.ActionSDate);
obj.ActionEDate = ConvertX.DDMMYY(obj.ActionEDate);
}
}
response.statusCode = true;
response.data = objList;
}
catch (Exception ex)
{
logger.error("Search error:" + ex.ToString());
response.statusText = ex.ToString();
}
mapMessage = Request.CreateResponse(HttpStatusCode.OK, response);
return(mapMessage);
}
public HttpResponseMessage GetProgressPlan()
{
bal = new T_PlaningBAL();
T_PlaningDTO dto = null;
List <ColumnReportDTO> objList = null;
ResposeType response = new ResposeType();
HttpResponseMessage mapMessage = null;
try
{
var context = HttpContext.Current;
dto = ConvertX.GetReqeustForm <T_PlaningDTO>();
string RoleLevel = context.Request.Form["RoleLevel"];
if (ObjUtil.isEmpty(RoleLevel))
{
throw new Exception("RoleLevel is require");
}
if (RoleLevel == "1")
{
string UserID = context.Request.Form["UserID"];
if (ObjUtil.isEmpty(UserID))
{
throw new Exception("UserID is require");
}
dto.CreateBy = UserID;
dto.UpdateBy = UserID;
}
T_PlaningBAL bal = new T_PlaningBAL();
objList = bal.GetGraphProgress(dto);
response.statusCode = true;
response.data = objList;
}
catch (Exception ex)
{
logger.error("GetProgressPlan error:" + ex.ToString());
response.statusText = ex.ToString();
}
mapMessage = Request.CreateResponse(HttpStatusCode.OK, response);
return(mapMessage);
}
public HttpResponseMessage View()
{
var deserializer = new JavaScriptSerializer();
bal = new T_PlaningBAL();
ResposeType response = new ResposeType();
HttpResponseMessage mapMessage = null;
T_PlaningDTO dto = null;
List <T_PlaningDTO> objList = null;
try
{
var context = HttpContext.Current;
dto = ConvertX.GetReqeustForm <T_PlaningDTO>();
if (dto.Year == null || "".Equals(dto.Year))
{
dto.Year = DateTime.Now.Year.ToString();
}
string UserID = context.Request.Form["UserID"];
if (ObjUtil.isEmpty(UserID))
{
throw new Exception("UserID is require");
}
dto.CreateBy = UserID;
dto.UpdateBy = UserID;
logger.debug("View dto :" + dto.ToString());
objList = bal.FindByObjListV2(dto);
response.statusCode = true;
response.data = objList;
}
catch (Exception ex)
{
logger.error("View error:" + ex.ToString());
response.statusText = ex.ToString();
}
mapMessage = Request.CreateResponse(HttpStatusCode.OK, response);
return(mapMessage);
}
