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