public DataSet Opr_DocumentUpload(StudentDocumentVerification _obj) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("Opr_DocumentUpload", _cn); _cmd.Parameters.AddWithValue("@Type", _obj.Type); _cmd.Parameters.AddWithValue("@For", _obj.For); _cmd.Parameters.AddWithValue("@studentid", _obj.studentid); _cmd.Parameters.AddWithValue("@ID", _obj.ID); _cmd.Parameters.AddWithValue("@Path", _obj.Path); _cmd.Parameters.AddWithValue("@MainPart", _obj.MainPart); _cmd.Parameters.AddWithValue("@DeciamlPart", _obj.DeciamlPart); _cmd.Parameters.AddWithValue("@EQ_AE_ID", _obj.EQ_AE_ID); _cmd.Parameters.AddWithValue("@Score", _obj.Score); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return(_ds); } catch (Exception) { throw; } finally { _cn.Close(); } }
public JsonResult UploadDocs(StudentDocumentVerification _obj) { // mStudent_Ch_Doc_Upload _obj = new mStudent_Ch_Doc_Upload(); string Message = string.Empty, Code = string.Empty, Error = string.Empty; try { string path = ""; string filename = ""; string fname = ""; if (_obj.For == "Upload") { if (Request.Files.Count > 0) { if (Request.Files[0].ContentLength > 0) { HttpFileCollectionBase files = Request.Files; path = AppDomain.CurrentDomain.BaseDirectory + "Uploads/studentDocument/" + Session["studentid"].ToString() + "/" + Session["ApplicationNo"].ToString() + "/"; filename = Path.GetFileName(Request.Files[0].FileName); HttpPostedFileBase file = files[0]; _obj.name = _obj.name.Trim().Replace(" / ", "_"); _obj.name = _obj.name.Trim().Replace("/", ""); _obj.name = _obj.name.Trim().Replace(" ", ""); _obj.name = _obj.name.Trim().Replace("//", "_"); _obj.name = _obj.name.Trim().Replace("(", "_"); _obj.name = _obj.name.Trim().Replace(")", "_"); _obj.name = _obj.name.Trim().Replace(",", ""); filename = _obj.name + "_" + Session["ApplicationNo"].ToString() + Path.GetExtension(file.FileName); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } else { string[] curentfiles = Directory.GetFiles(path); foreach (string curentfile in curentfiles) { if (curentfile.IndexOf(filename) >= 0) { System.IO.File.Delete(curentfile); } } } fname = Path.Combine(Server.MapPath("~/Uploads/studentDocument/" + Session["studentid"].ToString() + "/" + Session["ApplicationNo"].ToString() + "/"), filename); file.SaveAs(fname); _obj.Path = "Uploads/studentDocument/" + Session["studentid"].ToString() + "/" + Session["ApplicationNo"].ToString() + "/" + filename; } else { Message = "Error from server side. Kindly refresh the page and try again."; Code = "servererror"; _obj.Path = ""; } } else { Message = "Error from server side. Kindly refresh the page and try again."; Code = "servererror"; _obj.Path = ""; } } else if (_obj.For == "EQ") { } else if (_obj.For == "AE") { } _obj.Type = "UPDATE"; _obj.studentid = Session["studentid"].ToString(); ChoiceFillingRepository _objRepo = new ChoiceFillingRepository(); DataSet _ds = _objRepo.Opr_DocumentUpload(_obj); if (_ds != null) { if (_ds.Tables[0].Rows.Count > 0) { if (_ds.Tables[0].Rows[0]["COUNTS"].ToString() == "1") { Message = "Document uploaded successfully!"; Code = "success"; } else if (_ds.Tables[0].Rows[0]["COUNTS"].ToString() == "-1") { Message = "Timeout!"; Code = "timeout"; } else { Message = "Error from server side. Kindly refresh the page and try again."; Code = "servererror"; } } else { Message = "Error from server side. Kindly refresh the page and try again."; Code = "servererror"; } } else { Message = "Error from server side. Kindly refresh the page and try again."; Code = "servererror"; } } catch (NullReferenceException) { Message = "Your session has been expired. Kindly login again."; Code = "sessionexpired"; } catch (Exception ex) { Error = ex.Message; Message = "Error from server side. Kindly refresh the page and try again."; Code = "servererror"; } return(Json(new { m = Message, c = Code, p = _obj.Path, e = Error }, JsonRequestBehavior.AllowGet )); }