Scribd
Upload
64 views2 pages

Writedatabase: Summary Description For Registerusers

This class defines methods for writing data to a database. It contains methods for registering users by inserting data into a users table, adding books by inserting into a books table, and adding companies by inserting into a companies table. Each method opens a SqlConnection, defines an insert query with parameters, executes it using SqlCommand, handles exceptions, and closes the connection.

Uploaded by

smzuma9869
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
64 views2 pages

Writedatabase: Summary Description For Registerusers

This class defines methods for writing data to a database. It contains methods for registering users by inserting data into a users table, adding books by inserting into a books table, and adding companies by inserting into a companies table. Each method opens a SqlConnection, defines an insert query with parameters, executes it using SqlCommand, handles exceptions, and closes the connection.

Uploaded by

smzuma9869
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

using System;

using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;

/// <summary>
/// Summary description for registerUsers
/// </summary>
public class writeDatabase
{
public writeDatabase()
{
//
// TODO: Add constructor logic here
//
}

public static string connectionStr =


WebConfigurationManager.ConnectionStrings["LibraryConn"].ConnectionString;
public static SqlConnection sqlConn = new SqlConnection(connectionStr);
public static string status;
public void regUsers(string fullname, string address, string telNo,string emailAdd )
{

string query = "insert into users(FullName,PhysicalAddress,TelNumber,EmailAddress)


values(@fulname,@address,@contact,@email)";
try
{
sqlConn.Open();
SqlCommand cmd = new SqlCommand(query, sqlConn);
cmd.Parameters.AddWithValue("@fulname", fullname);
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@contact", telNo);
cmd.Parameters.AddWithValue("@email", emailAdd);

int result = cmd.ExecuteNonQuery();

if (result == 1)
{
status = "New record saved successfully";
}
}catch(System.Data.SqlClient.SqlException exc){

string msg = "Insert Error";


msg += exc.Message;
status = msg;
}
finally
{
sqlConn.Close();
}

public void addBooks(string title, string author, string ISBN,int copies,decimal amount)
{
string query = "insert into books(Title,Author,ISBN,Copies,Amount)
values(@title,@author,@ISBN,@copies,@amount)";

try
{
sqlConn.Open();
SqlCommand cmd = new SqlCommand(query, sqlConn);
cmd.Parameters.AddWithValue("@title", title);
cmd.Parameters.AddWithValue("@author", author);
cmd.Parameters.AddWithValue("@ISBN", ISBN);
cmd.Parameters.AddWithValue("@copies", copies);
cmd.Parameters.AddWithValue("@amount", amount);
int result = cmd.ExecuteNonQuery();

if (result == 1)
{
status = "New record saved successfully";
}
}
catch(System.Data.SqlClient.SqlException exc2 )
{
string msg = "Insert Error";
msg += exc2.Message;
status = msg;

}
finally
{
sqlConn.Close();
}

public void addCompanies(string name, string address, string contacts)


{
string query = "insert into companies(CompName,CompAddress,CompContacts) values(
@name,@address,@cont)";
try
{
sqlConn.Open();
SqlCommand cmd = new SqlCommand(query, sqlConn);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@cont", contacts);

int result = cmd.ExecuteNonQuery();


if (result == 1)
{
status = "New record saved successfully";
}
}
catch (System.Data.SqlClient.SqlException exc3)
{
string msg = "Insert Error";
msg += exc3.Message;
status = msg;

}
finally
{
sqlConn.Close();
}

You might also like