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