public FileUpViewModel Insert(FileUpViewModel objEntity) { try { Database objDB = base.GetDatabase(); // Create a suitable command type and add the required parameter. using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SP_FileUpViewModelInsert)) { objDB.AddInParameter(sprocCmd, PARAM_FileName, DbType.String, objEntity.FileName); objDB.AddOutParameter(sprocCmd, PARAM_Id, DbType.Int16, objEntity.Id); objDB.AddOutParameter(sprocCmd, PARAM_Result, DbType.Int32, objEntity.Result); objDB.ExecuteNonQuery(sprocCmd); objEntity.Id = Convert.ToInt32(objDB.GetParameterValue(sprocCmd, PARAM_Id)); objEntity.Result = Convert.ToInt32(objDB.GetParameterValue(sprocCmd, PARAM_Result)); } } catch (Exception ex) { throw ex; } finally { } return(objEntity); }
public ActionResult Create(FileUpViewModel objEntity) { FileUpViewModel objFileUpRepository = new FileUpViewModel(); FileUpRepository objfileRepository = new FileUpRepository(); string fileName = string.Empty; if (ModelState.IsValid) { if (!string.IsNullOrEmpty(objEntity.UpFile.FileName)) { fileName = Guid.NewGuid().ToString() + Path.GetExtension(objEntity.UpFile.FileName); objEntity.FileName = fileName; } objfileRepository.Insert(objEntity); if (objEntity.Result == ResultFlags.Success.GetHashCode()) { //save image http://www.w3schools.com/aspnet/webpages_ref_helpers.asp //file name if (!string.IsNullOrEmpty(objEntity.UpFile.FileName)) { string path = Path.Combine(Server.MapPath(ApplicationConstant.UPLOADED_EMPLOYER_LOGO_PATH), fileName); // WebImage.Save() objEntity.UpFile.SaveAs(path); } this.Flash("success", "Student Insert successfully "); return(RedirectToAction("Index")); } else if (objEntity.Result == ResultFlags.Failure.GetHashCode()) { this.Flash("error", "Faild to Insert File"); return(RedirectToAction("Index")); } else if (objEntity.Result == ResultFlags.Duplicate.GetHashCode()) { this.Flash("warning", "File is Already Exist"); return(RedirectToAction("Index")); } } return(View(objEntity)); }