public int DeleteInformation(StoryPhotoObject storyPhotoObj)
{
SqlConnection con = GetConnection();
con.Open();
SqlCommand cmd = new SqlCommand("Delete_StoryPhoto", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PhotoId", storyPhotoObj.PhotoId);
cmd.Parameters.AddWithValue("@StoryId", storyPhotoObj.StoryId);
try
{
return(cmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
cmd.Dispose();
con.Close();
con.Dispose();
}
}
protected void btn_upload_Click(object sender, EventArgs e)
{
if (FileUploadStory.HasFiles)
{
string photopath = "";
string uploadFolder = "~/Story_Photos/";
DataTable dt = new DataTable();
dt.Columns.Add("StoryId");
dt.Columns.Add("PhotoPath");
dt.Columns.Add("Status");
StoryPhotoObject storyphotoobj = new StoryPhotoObject();
foreach (HttpPostedFile uploadedFile in FileUploadStory.PostedFiles)
{
string extension = Path.GetExtension(uploadedFile.FileName);
photopath = Guid.NewGuid().ToString() + extension;
uploadedFile.SaveAs(Server.MapPath(uploadFolder + photopath));
storyphotoobj.StoryId = Int32.Parse(tbxStoryId.Text);
storyphotoobj.PhotoPath = photopath;
if (ddlPhotoStatus.Visible == true)
{
if (ddlPhotoStatus.SelectedValue == "1")
{
storyphotoobj.Status = true;
}
else if (ddlPhotoStatus.SelectedValue == "0")
{
storyphotoobj.Status = false;
}
}
else
{
storyphotoobj.Status = true;
}
dt.Rows.Add(new Object[] { storyphotoobj.StoryId, storyphotoobj.PhotoPath, storyphotoobj.Status });
}
try
{
dalSP.InsertInformation(dt);
LoadAllStory();
LoadAllStoryPhoto();
LoadStoryTitle();
PanelSuccess.Visible = true;
}
catch
{
PanelFaild.Visible = true;
throw;
}
}
}
protected void btn_update_Click(object sender, EventArgs e)
{
int id = int.Parse(Session["photo_id"].ToString());
DataTable dt = dal.SelectInformationById(id);
StoryPhotoObject photoObj = new StoryPhotoObject();
photoObj.PhotoId = int.Parse(Session["photo_id"].ToString());
photoObj.StoryId = Int32.Parse(dt.Rows[0]["StoryId"].ToString());
if (FileUploadStory.HasFile)
{
string extension = Path.GetExtension(FileUploadStory.FileName);
string photopath = Guid.NewGuid().ToString() + extension;
string uploadFolder = "~/Story_Photos/";
FileUploadStory.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;
}
}
}
