private void GetLibrary()
{
try
{
objAttachmentcls = new AttachmentCls();
objAttachmentcls.LibraryCode = Request.QueryString["LibCode"];
DataTable dt = objAttachmentcls.GetLibCode();
if (dt.Rows.Count > 0)
{
txtLibraryCode.Text = dt.Rows[0]["t_lbcd"].ToString();
txtLibDesc.Text = dt.Rows[0]["t_desc"].ToString();
txtPath.Text = dt.Rows[0]["t_path"].ToString();
txtServerName.Text = dt.Rows[0]["t_serv"].ToString();
ddlIsActive.SelectedValue = dt.Rows[0]["t_acti"].ToString();
btnSaveLibrary.Text = "Update";
txtLibraryCode.Enabled = false;
divHeader.InnerText = "Update Library";
btnDelete.Visible = true;
}
else
{
btnSaveLibrary.Text = "Save";
btnDelete.Visible = false;
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
}
}
protected void btnSaveLibrary_Click(object sender, EventArgs e)
{
try
{
int res = 0;
if (txtLibraryCode.Text != "" && txtLibDesc.Text != "" && txtPath.Text != "" && txtServerName.Text != "")
{
objAttachmentcls = new AttachmentCls();
objAttachmentcls.LibraryCode = txtLibraryCode.Text.Trim();
objAttachmentcls.LibraryDescription = txtLibDesc.Text.Trim();
objAttachmentcls.Path = txtPath.Text.Trim();
objAttachmentcls.IsActive = ddlIsActive.SelectedValue;
objAttachmentcls.ServerName = txtServerName.Text.Trim();
if (btnSaveLibrary.Text == "Save")
{
DataTable dt = objAttachmentcls.GetLibCode();
if (dt.Rows.Count == 0)
{
res = objAttachmentcls.InsertLibrary();
if (res > 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Saved Successfully');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Not Saved');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Library Code already exist');", true);
}
}
else
{
if (ddlIsActive.SelectedValue == "N")
{
DataTable dtLibCode = objAttachmentcls.GetLibraryCodeFromDataBase();
if (dtLibCode.Rows.Count > 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Library Code Already in used so it is not Deactivated');", true);
}
else
{
res = objAttachmentcls.UpdateLibrary();
}
}
else
{
res = objAttachmentcls.UpdateLibrary();
}
if (res > 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Updated Successfully');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Not Updated');", true);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Please enter all data');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
}
}
