public bool SaveClaimCertFile(ref ClaimCert model) { var result = false; using (var conn = new SqlConnection(_connectionString)) { var cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SaveClaimCertFile"; cmd.Parameters.AddWithValue("@IdClaim", model.IdClaim); cmd.Parameters.AddWithValue("@file", model.File); cmd.Parameters.AddWithValue("@fileName", model.FileName); conn.Open(); var rd = cmd.ExecuteReader(); if (rd.HasRows) { rd.Read(); var id = rd.GetInt32(0); if (id != -1) { result = true; model.Id = id; } } rd.Dispose(); } return result; }
public ActionResult SaveFile(string claimId) { if (Request.Files.Count > 0) { int? idClaim = null; try { idClaim = Convert.ToInt32(Request.QueryString["claimId"]); //idClaim = Convert.ToInt32(RouteData.Values["claimId"]); } catch (Exception ex) { idClaim = null; } if (idClaim != null && idClaim > 0) { //foreach (HttpPostedFileWrapper file in Request.Files) //{ for(int i=0; i<Request.Files.Count; i++) { var file = Request.Files[i]; byte[] fileData = null; using (var br = new BinaryReader(file.InputStream)) { fileData = br.ReadBytes(file.ContentLength); } var db = new DbEngine(); var cert = new ClaimCert() {IdClaim = idClaim.Value, File = fileData, FileName = file.FileName}; db.SaveClaimCertFile(ref cert); } //} } } return RedirectToAction("Index", "Calc", new { claimId = Request.QueryString["claimId"] }); }