public static ContentDownloadInfo GetInfo(int content_ID, int downloadId) { ContentDownloadInfo retVal = null; var dbConn = new SqlConnection(AppEnv.ConnectionString); var dbCmd = new SqlCommand("CMS_ContentDownload_GetInfo", dbConn) { CommandType = CommandType.StoredProcedure }; dbCmd.Parameters.AddWithValue("@Content_ID", content_ID); dbCmd.Parameters.AddWithValue("@Download_ID", downloadId); try { dbConn.Open(); var dr = dbCmd.ExecuteReader(); if (dr.Read()) { retVal = new ContentDownloadInfo(); retVal.Content_ID = ConvertUtility.ToInt32(dr["Content_ID"]); retVal.Download_ID = ConvertUtility.ToInt32(dr["Download_ID"]); retVal.Priority = ConvertUtility.ToInt32(dr["Priority"]); } if (dr != null) { dr.Close(); } } finally { dbConn.Close(); } return(retVal); }
public static void Update(ContentDownloadInfo contentDownloadInfo) { var dbConn = new SqlConnection(AppEnv.ConnectionString); var dbCmd = new SqlCommand("CMS_ContentDownload_Update", dbConn) { CommandType = CommandType.StoredProcedure }; dbCmd.Parameters.AddWithValue("@Content_ID", contentDownloadInfo.Content_ID); dbCmd.Parameters.AddWithValue("@Download_ID", contentDownloadInfo.Download_ID); dbCmd.Parameters.AddWithValue("@Priority", contentDownloadInfo.Priority); try { dbConn.Open(); dbCmd.ExecuteNonQuery(); } finally { dbConn.Close(); } }
public static int Insert(ContentDownloadInfo contentDownloadInfo) { var dbConn = new SqlConnection(AppEnv.ConnectionString); var dbCmd = new SqlCommand("CMS_ContentDownload_Insert", dbConn) { CommandType = CommandType.StoredProcedure }; dbCmd.Parameters.AddWithValue("@Content_ID", contentDownloadInfo.Content_ID); dbCmd.Parameters.AddWithValue("@Download_ID", contentDownloadInfo.Download_ID); dbCmd.Parameters.AddWithValue("@Priority", contentDownloadInfo.Priority); dbCmd.Parameters.AddWithValue("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue; try { dbConn.Open(); dbCmd.ExecuteNonQuery(); return((int)dbCmd.Parameters["@RETURN_VALUE"].Value); } finally { dbConn.Close(); } }
private static ContentDownloadInfo CreateEntityFromReader(IDataReader reader) { var item = new ContentDownloadInfo(); try { if (!reader.IsDBNull(reader.GetOrdinal("Content_ID"))) { item.Content_ID = ConvertUtility.ToInt32(reader["Content_ID"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Download_ID"))) { item.Download_ID = ConvertUtility.ToInt32(reader["Download_ID"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Priority"))) { item.Priority = ConvertUtility.ToInt32(reader["Priority"]); } } catch { } return(item); }
protected void btnAddNew_Click(object sender, EventArgs e) { var dirUpload = AppEnv.UploadDocument; double filesize = 0; string extension = ""; string fileAvatarPath = "", newfileAvatarName = ""; var info = new DownloadInfo(); if (txtFile.PostedFile.FileName.Length > 0) { var fileNameWithoutExtension = Path.GetFileNameWithoutExtension(txtFile.PostedFile.FileName); if (fileNameWithoutExtension != null) { string filename = fileNameWithoutExtension.Replace(" ", "_").Replace("#", "_"); var s = Path.GetExtension(txtFile.PostedFile.FileName); if (s != null) { extension = s.ToLower(); } newfileAvatarName = filename + "_" + DateTime.Now.ToString("mmss") + txtFile.PostedFile.FileName.Substring(txtFile.PostedFile.FileName.LastIndexOf('.')); } txtFile.PostedFile.SaveAs(Server.MapPath(dirUpload) + newfileAvatarName); double filesizeb = txtFile.PostedFile.ContentLength; filesize = filesizeb / (1024 * 1024); fileAvatarPath = dirUpload + newfileAvatarName; } else { fileAvatarPath = ""; } if (fileAvatarPath.Length > 0) { if (txtName.Text.Length > 0) { info.Download_Name = ConvertUtility.ToString(txtName.Text); } else { info.Download_Name = newfileAvatarName; } info.Download_Description = txtTeaser.Text; info.Download_File = fileAvatarPath; info.Download_Extension = extension; info.Download_Visible = chkVisible.Checked; info.Download_CreateDate = DateTime.Now; info.Download_FileSize = ConvertUtility.ToDouble(filesize.ToString("#0.00")); info.Download_View = 0; info.User_ID = ConvertUtility.ToInt32(ckid); try { var fileId = DownloadDB.Insert(info); var contentDownloadInfo = new ContentDownloadInfo(); contentDownloadInfo.Content_ID = _contentId; contentDownloadInfo.Download_ID = fileId; contentDownloadInfo.Priority = 0; ContentDownloadDB.Insert(contentDownloadInfo); Response.Redirect(Request.RawUrl + "#idTab3"); lblStatusUpdate.Text = lblStatusUpdate2.Text = MiscUtility.UPDATE_SUCCESS; } catch { lblStatusUpdate.Text = lblStatusUpdate2.Text = MiscUtility.UPDATE_ERROR; } } }