public async Task <string> UploadRAWFileAsync(HttpPostedFileBase rawFile, string patientNumber) { string PatientRawFilePath = null; if (rawFile == null) { return(null); } try { CloudBlobContainer cloudBlobContainer = cloudBlobClient.GetContainerReference(PSScansRAW); string PatientRawFileName = Guid.NewGuid().ToString() + "-" + patientNumber + "-RAWSCAN"; CloudBlockBlob cloudBlockBlob = cloudBlobContainer.GetBlockBlobReference(PatientRawFileName); cloudBlockBlob.Properties.ContentType = rawFile.GetType().Name; await cloudBlockBlob.UploadFromStreamAsync(rawFile.InputStream); PatientRawFilePath = cloudBlockBlob.Uri.ToString(); } catch (Exception) { return(null); } return(PatientRawFilePath); }
/// <summary> /// 压缩并保存图片 /// </summary> /// <returns></returns> public static string CompressImg(HttpPostedFileBase file, int size) { var type = file.GetType(); string directory = HttpRuntime.AppDomainAppPath.ToString(); string path = "/Upload"; string extension = Path.GetExtension(file.FileName); CreateCatalog(directory, path); path = string.Format("{0}/{1}", path, DateTime.Now.ToString("yyyyMMdd")); CreateCatalog(directory, path); path = string.Format("{0}/{1}{2}{3}", path, DateTime.Now.ToString("yyyyMMddHHmmssfff"), new Random(GetRandomSeed()).Next(1, 1000), extension); GC.Collect(); return(CreateThumbnail(GetLocalPath(path), size, file.InputStream) ? path : ""); }
public ActionResult addimage(PieceJoint model, HttpPostedFileBase image1) { var db = new HELPDESK3Entities(); if (image1 != null) { model.img = new byte[image1.ContentLength]; model.filename = image1.FileName; model.type = "" + image1.GetType(); image1.InputStream.Read(model.img, 0, image1.ContentLength); } db.PieceJoint.Add(model); db.SaveChanges(); ViewBag.filename = image1.FileName; List <file> list = new List <file>(); const string connect = @"Server=WAHID;Database=HELPDESK3;Trusted_Connection=True;"; using (var conn = new SqlConnection(connect)) { var qry = "SELECT [IdPiece],[filename] FROM PieceJoint "; var cmd = new SqlCommand(qry, conn); conn.Open(); SqlDataReader result = cmd.ExecuteReader(); while (result.Read()) { list.Add(new file( result.GetInt32(0), result.GetString(1) )); } } ViewBag.list = list; return(View(model)); }
public ActionResult AddSave(Review review, HttpPostedFileBase upload) { // missing PublishDate if (review.PublishDate == DateTime.MinValue) { TempData["Error"] = TempData["Error"] + " Publish Date was empty"; } // missing Type if (String.IsNullOrEmpty(review.ReviewType)) { TempData["Error"] = TempData["Error"] + " Review Type was empty"; } // Odd way to handle empty image, but it works try { if (upload.GetType() == typeof(HttpPostedFileBase)) { // This will never hit TempData["Error"] = null; } } catch { TempData["Error"] = TempData["Error"] + " Image was not uploaded correctly"; } // missing header if (String.IsNullOrEmpty(review.ReviewHeader)) { TempData["Error"] = TempData["Error"] + " Title was empty"; } // missing review if (String.IsNullOrEmpty(review.ReviewText)) { TempData["Error"] = TempData["Error"] + " Review was empty"; } // return with error if (TempData["Error"] != null) { return(View("Add")); } if (upload.ContentLength > 3500000) { TempData["Error"] = "File Size is Too Large"; return(View("Add")); } // final catch if somehow there is an issue, but gets by other checks if (!ModelState.IsValid) { TempData["Error"] = "Unable to process, form data was missing"; return(View("Add")); } reviewRepository = new ReviewRepository(); if (upload != null && upload.ContentLength > 0) { var image = new Image { ImageName = System.IO.Path.GetFileName(upload.FileName), ContentType = upload.ContentType }; using (var reader = new System.IO.BinaryReader(upload.InputStream)) { image.ImageData = reader.ReadBytes(upload.ContentLength); } review.Image = image; } reviewRepository.Create(review); TempData["Success"] = "Successfully Added Review "; return(View("Index")); // If I ever wanted to show addition right away: // return RedirectToAction("Index", "Home"); }
public void UploadUser() { GridView GridView1 = new GridView(); int r = Request.Files.Count; HttpPostedFileBase file = Request.Files[0]; //Uploaded file //Use the following properties to get file's name, size and MIMEType int fileSize = file.ContentLength; string fileName = file.FileName; string[] values = fileName.Split('.'); string SheetName = values[0]; string filetype = file.GetType().ToString(); //OleDbConnection objConn = null; //System.Data.DataTable dt1 = null; //fileName = Server.MapPath(Path.Combine("~/Content/",Path.ChangeExtension(fileName, ".xlsx"))); //fileName = Server.MapPath(Path.Combine("~/Content/MyExcelFile_files/", Path.ChangeExtension(fileName, ".xlsx"))); //file.SaveAs(fileName); fileName = Server.MapPath(Path.Combine("~/Content/", fileName)); file.SaveAs(Path.ChangeExtension(fileName, ".xlsx")); using (SpreadsheetDocument doc = SpreadsheetDocument.Open(fileName, false)) { //Read the first Sheet from Excel file. Sheet sheet = doc.WorkbookPart.Workbook.Sheets.GetFirstChild <Sheet>(); //Get the Worksheet instance. Worksheet worksheet = (doc.WorkbookPart.GetPartById(sheet.Id.Value) as WorksheetPart).Worksheet; //Fetch all the rows present in the Worksheet. IEnumerable <Row> rows = worksheet.GetFirstChild <SheetData>().Descendants <Row>(); //Create a new DataTable. DataTable dt = new DataTable(); //Loop through the Worksheet rows. foreach (Row row in rows) { //Use the first row to add columns to DataTable. if (row.RowIndex.Value == 1) { foreach (Cell cell in row.Descendants <Cell>()) { dt.Columns.Add(GetValue(doc, cell)); } } else { //Add rows to DataTable. dt.Rows.Add(); int i = 0; foreach (Cell cell in row.Descendants <Cell>()) { dt.Rows[dt.Rows.Count - 1][i] = GetValue(doc, cell); i++; } } } //GridView1.DataSource = dt; //GridView1.DataBind(); int AlreadyExist = 0; string PhoneNumber = "", EmailAddress = "", PhoneNumberSaved = "", EmailAddressSaved = ""; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i][1].ToString() != string.Empty) { var user = new ApplicationUser { UserName = admin.GenerateUserName(), Email = dt.Rows[i][2].ToString(), PhoneNumber = dt.Rows[i][1].ToString() }; int count = admin.GetUserDetails(generic.GetSubscriberId(User.Identity.GetUserId())).Where(c => c.PhoneNumber == dt.Rows[i][1].ToString() || c.Email == dt.Rows[i][2].ToString()).Count(); if (count == 0) { rm.InsertBulkUser(user.Id, generic.GetSubscriberId(User.Identity.GetUserId()), dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString(), dt.Rows[i][3].ToString(), dt.Rows[i][0].ToString(), dt.Rows[i][4].ToString()); PhoneNumberSaved = PhoneNumberSaved + dt.Rows[i][1].ToString() + ","; EmailAddressSaved = EmailAddressSaved + dt.Rows[i][2].ToString() + ","; } else { AlreadyExist = AlreadyExist + 1; PhoneNumber = PhoneNumber + dt.Rows[i][1].ToString() + ","; EmailAddress = EmailAddress + dt.Rows[i][2].ToString() + ","; } } } doc.Close(); if (PhoneNumberSaved != "" && EmailAddressSaved != "") { ViewBag.BulkUserUpdated = true; ViewBag.ExistedPhoneNumberSaved = PhoneNumberSaved.TrimEnd(','); ViewBag.ExistedEmailSaved = PhoneNumberSaved.TrimEnd(','); } else if (PhoneNumber != "" && EmailAddress != "") { ViewBag.AlreadyExist = true; ViewBag.ExistedPhoneNumber = PhoneNumber.TrimEnd(','); ViewBag.ExistedEmail = EmailAddress.TrimEnd(','); } System.GC.Collect(); System.GC.WaitForPendingFinalizers(); if (System.IO.File.Exists(fileName)) { if (System.IO.File.Exists(fileName)) { System.IO.File.Delete(fileName); } } } TempData["BulkUserUpdated"] = true; }
public void importdatafromexcel(string excelfilepath) { GridView GridView1 = new GridView(); int r = Request.Files.Count; HttpPostedFileBase file = Request.Files[0]; //Uploaded file //Use the following properties to get file's name, size and MIMEType int fileSize = file.ContentLength; string fileName = file.FileName; string[] values = fileName.Split('.'); string SheetName = values[0]; string filetype = file.GetType().ToString(); string ExistedNumber = string.Empty; //fileName = Server.MapPath(Path.Combine("~/Content/",Path.ChangeExtension(fileName, ".xlsx"))); //fileName = Server.MapPath(Path.Combine("~/Content/MyExcelFile_files/", Path.ChangeExtension(fileName, ".xlsx"))); //file.SaveAs(fileName); fileName = Server.MapPath(Path.Combine("~/Content/", fileName)); file.SaveAs(Path.ChangeExtension(fileName, ".xlsx")); using (SpreadsheetDocument doc = SpreadsheetDocument.Open(fileName, false)) { //Read the first Sheet from Excel file. Sheet sheet = doc.WorkbookPart.Workbook.Sheets.GetFirstChild <Sheet>(); //Get the Worksheet instance. Worksheet worksheet = (doc.WorkbookPart.GetPartById(sheet.Id.Value) as WorksheetPart).Worksheet; //Fetch all the rows present in the Worksheet. IEnumerable <Row> rows = worksheet.GetFirstChild <SheetData>().Descendants <Row>(); //Create a new DataTable. DataTable dt = new DataTable(); //Loop through the Worksheet rows. foreach (Row row in rows) { //Use the first row to add columns to DataTable. if (row.RowIndex.Value == 1) { foreach (Cell cell in row.Descendants <Cell>()) { dt.Columns.Add(GetValue(doc, cell)); } } else { //Add rows to DataTable. dt.Rows.Add(); int i = 0; foreach (Cell cell in row.Descendants <Cell>()) { dt.Rows[dt.Rows.Count - 1][i] = GetValue(doc, cell); i++; } } } GridView1.DataSource = dt; GridView1.DataBind(); for (int i = 0; i < dt.Rows.Count; i++) { //DateTime today = System.DateTime.Now; DateTime today = Convert.ToDateTime(dt.Rows[i][4]); bool IsPresent = false; if (dt.Rows[i][5].ToString() == "P" || dt.Rows[i][5].ToString() == "true") { IsPresent = true; } else { IsPresent = false; } if (!rm.IsStudentAttendenceExists(dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString(), today)) { rm.InsertStudentAttendence(dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString(), today, IsPresent, dt.Rows[i][6].ToString()); } } doc.Close(); System.GC.Collect(); System.GC.WaitForPendingFinalizers(); if (System.IO.File.Exists(fileName)) { if (System.IO.File.Exists(fileName)) { System.IO.File.Delete(fileName); } } } //string path = Path.ChangeExtension(excelfilepath, ".xlsx"); ////string excelConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1;\""; //string excelConnection = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;\""; ////string path = @"E:\Blink\Blink\Content\MyExcelFile.xls"; ////string path = Server.MapPath(excelfilepath); //string ssqltable = "CandidateAttendances"; //HttpPostedFileBase file = Request.Files[0]; //Uploaded file ////Use the following properties to get file's name, size and MIMEType //int fileSize = file.ContentLength; //string fileName = file.FileName; //string[] values = fileName.Split('.'); //string SheetName = values[0]; //string filetype = file.GetType().ToString(); //OleDbConnection objConn = null; //System.Data.DataTable dt1 = null; //objConn = new OleDbConnection(excelConnection); //// Open connection with the database. //objConn.Open(); //// Get the data table containg the schema guid. //dt1 = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); //String[] excelSheets = new String[dt1.Rows.Count]; //int i1 = 0; //// Add the sheet name to the string array. //foreach (DataRow row in dt1.Rows) //{ // excelSheets[i1] = row["TABLE_NAME"].ToString(); // i1++; //} //// make sure your sheet name is correct, here sheet name is sheet1, so you can change your sheet name if have different //string myexceldataquery = "select * from [" + excelSheets[0] + "]"; //try //{ // //create our connection strings // string ssqlconnectionstring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; // //execute a query to erase any previous data from our destination table // string sclearsql = "select * from " + ssqltable; // SqlConnection sqlconn = new SqlConnection(ssqlconnectionstring); // SqlCommand sqlcmd = new SqlCommand(sclearsql, sqlconn); // sqlconn.Open(); // sqlcmd.ExecuteNonQuery(); // sqlconn.Close(); // using (OleDbDataAdapter adaptor = new OleDbDataAdapter(myexceldataquery, excelConnection)) // { // DataSet ds = new DataSet(); // adaptor.Fill(ds); // System.Data.DataTable dt = ds.Tables[0]; // for (int i = 0; i < dt.Rows.Count; i++) // { // //DateTime today = System.DateTime.Now; // DateTime today = Convert.ToDateTime(dt.Rows[i][4]); // bool IsPresent = false; // if (dt.Rows[i][5].ToString() == "P" || dt.Rows[i][5].ToString() == "true") // { // IsPresent = true; // } // else // { // IsPresent = false; // } // if (!rm.IsStudentAttendenceExists(dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString(), today)) // rm.InsertStudentAttendence(dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString(), today, IsPresent, dt.Rows[i][6].ToString()); // } // } //} //catch (Exception ex) //{ // ex.ToString(); // //handle exception //} }