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