public HttpResponseMessage SearchAllDryFilms() { bal = new T_Planing_Action_AfterAppliedCoatingBAL(); ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; T_Planing_Action_AfterAppliedCoatingDTO dto = null; List <T_Planing_Action_AfterAppliedCoating_DryFilmDTO> objList = null; try { var context = HttpContext.Current; dto = ConvertX.GetReqeustForm <T_Planing_Action_AfterAppliedCoatingDTO>(); logger.debug("PlanActionAfterAppliedCoatingController SearchAllDryFilms dto:" + dto.ToString()); objList = bal.FindAllDryFilms(dto); response.statusCode = true; response.data = objList; } catch (Exception ex) { logger.error("PlanActionAfterAppliedCoatingController SearchAllDryFilms error:" + ex.ToString()); response.statusText = ex.ToString(); } mapMessage = Request.CreateResponse(HttpStatusCode.OK, response); return(mapMessage); }
public HttpResponseMessage Search() { bal = new T_Planing_Action_AfterAppliedCoatingBAL(); ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; T_Planing_Action_AfterAppliedCoatingDTO dto = null; List <T_Planing_Action_AfterAppliedCoatingDTO> objList = null; response.statusCode = false; try { var context = HttpContext.Current; dto = ConvertX.GetReqeustForm <T_Planing_Action_AfterAppliedCoatingDTO>(); objList = bal.FindByObjList(dto); foreach (T_Planing_Action_AfterAppliedCoatingDTO mainDTO in objList) { //Find detail and push to main object in list T_Planing_Action_AfterAppliedCoatingDTO detailDTO = new T_Planing_Action_AfterAppliedCoatingDTO(); detailDTO.PID = mainDTO.PID; detailDTO = bal.FindByPK(detailDTO); mainDTO.UploadFileList = detailDTO.UploadFileList; mainDTO.DryFilmThicknessList = detailDTO.DryFilmThicknessList; if (!ObjUtil.isEmpty(mainDTO.UploadFileList)) { foreach (T_Planing_File file in mainDTO.UploadFileList) { file.HtmlFile = System.Web.VirtualPathUtility.ToAbsolute(planPath + "/" + file.PID + "/" + file.UploadType + "/" + file.FileName); string fullPath = context.Server.MapPath(planPath) + @"\" + file.PID + @"\" + file.UploadType + @"\" + file.FileName; file.Base64File = Utility.convertFileToBase64(fullPath); } } } 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 T_Planing_Action_AfterAppliedCoatingDTO FindByPK(object data) { List <SqlParameter> parameterList = new List <SqlParameter>(); var obj = new T_Planing_Action_AfterAppliedCoatingDTO(); dataTable = null; string procName = "sp_T_Planing_Action_AfterAppliedCoating_FindByPK"; try { dataTable = new DataTable(); adapter = new SqlDataAdapter(); SqlConnection conn = OpenConnection(); if (data != null) { parameterList.AddRange(GetParameters(procName, data).ToArray()); } command = new SqlCommand(procName, conn); command.CommandType = CommandType.StoredProcedure; if (data != null) { command.Parameters.AddRange(parameterList.ToArray()); } using (SqlDataReader reader = command.ExecuteReader()) { obj = ConvertX.GetListFromDataReader <T_Planing_Action_AfterAppliedCoatingDTO>(reader).ToList().FirstOrDefault(); reader.NextResult(); obj.UploadFileList = ConvertX.GetListFromDataReader <T_Planing_File>(reader).ToList(); reader.NextResult(); obj.DryFilmThicknessList = ConvertX.GetListFromDataReader <T_Planing_Action_AfterAppliedCoating_DryFilmDTO>(reader).ToList(); } } catch (Exception ex) { } finally { CloseConnection(); } return(obj); }
public HttpResponseMessage SearchAllFiles() { bal = new T_Planing_Action_AfterAppliedCoatingBAL(); ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; T_Planing_Action_AfterAppliedCoatingDTO dto = null; List <T_Planing_File> objList = null; try { var context = HttpContext.Current; dto = ConvertX.GetReqeustForm <T_Planing_Action_AfterAppliedCoatingDTO>(); logger.debug("PlanActionAfterAppliedCoatingController SearchAllFiles dto:" + dto.ToString()); objList = bal.FindAllFiles(dto); if (!ObjUtil.isEmpty(objList)) { foreach (T_Planing_File file in objList) { file.HtmlFile = System.Web.VirtualPathUtility.ToAbsolute(planPath + "/" + file.PID + "/" + file.UploadType + "/" + file.FileName); string fullPath = context.Server.MapPath(planPath) + @"\" + file.PID + @"\" + file.UploadType + @"\" + file.FileName; file.Base64File = Utility.convertFileToBase64(fullPath); } } response.statusCode = true; response.data = objList; } catch (Exception ex) { logger.error("PlanActionAfterAppliedCoatingController SearchAllFiles error:" + ex.ToString()); response.statusText = ex.ToString(); } mapMessage = Request.CreateResponse(HttpStatusCode.OK, response); return(mapMessage); }
public HttpResponseMessage View() { bal = new T_Planing_Action_AfterAppliedCoatingBAL(); ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; T_Planing_Action_AfterAppliedCoatingDTO dto = null; response.statusCode = false; try { var context = HttpContext.Current; dto = ConvertX.GetReqeustForm <T_Planing_Action_AfterAppliedCoatingDTO>(); dto = bal.FindByPK(dto); if (dto != null && dto.UploadFileList != null) { foreach (var uploadFile in dto.UploadFileList) { uploadFile.HtmlFile = System.Web.VirtualPathUtility.ToAbsolute(planPath + "/" + dto.PID + "/" + uploadFile.UploadType + "/" + uploadFile.FileName); string fullPath = context.Server.MapPath(planPath) + @"\" + uploadFile.PID + @"\" + uploadFile.UploadType + @"\" + uploadFile.FileName; uploadFile.Base64File = Utility.convertFileToBase64(fullPath); } } response.statusCode = true; response.data = dto; } catch (Exception ex) { logger.error("View error:" + ex.ToString()); response.statusText = ex.ToString(); } mapMessage = Request.CreateResponse(HttpStatusCode.OK, response); return(mapMessage); }
public override bool Add(object data) { List <SqlParameter> parameterList = new List <SqlParameter>(); string procName = "sp_T_Planing_Action_AfterAppliedCoating_Insert"; string PID = ""; SqlConnection conn = OpenConnection(); SqlTransaction transaction = conn.BeginTransaction(); isCan = true; try { obj = (T_Planing_Action_AfterAppliedCoatingDTO)data; //obj.DateINstalled = ConvertX.MMddYY(obj.DateINstalled); command = new SqlCommand(procName, conn, transaction); command.CommandType = CommandType.StoredProcedure; if (data != null) { parameterList.AddRange(GetParameters(procName, obj, transaction).ToArray()); command.Parameters.AddRange(parameterList.ToArray()); } command.ExecuteNonQuery(); PID = obj.PID; if (obj.DeleteFiles != null && obj.DeleteFiles.Length > 0) { procName = "sp_T_Planing_Action_AfterAppliedCoating_Files_Delete"; foreach (var fileNo in obj.DeleteFiles.Split(',')) { if (fileNo != null && fileNo != "") { command = new SqlCommand(procName, conn, transaction); command.CommandType = CommandType.StoredProcedure; T_Planing_File file = new T_Planing_File(); file.PID = PID; file.No = fileNo; parameterList = new List <SqlParameter>(); parameterList.AddRange(GetParameters(procName, file, transaction).ToArray()); command.Parameters.AddRange(parameterList.ToArray()); // command.Parameters[0].Value = ""; command.ExecuteNonQuery(); } } } procName = "sp_T_Planing_Action_AfterAppliedCoating_Files_Insert"; if (obj.UploadFileList != null && obj.UploadFileList.Count > 0) { foreach (T_Planing_File file in obj.UploadFileList) { file.PID = PID; command = new SqlCommand(procName, conn, transaction); command.CommandType = CommandType.StoredProcedure; if (file != null) { parameterList = new List <SqlParameter>(); parameterList.AddRange(GetParameters(procName, file, transaction).ToArray()); command.Parameters.AddRange(parameterList.ToArray()); // command.Parameters[0].Value = ""; } command.ExecuteNonQuery(); } } procName = "sp_T_Planing_Action_AfterAppliedCoating_DryFilmThickness_Insert"; if (obj.DryFilmThicknessList != null && obj.DryFilmThicknessList.Count > 0) { foreach (T_Planing_Action_AfterAppliedCoating_DryFilmDTO dto in obj.DryFilmThicknessList) { dto.PID = PID; dto.ClockPosition1 = dto.ClockPosition1 == "" ? null: dto.ClockPosition1; dto.ClockPosition2 = dto.ClockPosition2 == "" ? null : dto.ClockPosition2; dto.ClockPosition3 = dto.ClockPosition3 == "" ? null : dto.ClockPosition3; dto.ClockPosition4 = dto.ClockPosition4 == "" ? null : dto.ClockPosition4; command = new SqlCommand(procName, conn, transaction); command.CommandType = CommandType.StoredProcedure; if (dto != null) { parameterList = new List <SqlParameter>(); parameterList.AddRange(GetParameters(procName, dto, transaction).ToArray()); command.Parameters.AddRange(parameterList.ToArray()); } command.ExecuteNonQuery(); } } transaction.Commit(); } catch (Exception ex) { isCan = false; transaction.Rollback(); throw new Exception(ex.Message); } finally { CloseConnection(); } return(isCan); }