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;
}
}
}
