public async Task <object> Add(State entity)
{
string storedProcedure = String.Empty;
object result;
int rows;
storedProcedure = Settings.Database.StoredProcedures.FirstOrDefault(p => p == ADD_PROC);
if (storedProcedure == null)
{
SqlCommandType = Constants.DBCommandType.SQL;
CMDText = ADD_STMT;
}
else
{
SqlCommandType = Constants.DBCommandType.SPROC;
CMDText = storedProcedure;
}
MapFromObject = new StateMapFromObject(logger);
result = await base.Add(entity, entity.PK);
if (result != null)
{
rows = (int)result;
}
else
{
rows = -1;
}
return(rows);
}
public object Add(State entity)
{
string storedProcedure = String.Empty;
object result;
storedProcedure = Settings.Database.StoredProcedures.FirstOrDefault(p => p == ADD_PROC);
if (storedProcedure == null)
{
SqlCommandType = Constants.DBCommandType.SQL;
CMDText = ADD_STMT;
}
else
{
SqlCommandType = Constants.DBCommandType.SPROC;
CMDText = storedProcedure;
}
MapFromObject = new StateMapFromObject(logger);
result = base.Add(entity, entity.PK);
if (result != null && (int)result == 1)
{
return(entity.PK.Key);
}
else
{
return(String.Empty);
}
}
public async Task <int> Update(State entity)
{
string storedProcedure = String.Empty;
storedProcedure = Settings.Database.StoredProcedures.FirstOrDefault(p => p == UPDATE_PROC);
if (storedProcedure == null)
{
SqlCommandType = Constants.DBCommandType.SQL;
CMDText = UPDATE_STMT;
}
else
{
SqlCommandType = Constants.DBCommandType.SPROC;
CMDText = storedProcedure;
}
MapFromObject = new StateMapFromObject(logger);
return(await base.Update(entity, entity.PK));
}
