/// <summary>
/// Deletes rows from table which matches the given condition.
/// </summary>
/// <param name="tableSchema">The table schema. This includes table name and condition which specifies which row to delete.</param>
/// <returns></returns>
public ResultSet DeleteFromTable(TableSchema tableSchema)
{
ResultSet tableData = new ResultSet();
try
{
DBHandler dbHandler = new DBHandler();
// Creating connection
DbConnection dbConnection = dbHandler.CreateDbConnection(tableSchema.ProviderName, tableSchema.ConnectionString);
dbConnection.Open();
// Generating query string
string deleteQuery = QueryGenerator.GenerateDeleteQuery(tableSchema);
if (!string.IsNullOrEmpty(deleteQuery))
{
DbCommand dbCommand = dbConnection.CreateCommand();
dbCommand.CommandText = deleteQuery;
dbCommand.Connection = dbConnection;
int rowsAffected = dbCommand.ExecuteNonQuery();
tableData.NumberOfRowsAffected = rowsAffected;
tableData.IsSuccess = true;
}
else
{
tableData.IsSuccess = false;
tableData.ErrorMessage = "Error in generating query string.";
}
dbConnection.Close();
return(tableData);
}
catch (Exception ex)
{
tableData.IsSuccess = false;
tableData.NumberOfRowsAffected = 0;
tableData.ErrorMessage = ex.Message;
return(tableData);
}
}
public bool AddCustomerDetail(CustDetail customerDetail)
{
try
{
DBHandler dbHandler = new DBHandler();
string connectionString = WebConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
string proiderName = WebConfigurationManager.AppSettings["DBProvider"].ToString();
// Creating connection
// File.AppendAllText(@"D:\Charmi\Test.txt", "ConnectionString: " + connectionString + Environment.NewLine + "providerName: " + proiderName);
SqlConnection sqlConn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("INSERT INTO dbo.CustomerData ([CustID],[AccountNumber],[Name],[CustType],[DOB],[ApplicantMaritalStatus],[EmailAddress]) VALUES " +
"('" + customerDetail.CustomerID + "', '" + customerDetail.AccountNumber + "', '" + customerDetail.CustomerName + "', 'public' ,'" + customerDetail.DOB + "', '" + customerDetail.MaritalStatus + "', '" + customerDetail.EmailAddress + "' )", sqlConn);
sqlConn.Open();
cmd.ExecuteNonQuery();
sqlConn.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
