public string FileUploadMethod(string fn, string path, Stream fs, string fc, string gfn, int id) { string givingFilename = gfn; string filename = fn; string contentType = fc; int FolderID = id; using (fs) { using (BinaryReader br = new BinaryReader(fs)) { byte[] bytes = br.ReadBytes((Int32)fs.Length); using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Database"].ConnectionString)) { SqlCommand cmd = new SqlCommand("db_owner.UploadFile", con); cmd.CommandType = CommandType.StoredProcedure; { cmd.Connection = con; cmd.Parameters.AddWithValue("@GName", givingFilename); cmd.Parameters.AddWithValue("@Name", filename); cmd.Parameters.AddWithValue("@ContentType", contentType); cmd.Parameters.AddWithValue("@Data", bytes); cmd.Parameters.AddWithValue("@ID", id); cmd.Parameters.AddWithValue("@UserID", Model_Layer.SessionData.SessionUserID); con.Open(); msg = HelperOutputMsgs.printMessage(cmd.ExecuteNonQuery()); con.Close(); return(msg); } } } } }
public string DeleteFolderDB(int ID) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Database"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("db_owner.DeleteFolder", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ID", ID)); msg = HelperOutputMsgs.printMessage(cmd.ExecuteNonQuery()); con.Close(); con.Dispose(); return(msg); }
public string UploadLinkDB(string Name, string Url) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Database"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("db_owner.UploadLink", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Name", Name)); cmd.Parameters.Add(new SqlParameter("@Url", Url)); msg = HelperOutputMsgs.printMessage(cmd.ExecuteNonQuery()); con.Close(); con.Dispose(); return(msg); }