public int DeleteInformation(PhotoGalleryObject photogalleryObj) { SqlConnection con = GetConnection(); con.Open(); SqlCommand cmd = new SqlCommand("Delete_PhotoGallery", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PhotoId", photogalleryObj.PhotoId); cmd.Parameters.AddWithValue("@UserId", photogalleryObj.UserId); try { return(cmd.ExecuteNonQuery()); } catch { throw; } finally { cmd.Dispose(); con.Close(); con.Dispose(); } }
public int InsertInformation(PhotoGalleryObject photogalleryObj) { SqlConnection con = GetConnection(); con.Open(); SqlCommand cmd = new SqlCommand("Insert_PhotoGallery", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PhotoPath", photogalleryObj.PhotoPath); cmd.Parameters.AddWithValue("@PhotoBrief", photogalleryObj.PhotoBrief); cmd.Parameters.AddWithValue("@PhotoDetail", photogalleryObj.PhotoDetail); cmd.Parameters.AddWithValue("@UserId", photogalleryObj.UserId); cmd.Parameters.AddWithValue("@Status", photogalleryObj.Status); try { return(cmd.ExecuteNonQuery()); } catch { throw; } finally { cmd.Dispose(); con.Close(); con.Dispose(); } }
protected void btn_update_Click(object sender, EventArgs e) { PhotoGalleryObject photogalleryObj = new PhotoGalleryObject(); photogalleryObj.PhotoId = int.Parse(Session["PhotoGallery_id"].ToString()); DataTable dt = dal.SelectInformationById(photogalleryObj.PhotoId); photogalleryObj.PhotoBrief = tbxPhotoBrief.Text; photogalleryObj.PhotoDetail = tbxPhotoDetail.Text; photogalleryObj.UserId = Int32.Parse(Session["user_id"].ToString()); if (ddlPhotoStatus.SelectedValue == "1") { photogalleryObj.Status = true; } else if (ddlPhotoStatus.SelectedValue == "0") { photogalleryObj.Status = false; } if (PhotoUpload.HasFile) { string extension = Path.GetExtension(PhotoUpload.FileName); string photopath = Guid.NewGuid().ToString() + extension; string uploadFolder = "~/Photo_gallery/"; PhotoUpload.SaveAs(Server.MapPath(uploadFolder + photopath)); photogalleryObj.PhotoPath = photopath; } else { photogalleryObj.PhotoPath = dt.Rows[0]["PhotoPath"].ToString(); } try { int result = dal.UpdateInformation(photogalleryObj); if (result == 1) { getPhotoGalleryById(); SuccessPanel.Visible = true; } else { DangerPanel.Visible = true; } } catch { throw; } }