Notes

namespace ConsoleApp4
{
internal class Movies
{
SqlConnection conn;
string connectionString = "Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Movies;Integrated Security=SSPI";
public Movies()
{
conn = new SqlConnection(connectionString);
}
static void Main()
{
Movies sQLCommand = new Movies();
Console.WriteLine("Before Inserting");
sQLCommand.Readdata();

sQLCommand.Insertdata();
Console.WriteLine();
Console.WriteLine("After Inserting");
sQLCommand.Readdata();

sQLCommand.UpdateData();
Console.WriteLine();
Console.WriteLine("After Updating");
sQLCommand.Readdata();

sQLCommand.Deletedata();
Console.WriteLine();
Console.WriteLine("After Deleting");
sQLCommand.Readdata();

int noofrecords = sQLCommand.Getnoofrecords();
Console.WriteLine();
Console.WriteLine("No of Records:{0}", noofrecords);
}
public int Getnoofrecords()
{
int count = -1;
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("select count(*) from movies", conn);
count = (int)cmd.ExecuteScalar();
}
finally
{
if (conn != null)
conn.Close();
}
return count;
}
public void Deletedata()
{
try
{
conn.Open();
string deleteString = @"delete from movies where id=206";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = deleteString;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
}
finally
{
if (conn != null)
conn.Close();
}
}
public void UpdateData()
{
try
{
conn.Open();
string updateString = @" update movies
set description ='Sci-fi' where description ='Sci'";
SqlCommand cmd = new SqlCommand(updateString);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
public void Insertdata()
{
try
{
conn.Open();
string insertString = @"Insert into movies(id , name, description)
values(206 , 'The Rim of the World ','Sci')";
SqlCommand cmd = new SqlCommand(insertString, conn);
cmd.ExecuteNonQuery();
}
finally
{
if (conn != null)
conn.Close();
}
}
public void Readdata()
{
SqlDataReader rdr = null;
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("Select * from movies", conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Console.WriteLine(rdr[0]);
Console.WriteLine(rdr[1]);
Console.WriteLine(rdr[2]);


}

}
finally
{
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
}
}
}
}




static void Main(string[] args)
{
try
{

string ConnectionString = "Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Movies;Integrated Security=SSPI";

using (SqlConnection connection = new SqlConnection(ConnectionString))
{
SqlCommand cmd = new SqlCommand("sprating_movies", connection)
{

CommandType = CommandType.StoredProcedure
};

connection.Open();

SqlDataReader sdr = cmd.ExecuteReader();

while (sdr.Read())
{

Console.WriteLine(sdr["id"] + ", " + sdr["rating"]+", " + sdr["user_id"]+", " + sdr["movie_id"]+
", " + sdr["name"]+ ", " + sdr["description"]);

}
}
}
catch (Exception ex)
{
Console.WriteLine($"Exception Occurred: {ex.Message}");
}
Console.ReadKey();
}




static void Main(string[] args)
{
try
{

string ConnectionString = "Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Movies;Integrated Security=SSPI";

using (SqlConnection connection = new SqlConnection(ConnectionString))
{
SqlCommand cmd = new SqlCommand()
{

CommandText = "sp_movieid",
Connection = connection,
CommandType = CommandType.StoredProcedure
};
SqlParameter param1 = new SqlParameter
{
ParameterName = "@tag",
SqlDbType = SqlDbType.NVarChar,
Value = "Good" ,
Direction = ParameterDirection.Input
};

cmd.Parameters.Add(param1);



SqlParameter outParameter = new SqlParameter
{
ParameterName = "@movie_id" ,
SqlDbType = SqlDbType.Int,
Direction = ParameterDirection.Output
};
cmd.Parameters.Add(outParameter);
connection.Open();

cmd.ExecuteNonQuery();


Console.WriteLine(outParameter.Value.ToString());


}
}
catch (Exception ex)
{
Console.WriteLine($"Exception Occurred: {ex.Message}");
}
Console.ReadKey();
}