internal int InsertExternalDataStore(DataSourceConfigurationEntity obj)
{
int result = 0;
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "cfg.InsertExternalDataStore";
sproc.StoredProceduresParameter.Add(GetParam("@id", obj.Id == null ? "0" : Convert.ToString(obj.Id), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@externalDataStoreName", !string.IsNullOrEmpty(obj.ExternalDataStoreName) ? obj.ExternalDataStoreName : "", SQLServerDatatype.NvarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@externalDataStoreTypeId", obj.externalDataStoreType.Id == null ? "0" : Convert.ToString(obj.externalDataStoreType.Id), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@dataStoreConfiguration", !string.IsNullOrEmpty(obj.DataStoreConfiguration) ? obj.DataStoreConfiguration : null, SQLServerDatatype.NvarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@userId", obj.UserId == null ? "0" : Convert.ToString(obj.UserId), SQLServerDatatype.IntDataType));
result = Convert.ToInt32(sql.ExecuteScalar(CommandType.StoredProcedure, sproc));
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public int InsertExternalDataStore(DataSourceConfigurationEntity obj)
{
return(rep.InsertExternalDataStore(obj));
}
