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