public OpenPOoutputmodel Post(OpenPOinputmodel model)
{
string plantcd = model.plantcd;
OpenPOoutputmodel result = new OpenPOoutputmodel();
DataTable dt = new DataTable();
string JsonString = string.Empty;
JsonString = JsonConvert.SerializeObject(dt);
result.OutputData = result.getDataFromDB("EXEC [helper].[uSP_Open_PO_Report_Data] '" + model.materialnum + "','" + model.ponum + "','" + plantcd + "','" + model.pripbg + "','" + model.potype + "','" + model.plannername + "','" + model.plannermanager + "','" + model.plannerdirector + "','" + model.suppliersitename + "','" + model.ParentSupplierName + "'", " ");
return(result);
}
public OpenPOinputmodel Get()
{
OpenPOoutputmodel result = new OpenPOoutputmodel();
OpenPOinputmodel input = new OpenPOinputmodel();
DataTable dt = new DataTable();
string JsonString = string.Empty;
JsonString = JsonConvert.SerializeObject(dt);
input.pripbg = result.getDataFromDB("exec helper.uSP_open_po_inputs 'pripbg' ", " ");
input.plantcd = result.getDataFromDB("exec helper.uSP_open_po_inputs 'plantcd'", " ");
input.potype = result.getDataFromDB("exec helper.uSP_open_po_inputs 'potype'", " ");
input.plannername = result.getDataFromDB("exec helper.uSP_open_po_inputs 'plannername'", " ");
input.plannermanager = result.getDataFromDB("exec helper.uSP_open_po_inputs 'plannermanager'", " ");
input.plannerdirector = result.getDataFromDB("exec helper.uSP_open_po_inputs 'plannerdirector'", " ");
input.suppliersitename = result.getDataFromDB("exec helper.uSP_open_po_inputs 'suppliersitename'", " ");
input.ParentSupplierName = result.getDataFromDB("exec helper.uSP_open_po_inputs 'ParentSupplierName'", " ");
return(input);
}
// GET api/values
//public IEnumerable<string> Get()
//{
// return new string[] { "value1", "value2" };
//}
// GET api/values/5
public string Get(int id)
{
OpenPOoutputmodel model = new OpenPOoutputmodel();
var str = "";
var query = "";
if (id == 1)
{
str = HttpContext.Current.Request.LogonUserIdentity.Name.ToString();
query = "dbo.usp_gscobi_app_assitant '" + str + "','login'";
}
if (id == 2)
{
str = HttpContext.Current.Request.LogonUserIdentity.Name.ToString();
str = str.Replace("AMAT\\", "");
query = "insert into [GSCA_APPS].[dbo].[gscobi_apps_users_access_log] values ('" + str + "','OpenPoReport',GETDATE())";
}
if (id == 3)
{
str = HttpContext.Current.Request.LogonUserIdentity.Name.ToString();
str = str.Replace("AMAT\\", "");
query = "select EMPLOYEE_NTID, Favouriteslist from [dbo].[gscobi_apps_users_favourites_list] where [EMPLOYEE_NTID]='" + str + "' and [APPLICATION_NAME] = 'OpenPoReport'";
}
if (id == 4)
{
query = "select max(extractdate) as refreshdate from dbo.open_pos";
}
return(model.getDataFromDB(query, " "));;
}