public IHttpActionResult DownloadRateCardExcelTemplate(string CourierCompany, string LogisticType, string RateType)
{
FrayteManifestName file = new FrayteManifestName();
file = new BaseRateCardUpdateRepository().DownloadRateCardExcelTemplate(CourierCompany, LogisticType, RateType);
return(Ok(file));
}
public FrayteResult UploadBaseRate()
{
FrayteResult result = new FrayteResult();
var httpRequest = HttpContext.Current.Request;
if (httpRequest.Files.Count > 0)
{
HttpFileCollection files = httpRequest.Files;
HttpPostedFile file = files[0];
if (!string.IsNullOrEmpty(file.FileName))
{
string connString = "";
string filename = DateTime.Now.ToString("MM_dd_yyyy_hh_mm_ss_") + file.FileName;
string filepath = HttpContext.Current.Server.MapPath("~/UploadFiles/Shipments/" + filename);
file.SaveAs(filepath);
connString = new BaseRateCardUpdateRepository().getExcelConnectionString(filename, filepath);
string fileExtension = "";
fileExtension = new BaseRateCardUpdateRepository().getFileExtensionString(filename);
try
{
if (!string.IsNullOrEmpty(fileExtension))
{
var ds = new DataSet();
using (var conn = new OleDbConnection(connString))
{
conn.Open();
DataTable dbSchema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
//for (int j = 0; j < dbSchema.Rows.Count; j++)
//{
string firstSheetName = dbSchema.Rows[0]["TABLE_NAME"].ToString();
var query = "SELECT * FROM " + "[" + firstSheetName + "]";
using (var adapter = new OleDbDataAdapter(query, conn))
{
adapter.Fill(ds, "Rates");
}
var exceldata = ds.Tables[0];
if (exceldata.Rows.Count > 0)
{
result = new BaseRateCardUpdateRepository().UpdateRates(exceldata);
}
//}
}
if ((System.IO.File.Exists(filepath)))
{
System.IO.File.Delete(filepath);
}
}
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
}
}
return(result);
}
