User-1802908944 posted
you can right these line in DAL and call it in on you presentation layer.
public static void DBBackUp(string r)
{
Database db = null; //Creating Object of Database Class
DbCommand dbCmd = null; //Creating Object of DbCommand Class
string strBackUp = "";
strBackUp = con.Database.ToString() + r;
//con.Open();
//dbCmd.Connection = con;
dbCmd = db.GetStoredProcCommand(ConstantDAL.spDbBackUp);
db.AddInParameter(dbCommand, ConstantDAL.pnDBName, DbType.String, QuestionCategory.Category);
db.AddInParameter(dbCommand, ConstantDAL.pnBackUpFileName, DbType.String, QuestionCategory.Code);
int result = 0;
Database db = null; //Creating Object of Database Class
DbCommand dbCommand = null; //Creating Object of DbCommand Class
try
{
//Insert Into [QuestionCategory] Table
db = ConnectionString.GetDataBaseInstance();
dbCommand = db.GetStoredProcCommand(ConstantDAL.spInsertQuestionCategory);
db.AddInParameter(dbCommand, ConstantDAL.pnQuestionCategory, DbType.String, QuestionCategory.Category);
db.AddInParameter(dbCommand, ConstantDAL.pnQuestionCategoryCode, DbType.String, QuestionCategory.Code);
db.AddInParameter(dbCommand, ConstantDAL.pnQuestionCategoryDescription, DbType.String, QuestionCategory.Description);
db.AddInParameter(dbCommand, ConstantDAL.pnQuestionCategoryStatus, DbType.String, QuestionCategory.Status);
result = db.ExecuteNonQuery(dbCommand);
return result; //returns value
}
catch (Exception ex)
{
throw ex;
}
finally
{
QuestionCategory = null;
db = null;
dbCommand = null;
}
}
string ConnectionString = string.Empty;
//// Get connection information from the application configuration file
ConnectionString = ConfigurationManager.ConnectionStrings["SQLServerConnection"].ConnectionString;
//// Declare new SQL Command object
SqlCommand command = new SqlCommand();
//// Declare new SQL Connection object
SqlConnection connection = new SqlConnection(ConnectionString);
// set SQL Command object's text, type, and connection
command.CommandText = strQuery;
command.CommandType = CommandType.StoredProcedure;
command.CommandType = CommandType.Text;
command.Parameters.Add("@Name", SqlDbType.Int).Value = _Name;
command.Connection = connection;
//// Open database Connection
connection.Open();
command.ExecuteNonQuery();
connection.close();
working code
happy coding
