public HttpResponseMessage Add() { bal = new M_RegionBAL(); ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; M_RegionDTO dto = null; response.statusCode = false; try { var context = HttpContext.Current; dto = ConvertX.GetReqeustForm <M_RegionDTO>(); string UserID = context.Request.Form["UserID"]; if (ObjUtil.isEmpty(UserID)) { throw new Exception("UserID is require"); } dto.CreateBy = UserID; dto.UpdateBy = UserID; logger.debug("Add dto:" + dto.ToString()); response.statusCode = bal.Add(dto); } catch (Exception ex) { logger.error("Add error:" + ex.ToString()); response.statusText = ex.ToString(); } mapMessage = Request.CreateResponse(HttpStatusCode.OK, response); return(mapMessage); }
public HttpResponseMessage GetPlan() { ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; T_Planing_SpecPODTO dto = null; try { var context = HttpContext.Current; dto = ConvertX.GetReqeustForm <T_Planing_SpecPODTO>(); bal = new T_Planing_SpecPOBAL(); logger.debug("View dto:" + dto.ToString()); dto = bal.FindByObjHistory(dto); 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 List <M_UndergroundDTO> FindByObjList() { List <SqlParameter> parameterList = new List <SqlParameter>(); objList = new List <M_UndergroundDTO>(); dataTable = null; string procName = "sp_M_Underground_FindAll"; try { dataTable = new DataTable(); adapter = new SqlDataAdapter(); SqlConnection conn = OpenConnection(); command = new SqlCommand(procName, conn); command.CommandType = CommandType.StoredProcedure; using (SqlDataReader reader = command.ExecuteReader()) { objList = ConvertX.GetListFromDataReader <M_UndergroundDTO>(reader).ToList(); } } catch (Exception ex) { } finally { CloseConnection(); } return(objList); }
public List <M_RegionPipelineDTO> getRegionPipeline() { List <M_RegionPipelineDTO> objList = new List <M_RegionPipelineDTO>(); try { SqlConnection conn = OpenConnection(); command = new SqlCommand("select * from dbo.fn_M_Region_PipelineTable()", conn); command.CommandType = CommandType.Text; using (SqlDataReader reader = command.ExecuteReader()) { objList = ConvertX.GetListFromDataReader <M_RegionPipelineDTO>(reader).ToList(); } return(objList); } catch (Exception ex) { throw new Exception(ex.Message); } finally { CloseConnection(); } }
public List <DropDownListDTO> FindByObjList(string tableName, string userID) { List <SqlParameter> parameterList = new List <SqlParameter>(); objList = new List <DropDownListDTO>(); dataTable = null; string procName = ""; procName = string.Format("sp_{0}_DropDownList", tableName); try { adapter = new SqlDataAdapter(); SqlConnection conn = OpenConnection(); command = new SqlCommand(procName, conn); command.CommandType = CommandType.StoredProcedure; if (userID != null) { parameterList.AddRange(GetParameters(procName, new DropDownListDTO(userID)).ToArray()); command.Parameters.AddRange(parameterList.ToArray()); } SqlDataReader reader = command.ExecuteReader(); objList = ConvertX.ConvertDataReaderToObjectList <DropDownListDTO>(reader); reader.Close(); } catch (Exception ex) { } finally { CloseConnection(); } return(objList); }
public HttpResponseMessage View() { var deserializer = new JavaScriptSerializer(); bal = new T_Planing_WeatherCollectionBAL(); ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; T_Planing_WeatherCollectionDTO dto = null; try { var context = HttpContext.Current; dto = ConvertX.GetReqeustForm <T_Planing_WeatherCollectionDTO>(); logger.debug("View dto:" + dto.ToString()); dto = bal.FindByPK(dto); 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 HttpResponseMessage Delete() { bal = new T_Planing_WeatherCollectionBAL(); ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; T_Planing_WeatherCollectionDTO dto = null; try { var context = HttpContext.Current; //context.Response.ContentType = "multipart/form-data"; dto = ConvertX.GetReqeustForm <T_Planing_WeatherCollectionDTO>(); logger.debug("Delete dto:" + dto.ToString()); response.statusCode = bal.Delete(dto); } catch (Exception ex) { logger.error("Delete error:" + ex.ToString()); response.statusText = ex.ToString(); } mapMessage = Request.CreateResponse(HttpStatusCode.OK, response); return(mapMessage); }
public List <T_CardValidationDTO> FindByObjList(object data) { List <SqlParameter> parameterList = new List <SqlParameter>(); objList = new List <T_CardValidationDTO>(); dataTable = null; string procName = ""; procName = string.Format("sp_T_CardValidation_FindAll"); try { adapter = new SqlDataAdapter(); SqlConnection conn = OpenConnection(); command = new SqlCommand(procName, conn); command.CommandType = CommandType.StoredProcedure; SqlDataReader reader = command.ExecuteReader(); objList = ConvertX.ConvertDataReaderToObjectList <T_CardValidationDTO>(reader); reader.Close(); } catch (Exception ex) { } finally { CloseConnection(); } return(objList); }
public HttpResponseMessage FindByRouteCode() { bal = new M_SectionBAL(); ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; M_SectionDTO dto = null; response.statusCode = false; try { var context = HttpContext.Current; dto = ConvertX.GetReqeustForm <M_SectionDTO>(); logger.debug("FindByRouteCode dto:" + dto.ToString()); M_SectionDTO obj = bal.FinByRouteCodeName(dto); response.statusCode = true; response.data = obj; } catch (Exception ex) { logger.error("FindByRouteCode error:" + ex.ToString()); response.statusText = ex.ToString(); } mapMessage = Request.CreateResponse(HttpStatusCode.OK, response); return(mapMessage); }
public HttpResponseMessage Payment() { validateBAL = new T_CardValidationBAL(); try { // zoneDTO = ConvertX.GetReqeustForm<M_ZoneDTO>(); tranDto = ConvertX.GetReqeustForm <T_CreditCardDTO>(); results = validateBAL.Validate(tranDto); mapMessage = Request.CreateResponse(HttpStatusCode.OK, results); } catch (Exception ex) { mapMessage = Request.CreateResponse(HttpStatusCode.BadRequest, ex.ToString()); } finally { } return(mapMessage); }
public HttpResponseMessage Delete() { bal = new M_RegionBAL(); ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; M_RegionDTO dto = null; response.statusCode = false; try { var context = HttpContext.Current; dto = ConvertX.GetReqeustForm <M_RegionDTO>(); logger.debug("Delete dto:" + dto.ToString()); response.statusCode = bal.Delete(dto); } catch (Exception ex) { logger.error("Delete error:" + ex.ToString()); response.statusText = ex.ToString(); } mapMessage = Request.CreateResponse(HttpStatusCode.OK, response); return(mapMessage); }
private void UseInvertedKeyCheckBox_CheckedChanged(object sender, EventArgs e) { var key = ConvertX.ToUInt32(this.StringKeyBox.Text); key = Bin.Reverse(key); this.StringKeyBox.Text = $"0x{key:X8}"; }
public HttpResponseMessage SearchAllWallThickness() { bal = new T_Planing_Action_AfterRemovalBAL(); ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; T_Planing_Action_AfterRemovalDTO dto = null; List <T_Planing_Action_AfterRemoval_WallThicknessDTO> objList = null; try { var context = HttpContext.Current; dto = ConvertX.GetReqeustForm <T_Planing_Action_AfterRemovalDTO>(); logger.debug("PlanActionAfterRemovalController SearchAllWallThickness dto:" + dto.ToString()); objList = bal.FindAllWallThickness(dto); response.statusCode = true; response.data = objList; } catch (Exception ex) { logger.error("PlanActionAfterRemovalController SearchAllWallThickness error:" + ex.ToString()); response.statusText = ex.ToString(); } mapMessage = Request.CreateResponse(HttpStatusCode.OK, response); return(mapMessage); }
private void ApplyChanges_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.StringKeyBox.Text) || string.IsNullOrEmpty(this.StringLabelBox.Text)) { MessageBox.Show("Key value and label value cannot be left empty.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } uint key = ConvertX.ToUInt32(this.StringKeyBox.Text); if (this.UseInvertedKeyCheckBox.Checked) { key = Bin.Reverse(key); } if (key != this._record.Key) // if this is a different key from the one passed { var exist = this._record.ThisSTRBlock.GetRecord(key); if (exist != null) { MessageBox.Show($"StringRecord with key {this.StringKeyBox.Text} already exists", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } this.ApplyRecordChanges(key); this.DialogResult = DialogResult.OK; }
public HttpResponseMessage Select() { bal = new M_RegionBAL(); ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; List <Select2DTO> dataList = new List <Select2DTO>(); M_RegionDTO dto = null; response.statusCode = false; try { var context = HttpContext.Current; dto = ConvertX.GetReqeustForm <M_RegionDTO>(); logger.debug("Select dto:" + dto.ToString()); dataList = bal.Select2ByObjList(dto); response.statusCode = true; response.data = dataList; } catch (Exception ex) { logger.error("Select error:" + ex.ToString()); response.statusText = ex.ToString(); } mapMessage = Request.CreateResponse(HttpStatusCode.OK, response); return(mapMessage); }
public List <DropDownListDTO> RouteCodeByObjList(string createBy, string RegionID, string PipelineID, string AssetOwnerID) { List <SqlParameter> parameterList = new List <SqlParameter>(); objList = new List <DropDownListDTO>(); dataTable = null; string procName = ""; procName = string.Format("sp_M_RouteCode_FindByRegion_DropDownList"); try { parameterList.Add(new SqlParameter("@RegionID", RegionID)); parameterList.Add(new SqlParameter("@PipelineID", PipelineID)); parameterList.Add(new SqlParameter("@AssetOwnerID", AssetOwnerID)); parameterList.Add(new SqlParameter("@CreateBy", createBy)); adapter = new SqlDataAdapter(); SqlConnection conn = OpenConnection(); command = new SqlCommand(procName, conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddRange(parameterList.ToArray()); SqlDataReader reader = command.ExecuteReader(); objList = ConvertX.ConvertDataReaderToObjectList <DropDownListDTO>(reader); reader.Close(); } catch (Exception ex) { } finally { CloseConnection(); } return(objList); }
public List <ExportPlanHeader> ExportCaptionPlan() { List <SqlParameter> parameterList = new List <SqlParameter>(); List <ExportPlanHeader> result = null; dataTable = null; string procName = "sp_ExportPlan_Setting_FindAll"; try { dataTable = new DataTable(); adapter = new SqlDataAdapter(); SqlConnection conn = OpenConnection(); command = new SqlCommand(procName, conn); command.CommandType = CommandType.StoredProcedure; using (SqlDataReader reader = command.ExecuteReader()) { result = ConvertX.GetListFromDataReader <ExportPlanHeader>(reader).ToList(); } } catch (Exception ex) { } finally { CloseConnection(); } return(result); }
List <T_Planing_EnvironmentDTO> GetEnvironment(HttpContext context, List <T_Planing_EnvironmentDTO> envirommentList) { T_Planing_EnvironmentDTO environmentDTO = null; T_Planing_EnvironmentDTO deleteENVByDto = null; List <T_Planing_EnvironmentDTO> myResultList = envirommentList; environmentDTO = ConvertX.GetReqeustForm <T_Planing_EnvironmentDTO>(); if (context.Request.Form["Step"].Trim().ToLower().Equals("add")) { if (myResultList == null) { environmentDTO.No = 1; myResultList = new List <T_Planing_EnvironmentDTO>(); } else { //Add existing coating defect environmentDTO.No = myResultList.Count + 1; } myResultList.Add(environmentDTO); } else if (context.Request.Form["Step"].Trim().ToLower().Equals("delete")) { string No = context.Request.Form["No"]; deleteENVByDto = myResultList.Find(o => o.No.ToString() == No); if (deleteENVByDto != null) { myResultList.Remove(deleteENVByDto); } } return(myResultList); }
private void StringKeyBox_Validating(object sender, CancelEventArgs e) { if (ConvertX.ToUInt32(this.StringKeyBox.Text) == 0) { MessageBox.Show("Unable to convert key to a hexadecimal hash or it equals 0.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); e.Cancel = true; } }
public HttpResponseMessage Reject() { bal = new T_Planing_Action_SiteRecoveryBAL(); ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; T_Planing_Action_SiteRecoveryDTO dto = null; try { var context = HttpContext.Current; //context.Response.ContentType = "multipart/form-data"; dto = ConvertX.GetReqeustForm <T_Planing_Action_SiteRecoveryDTO>(); string UserID = context.Request.Form["UserID"]; if (ObjUtil.isEmpty(UserID)) { throw new Exception("UserID is require"); } string RoleLevel = context.Request.Form["RoleLevel"]; if (ObjUtil.isEmpty(RoleLevel)) { throw new Exception("RoleLevel is require"); } if (RoleLevel == "1") { dto.Rejecter = UserID; dto.RejectStatus = RoleLevel; } else if (RoleLevel == "2") { dto.Rejecter = UserID; dto.RejectStatus = RoleLevel; } else if (RoleLevel == "3" || RoleLevel == "4" || RoleLevel == "5") { dto.Rejecter = UserID; dto.RejectStatus = "3"; } dto.CreateBy = UserID; dto.UpdateBy = UserID; logger.debug("Reject dto :" + dto.ToString()); response.statusCode = bal.Reject(dto); } catch (Exception ex) { logger.error("Reject error:" + ex.ToString()); response.statusText = ex.ToString(); } mapMessage = Request.CreateResponse(HttpStatusCode.OK, response); return(mapMessage); }
public List <M_TypeOfRouteCodeDTO> FindByObjList(object data) { List <SqlParameter> parameterList = new List <SqlParameter>(); objList = new List <M_TypeOfRouteCodeDTO>(); dataTable = null; string procName = "sp_M_TypeOfRouteCode_FindByColumn"; 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()) { objList = ConvertX.GetListFromDataReader <M_TypeOfRouteCodeDTO>(reader).ToList(); //while (reader.Read()) //{ // obj = new M_TypeOfRouteCodeDTO(); // obj.TypeOfRouteID = reader["TypeOfRouteID"].ToString(); // obj.TypeOfRouteCode = reader["TypeOfRouteCode"].ToString(); // obj.Name = reader["Name"].ToString(); // obj.Status = reader["Status"].ToString(); // obj.CreateDate = reader["CreateDate"].ToString(); // obj.CreateBy = reader["CreateBy"].ToString(); // obj.UpdateDate = reader["UpdateDate"].ToString(); // obj.UpdateBy = reader["UpdateBy"].ToString(); // objList.Add(obj); //} } } catch (Exception ex) { } finally { CloseConnection(); } return(objList); }
public HttpResponseMessage Search() { var deserializer = new JavaScriptSerializer(); bal = new T_Planing_Action_BFRemovalBAL(); ResposeType response = new ResposeType(); HttpResponseMessage mapMessage = null; T_Planing_Action_BFRemovalDTO dto = null; List <T_Planing_Action_BFRemovalDTO> objList = null; try { var context = HttpContext.Current; dto = ConvertX.GetReqeustForm <T_Planing_Action_BFRemovalDTO>(); logger.debug("Search dto:" + dto.ToString()); objList = bal.FindByObjList(dto); foreach (T_Planing_Action_BFRemovalDTO bfDTO in objList) { //Find detail and push to main object in list T_Planing_Action_BFRemovalDTO detailDTO = new T_Planing_Action_BFRemovalDTO(); detailDTO.PID = bfDTO.PID; detailDTO = bal.FindByPK(detailDTO); bfDTO.ConditionList = detailDTO.ConditionList; bfDTO.UploadFileList = detailDTO.UploadFileList; bfDTO.UploadDefectFileList = detailDTO.UploadDefectFileList; if (!ObjUtil.isEmpty(bfDTO.UploadFileList)) { foreach (T_Planing_File file in bfDTO.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_PlaningDTO FindByPK(object data) { List <SqlParameter> parameterList = new List <SqlParameter>(); var obj = new T_PlaningDTO(); dataTable = null; string procName = "sp_T_Planing_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_PlaningDTO>(reader).ToList()[0]; 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); reader.NextResult(); obj.UploadFileList = ConvertX.GetListFromDataReader <T_Planing_File>(reader).ToList(); } } catch (Exception ex) { } finally { CloseConnection(); } return(obj); }
private static string ExecuteDeleteTPKSTR(BasicBase db, string root, string node, string hash) { switch (root) { case TPKBlocks: if (!db.TryGetCollection(node, root, out var inter)) { return($"Collection {node} cannot be found in root {root}."); } if (!(inter is TPKBlock tpk)) { return($"Collection {node} is not a {STRBlocks} collection."); } if (tpk.TryRemoveTexture(ConvertX.ToUInt32(hash), eKeyType.BINKEY, out var error)) { return(null); } else if (Settings.Default.EnableSuppressABCI) { return(null); } else { return(error); } case STRBlocks: if (!db.TryGetCollection(node, root, out var collection)) { return($"Collection {node} cannot be found in root {root}."); } if (!(collection is STRBlock str)) { return($"Collection {node} is not a {STRBlocks} collection."); } if (str.TryRemoveRecord(hash, out var fail)) { return(null); } else if (Settings.Default.EnableSuppressABCI) { return(null); } else { return(fail); } default: return($"Invalid root passed named {root}."); } }
public static ushort GetValueToUShort(string Name) { ConsoleVarNode Node = FindVar(Name); if (Node != null) { return(ConvertX.ToUShort(Node.Value, 0, "", "trim", 0)); } else { return(0); } }
public SummaryPlanReport GetReportSummaryPlanOverAll(object data) { List <SqlParameter> parameterList = new List <SqlParameter>(); List <ProgressGraphDto> objList = new List <ProgressGraphDto>(); dataTable = null; SummaryPlanReport resultDto = new SummaryPlanReport();; string procName = "sp_Report_T_Planing_SummaryPlanOverAllReport"; 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()) { resultDto.RawGraphReport = ConvertX.GetListFromDataReader <ProgressGraphDto>(reader).ToList(); reader.NextResult(); resultDto.RawRiskGraphBeforeReport = ConvertX.GetListFromDataReader <ProgressGraphDto>(reader).ToList(); reader.NextResult(); resultDto.RawRiskGraphCoatingTypeReport = ConvertX.GetListFromDataReader <ProgressGraphDto>(reader).ToList(); reader.NextResult(); resultDto.RawRiskGraphAfterReport = ConvertX.GetListFromDataReader <ProgressGraphDto>(reader).ToList(); reader.NextResult(); resultDto.RawRiskGraphPipelineTypeReport = ConvertX.GetListFromDataReader <ProgressGraphDto>(reader).ToList(); reader.NextResult(); resultDto.OverAllTableReport = ConvertX.GetListFromDataReader <SummaryPlanOverAllProgressDto>(reader).ToList(); } } catch (Exception ex) { } finally { CloseConnection(); } return(resultDto); }
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); }
private static string ExecuteUpdateTPKSTR(BasicBase db, string root, string node, string hash, string field, string value) { switch (root) { case TPKBlocks: if (!db.TryGetCollection(node, root, out var inter)) { return($"Collection {node} cannot be found in root {root}."); } if (!(inter is TPKBlock tpk)) { return($"Collection {node} is not a {STRBlocks} collection."); } var texture = tpk.FindTexture(ConvertX.ToUInt32(hash), eKeyType.BINKEY); if (texture == null) { return($"Texture with key {hash} does not exist in {node}"); } string error = null; texture.SetValue(field, value, ref error); return(error); case STRBlocks: if (!db.TryGetCollection(node, root, out var collection)) { return($"Collection {node} cannot be found in root {root}."); } if (!(collection is STRBlock str)) { return($"Collection {node} is not a {STRBlocks} collection."); } var record = str.GetRecord(hash); if (record == null) { return($"StringRecord with key {hash} does not exist."); } if (!record.TrySetValue(field, value)) { return($"Unable to set value {value} in field {field} specified."); } else { return(null); } default: return($"Invalid root passed named {root}."); } }
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 List <DropDownListDTO> FindByObjList(DropDownlistType type) { List <SqlParameter> parameterList = new List <SqlParameter>(); objList = new List <DropDownListDTO>(); dataTable = null; string procName = ""; switch (type) { case DropDownlistType.DIGFrom: procName = "sp_M_DIGFrom_DropDownList"; break; case DropDownlistType.ClockPosition: procName = "sp_M_ClockPosition_DropDownList"; break; case DropDownlistType.HolidayTest: procName = "sp_M_HolidayTest_DropDownList"; break; case DropDownlistType.PipeLine: procName = "sp_M_PipelineLength_DropDownList"; break; case DropDownlistType.Region: procName = "sp_M_Region_DropDownList"; break; case DropDownlistType.RouteCode: procName = "sp_M_RouteCode_DropDownList"; break; case DropDownlistType.AssertOwner: procName = "sp_M_AssertOwner_DropDownList"; break; case DropDownlistType.Holiday: procName = "sp_M_Holiday_DropDownList"; break; } try { adapter = new SqlDataAdapter(); SqlConnection conn = OpenConnection(); command = new SqlCommand(procName, conn); command.CommandType = CommandType.StoredProcedure; SqlDataReader reader = command.ExecuteReader(); objList = ConvertX.ConvertDataReaderToObjectList <DropDownListDTO>(reader); reader.Close(); } catch (Exception ex) { } finally { CloseConnection(); } return(objList); }
public PlaceShipRequest SetUpShip(Dictionary<string, Coordinate> userDictionary, int shipTypeAsNum) { string coordinateRequested = ""; string shipDirectionRequest = ""; int shipDirAsNum = 0; //get ship type ShipType shipType = SetShipType(shipTypeAsNum); Console.WriteLine("You are placing a {0}....", shipType); //get X & Y Console.Write("\t(1) Please enter your X & Y coordinate(Ex: A1): "); coordinateRequested = Console.ReadLine(); //get ship direction while (!int.TryParse(shipDirectionRequest, out shipDirAsNum)) { Console.Write("\t(2) Please enter your ship direction (up=0,down=1,left=2,right=3): "); shipDirectionRequest = Console.ReadLine(); } shipDirAsNum = int.Parse(shipDirectionRequest); ShipDirection shipDirection = SetShipDirection(shipDirAsNum); //get coordinate ConvertX convertX = new ConvertX(); Coordinate aCoordinate = convertX.Conversion(userDictionary, coordinateRequested); //place ship PlaceShipRequest placeShips = new PlaceShipRequest { Coordinate = aCoordinate, Direction = shipDirection, ShipType = shipType }; return placeShips; }