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;
}
