private void GetDatabase()
{
try
{
objAttachmentcls = new AttachmentCls();
objAttachmentcls.DBID = Request.QueryString["DBID"];
DataTable dt = objAttachmentcls.GetDBID();
if (dt.Rows.Count > 0)
{
txtDBID.Text = dt.Rows[0]["t_dbid"].ToString();
txtDBServerName.Text = dt.Rows[0]["t_serv"].ToString();
txtDatabaseName.Text = dt.Rows[0]["t_dbnm"].ToString();
txtDBDesc.Text = dt.Rows[0]["t_desc"].ToString();
ddlLibrary.SelectedValue = dt.Rows[0]["t_lbcd"].ToString();
btnSaveDatabaseDetails.Text = "Update";
txtDBID.Enabled = false;
divHeader.InnerText = "Update Database";
}
else
{
btnSaveDatabaseDetails.Text = "Save";
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
}
}
protected void ddlDBID_SelectedIndexChanged(object sender, EventArgs e)
{
objAttachmentcls = new AttachmentCls();
objAttachmentcls.DBID = ddlDBID.SelectedValue;
DataTable dt = objAttachmentcls.GetDBID();
txtDBDescription.Text = dt.Rows[0]["t_desc"].ToString();
txtDBDescription.Visible = true;
}
protected void btnSaveDatabaseDetails_Click(object sender, EventArgs e)
{
try
{
int res = 0;
if (txtDBID.Text != "" && txtDBServerName.Text != "" && txtDatabaseName.Text != "" && txtDBDesc.Text != "")
{
objAttachmentcls = new AttachmentCls();
objAttachmentcls.LibraryCode = ddlLibrary.SelectedValue;
objAttachmentcls.DBID = txtDBID.Text.Trim();
objAttachmentcls.DBServer = txtDBServerName.Text.Trim();
objAttachmentcls.DatabaseName = txtDatabaseName.Text.Trim();
objAttachmentcls.DBDescription = txtDBDesc.Text.Trim();
if (btnSaveDatabaseDetails.Text == "Save")
{
DataTable dt = objAttachmentcls.GetDBID();
if (dt.Rows.Count == 0)
{
res = objAttachmentcls.InsertDBdetails();
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('DBID already exist');", true);
}
}
else
{
res = objAttachmentcls.UpdateDatabase();
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);
}
}
