Beispiel #1
0
 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);
 }
Beispiel #2
0
 public int BLLInsertVideo(BLLVideoFile ur)
 {
     status = objvideo.DALInsertVideo(ur);
     return(status);
 }