public async Task <object> InsertRecordReturnsPrimaryKey()
{
object returnValue = new object();
string sql = "State_Insert";
DatabaseWrapper database = new DatabaseWrapper();
database.InitializeWithConfigurationFile(Config.ConnectionString);
int StateId = 0;
try
{
returnValue = Convert.ToInt32(await database
.CreateStoredProcedureCommand(sql)
.AddParameter("@StateId", StateId, true)
.AddParameter("@CountryId", 1)
.AddParameter("@IsDeleted", false)
.AddParameter("@StateAbbreviation", "TG")
.AddParameter("@StateName", "TG")
.InsertRecordAsync());
}
catch (SqlException ex)
{
returnValue = GetCustomExceptionOn(ex);
}
catch (Exception ex)
{
returnValue = GetCustomExceptionOn(ex);
}
finally
{
database.Connection.Close();
}
Console.WriteLine("newly added record Primary Key value: " + returnValue);
return(returnValue);
}
