public int InsertInformation(PublicationObject publicationObj)
{
SqlConnection con = GetConnection();
con.Open();
SqlCommand cmd = new SqlCommand("Insert_Publication", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PublicationTitle", publicationObj.PublicationTitle);
cmd.Parameters.AddWithValue("@PublicationPath", publicationObj.PublicationPath);
cmd.Parameters.AddWithValue("@UserId", publicationObj.UserId);
cmd.Parameters.AddWithValue("@Status", publicationObj.Status);
try
{
return(cmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
cmd.Dispose();
con.Close();
con.Dispose();
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
PublicationObject publicationObj = new PublicationObject();
publicationObj.PublicationTitle = tbxPublicationTitle.Text;
publicationObj.PublicationPath = tbxPublicationLink.Text;
publicationObj.UserId = Int32.Parse(Session["user_id"].ToString());
if (ddlPublicationStatus.SelectedValue == "1")
{
publicationObj.Status = true;
}
else if (ddlPublicationStatus.SelectedValue == "0")
{
publicationObj.Status = false;
}
try
{
int result = dal.InsertInformation(publicationObj);
if (result == 1)
{
LoadPublication();
SuccessPanel.Visible = true;
tbxPublicationTitle.Text = "";
tbxPublicationLink.Text = "";
}
else
{
DangerPanel.Visible = true;
tbxPublicationTitle.Text = "";
tbxPublicationLink.Text = "";
}
}
catch
{
throw;
}
}
protected void btn_update_Click(object sender, EventArgs e)
{
PublicationObject publicationObj = new PublicationObject();
publicationObj.PublicationId = int.Parse(Session["Publication_id"].ToString());
DataTable dt = dal.SelectInformationById(publicationObj.PublicationId);
publicationObj.PublicationTitle = tbxPublicationTitle.Text;
publicationObj.PublicationPath = tbxPublicationLink.Text;
publicationObj.UserId = Int32.Parse(Session["user_id"].ToString());
if (ddlPublicationStatus.SelectedValue == "1")
{
publicationObj.Status = true;
}
else if (ddlPublicationStatus.SelectedValue == "0")
{
publicationObj.Status = false;
}
try
{
int result = dal.UpdateInformation(publicationObj);
if (result == 1)
{
SuccessPanel.Visible = true;
}
else
{
DangerPanel.Visible = true;
}
}
catch
{
throw;
}
}
