public HttpResponseMessage SavePRData(PRHeaderModels Header)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
int id = repository.InsertHeader(Header, ref errMsg);
//ds.Tables.Add(dtDocumentVnos);
if (errMsg != "" && errMsg != "ยอดรวมมากกว่างบประมาณอนุมัติของแผนกในเดือนปัจจุบัน")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
public HttpResponseMessage GETListPROverForApprove(int id, int depid)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
dt = repository.GetPROverDataForApprove(id, depid, ref errMsg);
ds.Tables.Add(dt);
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
public HttpResponseMessage GETListReportBudget(int year, int month, int StaffCode, int DEPcode)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
DataTable dtHeaderData = Reportrepository.GetReportBudget(year, month, StaffCode, DEPcode, ref errMsg);
ds.Tables.Add(dtHeaderData);
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
/// <summary>Gets the value of a specific property with respect to a null-based (row or column) index.
/// </summary>
/// <typeparam name="TEnum">The type of the output which is assumed to be a enumeration.</typeparam>
/// <param name="rowIndex">The null-based index of the row.</param>
/// <param name="columnIndex">The null-based index of the column.</param>
/// <param name="enumStringRepresentationUsage">The method how to compute the <see cref="System.String"/> representation.</param>
/// <param name="value">The value (output).</param>
/// <returns>A value indicating whether <paramref name="value"/> contains valid data.</returns>
/// <exception cref="ArgumentException">Thrown, if <typeparamref name="TEnum"/> does not represents a enumeration.</exception>
public ExcelCellValueState TryGetValue <TEnum>(EnumStringRepresentationUsage enumStringRepresentationUsage, out TEnum value, int rowIndex, int columnIndex)
where TEnum : struct, IComparable, IConvertible, IFormattable
{
if ((rowIndex < m_RowCount) && (rowIndex >= 0) && (columnIndex < m_ColumnCount) && (columnIndex >= 0))
{
string valueDropDownListAsString = EnumString <TEnum> .GetValues(enumStringRepresentationUsage).AsExcelDropDownListString();
m_SetOfUsedPropertyIndices.Add(rowIndex);
m_Range.CreateDropdownList(rowIndex, columnIndex, valueDropDownListAsString);
if (ExcelDataConverter.IsEmptyCell(m_Data[rowIndex, columnIndex]) == true)
{
value = default(TEnum);
m_GuidedExcelDataQuery.SetData(rowIndex, columnIndex, typeof(TEnum));
return(ExcelCellValueState.EmptyOrMissingExcelCell);
}
else if (ExcelDataConverter.TryGetCellValue <TEnum>(m_Data[rowIndex, columnIndex], enumStringRepresentationUsage, out value) == true)
{
m_GuidedExcelDataQuery.SetData(rowIndex, columnIndex, value);
return(ExcelCellValueState.ProperValue);
}
}
value = default(TEnum);
return(ExcelCellValueState.NoValidValue);
}
public HttpResponseMessage PostLogPreview(int id)
{
string errMsg = "";
bool ret = false;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result response = new Result();
repository.LogPreview(id, ref errMsg);
if (errMsg != "")
{
response.StatusCode = (int)(StatusCodes.Error);
response.Messages = errMsg;
}
else
{
response.StatusCode = (int)(StatusCodes.Succuss);
response.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
public HttpResponseMessage GETGeneratePRID(int id)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
DataTable dtDocumentVnos = repository.GeneratePONo(id, ref errMsg);
ds.Tables.Add(dtDocumentVnos);
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
/// <summary>Gets the value of a specific Excel cell.
/// </summary>
/// <typeparam name="TEnum">The type of the output which is assumed to be a enumeration.</typeparam>
/// <param name="inputCell">The input Excel cell.</param>
/// <param name="value">The value of the Excel cell (output).</param>
/// <param name="enumStringRepresentationUsage">The method how to compute the <see cref="System.String"/> representation.</param>
/// <returns>A value indicating whether <paramref name="value"/> contains valid data.</returns>
/// <exception cref="ArgumentException">Thrown, if <typeparamref name="TEnum"/> does not represents a enumeration.</exception>
private ExcelCellValueState TryGetValue <TEnum>(object inputCell, out TEnum value, EnumStringRepresentationUsage enumStringRepresentationUsage)
where TEnum : struct, IComparable, IConvertible, IFormattable
{
object excelCellValue;
if (inputCell == null)
{
value = default(TEnum);
return(ExcelCellValueState.NoValidValue);
}
else if (inputCell is ExcelReference)
{
ExcelReference excelRange = (ExcelReference)inputCell;
string valueDropDownListAsString = EnumString <TEnum> .GetValues(enumStringRepresentationUsage).AsExcelDropDownListString();
excelRange.CreateDropdownList(0, 0, valueDropDownListAsString);
excelCellValue = excelRange.GetValue();
}
else
{
excelCellValue = inputCell;
}
if (ExcelDataConverter.IsEmptyCell(excelCellValue) == true)
{
value = default(TEnum);
return(ExcelCellValueState.EmptyOrMissingExcelCell);
}
return((ExcelDataConverter.TryGetCellValue <TEnum>(excelCellValue, enumStringRepresentationUsage, out value) == true) ? ExcelCellValueState.ProperValue : ExcelCellValueState.NoValidValue);
}
public HttpResponseMessage GETDashBroadByDepartment(int id)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
ds = Reportrepository.GetDashBroadByDepartment(id, ref errMsg);
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
public HttpResponseMessage GETPrepareReportPR()
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
dt = Reportrepository.GetDEP();
ds.Tables.Add(dt);
DataTable dtstatus = Reportrepository.GetPRStatus();
ds.Tables.Add(dtstatus);
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
public HttpResponseMessage GETReportPR(DateTime startdate, DateTime finishdate, int dep, int status)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
DataTable dtHeaderData = Reportrepository.GetPRReport(startdate, finishdate, dep, status, ref errMsg);
ds.Tables.Add(dtHeaderData);
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
public HttpResponseMessage UpdatePreviewDetailData(List <PRDetailModels> detail)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
//foreach (PRDetailModels item in detail) {
// item.Document_Detail_Hid = id;
//}
repository.UpdatePreviewDetail(detail, ref errMsg);
//ds.Tables.Add(dtDocumentVnos);
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
public HttpResponseMessage GETViewPO(int id, int StaffID)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
DataTable dtHeaderData = repository.GetPOHeaderData(id, StaffID, ref errMsg);
DataTable dtDetail = repository.GetDetailData(id, ref errMsg);
ds.Tables.Add(dtHeaderData);
ds.Tables.Add(dtDetail);
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
private EnumString GetEnumerator(string itemID, BrowseFilters filters, bool branches)
{
EnumString str2;
IOPCBrowseServerAddressSpace server = (IOPCBrowseServerAddressSpace)base.m_server;
try
{
server.ChangeBrowsePosition(OPCBROWSEDIRECTION.OPC_BROWSE_TO, (itemID != null) ? itemID : "");
}
catch
{
try
{
server.ChangeBrowsePosition(OPCBROWSEDIRECTION.OPC_BROWSE_DOWN, (itemID != null) ? itemID : "");
}
catch
{
throw new ResultIDException(ResultID.Da.E_UNKNOWN_ITEM_NAME);
}
}
try
{
OpcRcw.Da.IEnumString ppIEnumString = null;
server.BrowseOPCItemIDs(branches ? OPCBROWSETYPE.OPC_BRANCH : OPCBROWSETYPE.OPC_LEAF, (filters.ElementNameFilter != null) ? filters.ElementNameFilter : "", 0, 0, out ppIEnumString);
str2 = new EnumString(ppIEnumString);
}
catch
{
throw new ResultIDException(ResultID.Da.E_UNKNOWN_ITEM_NAME);
}
return(str2);
}
public HttpResponseMessage RejectPOData(PRHeaderModels Header)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
int id = repository.RejectPO(Header.Document_Id, Header.Document_CreateUser, ref errMsg);
//ds.Tables.Add(dtDocumentVnos);
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
public HttpResponseMessage GETStaffRoleDataByID(int POSid)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
dt = repository.GetPermissionDataByID(ref errMsg, POSid);
//dt = repository.GetDepartmentData(ref errMsg);
ds.Tables.Add(dt);
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
resData.Records = ds.Tables[0].Rows.Count;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
public async Task <HttpResponseMessage> GetBudgetByDep(int id)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
dt = await repository.GetBudgetByDep(id);
ds.Tables.Add(dt);
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
resData.Records = ds.Tables[0].Rows.Count;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
public HttpResponseMessage PostLogin(StaffModels item)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
dt = repository.Login(item.StaffLogin, item.StaffPassword, ref errMsg);
ds.Tables.Add(dt);
if (dt.Rows.Count <= 0 && errMsg == "")
{
errMsg = "รหัสพนักงาน/รหัสผ่าน ไม่ถูกต้อง." + Environment.NewLine + "โปรดตรวจสอบ รหัสพนักงาน/รหัสผ่าน ก่อน login เข้าระบบอีกครั้ง";
}
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
resData.Records = ds.Tables[0].Rows.Count;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
public HttpResponseMessage UpdateDetailData(PRDetailModels detail, int id)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
int docid = repository.UpdatetmpDetail(detail, ref errMsg);
//ds.Tables.Add(dtDocumentVnos);
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
private VKParams GetSearchParams(
String query,
Boolean autoComplete,
Boolean lyrics,
Boolean performerOnly,
VKSearchSortEnum sort,
Boolean searchOwn,
Int32 offset,
Int32?count)
{
VKParams param = new VKParams();
param.Add("q", query);
param.Add("auto_complete", autoComplete.ToVKValue());
param.Add("lyrics", lyrics.ToVKValue());
param.Add("performer_only", performerOnly.ToVKValue());
param.Add("sort", EnumString.GetStringValue(sort));
param.Add("search_own", searchOwn.ToVKValue());
param.Add("offset", offset);
if (count.HasValue)
{
param.Add("count", count);
}
return(param);
}
public HttpResponseMessage CancelPRTmpDetail(int id)
{
string errMsg = "";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
Result resData = new Result();
repository.DeleteTmpDetail(id, ref errMsg);
if (errMsg != "")
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = errMsg;
}
else
{
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
resData.Results = ds;
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
public HttpResponseMessage updateFileEdit(List <string> listfiledelete, int docid, string tmpupload)
{
Result resData = new Result();
try
{
//string path = HttpContext.Current.Server.MapPath("~/Upload/" + Pathfile);
foreach (string item in listfiledelete)
{
string sourcePath = System.Web.Hosting.HostingEnvironment.MapPath("~/Upload/" + item);
if (System.IO.File.Exists(sourcePath))
{
System.IO.File.Delete(sourcePath);
}
}
string Path = System.Web.Hosting.HostingEnvironment.MapPath("~/tmpUpload/" + tmpupload + "/");
string targetpath = System.Web.Hosting.HostingEnvironment.MapPath("~/Upload/" + docid.ToString() + "/");
if (System.IO.Directory.Exists(Path))
{
if (!System.IO.Directory.Exists(targetpath))
{
System.IO.Directory.CreateDirectory(targetpath);
}
string[] files = System.IO.Directory.GetFiles(Path);
// Copy the files and overwrite destination files if they already exist.
foreach (string s in files)
{
// Use static Path methods to extract only the file name from the path.
string fileName = System.IO.Path.GetFileName(s);
string destFile = System.IO.Path.Combine(targetpath, fileName);
System.IO.File.Copy(s, destFile, true);
}
System.IO.DirectoryInfo di = new System.IO.DirectoryInfo(Path);
foreach (System.IO.FileInfo file in di.GetFiles())
{
file.Delete();
}
foreach (System.IO.DirectoryInfo dir in di.GetDirectories())
{
dir.Delete(true);
}
}
resData.StatusCode = (int)(StatusCodes.Succuss);
resData.Messages = (String)EnumString.GetStringValue(StatusCodes.Succuss);
}
catch (Exception ex)
{
resData.StatusCode = (int)(StatusCodes.Error);
resData.Messages = ex.Message;;
}
//Send OK Response to Client.
return(Request.CreateResponse(HttpStatusCode.OK, resData));
}
/// <summary>
/// Determines what kind of role the node has
/// </summary>
/// <param name="node">The given xml node to check</param>
/// <returns>If the node is a parent, group, or child</returns>
private static GMNodeType GetNodeType(XmlNode node)
{
// If the node is a text type, it carries a value so it is a child node
// Else if the node's parent is the asset node, it is major resource parent node
// Else it is a group node
return(node.NodeType == XmlNodeType.Text ? GMNodeType.Child :
node.ParentNode.Name == EnumString.GetEnumString(GMResourceType.Assets) ? GMNodeType.Parent : GMNodeType.Group);
}
public override void Dispose()
{
if (this.Enumerator != null)
{
this.Enumerator.Dispose();
this.Enumerator = null;
}
}
private VKParams GetBroadcastParams(VKBroadcastFilterEnum filter, Boolean getOnlyActive)
{
VKParams param = new VKParams();
param.Add("active", getOnlyActive.ToVKValue());
param.Add("filter", EnumString.GetStringValue(filter));
return(param);
}
public string[] BrowseAccessPaths(string itemId)
{
IEnumString obj = null;
_server.BrowseAccessPaths(itemId, out obj);
var enumString = new EnumString(obj, 100);
return(Enumerable.Repeat(enumString, int.MaxValue).Select(_ => _.Next()).TakeWhile(_ => _ != null).ToArray());
}
public string[] BrowseItemIds(OpcBrowseType browseType, string filterCriteria, short dataTypeFilter, int accessRightsFilter)
{
IEnumString ppIEnumString = null;
_server.BrowseOPCItemIDs((OPCBROWSETYPE)browseType, filterCriteria, dataTypeFilter, accessRightsFilter, out ppIEnumString);
var enumString = new EnumString(ppIEnumString, 100);
return(Enumerable.Repeat(enumString, int.MaxValue).Select(_ => _.Next()).TakeWhile(_ => _ != null).ToArray());
}
public override void Dispose()
{
if (this.m_enumerator != null)
{
this.m_enumerator.Dispose();
this.m_enumerator = null;
}
base.Dispose();
}
internal BrowsePosition(ItemIdentifier itemID, BrowseFilters filters, EnumString enumerator, bool isBranch) : base(itemID, filters)
{
this.Enumerator = null;
this.IsBranch = true;
this.Names = null;
this.Index = 0;
this.Enumerator = enumerator;
this.IsBranch = isBranch;
}
/// <summary>
/// The state rover position.
/// </summary>
private void StateRoverPosition()
{
string stateRoverPosition = string.Format(
" X : {0} Y : {1} Direction : {2}",
this.RoverPosition.X,
this.RoverPosition.Y,
EnumString.GetStringValue(this.RoverCompass));
Console.WriteLine(stateRoverPosition);
}
/// <summary>Initializes a new instance of the <see cref="UserControlConfigurationGeneral"/> class.
/// </summary>
public UserControlConfigurationGeneral()
{
InitializeComponent();
foreach (var dropDownAdviseType in EnumString <ExcelLowLevel.DropDownListCreationType> .GetValues())
{
comboBoxAddDropDownList.Items.Add(dropDownAdviseType);
}
RestoreConfiguration();
}
///<summary>
/// IOPCServer::CreateGroupEnumerator - Creates various enumerators for the groups provided by the Server.
///</summary>
public void CreateGroupEnumerator(OpcRcw.Da.OPCENUMSCOPE dwScope, ref Guid riid, out object ppUnk)
{
lock (m_lock)
{
try
{
switch (dwScope)
{
case OPCENUMSCOPE.OPC_ENUM_PUBLIC:
case OPCENUMSCOPE.OPC_ENUM_PUBLIC_CONNECTIONS:
{
if (riid == typeof(OpcRcw.Comn.IEnumString).GUID)
{
ppUnk = new EnumString(null);
return;
}
if (riid == typeof(OpcRcw.Comn.IEnumUnknown).GUID)
{
ppUnk = new EnumUnknown(null);
return;
}
throw ComUtils.CreateComException("E_NOINTERFACE", ResultIds.E_NOINTERFACE);
}
}
if (riid == typeof(IEnumUnknown).GUID)
{
ppUnk = new EnumUnknown(m_groups);
return;
}
if (riid == typeof(OpcRcw.Comn.IEnumString).GUID)
{
ArrayList names = new ArrayList(m_groups.Count);
foreach (string name in m_groups.Keys)
{
names.Add(name);
}
ppUnk = new EnumString(names);
return;
}
throw ComUtils.CreateComException("E_NOINTERFACE", ResultIds.E_NOINTERFACE);
}
catch (Exception e)
{
throw ComUtils.CreateComException(e);
}
}
}
