public int UpdateInformation(AchievementPhotoObject achievementPhotoObj) { SqlConnection con = GetConnection(); con.Open(); SqlCommand cmd = new SqlCommand("Update_AchievementPhoto", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PhotoId", achievementPhotoObj.PhotoId); cmd.Parameters.AddWithValue("@AchievementId", achievementPhotoObj.AchievementId); cmd.Parameters.AddWithValue("@PhotoPath", achievementPhotoObj.PhotoPath); cmd.Parameters.AddWithValue("@Status", achievementPhotoObj.Status); try { return(cmd.ExecuteNonQuery()); } catch { throw; } finally { cmd.Dispose(); con.Close(); con.Dispose(); } }
protected void btn_upload_Click(object sender, EventArgs e) { if (FileUploadAchievement.HasFiles) { string photopath = ""; string uploadFolder = "~/Achievement_Photos/"; DataTable dt = new DataTable(); dt.Columns.Add("AchievementId"); dt.Columns.Add("PhotoPath"); dt.Columns.Add("Status"); AchievementPhotoObject achievementphotoObj = new AchievementPhotoObject(); foreach (HttpPostedFile uploadedFile in FileUploadAchievement.PostedFiles) { string extension = Path.GetExtension(uploadedFile.FileName); photopath = Guid.NewGuid().ToString() + extension; uploadedFile.SaveAs(Server.MapPath(uploadFolder + photopath)); achievementphotoObj.AchievementId = Int32.Parse(tbxAchievementId.Text); achievementphotoObj.PhotoPath = photopath; if (ddlPhotoStatus.SelectedValue == "1") { achievementphotoObj.Status = true; } else if (ddlPhotoStatus.SelectedValue == "0") { achievementphotoObj.Status = false; } dt.Rows.Add(new Object[] { achievementphotoObj.AchievementId, achievementphotoObj.PhotoPath, achievementphotoObj.Status }); } try { dalAP.InsertInformation(dt); LoadAchievement(); LoadAchievementTitle(); LoadAllAchievementPhoto(); PanelSuccess.Visible = true; } catch { PanelFaild.Visible = true; throw; } } }
protected void btn_update_Click(object sender, EventArgs e) { int id = int.Parse(Session["AchievementPhoto_id"].ToString()); DataTable dt = dal.SelectInformationById(id); AchievementPhotoObject photoObj = new AchievementPhotoObject(); photoObj.PhotoId = int.Parse(Session["AchievementPhoto_id"].ToString()); photoObj.AchievementId = Int32.Parse(dt.Rows[0]["AchievementId"].ToString()); if (FileUpload.HasFile) { string extension = Path.GetExtension(FileUpload.FileName); string photopath = Guid.NewGuid().ToString() + extension; string uploadFolder = "~/Achievement_Photos/"; FileUpload.SaveAs(Server.MapPath(uploadFolder + photopath)); photoObj.PhotoPath = photopath; if (ddlPhotoStatus.SelectedValue == "1") { photoObj.Status = true; } else if (ddlPhotoStatus.SelectedValue == "0") { photoObj.Status = false; } try { int result = dal.UpdateInformation(photoObj); if (result == 1) { getPhotoById(); PanelSuccess.Visible = true; } } catch { throw; } } else { photoObj.PhotoPath = dt.Rows[0]["PhotoPath"].ToString(); if (ddlPhotoStatus.SelectedValue == "1") { photoObj.Status = true; } else if (ddlPhotoStatus.SelectedValue == "0") { photoObj.Status = false; } try { int result = dal.UpdateInformation(photoObj); if (result == 1) { getPhotoById(); PanelSuccess.Visible = true; } } catch { throw; } } }