public System.Web.Http.Results.JsonResult <DataTable> GetRawData(string Ticker, string Year) { dal objdal = new dal(); DataTable dt = objdal.GetRawData(Ticker, int.Parse(Year)); return(Json <DataTable>(dt)); }
// GET api/<controller> public System.Web.Http.Results.JsonResult <string> UploadDocuments() { string response = ""; if (HttpContext.Current.Request.Files.AllKeys.Any()) { var httpPostedFile = HttpContext.Current.Request.Files["UploadedFile"]; string directory_path = HttpContext.Current.Server.MapPath("~/UploadedFiles/"); if (!System.IO.Directory.Exists(directory_path)) { System.IO.Directory.CreateDirectory(directory_path); } var filePath = HttpContext.Current.Server.MapPath("~/UploadedFiles/" + httpPostedFile.FileName); httpPostedFile.SaveAs(filePath); string conString = string.Empty; conString = ConfigurationManager.ConnectionStrings["Excel07ConString"].ConnectionString; DataTable dt = new DataTable(); conString = string.Format(conString, filePath); using (OleDbConnection connExcel = new OleDbConnection(conString)) { using (OleDbCommand cmdExcel = new OleDbCommand()) { using (OleDbDataAdapter odaExcel = new OleDbDataAdapter()) { cmdExcel.Connection = connExcel; //Get the name of First Sheet. connExcel.Open(); DataTable dtExcelSchema; dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); string sheetName = "Upload$"; connExcel.Close(); //Read Data from First Sheet. connExcel.Open(); cmdExcel.CommandText = "SELECT * From [" + sheetName + "]"; odaExcel.SelectCommand = cmdExcel; odaExcel.Fill(dt); connExcel.Close(); foreach (DataRow row in dt.Rows) { dal obj = new dal(); if (!String.IsNullOrEmpty(row["SYMBOL"].ToString())) { obj.InsertRawData(row["SYMBOL"].ToString(), row["RPTCODE"].ToString(), row["ACSHORT"].ToString(), row["ACCOUNTCODE"].ToString(), int.Parse(row["YEAR"].ToString()), row["AMOUNT"].ToString(), row["CIK"].ToString(), row["UNIT"].ToString(), row["ROUNDING"].ToString(), row[9].ToString(), row["QUARTER"].ToString()); response = row["SYMBOL"].ToString() + "|" + row["YEAR"].ToString(); } } } } } } return(Json <string>(response)); }
public System.Web.Http.Results.JsonResult <DataTable> GetMappedValues(string Ticker, int Year, string MappingType) { dal objdal = new dal(); DataTable dt = objdal.GetMappedData(Ticker, Year, MappingType); return(Json <DataTable>(dt)); }
public System.Web.Http.Results.JsonResult <DataTable> GetSymbol() { dal objdal = new dal(); DataTable dt = objdal.GetSymbol(); return(Json <DataTable>(dt)); }
public System.Web.Http.Results.JsonResult <string> UpdateMappedCode(AccountData objData) { dal objdal = new dal(); objdal.UpdateMappedCode(objData.AccountCode, objData.GeneralCode, int.Parse(objData.Year)); return(Json <string>("")); }
public System.Web.Http.Results.JsonResult <string> InsertGeneralCode(AccountData objData) { dal objdal = new dal(); objdal.InsertGeneralAccountCode(objData.AccountCode, objData.ACShortCode, objData.RPTCode); return(Json <string>("")); }