public static void DeleteLocation(Location location)
{
using (SqlConnection conn = DbConfiguration.GetDBConnection())
{
conn.Open();
var query = "DELETE FROM Locations where NAME = @name";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@name", location.Name);
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException sqle)
{
Console.WriteLine("Delete Location thất bại");
}
}
}
}
public static void UpdateLocation(Location location)
{
using (SqlConnection conn = DbConfiguration.GetDBConnection())
{
conn.Open();
var query = "UPDATE Locations SET FULLPATH = @fullpath where NAME = @name";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@fullpath", location.Path);
cmd.Parameters.AddWithValue("@name", location.Name);
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException sqle)
{
Console.WriteLine("Update Location thất bại");
}
}
}
}
/**
* Kiểm tra kết nối database
*/
public static bool TestConnection()
{
using (SqlConnection conn = DbConfiguration.GetDBConnection())
{
try
{
conn.Open();
Console.WriteLine("Kết nối database thành công");
return(true);
}
catch (InvalidOperationException invalid)
{
Console.WriteLine("Kết nối database thất bại");
return(false);
}
catch (SqlException sqle)
{
Console.WriteLine("Kết nối database thất bại");
return(false);
}
}
}
public static void SetLocation(Location location)
{
using (SqlConnection conn = DbConfiguration.GetDBConnection())
{
conn.Open();
var query = "INSERT INTO Locations (NAME, FULLPATH) VALUES (@name, @fullpath)";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@name", location.Name);
cmd.Parameters.AddWithValue("@fullpath", location.Path);
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException sqle)
{
Console.WriteLine("Thêm Location không thành công");
}
}
}
}
public static void UpdateType(string type, bool isuse)
{
using (SqlConnection conn = DbConfiguration.GetDBConnection())
{
conn.Open();
var query = "UPDATE FileType SET ISUSE = @isuse where TENTYPE = @tentype";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@tentype", SqlDbType.VarChar);
cmd.Parameters.Add("@isuse", SqlDbType.Bit);
try
{
cmd.Parameters[0].Value = type;
cmd.Parameters[1].Value = isuse;
cmd.ExecuteNonQuery();
}
catch (SqlException sqle)
{
Console.WriteLine("Update thất bại");
}
}
}
}