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