public int DALInsertVideo(BLLVideoFile obj) { using (SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { try { SqlParameter[] par = new SqlParameter[4]; par[0] = new SqlParameter("@url", obj.Url); par[1] = new SqlParameter("@filename", obj.Filename); par[2] = new SqlParameter("@userid", obj.Userid); par[3] = new SqlParameter("@status", 5); par[3].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(cn, CommandType.StoredProcedure, "VideoInsert", par); status = (int)par[3].Value; } catch (Exception ex) { } finally { cn.Close(); } } return(status); }
public int BLLInsertVideo(BLLVideoFile ur) { status = objvideo.DALInsertVideo(ur); return(status); }