//Inserting data into Database
public bool Insert(Payment1 p)
{
// Creating a default return type and setting its value to false
bool isSuccess = false;
//Step 1: Connect Database
SqlConnection conn = new SqlConnection(myconstring);
try
{
//Step 2: Create a SQL Query to insert data
string sql = "INSERT INTO pay(JobCard,FromDate,ToDate,CustomerName,VehicleNumber,MobileNUmber,BillAmount,DiscountAmount,NetAmount) VALUES(@JobCard,@FromDate,@ToDate,@CustomerName,@VehicleNumber,@MobileNUmber,@BillAmount,@DiscountAmount,@NetAmount)";
//Creating SQL command using sql and conn
SqlCommand cmd = new SqlCommand(sql, conn);
//Create parameters to add data
cmd.Parameters.AddWithValue("@JobCard", p.JobCard);
cmd.Parameters.AddWithValue("@FromDate", p.FromDate);
cmd.Parameters.AddWithValue("@ToDate", p.ToDate);
cmd.Parameters.AddWithValue("@CustomerName", p.CustomerName);
cmd.Parameters.AddWithValue("@VehicleNumber", p.VehicleNumber);
cmd.Parameters.AddWithValue("@MobileNUmber", p.MobileNUmber);
cmd.Parameters.AddWithValue("@BillAmount", p.BillAmount);
cmd.Parameters.AddWithValue("@DiscountAmount", p.DiscountAmount);
cmd.Parameters.AddWithValue("@NetAmount", p.NetAmount);
//Connection Opens here
conn.Open();
int rows = cmd.ExecuteNonQuery();
//If the query runs successfully then the values of rows will be greater than zero else its value will be 0
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
conn.Close();
}
return(isSuccess);
}
//Method to update data in database from our Application
public bool Update(Payment1 p)
{
//Craete a default return type and set it's default value to false
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconstring);
try
{
//SQL to update data in our Database
string sql = "UPDATE pay SET BillAmount = @BillAmount,DiscountAmount = @DiscountAmount,NetAmount = @NetAmount WHERE CustomerID = @CustomerID";
//Creating SQL command
SqlCommand cmd = new SqlCommand(sql, conn);
//Create Parameters to add value
cmd.Parameters.AddWithValue("@BillAmount", p.BillAmount);
cmd.Parameters.AddWithValue("@DiscountAmount", p.DiscountAmount);
cmd.Parameters.AddWithValue("@NetAmount", p.NetAmount);
cmd.Parameters.AddWithValue("@CustomerID", p.CustomerID);
//Open Database Connection
conn.Open();
int rows = cmd.ExecuteNonQuery();
//If the query runs successfully then the values of rows will be greater than zero else its value will be 0
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
conn.Close();
}
return(isSuccess);
}
//Method to Delete Data from the Database
public bool Delete(Payment1 p)
{
//Create a default return value and set its value to false
bool isSuccesss = false;
SqlConnection conn = new SqlConnection(myconstring);
try
{
//SQL to Delete data
string sql = "DELETE FROM pay WHERE CustomerID = @CustomerID";
//Creating SQL command
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@CustomerID", p.CustomerID);
//Open Connection
conn.Open();
int rows = cmd.ExecuteNonQuery();
//If the query runs successfully then the values of rows will be greater tah zero else its value is 0
if (rows > 0)
{
isSuccesss = true;
}
else
{
isSuccesss = false;
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
//Close connection
conn.Close();
}
return(isSuccesss);
}